Hi,
I have successfully installed ORACLE 10.2(SID= ANK) and uninstalled 10.1(SID= ANB) on same machine(Hostname INLD50057853A port 1521) .
but I am not able see listener services in windows service box for ANK I only see previous one, though I have uninstalled 10.1 with proper steps.
Below are only services I can see in my windows box
1) OracleANB101TNSListener (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)
Could you please let me know what can I do in such case now.
If I do command lsnrctl it gives me successfull message
C:>lsnrctl
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-JUN-2009 11:53
:10
Copyright © 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
If I do command tnsping ANK.WORLD it give me error message
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
If I do commant sqlplus /nolog it says
C:>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 1 11:55:06 2009
Copyright © 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/your_pass @ ank.world as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
my lsnrctl.log says
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-JUN-2009 11:59:44
Copyright © 1991, 2005, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNS-12560: TNS:protocol adapter error
sending you listener.ora , namespace.ora and sqlnet.ora
C:oracleNetworkadmin
listener.ora
################
1. Filename......: listener.ora
2. Created.......: created by SAP AG, R/3 Rel. >= 6.10
3. Name..........:
4. Date..........:
5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#3 $
################
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = ANK.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = ANK)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = INLD50057853A)
(PORT = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = ANK)
(ORACLE_HOME = C:oracle)
)
)
tnsnames.ora
################
1. Filename......: tnsnames.ora
2. Created.......: created by SAP AG, R/3 Rel. >= 6.10
3. Name..........:
4. Date..........:
5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#3 $
################
ANK.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = INLD50057853A)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = ANK)
(GLOBAL_NAME = ANK.WORLD)
)
)
sqlnet.ora
################
1. Filename......: sqlnet.ora
2. Created.......: created by SAP AG, R/3 Rel. >= 6.10
3. Name..........:
4. Date..........:
5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#3 $
################
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 hope this information is enough for you to know what issue I am facing now. but if you need some more logs do let me know. Its very tricky situation and I am sure solution is very small which I dont know currently and need experts point of view
Kindly suggest.
Regards,
Ankit Baphna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.