on 01-19-2010 5:33 PM
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
################
Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $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
Hi,
Check this note to resolve this : Note 441518 - ORA-12560 composite SAP Note
Gerard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i had the same issue and was resolved turning off the windows firewall and then restarting the server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi set this parameters.
1)listener.ora file
d11 = SID
R3DEVLOPMENT = HOST NAME
listener.ora Network Configuration File: G:\oracle\d11\102\network\admin\listener.ora
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
TNSNAMES.ORA Network Configuration File: g:\oracle\D11\102\network\admin\tnsnames.ora
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.