-   Linux - Newbie (
-   -   determine oracle port (

bluethundr 06-06-2010 09:07 AM

determine oracle port
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


netstat -tulpn | grep 1521
but that didn't turn up anything. I also tried several more common oracle ports


[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?


AlucardZero 06-06-2010 09:39 AM

lsof -i | grep oracle

Mikro 06-06-2010 09:48 AM


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...


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?

Disillusionist 06-07-2010 02:56 AM

Check the oracle listener is running.

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

lsnrctl status

All times are GMT -5. The time now is 01:19 AM.