Home » RDBMS Server » Server Administration » ORACLE 10.2 not able to start listener (merged 3)
ORACLE 10.2 not able to start listener (merged 3) [message #406074] Tue, 02 June 2009 01:27 Go to next message
ankitbaphna
Messages: 7
Registered: June 2009
Junior Member
Already same message open, so closing this one.

[Updated on: Tue, 02 June 2009 01:31]

Report message to a moderator

ORACLE 10.2 not able to start listener [message #406075 is a reply to message #406074] Tue, 02 June 2009 01:28 Go to previous messageGo to next message
ankitbaphna
Messages: 7
Registered: June 2009
Junior Member
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:\oracle\ANK\102\network\admin\sqlnet.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 <OracleANK102TNSListener>, error 1060.
Failed to start service, error 1060.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error


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

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

One more strange thing I have noticed. I have two SQLNET.ora in my machine

1) C:\oracle\ANK\102\NETWORK\ADMIN\SQLnet.ora
Content :-
*********************
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)

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



2) C:\oracle\NETWORK\ADMIN\sqlnet.ora
Content:-

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

################
# 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
NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, ONAMES, HOSTNAME)

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


but if I do tnsping ANK.WORLD it says used paramtere C:\oracle\ANK\102\NETWORK\ADMIN\SQLnet.ora

I see Listener.ora and tnsnames.ora in folder
C:\oracle\ANK\102\NETWORK\ADMIN\

Kindly sugges what to do?

Attaching tnsname, sqlnet and listener.ora files

Regards,
Ankit Baphna

  • Attachment: tnsnames.ora
    (Size: 0.56KB, Downloaded 160 times)
Oracle 10.2 Listener is not listening :) [message #406098 is a reply to message #406074] Tue, 02 June 2009 04:00 Go to previous messageGo to next message
ankitbaphna
Messages: 7
Registered: June 2009
Junior Member
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:\oracle\ANK\102\network\admin\sqlnet.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 <OracleANK102TNSListener>, error 1060.
Failed to start service, error 1060.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

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

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

One more strange thing I have noticed. I have two SQLNET.ora in my machine

1) C:\oracle\ANK\102\NETWORK\ADMIN\SQLnet.ora
Content :-
*********************
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)

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



2) C:\oracle\NETWORK\ADMIN\sqlnet.ora
Content:-

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

################
# 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
NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, ONAMES, HOSTNAME)

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


but if I do tnsping ANK.WORLD it says used paramtere C:\oracle\ANK\102\NETWORK\ADMIN\SQLnet.ora

I see Listener.ora and tnsnames.ora in folder
C:\oracle\ANK\102\NETWORK\ADMIN\

Kindly sugges what to do?

Attaching tnsname, sqlnet and listener.ora files

Regards,
Ankit Baphna
Re: Oracle 10.2 Listener is not listening :) [message #406100 is a reply to message #406098] Tue, 02 June 2009 04:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is useless to repeat over and over the same question.
You won't get more answer, it is even the opposite as I will not answer.

Regards
Michel
Re: Oracle 10.2 Listener is not listening :) [message #406118 is a reply to message #406100] Tue, 02 June 2009 05:52 Go to previous messageGo to next message
ankitbaphna
Messages: 7
Registered: June 2009
Junior Member
I did not copy this message intentionally.

I am new to this orafaq tool thats the reason...it got double entry bymistake. I was also not able to delete my own message.

Anyways thanks for your time.

Regards,
Ankit Baphna
Re: ORACLE 10.2 not able to start listener (merged 3) [message #406193 is a reply to message #406074] Tue, 02 June 2009 14:40 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
rename listener.ora & sqlnet.ora to new/different names.
reboot Windoze

after the system has been up 5 minutes or so open a COMMAND window
while logged onto OS as user oracle ( which ever account owns the Oracle s/w) & issue following commands:

lsnrctl start
lsnrctl status
lsnrctl service
set

using COPY & PASTE post commands above & the results back here
Re: ORACLE 10.2 not able to start listener (merged 3) [message #406298 is a reply to message #406193] Wed, 03 June 2009 03:45 Go to previous messageGo to next message
ankitbaphna
Messages: 7
Registered: June 2009
Junior Member
ok I renamed listener and sqlnet

check status of lsnrctlc start/service/status and sqlplus in document attached.

Regards,
Ankit Baphna

  • Attachment: cmd.doc
    (Size: 163.00KB, Downloaded 503 times)
Re: ORACLE 10.2 not able to start listener (merged 3) [message #406299 is a reply to message #406298] Wed, 03 June 2009 03:50 Go to previous messageGo to next message
ankitbaphna
Messages: 7
Registered: June 2009
Junior Member
ok I can see now listener started in service.

great
but in sqlplus still same issue not able to connect it says
TNS:Protocol Adapter error

Regards,
Ankit Baphna
Re: ORACLE 10.2 not able to start listener (merged 3) [message #406302 is a reply to message #406299] Wed, 03 June 2009 03:59 Go to previous message
ankitbaphna
Messages: 7
Registered: June 2009
Junior Member
Log of listener.log says

*************************************************
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-JUN-2009 14:09:43

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

Log messages written to c:\oracle\ANK\102\network\log\listener.log
Trace information written to c:\oracle\ANK\102\network\trace\listener.trc
Trace level is currently 0

Started with pid=4888
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=INLD50057853A)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
03-JUN-2009 14:09:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=I041468))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
WARNING: Subscription for node down event still pending
03-JUN-2009 14:10:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=I041468))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
03-JUN-2009 14:10:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=I041468))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * services * 0
03-JUN-2009 14:17:17 * ping * 0
WARNING: Subscription for node down event still pending
03-JUN-2009 14:17:30 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=I041468))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
03-JUN-2009 14:26:19 * ping * 0
WARNING: Subscription for node down event still pending
03-JUN-2009 14:27:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=I041468))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0



but when try to connet to sqlplus it gives tns protocol error.

Regards,
Ankit Baphna
Previous Topic: Querying installed bugfixes (10.2.0.4.0 merged 2)
Next Topic: Help Needed - to stop jobs
Goto Forum:
  


Current Time: Wed Dec 07 14:44:13 CST 2016

Total time taken to generate the page: 0.11614 seconds