Home » Server Options » RAC & Failsafe » Oracle 11.2.0.3 RAC - after upgrade cannot start database - TNS protocol error (11.2.0.3)
 Oracle 11.2.0.3 RAC - after upgrade cannot start database - TNS protocol error [message #623538] |
Thu, 11 September 2014 05:26  |
 |
superuser
Messages: 15
Registered: August 2014
|
Junior Member |
|
|
Hello,
I installed patch 32 for Oracle 11.2.0.3.
Unfortunately after patch i cannot start database on NODE2. On node 1 database is OPEN.
Some info:
NODE1: wrooratel01
NODE2: wrooratel02
Databse name: TNORA
Instance names: TNORA1 and TNORA2
Logs:
C:\Windows\system32>crsctl start res ora.tnora.db -n wrooratel02
CRS-2672: Attempting to start 'ora.tnora.db' on 'wrooratel02'
ORA-12560: TNS:protocol adapter error
CRS-5017: The resource action "ora.tnora.db start" encountered the following error:
ORA-12560: TNS:protocol adapter error
. For details refer to "(:CLSN00107:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log".
CRS-2674: Start of 'ora.tnora.db' on 'wrooratel02' failed
CRS-2679: Attempting to clean 'ora.tnora.db' on 'wrooratel02'
ORA-12560: TNS:protocol adapter error
CRS-2681: Clean of 'ora.tnora.db' on 'wrooratel02' succeeded
CRS-4000: Command Start failed, or completed with errors.
C:\Windows\system32>crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE wrooratel01
ONLINE ONLINE wrooratel02
ora.FLASH.dg
ONLINE ONLINE wrooratel01
ONLINE ONLINE wrooratel02
ora.LISTENER.lsnr
ONLINE ONLINE wrooratel01
ONLINE ONLINE wrooratel02
ora.OCR.dg
ONLINE ONLINE wrooratel01
ONLINE ONLINE wrooratel02
ora.asm
ONLINE ONLINE wrooratel01 Started
ONLINE ONLINE wrooratel02 Started
ora.gsd
OFFLINE OFFLINE wrooratel01
OFFLINE OFFLINE wrooratel02
ora.net1.network
ONLINE ONLINE wrooratel01
ONLINE ONLINE wrooratel02
ora.ons
ONLINE ONLINE wrooratel01
ONLINE ONLINE wrooratel02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE wrooratel02
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE wrooratel01
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE wrooratel01
ora.cvu
1 ONLINE ONLINE wrooratel01
ora.oc4j
1 ONLINE ONLINE wrooratel01
ora.scan1.vip
1 ONLINE ONLINE wrooratel02
ora.scan2.vip
1 ONLINE ONLINE wrooratel01
ora.scan3.vip
1 ONLINE ONLINE wrooratel01
ora.tnora.db
1 ONLINE ONLINE wrooratel01 Open
2 ONLINE OFFLINE Instance Shutdown
ora.twora.db
1 OFFLINE OFFLINE
2 ONLINE OFFLINE Instance Shutdown
ora.wrooratel01.vip
1 ONLINE ONLINE wrooratel01
ora.wrooratel02.vip
1 ONLINE ONLINE wrooratel02
C:\Windows\system32>lsnrctl stat
LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 10-SEP-2014 14:45:32
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
Start Date 10-SEP-2014 14:23:43
Uptime 0 days 0 hr. 21 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File e:\oracle\11.2.0\grid\network\admin\listener.ora
Listener Log File e:\oracle\11.2.0\grid\log\diag\tnslsnr\WROORATEL02\listener_scan1\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\LISTENER_SCAN1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.17.11.221)(PORT=1521)))
Services Summary...
Service "TNORA" has 1 instance(s).
Instance "tnora1", status READY, has 1 handler(s) for this service...
Service "TNORAXDB" has 1 instance(s).
Instance "tnora1", status READY, has 1 handler(s) for this service...
Service "TWORA" has 1 instance(s).
Instance "twora1", status READY, has 1 handler(s) for this service...
Service "TWORAXDB" has 1 instance(s).
Instance "twora1", status READY, has 1 handler(s) for this service...
The command completed successfully
Please help..
[Updated on: Thu, 11 September 2014 05:29] Report message to a moderator |
|
|
|
|
|
| Re: Oracle 11.2.0.3 RAC - after upgrade cannot start database - TNS protocol error [message #623544 is a reply to message #623543] |
Thu, 11 September 2014 06:28  |
|
superuser
Messages: 15
Registered: August 2014
|
Junior Member |
|
|
I can not connect to instance on node2:
C:\Windows\system32>set oracle_Sid=tnora2
C:\Windows\system32>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 11 13:24:57 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: ^C
C:\Windows\system32>
But tnsping is working:
C:\Windows\system32>tnsping tnora
TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 11-SEP-2
014 13:29:52
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
e:\oracle\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WROORASC
ANT100.XXXXXX-cant show domain at public forum)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVIC
E_NAME = TNORA)))
OK (10 msec) [Updated on: Thu, 11 September 2014 06:31] Report message to a moderator |
|
|
|
|
|
| Re: Oracle 11.2.0.3 RAC - after upgrade cannot start database - TNS protocol error [message #623546 is a reply to message #623545] |
Thu, 11 September 2014 06:42 |
|
superuser
Messages: 15
Registered: August 2014
|
Junior Member |
|
|
This is RAC, so i think i shouldnt doing this manualy in services.msc. Anyway this method dont work:
---------------------------
Services
---------------------------
Windows could not start the OracleServiceTNORA2 service on Local Computer.
Error 1053: The service did not respond to the start or control request in a timely fashion.
---------------------------
OK
---------------------------
Additional error from Event Viewer:
A timeout was reached (30000 milliseconds) while waiting for the OracleServiceTNORA2 service to connect.
[Updated on: Thu, 11 September 2014 06:49] Report message to a moderator |
|
|
|
|
|
| Re: Oracle 11.2.0.3 RAC - after upgrade cannot start database - TNS protocol error [message #623551 is a reply to message #623547] |
Thu, 11 September 2014 07:01 |
|
superuser
Messages: 15
Registered: August 2014
|
Junior Member |
|
|
Excusme me, Thank You for your help:)
If iam right, alert is in: E:\oracle\11.2.0\grid\log\wrooratel02?
If Yes, there is no helpful messages in alert, last is at 11:37am today, bacause i restarted listener, crs and whole server):
014-09-11 10:48:46.633:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(2492)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 10:48:46.661:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(2996)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 10:49:25.281:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5916)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 10:50:05.199:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5748)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 10:52:49.727:
[ctssd(5200)]CRS-2409:The clock on host wrooratel02 is not synchronous with the mean cluster time. No action has been taken as the Cluster Time Synchronization Service is running in observer mode.
2014-09-11 11:12:50.844:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5748)]CRS-5020:Not all endpoints are registered for listener LISTENER_SCAN1
2014-09-11 11:13:56.222:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5916)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:13:56.233:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(2492)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:15:42.487:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5748)]CRS-5016:Process "e:\oracle\11.2.0\grid\opmn\bin\onsctli.bat" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:15:42.646:
[e:\oracle\11.2.0\grid\bin\orarootagent.exe(4620)]CRS-5822:Agent 'e:\oracle\11.2.0\grid\bin\orarootagent.exe_nt authority\system' disconnected from server. Details at (:CRSAGF00117:) {0:2:813} in e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\orarootagent\orarootagent.log.
2014-09-11 11:15:43.568:
[mdnsd(4700)]CRS-5602:mDNS service stopping by request.
2014-09-11 11:15:43.570:
[ctssd(5124)]CRS-2405:The Cluster Time Synchronization Service on host wrooratel02 is shutdown by user
2014-09-11 11:16:02.117:
[cssd(4316)]CRS-1603:CSSD on node wrooratel02 shutdown by user.
2014-09-11 11:16:02.226:
[ohasd(4124)]CRS-2767:Resource state recovery not attempted for 'ora.cssdmonitor' as its target state is OFFLINE
2014-09-11 11:16:02.226:
[ohasd(4124)]CRS-2769:Unable to failover resource 'ora.cssdmonitor'.
2014-09-11 11:16:02.335:
[cssd(4316)]CRS-1660:The CSS daemon shutdown has completed
2014-09-11 11:16:06.516:
[gpnpd(4800)]CRS-2329:GPNPD on node wrooratel02 shutdown.
2014-09-11 11:16:36.760:
[ohasd(3460)]CRS-2112:The OLR service started on node wrooratel02.
2014-09-11 11:16:36.807:
[ohasd(3460)]CRS-1301:Oracle High Availability Service started on node wrooratel02.
2014-09-11 11:16:36.807:
[ohasd(1408)]CRS-8017:location: e:\oracle\11.2.0\grid\log\wrooratel02\lastgasp has 2 reboot advisory log files, 0 were announced and 0 errors occurred
2014-09-11 11:16:43.062:
[gpnpd(5652)]CRS-2328:GPNPD started on node wrooratel02.
2014-09-11 11:16:47.518:
[cssd(2996)]CRS-1713:CSSD daemon is started in clustered mode
2014-09-11 11:16:59.819:
[cssd(2996)]CRS-1707:Lease acquisition for node wrooratel02 number 2 completed
2014-09-11 11:17:01.623:
[cssd(2996)]CRS-1605:CSSD voting file is online: \\.\ORCLDISKOCR0; details in e:\oracle\11.2.0\grid\log\wrooratel02\cssd\ocssd.log.
2014-09-11 11:17:04.260:
[cssd(5540)]CRS-1601:CSSD Reconfiguration complete. Active nodes are wrooratel01 wrooratel02 .
2014-09-11 11:17:09.297:
[ctssd(5448)]CRS-2403:The Cluster Time Synchronization Service on host wrooratel02 is in observer mode.
2014-09-11 11:17:13.068:
[ctssd(5032)]CRS-2407:The new Cluster Time Synchronization Service reference node is host wrooratel01.
2014-09-11 11:17:13.069:
[ctssd(5448)]CRS-2401:The Cluster Time Synchronization Service started on host wrooratel02.
2014-09-11 11:17:13.076:
[ctssd(3852)]CRS-2409:The clock on host wrooratel02 is not synchronous with the mean cluster time. No action has been taken as the Cluster Time Synchronization Service is running in observer mode.
2014-09-11 11:17:29.340:
[ohasd(2108)]CRS-2765:Resource 'ora.mdnsd' has failed on server 'wrooratel02'.
2014-09-11 11:17:29.757:
[e:\oracle\11.2.0\grid/bin/oraagent.exe(4732)]CRS-5822:Agent 'e:\oracle\11.2.0\grid/bin/oraagent.exe_nt authority\system' disconnected from server. Details at (:CRSAGF00117:) {0:5:5} in e:\oracle\11.2.0\grid\log\wrooratel02\agent\ohasd\oraagent\oraagent.log.
2014-09-11 11:17:29.757:
[e:\oracle\11.2.0\grid/bin/orarootagent.exe(5388)]CRS-5822:Agent 'e:\oracle\11.2.0\grid/bin/orarootagent.exe_nt authority\system' disconnected from server. Details at (:CRSAGF00117:) {0:6:5} in e:\oracle\11.2.0\grid\log\wrooratel02\agent\ohasd\orarootagent\orarootagent.log.
2014-09-11 11:17:29.758:
[e:\oracle\11.2.0\grid/bin/cssdagent.exe(5992)]CRS-5822:Agent 'e:\oracle\11.2.0\grid/bin/cssdagent.exe_nt authority\system' disconnected from server. Details at (:CRSAGF00117:) {0:8:3} in e:\oracle\11.2.0\grid\log\wrooratel02\agent\ohasd\oracssdagent_system\oracssdagent_system.log.
2014-09-11 11:17:29.758:
[e:\oracle\11.2.0\grid/bin/cssdmonitor.exe(6408)]CRS-5822:Agent 'e:\oracle\11.2.0\grid/bin/cssdmonitor.exe_nt authority\system' disconnected from server. Details at (:CRSAGF00117:) {0:7:5} in e:\oracle\11.2.0\grid\log\wrooratel02\agent\ohasd\oracssdmonitor_system\oracssdmonitor_system.log.
2014-09-11 11:20:12.580:
[ohasd(1892)]CRS-2112:The OLR service started on node wrooratel02.
2014-09-11 11:20:12.642:
[ohasd(1892)]CRS-1301:Oracle High Availability Service started on node wrooratel02.
2014-09-11 11:20:12.658:
[ohasd(4872)]CRS-8017:location: e:\oracle\11.2.0\grid\log\wrooratel02\lastgasp has 2 reboot advisory log files, 0 were announced and 0 errors occurred
2014-09-11 11:20:19.977:
[gpnpd(4000)]CRS-2328:GPNPD started on node wrooratel02.
2014-09-11 11:20:25.002:
[cssd(3916)]CRS-1713:CSSD daemon is started in clustered mode
2014-09-11 11:20:35.623:
[cssd(3916)]CRS-1707:Lease acquisition for node wrooratel02 number 2 completed
2014-09-11 11:20:37.512:
[cssd(3916)]CRS-1605:CSSD voting file is online: \\.\ORCLDISKOCR0; details in e:\oracle\11.2.0\grid\log\wrooratel02\cssd\ocssd.log.
2014-09-11 11:21:03.689:
[cssd(2332)]CRS-1601:CSSD Reconfiguration complete. Active nodes are wrooratel02 .
2014-09-11 11:21:05.093:
[cssd(4104)]CRS-1601:CSSD Reconfiguration complete. Active nodes are wrooratel01 wrooratel02 .
2014-09-11 11:21:05.940:
[ctssd(2540)]CRS-2403:The Cluster Time Synchronization Service on host wrooratel02 is in observer mode.
2014-09-11 11:21:08.175:
[ctssd(5164)]CRS-2407:The new Cluster Time Synchronization Service reference node is host wrooratel02.
2014-09-11 11:21:08.175:
[ctssd(2540)]CRS-2401:The Cluster Time Synchronization Service started on host wrooratel02.
2014-09-11 11:21:59.118:
[crsd(2956)]CRS-1012:The OCR service started on node wrooratel02.
2014-09-11 11:21:59.220:
[evmd(5224)]CRS-1401:EVMD started on node wrooratel02.
2014-09-11 11:22:02.365:
[crsd(2956)]CRS-1201:CRSD started on node wrooratel02.
2014-09-11 11:22:03.845:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5824)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:22:03.845:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5788)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:22:03.845:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5852)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:22:03.853:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(1440)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:22:06.046:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5576)]CRS-5016:Process "e:\oracle\11.2.0\grid\opmn\bin\onsctli.bat" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:22:06.169:
[crsd(5304)]CRS-2772:Server 'wrooratel02' has been assigned to pool 'Generic'.
2014-09-11 11:22:06.172:
[crsd(5304)]CRS-2772:Server 'wrooratel02' has been assigned to pool 'ora.TWORA'.
2014-09-11 11:22:06.173:
[crsd(5304)]CRS-2772:Server 'wrooratel02' has been assigned to pool 'ora.TNORA'.
2014-09-11 11:22:07.176:
[client(2368)]CRS-4743:File E:\oracle\11.2.0\grid\oc4j\j2ee\home\OC4J_DBWLM_config\system-jazn-data.xml was updated from OCR(Size: 13384(New), 13385(Old) bytes)
2014-09-11 11:22:12.380:
[crsd(5304)]CRS-2765:Resource 'ora.net1.network' has failed on server 'wrooratel02'.
2014-09-11 11:22:28.012:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5624)]CRS-5020:Not all endpoints are registered for listener LISTENER
2014-09-11 11:22:28.023:
[crsd(5304)]CRS-2772:Server 'wrooratel01' has been assigned to pool 'Generic'.
2014-09-11 11:22:28.024:
[crsd(5304)]CRS-2772:Server 'wrooratel01' has been assigned to pool 'ora.TWORA'.
2014-09-11 11:22:28.025:
[crsd(5304)]CRS-2772:Server 'wrooratel01' has been assigned to pool 'ora.TNORA'.
2014-09-11 11:22:31.587:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5836)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:23:58.341:
[crsd(5304)]CRS-2807:Resource 'ora.tnora.db' failed to start automatically.
2014-09-11 11:37:22.987:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5624)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:37:50.054:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5576)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
2014-09-11 11:37:51.238:
[e:\oracle\11.2.0\grid\bin\oraagent.exe(5556)]CRS-5016:Process "e:\oracle\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "e:\oracle\11.2.0\grid\bin\oraagent.exe" for action "check" failed: details at "(:CLSN00010:)" in "e:\oracle\11.2.0\grid\log\wrooratel02\agent\crsd\oraagent\oraagent.log"
[Updated on: Thu, 11 September 2014 07:01] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Oracle 11.2.0.3 RAC - after upgrade cannot start database - TNS protocol error [message #623560 is a reply to message #623557] |
Thu, 11 September 2014 07:46 |
|
superuser
Messages: 15
Registered: August 2014
|
Junior Member |
|
|
Unfortunately now iam the main admin, cause previos changed work...
Anyway:
another log:
E:\oracle\oracle.rac\diag\clients\user_oracle.rac\host_2321774204_80\trace\sqlnet.log
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracletnora2)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=tnora2)(CID=(PROGRAM=e:\oracle\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=WROORATEL02)(USER=oracle.rac))))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 11-SEP-2014 13:24:57
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 203
nt OS err code: 0[Updated on: Thu, 11 September 2014 07:51] Report message to a moderator |
|
|
|
|
|
Goto Forum:
Current Time: Sat May 03 10:56:19 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
