Visit the LQ Articles and Editorials section
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 06-06-2010, 10:07 AM   #1
Registered: Jun 2003
Location: Summit, NJ
Distribution: CentOS 5.4
Posts: 123

Rep: Reputation: 15
Post 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?

Old 06-06-2010, 10:39 AM   #2
Senior Member
Registered: May 2006
Location: USA
Distribution: Debian
Posts: 4,701

Rep: Reputation: 566Reputation: 566Reputation: 566Reputation: 566Reputation: 566Reputation: 566
lsof -i | grep oracle
Old 06-06-2010, 10:48 AM   #3
Registered: Oct 2007
Distribution: Slackware
Posts: 40

Rep: Reputation: 17
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...

Old 06-07-2010, 03:42 AM   #4
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.7, Centos 5.10
Posts: 16,923

Rep: Reputation: 2215Reputation: 2215Reputation: 2215Reputation: 2215Reputation: 2215Reputation: 2215Reputation: 2215Reputation: 2215Reputation: 2215Reputation: 2215Reputation: 2215
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?
Old 06-07-2010, 03:56 AM   #5
Senior Member
Registered: Aug 2004
Location: England
Distribution: Ubuntu
Posts: 1,013

Rep: Reputation: 83
Check the oracle listener is running.

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


oracle, rhel

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How does nmap determine a port is tcpwrapped? gsmith411 Linux - Security 2 12-07-2009 02:06 PM
How to determine USB port tty value coondog52 Linux - Hardware 14 06-29-2009 06:18 PM
How do you determine usb port speed? Chronothread Linux - Hardware 1 09-03-2008 10:17 PM
determine which port telnet is using cj4331 Linux - Newbie 3 09-03-2008 02:20 PM
JBoss Web Port Conflict with Oracle EMS Port fortezza Programming 1 05-21-2006 08:02 PM

All times are GMT -5. The time now is 05:37 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration