This discussion is archived
3 Replies Latest reply: Sep 2, 2013 11:29 AM by Hussein Sawwan-Oracle RSS

TNS-12560: TNS:protocol adapter error

Mohammed Abdul Muqeet Explorer
Currently Being Moderated

Hi Experts,

 

Just wanted to let you know that there was some maintainace activity. After that when i tried to start the ebs db and listener it is givng the below error.

 

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-SEP-2013 20:59:45

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

Starting /u01/oracle/SID

 

/db/tech_st/11.2.0/bin/tnslsnr: please wait...

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
   Linux Error: 32: Broken pipe

 

oracle    3828     1  0 10:26 ?        00:00:00 /u01/oracle/SID/db/tech_st/11.2.0/bin/tnslsnr  SID -inherit

 

[oracle@hostname

 

]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 2 10:41:05 2013

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

Connected.
SQL> startup
ORA-00000: normal, successful completion

 

Please advise

 

Regards

Mohammed. Abdul Muqeet

  • 1. Re: TNS-12560: TNS:protocol adapter error
    Mohammed Abdul Muqeet Explorer
    Currently Being Moderated

    SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 2 10:50:36 2013

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

    Connected.
    SQL> select open_mode from v$database;
    select open_mode from v$database
    *
    ERROR at line 1:
    ORA-01012: not logged on
    Process ID: 0
    Session ID: 0 Serial number: 0

  • 2. Re: TNS-12560: TNS:protocol adapter error
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Please post the details of the application release, database version and OS.

     

    Just wanted to let you know that there was some maintainace activity. After that when i tried to start the ebs db and listener it is givng the below error.

     

    What kind of maintenance activities?

     

    LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-SEP-2013 20:59:45

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

    Starting /u01/oracle/SID

     

    /db/tech_st/11.2.0/bin/tnslsnr: please wait...

    TNS-12547: TNS:lost contact
    TNS-12560: TNS:protocol adapter error
      TNS-00517: Lost contact
       Linux Error: 32: Broken pipe

     

    oracle    3828     1  0 10:26 ?        00:00:00 /u01/oracle/SID/db/tech_st/11.2.0/bin/tnslsnr  SID -inherit

     

    What is the output of "ps -ef |grep tnslsnr"?

     

    Was the database env file set before starting the listener?

     

    SQL> startup

    ORA-00000: normal, successful completion

     

    Please post the output of "env | sort" command.

     

    Please also check the database log file for any errors.

     

     

    Thanks,

    Hussein

  • 3. Re: TNS-12560: TNS:protocol adapter error
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    MohammedAbdulMuqeet wrote:

     

    SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 2 10:50:36 2013

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

    Connected.
    SQL> select open_mode from v$database;
    select open_mode from v$database
    *
    ERROR at line 1:
    ORA-01012: not logged on
    Process ID: 0
    Session ID: 0 Serial number: 0

     

    If the database is not up yet, then this is an expected output.

     

    Please unmount the file system and mount it again (you may also reboot the server) and try the above commands again.

     

    Thanks,

    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points