LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices



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

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

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
 
Old 06-06-2010, 10:39 AM   #2
AlucardZero
Senior Member
 
Registered: May 2006
Location: USA
Distribution: Debian
Posts: 4,652

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

Rep: Reputation: 17
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
 
Old 06-07-2010, 03:42 AM   #4
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.6, Centos 5.10
Posts: 16,324

Rep: Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041
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
 
Old 06-07-2010, 03:56 AM   #5
Disillusionist
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):
Code:
lsnrctl status
 
  


Reply

Tags
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 03:05 AM.

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