ORA-01804 - Trying to connect to DB - pl/sql developer 12
- Thread starter Valdir
- Start date
This seems like an Oracle Client configuration issue. Can you start PL/SQL Developer without connecting, go to Help > Support Info and send me the text from the "Info" tab page?
Hi,
follow information at support info info and registry:
PL/SQL Developer
Version 12.0.7.1837 (64 bit)
01.113135 - 5 user license
Service Contract: 01/05/2018
Windows 10 Build 17134
Physical memory : 16,652,856 kB (8,724,076 available)
Paging file : 19,143,224 kB (10,279,812 available)
Virtual memory : 137,438,953,344 kB (137,434,377,340 available)
Parameters
C:\Program Files\PLSQL Developer 12\plsqldev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True
Preference Files
C:\Users\vamadeir\AppData\Roaming\PLSQL Developer 12\Preferences\default\Default.ini
C:\Users\vamadeir\AppData\Roaming\PLSQL Developer 12\Preferences\vamadeir\default.ini
License File
C:\Users\vamadeir\AppData\Roaming\PLSQL Developer\aalf.dat
Debug file
C:\Users\vamadeir\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf
Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)
Aliases
GPA_RMS14_106
GPA_RMS14_CONVA
GPA_RMS14_CONVC
GPA_RMS14_CONVD
GPA_RMS14_HOM530
...
Homes
OraClient12Home3 (c:\oracle)
OraClient12Home4 (C:\Oracle\app\client\vamadeir\product\12.1.0\client_1)
DLLs
C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\bin\oci.dll
TNS File
C:\oracle\app\client\vamadeir\product\12.1.0\client_1\network\admin\tnsnames.ora
Using
Home: OraClient12Home4
DLL: C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\bin\oci.dll
OCI: version 12.1 (12.1.0.2.0)
Process
Working Set = 139,309,056
Memory = 42,437,704
GDI Objects = 1213
User Objects = 356
Handles = 570
Monitor
PixelsPerInch = 144
Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080
MainFormOnTaskbar = False
-- REGISTRY
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
SOFTWARE\ORACLE\Explorer Extensions
Company = Oracle Corporation
OBEEPatch = 0
OBEEVersion = 2.0.1.912081
OBEEVersionNumber = 912081
Path = C:\Program Files\Oracle\Explorer Extensions\
User = Valdir Madeira
Version = 2.0.1.9.1
SOFTWARE\ORACLE\JavaDeploy
SOFTWARE\ORACLE\KEY_OraClient12Home1
ORACLE_HOME = C:\app\client\vamadeir\product\12.1.0\client_1
ORACLE_HOME_NAME = OraClient12Home1
ORACLE_GROUP_NAME = Oracle - OraClient12Home1
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = C:\app\client\vamadeir\product\12.1.0\client_1\oledb\mesg
ORACLE_HOME_TYPE = 2
ORACLE_SVCUSER = NT AUTHORITY\LOCAL SERVICE
ORACLE_SVCUSER_PWDREQ = 0
SQLPATH = C:\app\client\vamadeir\product\12.1.0\client_1\dbs
ORACLE_BASE = C:\app\client\vamadeir
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient12Home1
MSHELP_TOOLS = C:\app\client\vamadeir\product\12.1.0\client_1\MSHELP
SOFTWARE\ORACLE\KEY_OraClient12Home1\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\KEY_OraClient12Home2
ORACLE_HOME = C:\Valdir\Oracle
ORACLE_HOME_NAME = OraClient12Home2
ORACLE_GROUP_NAME = Oracle - OraClient12Home2
SOFTWARE\ORACLE\KEY_OraClient12Home3
ORACLE_HOME = c:\oracle
ORACLE_HOME_NAME = OraClient12Home3
ORACLE_GROUP_NAME = Oracle - OraClient12Home3
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = c:\oracle\oledb\mesg
ORACLE_HOME_TYPE = 2
ORACLE_SVCUSER = NT AUTHORITY\LOCAL SERVICE
ORACLE_SVCUSER_PWDREQ = 0
SQLPATH = c:\oracle\dbs
ORACLE_BASE = c:\app\client\vamadeir
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient12Home3
MSHELP_TOOLS = c:\oracle\MSHELP
SOFTWARE\ORACLE\KEY_OraClient12Home3\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\KEY_OraClient12Home4
ORACLE_HOME = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1
ORACLE_HOME_NAME = OraClient12Home4
ORACLE_GROUP_NAME = Oracle - OraClient12Home4
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\oledb\mesg
ORACLE_HOME_TYPE = 2
ORACLE_SVCUSER = NT AUTHORITY\LOCAL SERVICE
ORACLE_SVCUSER_PWDREQ = 0
SQLPATH = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\dbs
ORACLE_BASE = C:\Oracle\app\client\vamadeir
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient12Home4
MSHELP_TOOLS = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\MSHELP
SOFTWARE\ORACLE\KEY_OraClient12Home4\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\ODP.NET
SOFTWARE\ORACLE\ODP.NET\2.121.2.0
DllPath = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\bin
TraceFileName = C:\odpnet2.trc
TraceLevel = 0
TraceOption = 0
PromotableTransaction = promotable
SelfTuning = 1
StatementCacheWithUdts = 1
UdtCacheSize = 4096
PerformanceCounters = 0
MaxStatementCacheSize = 100
DemandOraclePermission = 0
SOFTWARE\ORACLE\ODP.NET\4.121.2.0
DllPath = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\bin
TraceFileName = C:\odpnet4.trc
TraceLevel = 0
TraceOption = 0
SelfTuning = 1
MaxStatementCacheSize = 100
DemandOraclePermission = 0
PerformanceCounters = 0
PromotableTransaction = promotable
StatementCacheWithUdts = 1
UdtCacheSize = 4096
SOFTWARE\ORACLE\ODP.NET.Managed
SOFTWARE\ORACLE\ODP.NET.Managed\4.122.1.0
TNS_ADMIN = c:\app\client\vamadeir\product\12.2.0\client_1\network\admin
SOFTWARE\ORACLE\Oracle Documents
SOFTWARE\ORACLE\Oracle Documents\CommandDLL
PathX64Release = C:\Program Files (x86)\Oracle\Oracle Content\desktop client\integration\office\x64\Command.dll
PathWin32Release = C:\Program Files (x86)\Oracle\Oracle Content\desktop client\integration\office\x86\Command.dll
SOFTWARE\ORACLE\Oracle Documents\DataBinderDLL
PathX64Release = C:\Program Files (x86)\Oracle\Oracle Content\desktop client\integration\office\x64\DataBinder.dll
PathWin32Release = C:\Program Files (x86)\Oracle\Oracle Content\desktop client\integration\office\x86\DataBinder.dll
Thanks
follow information at support info info and registry:
PL/SQL Developer
Version 12.0.7.1837 (64 bit)
01.113135 - 5 user license
Service Contract: 01/05/2018
Windows 10 Build 17134
Physical memory : 16,652,856 kB (8,724,076 available)
Paging file : 19,143,224 kB (10,279,812 available)
Virtual memory : 137,438,953,344 kB (137,434,377,340 available)
Parameters
C:\Program Files\PLSQL Developer 12\plsqldev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True
Preference Files
C:\Users\vamadeir\AppData\Roaming\PLSQL Developer 12\Preferences\default\Default.ini
C:\Users\vamadeir\AppData\Roaming\PLSQL Developer 12\Preferences\vamadeir\default.ini
License File
C:\Users\vamadeir\AppData\Roaming\PLSQL Developer\aalf.dat
Debug file
C:\Users\vamadeir\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf
Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)
Aliases
GPA_RMS14_106
GPA_RMS14_CONVA
GPA_RMS14_CONVC
GPA_RMS14_CONVD
GPA_RMS14_HOM530
...
Homes
OraClient12Home3 (c:\oracle)
OraClient12Home4 (C:\Oracle\app\client\vamadeir\product\12.1.0\client_1)
DLLs
C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\bin\oci.dll
TNS File
C:\oracle\app\client\vamadeir\product\12.1.0\client_1\network\admin\tnsnames.ora
Using
Home: OraClient12Home4
DLL: C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\bin\oci.dll
OCI: version 12.1 (12.1.0.2.0)
Process
Working Set = 139,309,056
Memory = 42,437,704
GDI Objects = 1213
User Objects = 356
Handles = 570
Monitor
PixelsPerInch = 144
Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080
MainFormOnTaskbar = False
-- REGISTRY
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
SOFTWARE\ORACLE\Explorer Extensions
Company = Oracle Corporation
OBEEPatch = 0
OBEEVersion = 2.0.1.912081
OBEEVersionNumber = 912081
Path = C:\Program Files\Oracle\Explorer Extensions\
User = Valdir Madeira
Version = 2.0.1.9.1
SOFTWARE\ORACLE\JavaDeploy
SOFTWARE\ORACLE\KEY_OraClient12Home1
ORACLE_HOME = C:\app\client\vamadeir\product\12.1.0\client_1
ORACLE_HOME_NAME = OraClient12Home1
ORACLE_GROUP_NAME = Oracle - OraClient12Home1
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = C:\app\client\vamadeir\product\12.1.0\client_1\oledb\mesg
ORACLE_HOME_TYPE = 2
ORACLE_SVCUSER = NT AUTHORITY\LOCAL SERVICE
ORACLE_SVCUSER_PWDREQ = 0
SQLPATH = C:\app\client\vamadeir\product\12.1.0\client_1\dbs
ORACLE_BASE = C:\app\client\vamadeir
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient12Home1
MSHELP_TOOLS = C:\app\client\vamadeir\product\12.1.0\client_1\MSHELP
SOFTWARE\ORACLE\KEY_OraClient12Home1\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\KEY_OraClient12Home2
ORACLE_HOME = C:\Valdir\Oracle
ORACLE_HOME_NAME = OraClient12Home2
ORACLE_GROUP_NAME = Oracle - OraClient12Home2
SOFTWARE\ORACLE\KEY_OraClient12Home3
ORACLE_HOME = c:\oracle
ORACLE_HOME_NAME = OraClient12Home3
ORACLE_GROUP_NAME = Oracle - OraClient12Home3
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = c:\oracle\oledb\mesg
ORACLE_HOME_TYPE = 2
ORACLE_SVCUSER = NT AUTHORITY\LOCAL SERVICE
ORACLE_SVCUSER_PWDREQ = 0
SQLPATH = c:\oracle\dbs
ORACLE_BASE = c:\app\client\vamadeir
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient12Home3
MSHELP_TOOLS = c:\oracle\MSHELP
SOFTWARE\ORACLE\KEY_OraClient12Home3\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\KEY_OraClient12Home4
ORACLE_HOME = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1
ORACLE_HOME_NAME = OraClient12Home4
ORACLE_GROUP_NAME = Oracle - OraClient12Home4
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\oledb\mesg
ORACLE_HOME_TYPE = 2
ORACLE_SVCUSER = NT AUTHORITY\LOCAL SERVICE
ORACLE_SVCUSER_PWDREQ = 0
SQLPATH = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\dbs
ORACLE_BASE = C:\Oracle\app\client\vamadeir
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient12Home4
MSHELP_TOOLS = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\MSHELP
SOFTWARE\ORACLE\KEY_OraClient12Home4\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\ODP.NET
SOFTWARE\ORACLE\ODP.NET\2.121.2.0
DllPath = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\bin
TraceFileName = C:\odpnet2.trc
TraceLevel = 0
TraceOption = 0
PromotableTransaction = promotable
SelfTuning = 1
StatementCacheWithUdts = 1
UdtCacheSize = 4096
PerformanceCounters = 0
MaxStatementCacheSize = 100
DemandOraclePermission = 0
SOFTWARE\ORACLE\ODP.NET\4.121.2.0
DllPath = C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\bin
TraceFileName = C:\odpnet4.trc
TraceLevel = 0
TraceOption = 0
SelfTuning = 1
MaxStatementCacheSize = 100
DemandOraclePermission = 0
PerformanceCounters = 0
PromotableTransaction = promotable
StatementCacheWithUdts = 1
UdtCacheSize = 4096
SOFTWARE\ORACLE\ODP.NET.Managed
SOFTWARE\ORACLE\ODP.NET.Managed\4.122.1.0
TNS_ADMIN = c:\app\client\vamadeir\product\12.2.0\client_1\network\admin
SOFTWARE\ORACLE\Oracle Documents
SOFTWARE\ORACLE\Oracle Documents\CommandDLL
PathX64Release = C:\Program Files (x86)\Oracle\Oracle Content\desktop client\integration\office\x64\Command.dll
PathWin32Release = C:\Program Files (x86)\Oracle\Oracle Content\desktop client\integration\office\x86\Command.dll
SOFTWARE\ORACLE\Oracle Documents\DataBinderDLL
PathX64Release = C:\Program Files (x86)\Oracle\Oracle Content\desktop client\integration\office\x64\DataBinder.dll
PathWin32Release = C:\Program Files (x86)\Oracle\Oracle Content\desktop client\integration\office\x86\DataBinder.dll
Thanks
Thanks. Can you start "C:\Oracle\app\client\vamadeir\product\12.1.0\client_1\bin\sqlplus.exe" and try to connect to the same database?
Similar threads
- Discussion
- Discussion
