1 2 Previous Next 17 Replies Latest reply: May 8, 2012 5:17 AM by 934793 RSS

    Unable to login- ORA-12560: TNS:protocol adapter error

    934793
      I have upgraded the oracle db to 11.1.0.7 from 11.1.0.0 . before upgrade i have stop the db and listener process.
      after the upgrade, i have started the listener(mentioned the listener status below) and tried to login as a sysdba, but unable to login itself to the db. Kindly help me to login and to start the database.


      Error msg :
      bash-3.00$ cd $ORACLE_HOME
      bash-3.00$ cd bin
      bash-3.00$ sqlplus /nolog

      SQLPlus: Release 11.1.0.7.0 - Production on Thu Apr 26 19:28:19 2012*

      Copyright (c) 1982, 2008, Oracle.  All rights reserved.

      SQL> connect sys as sysdba
      Enter password:
      ERROR:
      ORA-12560: TNS:protocol adapter error


      bash-3.00$ lsnrctl status

      LSNRCTL for Solaris: Version 11.1.0.7.0 - Production on 27-APR-2012 16:30:01

      Copyright (c) 1991, 2008, Oracle. All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1525)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Solaris: Version 11.1.0.7.0 - Production
      Start Date 27-APR-2012 10:50:31
      Uptime 0 days 5 hr. 39 min. 30 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u02/AIUJAPAN/oracle11g/product/11.1.0/db_1/network/ad
      min/listener.ora
      Listener Log File /u02/AIUJAPAN/oracle11g/diag/tnslsnr/AIGUK/listener/al
      ert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1525)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.95.24.10)(PORT=1525)))
      The listener supports no services
      The command completed successfully
      bash-3.00$
        • 1. Re: Unable to login- ORA-12560: TNS:protocol adapter error
          Douglas Paiva
          Verify if your ORACLE_HOME was changed from /u02/AIUJAPAN/oracle11g/product/11.1.0/db_1 to /u02/AIUJAPAN/oracle11g/product/11.1.7/db_1,if this is true then change value of your enviroment variable $ORACLE_HOME to correct value.

          Att,

          Douglas Paiva
          • 2. Re: Unable to login- ORA-12560: TNS:protocol adapter error
            934793
            Oracle home path is not changed. please find the current oraclehome path and unable to find the directory - /u02/AIUJAPAN/oracle11g/product/11.1.7/db_1

            cd $ORACLE_HOME
            pwd
            /u02/AIUJAPAN/oracle11g/product/11.1.0/db_1
            • 3. Re: Unable to login- ORA-12560: TNS:protocol adapter error
              mBk77
              Have you set the PATH to $ORACLE_HOME/bin, ORACLE_SID, LD_LIBRARY_PATH, TNS_ADMIN environment variables correctly.
              • 4. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                934793
                ya have updated the oracle path in the enviromental variables. Please find the same.

                bash-3.00$ cat .profile
                *# This is the default standard profile provided to a user.*
                *# They are expected to edit it to meet their own needs.*
                *#TERM=colors#256*
                *#export TERM*
                COBDIR=/u01/opt/microfocus/cobol
                ORACLE_BASE=/u02/AIUJAPAN/oracle11g
                ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
                ORACLE_SID=AIUJAPAN
                export COBDIR
                export ORACLE_BASE
                export ORACLE_HOME
                export ORACLE_SID
                LD_LIBRARY_PATH=$ORACLE_HOME/lib
                PATH=$PATH:/usr/local/bin:/usr/ccs/bin:$ORACLE_HOME/bin
                CLASSPATH=$CLASSPATH:/oracle/AIG_IBM/AIG/classes12.zip:
                export CLASSPATH
                export LD_LIBRARY_PATH
                export PATH
                *MAIL=/usr/mail/${LOGNAME:?}*
                bash
                bash-3.00$
                • 5. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                  sb92075
                  Issue the following OS commands

                  id
                  env | sort
                  hostname
                  cat /etc/hosts
                  uname -a
                  ifconfig
                  lsnrctl start
                  lsnrctl status
                  lsnrctl service


                  COPY commands & results then PASTE all back here
                  • 6. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                    934793
                    PFA

                    Edited by: 931790 on May 7, 2012 3:38 AM
                    • 7. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                      817202
                      Hi,


                      If you are able to open net manager, try to recreate Listener as well as tnsnames.ora file and check wheather it works or not and let me know.
                      • 8. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                        934793
                        Hi
                        Already did the same. But still not working.
                        • 9. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                          934793
                          Already Reconfigured the Tnsora file also. but still the same error
                          • 10. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                            Hemant
                            HI ,
                            try to tnsping Your Service name.
                            Is it ok

                            Like

                            [oracledb@U2ISPC25 admin]$ tnsping BTDBNEW

                            TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 07-MAY-2012 18:10:54

                            Copyright (c) 1997, 2005, Oracle. All rights reserved.

                            Used parameter files:
                            /apps/oracledb/product/10.2.0/orahome/network/admin/sqlnet.ora

                            Used EZCONNECT adapter to resolve the alias
                            Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=BTDBNEW))(ADDRESS=(PROTOCOL=TCP)(HOST=194.9.9.231)(PORT=1521)))
                            OK (10 msec)
                            [oracledb@U2ISPC25 admin]$


                            and Also see there is proper permission on tnsnames.ora and listener.ora
                            Thanks
                            Hemant
                            • 11. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                              934793
                              bash-3.00$ tnsping AIUJAPAN

                              TNS Ping Utility for Solaris: Version 11.1.0.7.0 - Production on 08-MAY-2012 10:
                              35:22

                              Copyright (c) 1997, 2008, Oracle. All rights reserved.

                              Used parameter files:
                              /u02/AIUJAPAN/oracle11g/product/11.1.0/db_1/network/admin/sqlnet.ora


                              Used TNSNAMES adapter to resolve the alias
                              )SID = AIUJAPAN)orcl.aig.com)OST = 10.95.24.10)(PORT = 1525))
                              OK (10 msec)
                              • 12. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                                sb92075
                                Issue the following OS commands

                                id
                                env | sort
                                hostname
                                cat /etc/hosts
                                uname -a
                                ifconfig
                                lsnrctl start
                                lsnrctl status
                                lsnrctl service
                                COPY commands & results then PASTE all back here
                                • 13. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                                  934793
                                  id
                                  uid=100(oracle) gid=102(oinstall)
                                  ---------------------------------------------------------------------------------------------
                                  env | sort
                                  CLASSPATH=:/oracle/AIG_IBM/AIG/classes12.zip:
                                  COBDIR=/u01/opt/microfocus/cobol
                                  HOME=/export/home/oracle
                                  HZ=100
                                  LD_LIBRARY_PATH=/u02/AIUJAPAN/oracle11g/product/11.1.0/db_1/lib
                                  LOGNAME=oracle
                                  MAIL=/var/mail/oracle
                                  ORACLE_BASE=/u02/AIUJAPAN/oracle11g
                                  ORACLE_HOME=/u02/AIUJAPAN/oracle11g/product/11.1.0/db_1
                                  ORACLE_SID=AIUJAPAN
                                  PATH=/usr/bin::/usr/local/bin:/usr/ccs/bin:/u02/AIUJAPAN/oracle11g/product/11.1.
                                  0/db_1/bin
                                  PWD=/export/home/oracle
                                  SHELL=/bin/sh
                                  SHLVL=1
                                  TERM=ansi
                                  TZ=Asia/Calcutta
                                  _=/usr/bin/env
                                  ---------------------------------------------------------------------------------------------
                                  hostname
                                  AIGUK.aig.com
                                  ---------------------------------------------------------------------------------------------
                                  cat /etc/hosts
                                  #
                                  # Internet host table
                                  #
                                  127.0.0.1 localhost
                                  #10.95.24.73 AIGUK.aig.com
                                  10.95.24.10 AIGUK.aig.com
                                  10.95.24.10 AIGUK

                                  #10.95.24.73 AIGUK

                                  10.95.24.71 AIUNHLM
                                  192.18.108.101 supportfiles.sun.com
                                  #10.90.140.40 mailhost
                                  10.90.140.55 mailhost
                                  ---------------------------------------------------------------------------------------------
                                  uname -a
                                  SunOS AIGUK.aig.com 5.10 Generic_118833-20 sun4u sparc SUNW,Sun-Fire-V490
                                  ---------------------------------------------------------------------------------------------
                                  ifconfig
                                  - This command is not working - saying "Command not found"
                                  ---------------------------------------------------------------------------------------------
                                  lsnrctl start
                                  LSNRCTL for Solaris: Version 11.1.0.7.0 - Production on 04-MAY-2012 20:39:52

                                  Copyright (c) 1991, 2008, Oracle. All rights reserved.

                                  TNS-01106: Listener using listener name LISTENER has already been started
                                  ---------------------------------------------------------------------------------------------
                                  lsnrctl status
                                  LSNRCTL for Solaris: Version 11.1.0.7.0 - Production on 04-MAY-2012 20:40:17

                                  Copyright (c) 1991, 2008, Oracle. All rights reserved.

                                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1525)))
                                  STATUS of the LISTENER
                                  ------------------------
                                  Alias LISTENER
                                  Version TNSLSNR for Solaris: Version 11.1.0.7.0 - Production
                                  Start Date 27-APR-2012 10:50:31
                                  Uptime 7 days 9 hr. 49 min. 45 sec
                                  Trace Level off
                                  Security ON: Local OS Authentication
                                  SNMP OFF
                                  Listener Parameter File /u02/AIUJAPAN/oracle11g/product/11.1.0/db_1/network/ad
                                  min/listener.ora
                                  Listener Log File /u02/AIUJAPAN/oracle11g/diag/tnslsnr/AIGUK/listener/al
                                  ert/log.xml
                                  Listening Endpoints Summary...
                                  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1525)))
                                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.95.24.10)(PORT=1525)))
                                  The listener supports no services
                                  The command completed successfully
                                  ---------------------------------------------------------------------------------------------
                                  lsnrctl service

                                  LSNRCTL for Solaris: Version 11.1.0.7.0 - Production on 04-MAY-2012 20:40:46

                                  Copyright (c) 1991, 2008, Oracle. All rights reserved.

                                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1525)))
                                  The listener supports no services
                                  The command completed successfully
                                  • 14. Re: Unable to login- ORA-12560: TNS:protocol adapter error
                                    baskar.l
                                    Hi,
                                    Listening Endpoints Summary...
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1525)))
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.95.24.10)(PORT=1525)))
                                    The listener supports no services
                                    The command completed successfully
                                    Can you check if local_listener parameter is set?

                                    Thank you,
                                    Baskar.l
                                    1 2 Previous Next