ora 12560 TNS Protocol Adapter error after upgraded the oracle from 10.2.0.1 to 10.2.05

[Former Member]

Hi Experts,

     I am getting below error when run the "sqlplus" after upgraded the oracle from 10.2.0.1 to 10.2.0.5. Of course, during the installation, got stuck with one error which was skipped by click on "continue" and finally completed the upgrade. I checked so many threads which is related to this error but no one was helped. I am attaching below errors and sqlnet.ora and listener.ora file. please suggest how to resolve..

RTSOPS01:orabt2 20% sqlplus -version

SQL*Plus: Release 10.2.0.5.0 - Production

RTSOPS01:orabt2 21% sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 5 18:07:45 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name:

tnsnames.ora:

################

# Filename......: tnsnames.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

BT2.WORLD=

  (DESCRIPTION =

    (ADDRESS_LIST =

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = RTSOPS01)

          (PORT = 1527)

        )

    )

    (CONNECT_DATA =

       (SID = BT2)

       (GLOBAL_NAME = BT2.WORLD)

    )

  )

listener.ora:

################

# Filename......: listener.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

  (ADDRESS_LIST =

        (ADDRESS =

          (PROTOCOL = IPC)

          (KEY = BT2.WORLD)

        )

        (ADDRESS=

          (PROTOCOL = IPC)

          (KEY = BT2)

        )

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = 10.8.54.129)

          (PORT = 1527)

        )

  )

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = BT2)

      (ORACLE_HOME = /oracle/BT2/102_64)

    )

  )

================

Below is the error during installation phage which i skipped by press "Continue", Remaining process worked fine.

Please tell me which logs still need to publish...

Error (orainventory logs)

INFO: Start output from spawned process:

INFO: ----------------------------------

INFO:

INFO: chmod 755 /oracle/BT2/102_64/bin

INFO:

INFO:  - Linking Oracle

/

INFO: /oracle/BT2/102_64/lib//libserver10.a(vsnf.o)

INFO:

INFO: ld:

INFO: fatal:

INFO: symbol referencing errors. No output written to

INFO: /oracle/BT2/102_64/rdbms/lib/oracle

INFO:

INFO: *** Error code 1

INFO: make: Fatal error: Command failed for target `/oracle/BT2/102_64/rdbms/lib/oracle'

INFO: End output from spawned process.

INFO: ----------------------------------

INFO: Exception thrown from action: make

Exception Name: MakefileException

Exception String: Error in invoking target 'ioracle' of makefile '/oracle/BT2/102_64/rdbms/lib/ins_rdbms.mk'. See '/oracle/oraInventory/logs/i

nstallActions2014-03-04_07-24-32PM.log' for details.

Exception Severity: 1

INFO: The output of this make operation is also available at: '/oracle/BT2/102_64/install/make.log'

INFO:

INFO: Start output from spawned process:

INFO: ----------------------------------

INFO:

INFO: chmod 755 /oracle/BT2/102_64/bin

INFO:

INFO:  - Linking Oracle

INFO: rm -f /oracle/BT2/102_64/rdbms/lib/oracle

@

@

@

Regards

Santosh K

[Former Member]

Hi All,

     I have tried a lot but nothing helped me out. So i have crashed the server and installed fresh installation as it is test system.

     Thank you all for valuable suggestions...

Regards

Santosh K

[ahmed_ibrahim2]

dear santosh ,

check the following sap note

441518 - ORA-12560 composite SAP Note

1734700 - ORA-12560: TNS:protocol adapter error

304467 - Core dump / ORA-125XX with ReliantUnix and Oracle

Best Regards

AhMeD

[Former Member]

Check log file /oracle/oraInventory/logs/installActions2014-03-04_07-24-32PM.log for error details.

[Former Member]

Hi Roman,

     I have already provided the logs(see my first query) .

Error (orainventory logs)

INFO: Start output from spawned process:

INFO: ----------------------------------

INFO:

INFO: chmod 755 /oracle/BT2/102_64/bin

INFO:

INFO:  - Linking Oracle

/

INFO: /oracle/BT2/102_64/lib//libserver10.a(vsnf.o)

INFO:

INFO: ld:

INFO: fatal:

INFO: symbol referencing errors. No output written to

INFO: /oracle/BT2/102_64/rdbms/lib/oracle

INFO:

INFO: *** Error code 1

INFO: make: Fatal error: Command failed for target `/oracle/BT2/102_64/rdbms/lib/oracle'

INFO: End output from spawned process.

INFO: ----------------------------------

INFO: Exception thrown from action: make

Exception Name: MakefileException

Exception String: Error in invoking target 'ioracle' of makefile '/oracle/BT2/102_64/rdbms/lib/ins_rdbms.mk'. See '/oracle/oraInventory/logs/i

nstallActions2014-03-04_07-24-32PM.log' for details.

Exception Severity: 1

INFO: The output of this make operation is also available at: '/oracle/BT2/102_64/install/make.log'

INFO:

INFO: Start output from spawned process:

INFO: ----------------------------------

INFO:

INFO: chmod 755 /oracle/BT2/102_64/bin

INFO:

INFO:  - Linking Oracle

INFO: rm -f /oracle/BT2/102_64/rdbms/lib/oracle

@

@

@

Regards

Santosh K

[Reagan]

Hello

Try to relink the binaries and see if that helps.

su - orabt2

relink all

Regards

RB

[Former Member]

Hi Benjamin,

     Thanks for your quick reply. Just i have performed your command (relink all) but couldn't help.

I have given the master password which included the special character "@", is this creating issue..? if it is, can u confirm how to change this password and you know that database is down..

Waiting for Your Suggestion...

Regards

Santosh K

[Reagan]

Hello Santosh

I am not sure what master password you are mentioning here.

Could you provide the environment variables of the orabt2 user please ?

Regards

RB

[Former Member]

Hi,

Password is : Bt1@123

Environmental variables:

----------------------------------

RTSOPS01:orabt2 1% env

USER=orabt2

LOGNAME=orabt2

HOME=/export/home/orabt2

PATH=/oracle/BT2/102_64/bin:.:/export/home/orabt2:/usr/sap/BT2/SYS/exe/run:/usr/bin:/bin:/usr/ccs/bin:/usr/ucb

MAIL=/var/mail//orabt2

SHELL=/bin/csh

TZ=Asia/Calcutta

SSH_CLIENT=10.8.78.45 3591 22

SSH_CONNECTION=10.8.78.45 3591 10.8.54.129 22

SSH_TTY=/dev/pts/7

TERM=xterm

DISPLAY=localhost:15.0

PWD=/export/home/orabt2

SAPSYSTEMNAME=BT2

DIR_LIBRARY=/usr/sap/BT2/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/BT2/SYS/exe/run:/oracle/BT2/102_64/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=BT2

dbs_ora_schema=SAPSR3

ORACLE_SID=BT2

DB_SID=BT2

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/BT2/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/BT2

Regards

Santosh

[Reagan]

and for which user this password is for ?

Regards

RB

[Former Member]

Hi Reagan,

     That is master password for all users (ddic,sap*,SYS and sydba) who are created during installation phage..

Regards

Santosh K

[Reagan]

Hello Santosh

I don't think that could be reason for this error.

The last option I can suggest you is this.

Kill all processes running under orasid or if possible restart the server.

Once done connect to the database as follows.

su - orasid

sqlplus /nolog

connect /as sysdba

Let us know the outcome

Regards

RB

[Former Member]

Hi Reagan,

     Just i have rebooted(OS) the entire server, but No luck. Still i am facing the same issue.. below is the error after reboot.

SQL> connect /as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

Could you tell me still what we can do for this

Regards

Santosh K

[Reagan]

In that case you may re-install the latest patchset of 10G and apply the latest SBP and see if that helps.

Regards

RB

[Former Member]

Hi Experts,

     Still I am waiting for your suggestions... I have searched many threads but no help. So please respond how to resolve the issue...

Regards

Santosh K

[Former Member]

Hi Santosh,

Have u done the post upgrade steps ? If no please follow below steps :

a. Log in as the Oracle software owner user

 b. For single-instance installations, start the listener as follows
 $ lsnrctl start
 

c. For single-instance installations, use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
 $ sqlplus /nolog 
 SQL> CONNECT SYS AS SYSDBA
 Enter password:SYS_password
 Enter the following SQL*Plus commands:
 SQL> STARTUP UPGRADE
 SQL> SPOOL patch.log
 SQL> @?/rdbms/admin/catupgrd.sql
 SQL> SPOOL OFF
 

d. Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.
 

e. This list provides the version and status of each SERVER component in the database.
 

f. If necessary, rerun the catupgrd.sql script after correcting any problems.



g. Restart the database:
 SQL> SHUTDOWN IMMEDIATE
 SQL> STARTUP
 

h. Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
 SQL> @?/rdbms/admin/utlrp.sql
 

i. Run the following command to check the status of all the components after the upgrade:
 SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
 In the output of the preceding command, the status of all the components should be VALID for a successful upgrade

[Former Member]

Hi Islam,

     I got the same error that is related to "TNS protocol adapter error"

RTSOPS01:orabt2 1% sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Mar 7 19:36:24 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> connect sys as sysdba

Enter password:

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

Before upgrade, system was working fine but facing error after the upgrade

Please help in this regard

Regards

Santosh K