Home » RDBMS Server » Server Administration » Port used by Oracle
Port used by Oracle [message #249434] Wed, 04 July 2007 08:25 Go to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Hi,

We are using oracle 10g in a Solaris box. The same box has Informatica also installed. But it runs on port 6001. But whenever the server is restarted the Oracle database picks up the port 6001 and does not allow Informatica to be started. But I am have no clue of which Oracle process is using this port. I had confirmed that Oracle is using that particular port, by shutting down and starting up the database.

Please help.

Report message to a moderator

Re: Port used by Oracle [message #249447 is a reply to message #249434] Wed, 04 July 2007 09:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Look at $ORACLE_HOME/install/portlist.ini to see what ports are being used. You can also review Managing Oracle Database Port Numbers.

Report message to a moderator

icon9.gif  Re: Port used by Oracle [message #249658 is a reply to message #249447] Thu, 05 July 2007 08:08 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
The portlist.ini does not have the port 6001 included. The specified url was informative. But I was unable to get any info related to my issue.

Report message to a moderator

Re: Port used by Oracle [message #250399 is a reply to message #249434] Mon, 09 July 2007 22:23 Go to previous messageGo to next message
mrfred8
Messages: 3
Registered: July 2007
Location: chicago
Junior Member
make sure lsof is installed on your box

run the command lsof -i -P|grep 6001 it will show you what process is using port 6001


Good Luck,
Fred
http://oraclebooks.org

Report message to a moderator

Re: Port used by Oracle [message #250400 is a reply to message #249434] Mon, 09 July 2007 22:27 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Alternatively
$ netstat -a | grep ESTAB
or
$ netstat -a | grep ESTAB | grep 6001

Report message to a moderator

Previous Topic: Auto start oracle
Next Topic: Autoextend on/off ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:41:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.