Skip to Content
avatar image
Former Member

ORA-12560: TNS:protocol adapter error

Hello Experts,

I need a reply ASAP if you don't mind. I am in the process of upgrading Oracle 9.2.0.8 to 10.2.0.4 on our BW system. I installed the Oracle10g server software and installed all the patches. When

I try to start oracle I recieve ORA-12560: TNS:protocol adapter error.

I am upgrading on Microsoft Window Server 2003 Enterprise Edtion

User Variable is set to ORACLE_HOME = G:\oracle\dbw\102

System Variable Path is set to:

G:\oracle\DBW\102\bin;C:\j2sdk1.4.2_16\jre\bin\client;C:\j2sdk1.4.2_16\jre\bin;C:\Perl\bin;C:\Program Files\EMC\PowerPath\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Dell\SysMgt\oma\bin;C:\Program Files\Windows Resource Kits\Tools;G:\oracle\dbw\102\OPatch

listener.ora

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

  1. Filename......: listener.ora

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

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DBW.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DBW)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = BSRDBW001)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = DBW)

(ORACLE_HOME = G:\oracle\dbw\102)

)

)

Can someone help please. Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 19, 2010 at 06:01 PM

    Hi,

    Check this note to resolve this : Note 441518 - ORA-12560 composite SAP Note

    Gerard

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2010 at 06:06 PM

    You have to upgrade the oracle database using DBUA or manual method after installing the software .

    I guess you havent done that.

    Make use of the oracle patch document and upgrade oracle using DBUA. This is mandatory after the installation of the software.

    Remember by installation you are installing the software only , you have to upgrade the data structure using DBUA or manual method.

    Hope it helps,

    Gerard

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      HI,

      Please check if <dbsid> adm user is a member of dba group.

      Also try "relink all" command from ORACLE_HOME

      Then try...

      Regards.

      Rajesh Narkhede

  • avatar image
    Former Member
    Jan 20, 2010 at 03:55 AM

    Hi set this parameters.

    1)listener.ora file

    d11 = SID

    R3DEVLOPMENT = HOST NAME

    1. listener.ora Network Configuration File: G:\oracle\d11\102\network\admin\listener.ora

    2. Generated by Oracle configuration tools.

    SID_LIST_LISTENER =

    (SID_LIST =

    (SID_DESC =

    (SID_NAME = PLSExtProc)

    (ORACLE_HOME = g:\oracle\d11\102)

    (PROGRAM = extproc)

    )

    (SID_DESC =

    (SDU = 32768)

    (SID_NAME = d11)

    (ORACLE_HOME = g:\oracle\d11\102)

    )

    (SID_DESC =

    (SDU = 32768)

    (SID_NAME = d11)

    (ORACLE_HOME = g:\oracle\d11\102)

    )

    )

    CONNECT_TIMEOUT_LISTENER = 10

    STARTUP_WAIT_TIME_LISTENER = 0

    LISTENER =

    (DESCRIPTION_LIST =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = R3DEVLOPMENT)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = R3DEVLOPMENT)(PORT = 1527))

    )

    )

    TRACE_LEVEL_LISTENER = OFF

    2) TNSNAME.0RA

    d11 = SID

    R3DEVLOPMENT = HOST NAME

    1. TNSNAMES.ORA Network Configuration File: g:\oracle\D11\102\network\admin\tnsnames.ora

    2. Generated by Oracle configuration tools.

    EXTPROC_CONNECTION_DATA =

    (DESCRIPTION =

    (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

    (CONNECT_DATA =

    (SID = PLSExtProc)

    (PRESENTATION = RO)

    )

    )

    D11.WORLD =

    (DESCRIPTION =

    (SDU = 32768)

    (ADDRESS_LIST =

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = R3DEVLOPMENT)

    (PORT = 1521)

    (PORT = 1527)

    )

    )

    (CONNECT_DATA =

    (SID = D11)

    (GLOBAL_NAME = D11.WORLD)

    )

    )

    3) SQLNET.ORA

    AUTOMATIC_IPC = ON

    TRACE_LEVEL_CLIENT = OFF

    NAMES.DEFAULT_DOMAIN = WORLD

    NAME.DEFAULT_ZONE = WORLD

    SQLNET.EXPIRE_TIME = 0

    SQLNET.AUTHENTICATION_SERVICES = (NTS)

    TCP.NODELAY=YES

    tcp.invited_nodes = (10.10.100.XX)

    AFTER SET THIS PARAMETETR RESTART ORACLE SERVICE.

    REGARS

    VIKAS N

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 10, 2013 at 12:37 PM

    i had the same issue and was resolved turning off the windows firewall and then restarting the server.

    Add comment
    10|10000 characters needed characters exceeded