| WIERD LISTENER ISSUE [message #335495] |
Tue, 22 July 2008 05:56  |
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 #335507 is a reply to message #335495] |
Tue, 22 July 2008 06:45  |
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 #335546 is a reply to message #335495] |
Tue, 22 July 2008 09:34 |
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 #335624 is a reply to message #335621] |
Wed, 23 July 2008 00:39 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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)!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
