OraFAQ Forum: Server Administration » ORACLE 10.2 not able to start listener (merged 3)

Home » RDBMS Server » Server Administration » ORACLE 10.2 not able to start listener (merged 3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE 10.2 not able to start listener (merged 3) [message #406074]

Tue, 02 June 2009 01:27

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

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 1186 times)

Report message to a moderator

Oracle 10.2 Listener is not listening :) [message #406098 is a reply to message #406074]

Tue, 02 June 2009 04:00

ankitbaphna
Messages: 7
Registered: June 2009

Junior Member

Report message to a moderator

Re: Oracle 10.2 Listener is not listening :) [message #406100 is a reply to message #406098]

Tue, 02 June 2009 04:08

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Oracle 10.2 Listener is not listening :) [message #406118 is a reply to message #406100]

Tue, 02 June 2009 05:52

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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

Report message to a moderator

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

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 1585 times)

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Querying installed bugfixes (10.2.0.4.0 merged 2)
Next Topic:	Help Needed - to stop jobs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 22:28:17 CDT 2024