Print Thread
ORA-01804 on version 15.0,1.2051
#64116 08/04/22 08:39 PM
Joined: Aug 2022
Posts: 1
A
Aga Offline OP
Member
OP Offline
Member
A
Joined: Aug 2022
Posts: 1
Hi,

when I'm trying to connect to database I get Error while trying to retrieve text for error ORA-01804
tnsping works correctly.

Here is my info tab from Support info:

PL/SQL Developer
Version 15.0.1.2051 (64 bit)
01.134474 - 5 user license
Service Contract: 01.02.2022
Style: Sky
Windows 10 Build 19044
pl-PL(1045)/Polski (Polska)

Physical memory : 33 270 564 kB (26 901 836 available)
Paging file : 38 513 444 kB (32 630 120 available)
Virtual memory : 137 438 953 344 kB (137 434 227 364 available)

Parameters
C:\Program Files\PLSQL Developer 15\plsqldev.exe

Preferences
Session mode: Multi
OCI Library: C:\app\client\akx\product\19.0.0\client_1\bin\oci.dll
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Users\akx\AppData\Roaming\PLSQL Developer 15\Preferences\default\Default.ini
C:\Users\akx\AppData\Roaming\PLSQL Developer 15\Preferences\akx\default.ini

License File
C:\ProgramData\PLSQL Developer\aalf.dat

Debug file
C:\Users\akx\AppData\Roaming\PLSQL Developer 15\PlSqlDev.elf

Plug-Ins
*Active Query Builder (1.5.0) (C:\Program Files\PLSQL Developer 15\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (1.4.0) (C:\Program Files\PLSQL Developer 15\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
DEV
PROD
UAT
...

Homes
OraClient19Home1 (C:\app\client\akx\product\19.0.0\client_1)

DLLs
C:\app\client\akx\product\19.0.0\client_1\bin\oci.dll

TNS File
C:\app\client\akx\product\19.0.0\client_1\network\admin\tnsnames.ora

Using
Home: OraClient19Home1
DLL: C:\app\client\akx\product\19.0.0\client_1\bin\oci.dll
OCI: version 12.1 (19.3.0.0.0)

Process
Working Set = 142 090 240
Memory = 26 485 456
GDI Objects = 662
User Objects = 348
Handles = 714

Monitor
PixelsPerInch = 96

Id = 0
PPI = 96
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080

MainFormOnTaskbar = True


I will be grateful for help

Last edited by Aga; 08/04/22 08:49 PM.
Re: ORA-01804 on version 15.0,1.2051
Aga #64118 08/05/22 08:51 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
To verify that the Oracle Client is working correctly, can you start C:\app\client\akx\product\19.0.0\client_1\bin\sqplus.exe and try to connect? At the SQL*Plus prompts, enter:

Enter user-name: <username>@<database>
Enter password: <password>


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.128s Queries: 15 (0.049s) Memory: 2.4988 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-20 12:12:50 UTC
Valid HTML 5 and Valid CSS