OraFAQ Forum: SQL & PL/SQL » Query to get port no

Home » SQL & PL/SQL » SQL & PL/SQL » Query to get port no

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

Query to get port no [message #446109]

Fri, 05 March 2010 08:46

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

Report message to a moderator

Re: Query to get port no [message #446110 is a reply to message #446109]

Fri, 05 March 2010 08:50

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

Senior Member
Account Moderator

Which port are you talking about?

Regards
Michel

Report message to a moderator

Re: Query to get port no [message #446113 is a reply to message #446110]

Fri, 05 March 2010 08:52

vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore

Senior Member

Hi Michel,

I am asking about oracle port.

thanks & Regards
Vikram

Report message to a moderator

Re: Query to get port no [message #446114 is a reply to message #446113]

Fri, 05 March 2010 08:54

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

Senior Member
Account Moderator

Which Oracle port, be precise.

Regards
Michel

Report message to a moderator

Re: Query to get port no [message #446115 is a reply to message #446113]

Fri, 05 March 2010 08:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: Query to get port no [message #446116 is a reply to message #446114]

Fri, 05 March 2010 08:56

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

Report message to a moderator

Re: Query to get port no [message #446117 is a reply to message #446116]

Fri, 05 March 2010 08:58

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

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

Report message to a moderator

Re: Query to get port no [message #446118 is a reply to message #446117]

Fri, 05 March 2010 09:01

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

Report message to a moderator

Re: Query to get port no [message #446119 is a reply to message #446118]

Fri, 05 March 2010 09:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

lsnrctl status

command above will display the port(s)

Report message to a moderator

Re: Query to get port no [message #446121 is a reply to message #446119]

Fri, 05 March 2010 09:04

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

Report message to a moderator

Re: Query to get port no [message #446136 is a reply to message #446121]

Fri, 05 March 2010 10:36

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

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 04 20:42:16 CDT 2025