ORA-12560: TNS:protocol adapter error

[Former Member]

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 · Accepted solution]

Hi,

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

Gerard

[marcosmata]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Gerard,

Thank you so much for your reply, yes you are absolutely right that we need to upgrade the oracle database using DBUA or manual method after installing the software. We have upgraded three other SAP oracle databases (DEV APO, XI, R3 to 10.2.4 using the same procedure no problem. On BW all hell broke loose. According to the Upgrade Guide - Upgrade to Oracle Database 10g Release 2 (10.2: Windows these are the steps

- Do some minor steps here

- Install Oracle 10g Server Software

- Install the current patch set

- Install the current patch collection

- Install the Oracle 10g client software

- Copy and Adapt the SQL*NET files

- Backup the oracle database

- Changing the environment for user <dbsid> adm

- Perform the Database Upgrade

There is a step in installing the Oracle 10g client software

2. Define the following parameter in all instance profiles

DIR_CLIENT_ORAHOME=$(DIR_EXECUTABLE) were you need to restart the server and bounce the database. When

I tried to log as sysdba I recieved the ORA-12560: TNS:protocol adapter error.

I will try and follow SAP Note 441518 as you suggested. Hopefully this will fix our issue.

Thanks again

[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