upgrade to 11g - ERROR Creating the Oracle TNSListener Service

[Former Member]

Hi All,

I'm not able to see my posted question.

so, i'm doing this again with the same subject.

I'm facing problem in creating Listener during the post-processing steps of Oracle upgrade.

upgrade from 10.2.0.4 to 11.2.0.3, I have applied recent patches for 11.2.0.3.

i'm getting error as below:-

Microsoft Windows [Version 6.0.6002]

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

C:\Windows\system32>cd\

C:\>d:

D:\>cd oracle\SID\11203\BIN

D:\oracle\SID\11203\BIN>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 28-APR-2013 23:59:40

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

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

D:\oracle\SID\11203\BIN>tnsping SID

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 29-APR-2013 00:00:44

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

Used parameter files:

D:\usr\sap\SID\SYS\profile\oracle\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = ERPPRDSERV)(PORT = 1527)

) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SID)))

TNS-12541: TNS:no listener

D:\oracle\SID\11203\BIN>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 29-APR-2013 00:04:10

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

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

LSNRCTL> service

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.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=SID))

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=192.168.3.200)(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> start

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

LSNRCTL>

I have rechecked the Environment variables.

The "ORACLE_HOME" is pointing to new oracle 11g in both user and system variables.

start -> RUN -> %oracle_home% is working fine

and the TNS_ADM is set in user variables.

i'm using REAL VNC instead of MSTSC.

Kindly give advise/solution on the above reported problem.

Kind regards,

Harika

SNC.txt.zip

[Former Member · Accepted solution]

Try to start listener as service in services.msc

[Former Member · Accepted solution]

Error in creating listener for 11g.

as per (upgrade guide) :

5.2 Creating the Oracle TNSListener Service

Prerequisites

Stop the old Oracle listener before you create the Oracle TNSListener Service.

Procedure

Open a command prompt and enter the following command:<complete_path_to_new_Oracle_Home>\bin\lsnrctl start

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

[Former Member · Accepted solution]

Hi Harika,

1. Have u upgraded instant client ?

2. Copy your old TNS files and paste it in new /oracle/SID/11203/network/admin/ and change the old oracle home with new oracle home.

3. you also check the /sapmnt/<SID>/profile/oracle/sqlnet.ora, tnsnames.ora.

4. Also check the profile parameter of user ora<sid> home

Regards

Ganesh Datt Tiwari

[former_member206552 · Accepted solution]

hi harika

as a suggestion have you tried running NETCA manually again ?

http://www.orafaq.com/wiki/NetCA

regards

marius

[Former Member · Accepted solution]

We have restored full system and upgraded again.

This time, listener started successfully with out any problem.

Thank you all for quick reply.

kind regards,

Harika

[Former Member]

Request you to check attachments.

sqlnet.ora contains the following:

# This file is actually generated by netca. But if customers choose to

# install "Software Only", this file wont exist and without the native

# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

please check and let me know incase of any errors.

kind regards,

harika

[former_member206552]

morning harika,

can you please make sure the firewall is not on,

also have a look at the following

http://www.dba-oracle.com/t_windows_tns_no_listener_error.htm

best regards

marius

[Former Member]

Hi Marius,

Firewall is off.

I have checked the directory permissions "system" is having full authorizations.

i have cross checked with Note 441518 - ORA-12560 composite SAP Note

1. Windows: Starting client tools (svrmgrl, sqlplus, sapdba, and so on) using a terminal server

    - This time i have used direct access (with out Real VNC).

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

    - Service is running.

    - we have stopped the old oracle service as directed in upgrade guide

3. Incorrect or missing entry for ORACLE_SID in environment or registry

    - Registry has the entries as per note.

4. Characters that are not alphanumeric in the system ID (SID)

     - SID is fine "ABC" aplhabets only

5. Windows: Missing directory authorizations

    - "system" has the autorization and <sid>adm too

6. Error when creating the database for a new installation

    - no errors reported during installation or upgradation.

7. Resource problems    

    - Enough memory is available in system.

10. Windows: Oracle software installed incorrectly

    - installation as per instructions mentioned in upgrade guide.

11. Windows: Reboot required

    - rebooted couple of times and checked.

able to connect to DB as "sysdba" and DB status is OPEN.

Kind regards,

Harika

[karthikeyan_natarajan4]

Hi Harika,

looks everything is fine, check the status of oracle listener in services

regards

karthik