OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Port number (Oracle 9i ,XP)

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

Port number [message #388325]

Tue, 24 February 2009 05:59

rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com

Senior Member

Is there any way to know the port number of a particular instance from the database.

Thanks

Report message to a moderator

Re: Port number [message #388326 is a reply to message #388325]

Tue, 24 February 2009 06:01

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you mean with "the port number of a particular instance"?
How is this a SQL or PL/SQL question?

Regards
Michel

Report message to a moderator

Re: Port number [message #388336 is a reply to message #388325]

Tue, 24 February 2009 06:33

rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com

Senior Member

In this script i will get port number ;but i want to obtain port number individually .How can i get it

This will not suuport in 9i only from 10 g

select D.LISTENER from SYS.V_$DISPATCHER_CONFIG d

Please help

Thanks in Advance

[Updated on: Tue, 24 February 2009 06:35]

Report message to a moderator

Re: Port number [message #388343 is a reply to message #388336]

Tue, 24 February 2009 06:50

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

1/ What do you mean by port number in oracle instance???

Or

1/ You want to find Listener port number from Query?? If Yes

[Updated on: Tue, 24 February 2009 06:54]

Report message to a moderator

Re: Port number [message #388347 is a reply to message #388343]

Tue, 24 February 2009 07:08

rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com

Senior Member

Yes i mean Listener Port number but this is not by running this query its not getting the port number that we supplied during oracle server installation
ie :1521

SELECT NAME, NETWORK FROM V$DISPATCHER;

Thanks

Report message to a moderator

Re: Port number [message #388350 is a reply to message #388347]

Tue, 24 February 2009 07:27

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

You could use

> lsnrctl status

from the command line.

I don't know if it makes any sense to try to get the port number form inside SQL, since then you would have to already be connected to the database, which you can't really do when you don't have the port number?

Or what is the exact scenario you are having?

[Updated on: Tue, 24 February 2009 07:29]

Report message to a moderator

Re: Port number [message #388352 is a reply to message #388350]

Tue, 24 February 2009 07:31

rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com

Senior Member

I want to get using a sql query

Report message to a moderator

Re: Port number [message #388396 is a reply to message #388325]

Tue, 24 February 2009 10:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there any way to know the port number of a particular instance from the database.
Instances do NOT have port numbers; but listener do.
I could be mistaken, but I am unaware that the "port number" is stored or contained with the DB; because the DB does not care about any port number.

Report message to a moderator

Previous Topic:	SHUTDOWN IMMEDIATE
Next Topic:	LOB Segments not releasing space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 20:29:00 CST 2024