TNS-12560: TNSrotocol adapter error

[paolo_rubino]

Iu2019m installing SAP ERP 6.0 on a Windows server 2008 with Oracle 10.2.0.4.0.

First of all I installed the Oracle software by means of Oracle Universal Installer.Then I used the Sapinst tool. At the step u201CConfigure Oracle server Networku201D I get an error. In the lsnrctl.log file I can read:

TNS-12560: TNSrotocol adapter error

TNS-00530: Protocol adapter error

These are my .ora files in the path <oracle-home>\NETWORK\ADMIN::

1 )LISTENER.ORA

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DEV.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DEV)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = SAP-BTdemo)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = DEV)

(ORACLE_HOME = F:\oracle\DEV\102)

)

)

2) SQLnet.ora:

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

1. 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

1. 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

SQLNET.AUTHENTICATION_SERVICES = (NTS)

1. 05.01.06 set to default

#TCP.NODELAY=YES

1. 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

3) tnsname.ora:

DEV.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = SAP-BTdemo)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = DEV)

(GLOBAL_NAME = DEV.WORLD)

)

)

I have set the following Environment Variables:

u2022 ORACLE_HOME = F:\oracle\DEV\102

u2022 ORACLE _SID= DEV

u2022 TNS_ADMIN= F:\oracle\DEV\102\NETWORK\ADMIN

I have installed Oracle by Universal Installer and, in the Server Manager, I got only the following Oracle Service:

OracleDEV102iSQL*Plus

If I use the command lsnrctl start from Windows prompt I get the same error.

Can anyone help me?

[former_member204746]

open a command prompt and try to start the listener yourself:

LSNRCTL start

you should get a windows error about a missing service, and a few moments later, this sercvice should be created. tell us the name of the windows service that is created, also supply logs of this command.

[paolo_rubino]

Microsoft Windows [Version 6.0.6002]

Copyright (c) 2006 Microsoft Corporation. All rights reserved.

C:\Windows\system32>lsnrctl start

LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 28-OCT-2010 07:50

:55

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

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

And this is the logfile:

LSNRCTL> show log_file

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=10.32.33.4)(PORT

=1527))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 61: Unknown error

LSNRCTL>

Edited by: Paolo Rubino on Oct 28, 2010 9:14 AM

[paolo_rubino]

I found an Oracle note which told me to start the listener in the local host, rather than on remote by means of Remote Desktop Connection. So I scheduled this job and it seemed to work: listener up and tnsping DEV is ok.

The problem is that when I launch SAPinst the Listener Service is stopped again and it gives me the same error.

Is it a problem due to the fact that I am using a Remote Desktop Connection to the remote host?

Any idea?

Thanks in advance...

[Former Member]

Can you please check Note 441518 - ORA-12560 composite SAP Note

[paolo_rubino]

I had already read this note. The only points which seem doubtful to me are:

2. Windows: Service oracleservice<sid> does not run

5. Windows: Missing directory authorizations

As for point 2 , I told that I miss this service after Oracle sw installation. Is it normal? Is SAPinst's duty to create it or should it be created during sw installation by means of OUI?

As for point 5, I am logged to the server as "Administrator". How can I check if I have all of the necessary permissions?

Thanks in advance.

[Former Member]

I have gone through my old installation docs and not found the oracle<SID> service created after oracle installation. looks like the service may be get craeted by sapinst. let me again search for other installations docs.

[paolo_rubino]

Ok, do you remember if after the Oracle sw installation you had only the service OracleDEV102iSQL*Plus on?

This would mean that the Oracle sw installation is correct while it is a SAPinst' s problem .... thank you

[Former Member]

>OracleDEV102iSQL*Plus on?

yes, the oracle isql service was on.

[former_member204746]

it is normal to only see 1 windows service being created using SAP procedure.

this service is:: OracleDEV102iSQL*Plus.

when you will continue to run SAPINST as documented in the install guide, it will create other Oracle services for you.

so, now, you should not try to create a database or create a listener, this is not your job to do, let SAPINST work for you.

[Former Member]

Windows - Oracle Installation procedure.

1. Install the Oracle Software using sapserver.cmd

2. Apply the Oracle Patch.

3. Install Java SDK 1.4

4. See the envroinment variables ORACLE_HOME and JAVA_HOME. (if one SAP instance installed in this server, you can set this envroinment variable under system variables)

5. Run the SAPINST. SAPINST will creates the Database on Oracle in the name of SID, database service, Listener service and parameter files(listener.ora, tnsnames.ora, sqlnet.ora init<sid>.ora, init<sid>.sap).

If you followed the above procedure check the below things.

1. Check the database is up and running (Login to sqlplus "/as sysdba" )

2. Check the listener service is started (lsnrctl status), if not, start it(lsnrctl start)

3. Check the tnsnames (tnsping <SID> from the command probpt).

Rgds,

JP.

[paolo_rubino]

Ok, I made all the things that you say: installed Oracle sw, installed the Opatch end started SAPinst.

But SAPinst stops when configuring oracle server network. I really don't understand what to do. If i write the command of LSNRCTL and tnsping the DEV (my DBsid) i have the following error:

LSNRCTL> services

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=10.32.33.4)(PORT

=1527))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 61: Unknown error

LSNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DEV))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=10.32.33.4)(PORT

=1527))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 61: Unknown error

C:\SAPinst>tnsping DEV

TNS Ping Utility for 64-bit Windows: Version 10.2.0.4.0 - Production on 27-OCT-2

010 14:11:45

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:

F:\oracle\DEV\102\NETWORK\ADMIN\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP

.WORLD) (PROTOCOL = TCP) (HOST = 10.32.33.4) (PORT = 1527))) (CONNECT_DATA = (SI

D = DEV) (GLOBAL_NAME = DEV.WORLD)))

TNS-12541: TNS:no listener

Why isn't SAPINST able to use the listener??

Edited by: Paolo Rubino on Oct 27, 2010 3:16 PM

[former_member204746]

you should not have played around with listener.ora, sqlnet.ora and tnsnames.ora fiels BEFORE starting SAPINST.

please supply contents of these files.

please tell us if any ORAcleSID102TNSlistener service exists. also, can you find any other Oracle service created? care to tell us which?

[paolo_rubino]

The .ora files were created by SAPinst in the steps before the error.

1) LISTENER.ORA:

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DEV.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DEV)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = SAP-BTdemo)

(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 = DEV)

(ORACLE_HOME = F:\oracle\DEV\102)

)

)

2) TNSNAMES:

DEV.WORLD =

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = SAP-BTdemo)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = DEV)

(GLOBAL_NAME = DEV.WORLD)

)

)

3) SQLNet:

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

I have only one Otracle Service: OracleDEV102iSQL*Plus

It seems that SAPinst is trying to create the other Oracle services ( LSNRCTL start) but isn't able to start or create the necessary services. Maybe Windows Server 2008 OS doesnt't allow the Sapinst to create these new services.

Is it possible, in your opinion?

[former_member204746]

Oracle DOES not install other Oracle SErvifes. This is the job for SAPINST. the Oracle clistener needs the service installed, but also OracleServideSID.

So, it is completely normal to only see 1 service.

after installing SAP, it will add addtional Windows ORacle services

[paolo_rubino]

The installation guide told me to install the Oracle Software and then start SAPinst.

So, how many services should I have after the installation of the software by means of Oracle Universal Installer (OUI)?

As I told you i have only one Oracle service created, that is OracleDEV102iSQL*Plus. I haven't understood if the Listener will be installed by SAPinst later or it should be installed by the OUI because it is necessary to the SAPinst to continue with installation.

Finally I need to know if the error is in my Oracle sw installation or in the SAPinst. Any help?