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 Go to next message
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 #623543 is a reply to message #623538] Thu, 11 September 2014 06:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
What happens when you try to start the instance with SQL*Plus? what is at the end of the instance's alert log?
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 Go to previous messageGo to next message
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 #623545 is a reply to message #623544] Thu, 11 September 2014 06:39 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Have you started the Windows service under which instance runs?
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 Go to previous messageGo to next message
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 #623547 is a reply to message #623546] Thu, 11 September 2014 06:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You have still not shown the alert log (or said "thank you for trying to assist").
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 Go to previous messageGo to next message
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 #623552 is a reply to message #623551] Thu, 11 September 2014 07:13 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I said the instance's alert log. You have shown the GI alert log.
Re: Oracle 11.2.0.3 RAC - after upgrade cannot start database - TNS protocol error [message #623554 is a reply to message #623552] Thu, 11 September 2014 07:22 Go to previous messageGo to next message
superuser
Messages: 15
Registered: August 2014
Junior Member
I hope i found file that You are asking:
E:\oracle\oracle.rac\diag\rdbms\tnora\tnora2\alert\log.xml

Last message is from yesterday, when i shutdown instance before install patch:
<msg time='2014-09-10T08:21:16.306+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='opistp_real:1762:1141351617' client_id='' type='NOTIFICATION'
 group='shutdown' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Shutting down instance (immediate)
 </txt>
</msg>
<msg time='2014-09-10T08:21:16.353+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='ksb_shut_detached_process:3334:3107995654' client_id='' type='NOTIFICATION'
 group='process end' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Stopping background process SMCO
 </txt>
</msg>
<msg time='2014-09-10T08:21:16.384+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='opistp_real:1835:3814512043' client_id='' type='NOTIFICATION'
 group='shutdown' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Shutting down instance: further logons disabled
 </txt>
</msg>
<msg time='2014-09-10T08:21:16.478+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='ksb_shut_detached_process:3334:3107995654' client_id='' type='NOTIFICATION'
 group='process end' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Stopping background process QMNC
 </txt>
</msg>
<msg time='2014-09-10T08:21:16.556+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='ksb_shut_detached_process:3334:3107995654' client_id='' type='NOTIFICATION'
 group='process end' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Stopping background process MMNL
 </txt>
</msg>
<msg time='2014-09-10T08:21:16.478+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='kkjshth:3846:4141434602' client_id='' type='NOTIFICATION'
 group='process end' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='' pid='11756'>
 <txt>Stopping background process CJQ0
 </txt>
</msg>
<msg time='2014-09-10T08:21:17.585+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='ksb_shut_detached_process:3334:3107995654' client_id='' type='NOTIFICATION'
 group='process end' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Stopping background process MMON
 </txt>
</msg>
<msg time='2014-09-10T08:21:17.616+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='opistp_real:2114:2031367711' client_id='' type='NOTIFICATION'
 group='shutdown' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>License high water mark = 7
 </txt>
</msg>
<msg time='2014-09-10T08:21:17.835+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module='oraagent.exe'
 pid='12740'>
 <txt>All dispatchers and shared servers shutdown
 </txt>
</msg>
<msg time='2014-09-10T08:21:17.944+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='opiexe:2999:4222364190' client_id='' type='NOTIFICATION'
 group='admin_ddl' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>ALTER DATABASE CLOSE NORMAL /* db agent *//* {1:21659:1677} */
 </txt>
</msg>
<msg time='2014-09-10T08:21:17.975+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='9412'>
 <txt>SMON: disabling tx recovery
 </txt>
</msg>
<msg time='2014-09-10T08:21:18.443+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='9412'>
 <txt>SMON: disabling cache recovery
 </txt>
</msg>
<msg time='2014-09-10T08:21:18.474+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='10368'>
 <txt>NOTE: Deferred communication with ASM instance
 </txt>
</msg>
<msg time='2014-09-10T08:21:18.522+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='10368'>
 <txt>NOTE: deferred map free for map id 11
 </txt>
</msg>
<msg time='2014-09-10T08:21:19.645+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='krso_proc_stop:2124:825284245' client_id='' type='NOTIFICATION'
 group='shutdown' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='' pid='10368'>
 <txt>Shutting down archive processes
 </txt>
</msg>
<msg time='2014-09-10T08:21:19.785+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='krso_proc_stop:2151:1369042098' client_id='' type='NOTIFICATION'
 group='shutdown' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='' pid='10368'>
 <txt>Archiving is disabled
 </txt>
</msg>
<msg time='2014-09-10T08:21:19.832+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='krso_proc_stop:2175:139982718' client_id='' type='NOTIFICATION'
 group='shutdown' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='' pid='10368'>
 <txt>Archive process shutdown avoided: 0 active
 </txt>
</msg>
<msg time='2014-09-10T08:21:19.879+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='10368'>
 <txt>Thread 2 closed at log sequence 4
 </txt>
</msg>
<msg time='2014-09-10T08:21:19.925+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='10368'>
 <txt>Successful close of redo thread 2
 </txt>
</msg>
<msg time='2014-09-10T08:21:19.972+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='11636'>
 <txt>NOTE: Deferred communication with ASM instance
 </txt>
</msg>
<msg time='2014-09-10T08:21:20.003+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='11636'>
 <txt>NOTE: deferred map free for map id 4
 </txt>
</msg>
<msg time='2014-09-10T08:21:20.737+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='opiexe:3070:2802784106' client_id='' type='NOTIFICATION'
 group='admin_ddl' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Completed: ALTER DATABASE CLOSE NORMAL /* db agent *//* {1:21659:1677} */
 </txt>
</msg>
<msg time='2014-09-10T08:21:20.768+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='opiexe:2999:4222364190' client_id='' type='NOTIFICATION'
 group='admin_ddl' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>ALTER DATABASE DISMOUNT /* db agent *//* {1:21659:1677} */
 </txt>
</msg>
<msg time='2014-09-10T08:21:20.815+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='krso_proc_stop:2124:825284245' client_id='' type='NOTIFICATION'
 group='shutdown' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Shutting down archive processes
 </txt>
</msg>
<msg time='2014-09-10T08:21:20.846+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='krso_proc_stop:2151:1369042098' client_id='' type='NOTIFICATION'
 group='shutdown' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Archiving is disabled
 </txt>
</msg>
<msg time='2014-09-10T08:21:20.893+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='12004'>
 <txt>NOTE: Deferred communication with ASM instance
 </txt>
</msg>
<msg time='2014-09-10T08:21:20.924+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='12004'>
 <txt>NOTE: deferred map free for map id 2
 </txt>
</msg>
<msg time='2014-09-10T08:21:20.939+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='10380'>
 <txt>NOTE: Deferred communication with ASM instance
 </txt>
</msg>
<msg time='2014-09-10T08:21:21.080+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='opiexe:3070:2802784106' client_id='' type='NOTIFICATION'
 group='admin_ddl' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='oraagent.exe' pid='12740'>
 <txt>Completed: ALTER DATABASE DISMOUNT /* db agent *//* {1:21659:1677} */
 </txt>
</msg>
<msg time='2014-09-10T08:21:21.220+02:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' pid='12740'>
 <txt>ARCH: Archival disabled due to shutdown: 1089
 </txt>
</msg>
<msg time='2014-09-10T08:21:21.251+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='krso_proc_stop:2124:825284245' type='NOTIFICATION' group='shutdown'
 level='16' host_id='WROORATEL02' host_addr='172.17.11.221'
 pid='12740'>
 <txt>Shutting down archive processes
 </txt>
</msg>
<msg time='2014-09-10T08:21:21.283+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='krso_proc_stop:2151:1369042098' type='NOTIFICATION' group='shutdown'
 level='16' host_id='WROORATEL02' host_addr='172.17.11.221'
 pid='12740'>
 <txt>Archiving is disabled
 </txt>
</msg>
<msg time='2014-09-10T08:21:21.329+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='10380'>
 <txt>NOTE: force a map free for map id 2
 </txt>
</msg>
<msg time='2014-09-10T08:21:22.328+02:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' pid='12740'>
 <txt>ARCH: Archival disabled due to shutdown: 1089
 </txt>
</msg>
<msg time='2014-09-10T08:21:22.343+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='12100'>
 <txt>Stopping background process VKTM
 </txt>
</msg>
<msg time='2014-09-10T08:21:22.375+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='krso_proc_stop:2124:825284245' type='NOTIFICATION' group='shutdown'
 level='16' host_id='WROORATEL02' host_addr='172.17.11.221'
 pid='12740'>
 <txt>Shutting down archive processes
 </txt>
</msg>
<msg time='2014-09-10T08:21:22.406+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='krso_proc_stop:2151:1369042098' type='NOTIFICATION' group='shutdown'
 level='16' host_id='WROORATEL02' host_addr='172.17.11.221'
 pid='12740'>
 <txt>Archiving is disabled
 </txt>
</msg>
<msg time='2014-09-10T08:21:22.437+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='12944'>
 <txt>NOTE: Shutting down MARK background process
 </txt>
</msg>
<msg time='2014-09-10T08:21:23.716+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt>Reconfiguration started (old inc 3, new inc 5)
 </txt>
</msg>
<msg time='2014-09-10T08:21:23.763+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt>List of instances:
 </txt>
</msg>
<msg time='2014-09-10T08:21:23.794+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> 2 (myinst: 2) 
 </txt>
</msg>
<msg time='2014-09-10T08:21:23.841+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Global Resource Directory frozen
 </txt>
</msg>
<msg time='2014-09-10T08:21:23.872+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> * dead instance detected - domain 0 invalid = TRUE 
 </txt>
</msg>
<msg time='2014-09-10T08:21:23.903+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Communication channels reestablished
 </txt>
</msg>
<msg time='2014-09-10T08:21:23.950+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Master broadcasted resource hash value bitmaps
 </txt>
</msg>
<msg time='2014-09-10T08:21:23.981+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Non-local Process blocks cleaned out
 </txt>
</msg>
<msg time='2014-09-10T08:21:24.028+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='kjblrcancel:6073:2514186345' client_id='' type='NOTIFICATION'
 group='gcs_lock' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='' pid='11236'>
 <txt> LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 </txt>
</msg>
<msg time='2014-09-10T08:21:24.028+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='kjblrcancel:6073:2514186345' client_id='' type='NOTIFICATION'
 group='gcs_lock' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' module='' pid='12272'>
 <txt> LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.089+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Set master node info 
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.120+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Submitted all remote-enqueue requests
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.136+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Dwn-cvts replayed, VALBLKs dubious
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.167+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> All grantable enqueues granted
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.198+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Post SMON to start 1st pass IR
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.229+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Submitted all GCS remote-cache requests
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.245+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Post SMON to start 1st pass IR
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.276+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt> Fix write in gcs resources
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.432+02:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='WROORATEL02' host_addr='172.17.11.221' module=''
 pid='3852'>
 <txt>Reconfiguration complete
 </txt>
</msg>
<msg time='2014-09-10T08:21:25.994+02:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='WROORATEL02'
 host_addr='172.17.11.221' pid='3852'>
 <txt>freeing rdom 0
 </txt>
</msg>
<msg time='2014-09-10T08:21:28.053+02:00' org_id='oracle' comp_id='rdbms'
 msg_id='opistp_real:1651:503144415' type='NOTIFICATION' group='shutdown'
 level='16' host_id='WROORATEL02' host_addr='172.17.11.221'
 pid='12740'>
 <txt>Instance shutdown complete
 </txt>
</msg>
Re: Oracle 11.2.0.3 RAC - after upgrade cannot start database - TNS protocol error [message #623557 is a reply to message #623554] Thu, 11 September 2014 07:39 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Wrong file. You need to ask your DBA where the alert log is.
In any case, I'm out now. Perhaps someone else can assist.
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 Go to previous messageGo to next message
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

Re: Oracle 11.2.0.3 RAC - after upgrade cannot start database - TNS protocol error [message #623669 is a reply to message #623560] Fri, 12 September 2014 07:45 Go to previous message
superuser
Messages: 15
Registered: August 2014
Junior Member
problem solved. Patch on node2 goes wrong. Grid was patched ok, but database not. I copied binaries from node1 to node2 and it worked.
Previous Topic: Unable to to start One node
Next Topic: RAC 12c:ORA-01031: insufficient privileges as sys user
Goto Forum:
  


Current Time: Thu Mar 28 13:16:37 CDT 2024