LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (http://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   determine oracle port (http://www.linuxquestions.org/questions/linux-newbie-8/determine-oracle-port-812454/)

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

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


All times are GMT -5. The time now is 05:07 AM.