Home » SQL & PL/SQL » SQL & PL/SQL » Query to get port no
Query to get port no [message #446109] Fri, 05 March 2010 08:46 Go to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi,

How to get a port number in database with a sql query.

Any help really appreciated.

Thanks in advance
Vikram
Re: Query to get port no [message #446110 is a reply to message #446109] Fri, 05 March 2010 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which port are you talking about?

Regards
Michel
Re: Query to get port no [message #446113 is a reply to message #446110] Fri, 05 March 2010 08:52 Go to previous messageGo to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi Michel,

I am asking about oracle port.

thanks & Regards
Vikram

Re: Query to get port no [message #446114 is a reply to message #446113] Fri, 05 March 2010 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which Oracle port, be precise.

Regards
Michel
Re: Query to get port no [message #446115 is a reply to message #446113] Fri, 05 March 2010 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 24904
Registered: January 2009
Senior Member
>How to get a port number in database with a sql query.
>I am asking about oracle port.

IMO, question makes no sense.

What problem are you really, really trying to solve.

Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Query to get port no [message #446116 is a reply to message #446114] Fri, 05 March 2010 08:56 Go to previous messageGo to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi Micel,

The port which current instance is running.

The which is provided in TNSNAMES.ORA file.

Regards
Vikram Kudikilla
Re: Query to get port no [message #446117 is a reply to message #446116] Fri, 05 March 2010 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The instance is not running on any port.
Listener is listening on a port.
This port is not known and available from the instance, it depends ONLY on the listener.

Regards
Michel
Re: Query to get port no [message #446118 is a reply to message #446117] Fri, 05 March 2010 09:01 Go to previous messageGo to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi,

I jst want to know the port where listener is listening.

SQL> select * from v$version
2 ;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Thanks & Regards
Vikram
Re: Query to get port no [message #446119 is a reply to message #446118] Fri, 05 March 2010 09:02 Go to previous messageGo to next message
BlackSwan
Messages: 24904
Registered: January 2009
Senior Member
lsnrctl status


command above will display the port(s)
Re: Query to get port no [message #446121 is a reply to message #446119] Fri, 05 March 2010 09:04 Go to previous messageGo to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi,

How to the same with sql query.

As dn't have access to unix system where oracle server is installed.

Thanks & Regards
Vikram
Re: Query to get port no [message #446136 is a reply to message #446121] Fri, 05 March 2010 10:36 Go to previous message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 05 March 2010 15:58
The instance is not running on any port.
Listener is listening on a port.
This port is not known and available from the instance, it depends ONLY on the listener.

Regards
Michel

Previous Topic: how to initialize a pl/sql array (merged by CM)
Next Topic: How to safely commit inside a cursor loop (merged by CM and JR)
Goto Forum:
  


Current Time: Sun Sep 25 11:10:18 CDT 2016

Total time taken to generate the page: 0.11161 seconds