LinuxQuestions.org - determine oracle port

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - determine oracle port (https://www.linuxquestions.org/questions/linux-newbie-8/determine-oracle-port-812454/)

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

lsof -i | grep oracle

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

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

Check the oracle listener is running.

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

Code:

lsnrctl status