Home » RDBMS Server » Server Administration » Port number (Oracle 9i ,XP)
Port number [message #388325] Tue, 24 February 2009 05:59 Go to next message
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
Re: Port number [message #388326 is a reply to message #388325] Tue, 24 February 2009 06:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Port number [message #388336 is a reply to message #388325] Tue, 24 February 2009 06:33 Go to previous messageGo to next message
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 Go to previous messageGo to next message
babuknb
Messages: 1734
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 Go to previous messageGo to next message
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
Re: Port number [message #388350 is a reply to message #388347] Tue, 24 February 2009 07:27 Go to previous messageGo to next message
ThomasG
Messages: 3189
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 Go to previous messageGo to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

I want to get using a sql query
Re: Port number [message #388396 is a reply to message #388325] Tue, 24 February 2009 10:21 Go to previous message
BlackSwan
Messages: 25050
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.
Previous Topic: SHUTDOWN IMMEDIATE
Next Topic: LOB Segments not releasing space
Goto Forum:
  


Current Time: Sat Dec 10 00:59:25 CST 2016

Total time taken to generate the page: 0.17670 seconds