Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Oracle 10.2 issues with services and listener, Not able to see listener in services.
ankitbaphna
post Jun 1 2009, 01:32 AM
Post #1


Member
**

Group: Members
Posts: 13
Joined: 26-May 09
Member No.: 40,769



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:\oracle\ANK\102\network\admin\sqlnet.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:\oracle\Network\admin

listener.ora

################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $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

################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $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
################
# Filename......: sqlnet.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $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
Go to the top of the page
 
+Quote Post
ankitbaphna
post Jun 1 2009, 04:30 AM
Post #2


Member
**

Group: Members
Posts: 13
Joined: 26-May 09
Member No.: 40,769



ok after doing more analysis I realised that ORACLE10.2 creates one listener and it is named as
ORACLEANK102TNSLISTENER

this is currently not getting start.
it is pointing to path C:\oracle\ANK\102\BIN\lsnrctl

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 <OracleANK102TNSListener>, error 1060.
Failed to start service, error 1060.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error


Regards,
Ankit Baphna
Go to the top of the page
 
+Quote Post
ankitbaphna
post Jun 1 2009, 04:37 AM
Post #3


Member
**

Group: Members
Posts: 13
Joined: 26-May 09
Member No.: 40,769



also If I do tnsping ANK.world it gives me below out put

C:\>tnsping ank.world

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

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

Used parameter files:
c:\oracle\ANK\102\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name


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

C:\oracle\ANK\102\NETWORK\ADMIN\SQLNET.ORA

# 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)


Regards,
Ankit Baphna
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 30th August 2014 - 07:22 AM