on 06-02-2009 6:23 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi,
Please check in environment variable path and SID.
and check the dba control file with correct(new) SID name.
Thanks,
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.