cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE 10.2 not able to start listener.

0 Kudos

Hi,

I have successfully installed ORACLE 10.2(SID= ANK) and uninstalled 10.1(SID= ANB) on same machine(Hostname INLD50057853A port 1521) .

Below are services I can see in my windows box

1) OracleANK102TNSListener (not able to start this service...it gives some error)

2) OracleANK102iSQL*Plus (not able to start this service also)

3) OracleOraDb10g_home1TNSListener (not able to start this also)

*************************

Comman output:-

C:>tnsping ANK.WORLD

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-JUN-2

009 11:52:03

Copyright © 1997, 2005, Oracle. All rights reserved.

Used parameter files:

c:oracleANK102

etworkadminsqlnet.ora

TNS-03505: Failed to resolve name

********************************

C:>lsnrctl

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-JUN-2009 14:56

:49

Copyright © 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start

Starting tnslsnr: please wait...

Failed to open service , error 1060.

Failed to start service, error 1060.

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

*********************************

if I go and check this sqlnet.ora it does not contain any useful data in it...

see content of sqlnet.ora

C:oracleANK102NETWORKADMINSQLNET.ORA

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

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

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

SQLNET.AUTHENTICATION_SERVICES = (NTS)

*********************

Please let me know what exactly is issue here, why I am not able to start my listener

Edited by: I041468 on Jun 2, 2009 7:23 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Ankit,

C:\>oradim -DELETE -SRVC OracleOraDb10g_home1TNSListener

try by replacing oradim=Oradim again. If it is deleting then ok or else just stop it.

and if sqlnet.ora path i.e. C:\oracle\ANK\102\NETWORK\ADMIN  is correct 
then is listener.ora and tnsnames.ora path i.e. C:\oracle\NETWORK\ADMIN is also correct?

No. Correct path for listener.ora and tnsnames.ora path is also same C:\oracle\ANK\102\NETWORK\ADMIN.

I think you need to check all files 1 by 1 & point it to correct ones. It seems it is pointing to wrong files.

Thanks,

Sushil

Answers (3)

Answers (3)

Former Member
0 Kudos

Ankit,

You can delete that service using below command.

Oradim u2013DELETE u2013SRVC OracleOraDb10g_home1TNSListener

I can see all three files listener/sqlnet/tnsnames in folder C:\oracle\NETWORK\Admin\
and I also can see sqlnet.ora in folder C:\oracle\ANK\102\NETWORK\Admin\sqlnet.ora

C:\oracle\ANK\102\NETWORK\Admin\sqlnet.ora this one is correct

Thanks

Sushil

0 Kudos

Hi,

I have tried command and got below output

C:\>oradim -DELETE -SRVC OracleOraDb10g_home1TNSListener

DIM-00008: A valid service name is OracleService appended with a SID.

any correction in this?

I have also set env var DBS_ORA_TNSNAMES=ANK

still same error while doing tnsping ANK.WORLD

C:\Documents and Settings\I041468>tnsping ANK.WORLD

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-JUN-2

009 13:55:55

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

Used parameter files:

c:\oracle\ANK\102\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

and if sqlnet.ora path i.e. C:\oracle\ANK\102\NETWORK\ADMIN is correct

then is listener.ora and tnsnames.ora path i.e. C:\oracle\NETWORK\ADMIN is also correct?

both are different path and according to what I saw during ORACLE 10.1 tnsnames/listener/sqlnet were in same folder.

Regards,

Ankit Baphna

Former Member
0 Kudos

Hi,

1)(no1) OracleANK102TNSListener t able to start this service...it gives some error)
2) OracleANK102iSQL*Plus (not able to start this service also)
3) OracleOraDb10g_home1TNSListener (not able to start this also)

Here 2 Listners are showing. I think you need to delete the one which is not needed(mostly last one)

Also check below sap notes.

Note 384839 - ora-12540, tns-12560, tns-12500, tns-12546

Note 437362 - Composite note ORA-12500

Note 723147 - ORA-12542: TNS: address already in use

Thanks,

Sushil

0 Kudos

Hi,

How do we delete listener? and is it safe to delete second listener because anyways it is not starting...let me know. I have also checked given SAP notes but still not able to start listener.

this is very confusing...

I have set ORACLE_HOME to C:\oracle\ANK\102

ORACLE_SID =ANK

I can see all three files listener/sqlnet/tnsnames in folder C:\oracle\NETWORK\Admin\

and I also can see sqlnet.ora in folder C:\oracle\ANK\102\NETWORK\Admin\sqlnet.ora

which one is correct one?

port in listener n tnsnames I have set on 1521

now I do not know my listener is referring to which file of which path?

Thanks,

Regards,

Ankit Baphna

anindya_bose
Active Contributor
0 Kudos

Can you please check your listener.ora file? Please also check environment variable DBS_ORA_TNSNAME, ORACLE_HOME, ORACLE_SID

Former Member
0 Kudos

Hi,

Please check in environment variable path and SID.

and check the dba control file with correct(new) SID name.

Thanks,

Mani