Viewed 1000+ timesYou Asked Testing Oracle12c Standard Edition under Windows Server 2012R2 with Role Active Directory.After the ORADIM -NEW -startmode MANUAL, I try a SQLPLUS SYS/pwd AS SYSDBA and it takes 10 seconds to connect to the idle instance.I try with listener running and stopped.ORACLE_SID is initialized.I used procmon.exe to see what sqlplus.exe does and it has tried several times to connect via the network before it works.Why sqlplus does not connect directly to oracle whithout trying the network ???*** 2017-01-24 22:06:20.5032017-01-24 22:06:20.503: [ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 2*** 2017-01-24 22:06:22.5092017-01-24 22:06:22.509: [ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 2...Output from PROCMON"22:06:21,0329881","ORACLE.EXE","1660","TCP Reconnect","W2012R2.W2012R2dom.local:54344 -> W2012R2.W2012R2dom.local:61012","SUCCESS","Length: 0, seqnum: 0, connid: 0""22:06:21,5486093","ORACLE.EXE","1660","TCP Reconnect","W2012R2.W2012R2dom.local:54344 -> W2012R2.W2012R2dom.local:61012","SUCCESS","Length: 0, seqnum: 0, connid: 0""22:06:22,0642175","ORACLE.EXE","1660","TCP Reconnect","W2012R2.W2012R2dom.local:54345 -> W2012R2.W2012R2dom.local:61003","SUCCESS","Length: 0, seqnum: 0, connid: 0""22:06:22,5798467","ORACLE.EXE","1660","TCP Reconnect","W2012R2.W2012R2dom.local:54345 -> W2012R2.W2012R2dom.local:61003","SUCCESS","Length: 0, seqnum: 0, connid: 0""22:06:23,0954456","ORACLE.EXE","1660","TCP Reconnect","W2012R2.W2012R2dom.local:54346 -> W2012R2.W2012R2dom.local:61012","SUCCESS","Length: 0, seqnum: 0, connid: 0""22:06:23,5954550","ORACLE.EXE","1660","TCP Reconnect","W2012R2.W2012R2dom.local:54346 -> W2012R2.W2012R2dom.local:61012","SUCCESS","Length: 0, seqnum: 0, connid: 0""22:06:24,1110820","ORACLE.EXE","1660","TCP Reconnect","W2012R2.W2012R2dom.local:54347 -> W2012R2.W2012R2dom.local:61003","SUCCESS","Length: 0, seqnum: 0, connid: 0""22:06:24,6267100","ORACLE.EXE","1660","TCP Reconnect","W2012R2.W2012R2dom.local:54347 -> W2012R2.W2012R2dom.local:61003","SUCCESS","Length: 0, seqnum: 0, connid: 0"Sorry for my english.Thanks. and Connor said...You might be suffering from this issueSlow Start of Sqlplus if Database is Down (Doc ID 2197760.1) To BottomTo Bottom APPLIES TO:SQL*Plus - Version 12.1.0.2 and laterInformation in this document applies to any platform.SYMPTOMSWhen database is down, sqlplus command has a delay of 1.5 minutes. However, when database is up, sqlplus responds immediately. CHANGES Upgraded database from 11g to 12c.( Fresh install of 12c DB does not show the issue.)CAUSEYou are encountering known issue:Bug 20562898 - CONN / AS SYSDBA TAKES MORE THAN A MINUTE ON A NOT STARTED INSTANCE SOLUTIONThe problem reproduces when neither of these files exist:$ORACLE_HOME/network/admin/ldap.oraor$ORACLE_HOME/ldap/admin/ldap.oraWorkaround:Copy the ldap.ora.sample file to ldap.ora. Solution:Apply patch for Bug 20562898. Rating (1 rating)Is this answer out of date? If it is, please let us know via a Comment Comments Comment Marc OTTEVAERE, January 25, 2017 - 11:44 am UTC
Key software oracle olr cannot be opened.error 2
Hi, I have installed oracle db 19c in my local few months ago. It was working fine but suddenly am not able to connect or open db. in the log files am seeing below error. couldnt figure it out. any help would be greatly appreciated.TNSLSNR.LOG[ GIPCNET][6504] gipcmodNetworkAsyncComplete: [network] error for endp 00000152A1C39F10, req 00000152A1C2A1E0, type sgipcnreqtypeConnect (1), data 0000000000000000, sret sgipcretConnectionRefused (28)2022-11-16 09:17:29.789: [ GIPCNET][6504] gipcmodNetworkAsyncComplete: slos op : sgipcwWait2022-11-16 09:17:29.789: [ GIPCNET][6504] gipcmodNetworkAsyncComplete: slos dep : The remote computer refused the network connection. (1225)2022-11-16 09:17:29.789: [ GIPCNET][6504] gipcmodNetworkAsyncComplete: slos loc : GetQueueComp2022-11-16 09:17:29.789: [ GIPCNET][6504] gipcmodNetworkAsyncComplete: slos info: failed for over 00000152A0A800C0[ default][6504]u_set_comp_error: comptype '103' : error '29'2022-11-16 09:17:29.790: [ default][6504]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 2
To make Oracle on Windows automatically start and stops we use these registry parameters: hkey_local_machine->software->oracle->key_home_name->ora_sid_autostartand hkey_local_machine->software->oracle->key_home_name->ora_sid_shutdownAlso, the registry hkey_local_machine->software->oracle->key_home_name holds some other very useful entries:
When you install Oracle there are a set of registry entries under hkey_local_machine, software, oracle. If you don't have the registry, and don't want the Oracle home, then you can just delete the directories. There is an Oracle directory under program files, which stores your Oracle Inventory, and your Oracle Home where ever you put that. 2ff7e9595c
Comments