determine oracle port

bluethundr · 06-06-2010, 09:07 AM

hello, I need to find out what port our oracle databases are listening on. We have a cluster of web servers running on RHEL boxes talking to another RHEL cluster the latter hosts the oracle database.

I tried netstat to determine the connections to the database

Code:

netstat -tulpn | grep 1521

but that didn't turn up anything. I also tried several more common oracle ports

Code:

[root@racprod-db03 ~]# netstat -tap | grep 2481
[root@racprod-db03 ~]# netstat -tap | grep 1810
[root@racprod-db03 ~]# netstat -tap | grep 7778
[root@racprod-db03 ~]# netstat -tap | grep 1521

nada. Does anybody out there know what the current port that Oracle is using or maybe can suggest a method of determining that?

thanks

AlucardZero · 06-06-2010, 09:39 AM

lsof -i | grep oracle

Mikro · 06-06-2010, 09:48 AM

Try

Code:

netstat -anp | grep oracle -i

or replace the "grep oracle" with whatever the service is called (never used oracle, but mysql gets listed using this)
Also look with ps -a if the oracle service is running, just to be sure...

Dån

chrism01 · 06-07-2010, 02:42 AM

By Default Oracle SQL*Net Sw listens on 1521. Have you set up the tool and tnslsnr.ora file?
What versions of RHEL and Oracle do you have?
eg http://www.cuddletech.com/articles/oracle/node41.html

Disillusionist · 06-07-2010, 02:56 AM

Check the oracle listener is running.

As oracle (with the correct oracle home set if multiple homes):

Code:

lsnrctl status