Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Former Member replied

Hi,

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

Gerard

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question