Home » RDBMS Server » Networking and Gateways » WIERD LISTENER ISSUE (Oracle 10g on HP UX B.11.11 U 9000/800)
WIERD LISTENER ISSUE [message #335495] Tue, 22 July 2008 05:56 Go to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Hey,

I am facing a wierd issue with listeners.

I am working on a hp server.
on path/home/****/ i had oracle server 10.1 installed and working proerly.
Then i installed oracle 10.2.0.1 on another filesystem /home2/****.

In the listener.ora of oracle 10.1 the port is 1521.
in the listener.ora of oracle 10.2 the port is 1522.

However the moment i start the listener on site oracle10.2, it starts the listener on port number 1521.

i have checked all the entries in pfile,spfile,tnsnames.ora,listener.ora,sqlnet.ora on the new installation i couuldn't find a mention of port 1521.

then why is it listening on port 1521..


Please help
Re: WIERD LISTENER ISSUE [message #335506 is a reply to message #335495] Tue, 22 July 2008 06:40 Go to previous messageGo to next message
Michel Cadot
Messages: 58856
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We have neither clue nor proof of you what did and say.

Regards
Michel
Re: WIERD LISTENER ISSUE [message #335507 is a reply to message #335495] Tue, 22 July 2008 06:45 Go to previous messageGo to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=rabobmhp)(PORT=1522))
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = HPQZ62)
(ORACLE_HOME = /oracle/product/10.2.0.1/Db_2)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rabobmhp)(PORT = 1522))
)
)
)


this is my listener.ora


and the o/p of my lsnrctl stat after i start it..
LSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 22-JUL-2008 17:04:16

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.1.0 - Production
Start Date 22-JUL-2008 16:46:13
Uptime 0 days 0 hr. 18 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0.1/Db_2/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0.1/Db_2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rabobmhp)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rabobmhp)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rabobmhp)(PORT=2100))(Presentation=FTP)(Session=RAW))




hope this is gud enuf a proof !!!

Please help
Re: WIERD LISTENER ISSUE [message #335526 is a reply to message #335495] Tue, 22 July 2008 07:54 Go to previous messageGo to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
check TNS_ADMIN environmental settings. and check which listener actually point to.

[Updated on: Tue, 22 July 2008 07:55]

Report message to a moderator

Re: WIERD LISTENER ISSUE [message #335546 is a reply to message #335495] Tue, 22 July 2008 09:34 Go to previous messageGo to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
there is one more doubt i want you to please help me with...

I have oracle10g installed on linux server.

I created another instance at a different oracle home on the same server...

what haapened was that the listener of the new instance automatically got started....

the entry is nowhere..still if i start the listener of older oracle instance..the newer instance listener automatically gets started...

can anyone please explain the funda.. !!!
Re: WIERD LISTENER ISSUE [message #335548 is a reply to message #335495] Tue, 22 July 2008 09:42 Go to previous messageGo to next message
BlackSwan
Messages: 22688
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

from above
>(HOST=)
null hostname????????????
Good Luck solving your mess/mystery.

[Updated on: Tue, 22 July 2008 10:12] by Moderator

Report message to a moderator

Re: WIERD LISTENER ISSUE [message #335621 is a reply to message #335548] Wed, 23 July 2008 00:35 Go to previous messageGo to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Sir,

I wrote exactly what the output of the commands was...

I have no clues as to why am i getting such a response...
Re: WIERD LISTENER ISSUE [message #335624 is a reply to message #335621] Wed, 23 July 2008 00:39 Go to previous message
BlackSwan
Messages: 22688
Registered: January 2009
Senior Member
ashish1986 wrote on Tue, 22 July 2008 22:35
Sir,

I wrote exactly what the output of the commands was...

I have no clues as to why am i getting such a response...


It is YOUR system.
since you are clueless, You're On Your Own (YOYO)!
Previous Topic: Oracle 10g to LDAP connectivity problems
Next Topic: WARNING: Subscription for node down event still pending
Goto Forum:
  


Current Time: Thu Aug 21 19:18:31 CDT 2014

Total time taken to generate the page: 0.09913 seconds