Home » Infrastructure » Linux » port allocation error on Database 10g
icon5.gif  port allocation error on Database 10g [message #252298] Wed, 18 July 2007 09:23 Go to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
I'm having trouble getting Database Control up and running in an Oracle Database 10g installation in RHEL4 Linux. I consistently see errors like these when I try to create or recreate the repository using emca:
SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]

When I check these port ranges with netstat or lsof, nothing is running on those ports, and I can't figure out why Oracle can't work with them. I've even disabled iptables completely to try again, but this has no effect.

When I try to set port values manually (emca -reconfig ports ...), I get "Database Control is not configured for this database."

When I configure Database Control (emca -config dbcontrol db), I get the port allocation error. It seems to be a vicious cycle.

Thanks for any ideas you may have.
Re: port allocation error on Database 10g [message #252338 is a reply to message #252298] Wed, 18 July 2007 12:00 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Whats your enteries in portlist.ini and readme.txt.
Re: port allocation error on Database 10g [message #252361 is a reply to message #252338] Wed, 18 July 2007 12:49 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
$ cat $ORACLE_HOME/install/portlist.ini
iSQL*Plus HTTP port number =5560

$ cat $ORACLE_HOME/install/readme.txt
The following J2EE Applications have been deployed and are accessible at the URLs listed below.

iSQL*Plus URL:
http://[my.hostname]:5560/isqlplus

iSQL*Plus DBA URL:
http://[my.hostname]:5560/isqlplus/dba


Re: port allocation error on Database 10g [message #252370 is a reply to message #252361] Wed, 18 July 2007 13:08 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
did you grep your ports with
netstat -i |grep <port> was that free?
Re: port allocation error on Database 10g [message #252375 is a reply to message #252370] Wed, 18 July 2007 13:13 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
Yes, I checked all active port ranges with netstat -na, and none of the ports Oracle wanted to allocate were open Sad
Re: port allocation error on Database 10g [message #252379 is a reply to message #252375] Wed, 18 July 2007 13:23 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Try to change the port for Em

http://download-uk.oracle.com/docs/html/B10130_02/ports.htm#BEHEFACG
Re: port allocation error on Database 10g [message #252385 is a reply to message #252379] Wed, 18 July 2007 14:15 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
Tried:

$ grep ConsoleServerPort $ORACLE_HOME/sysman/config/emoms.properties
oracle.sysman.emSDK.svlt.ConsoleServerPort=5500
$ grep ConsoleServerHTTPSPort $ORACLE_HOME/sysman/config/emoms.properties
oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=5500

$ emca -config dbcontrol db

STARTED EMCA at Jul 18, 2007 3:08:00 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: oracledb
Listener port number: 1522
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /usr/local/oracle/10g

Database hostname ................ [myhost]
Listener port number ................ 1522
Database SID ................ oracledb
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jul 18, 2007 3:08:12 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /usr/local/oracle/10g/cfgtoollogs/emca/oracledb/emca_2007-07-18_03-07-59-PM.log.
Jul 18, 2007 3:08:12 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
Jul 18, 2007 3:08:13 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
Refer to the log file at /usr/local/oracle/10g/cfgtoollogs/emca/oracledb/emca_2007-07-18_03-07-59-PM.log for more details.
Could not complete the configuration. Refer to the log file at /usr/local/oracle/10g/cfgtoollogs/emca/oracledb/emca_2007-07-18_03-07-59-PM.log for more details.

Mad
Re: port allocation error on Database 10g [message #252410 is a reply to message #252385] Wed, 18 July 2007 15:00 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
try these commands

emca -reconfig ports -DBCONTROL_HTTP_PORT 1820



emca -reconfig ports -RMI_PORT 5520



emca -reconfig ports -JMS_PORT 5521
Re: port allocation error on Database 10g [message #252412 is a reply to message #252410] Wed, 18 July 2007 15:03 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
All three commands fail with "SEVERE: Database Control is not configured for this database."
Re: port allocation error on Database 10g [message #252414 is a reply to message #252412] Wed, 18 July 2007 15:05 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Post cat /etc/sysctl.conf ??


cat >> /etc/sysctl.conf <<EOF

fs.file-max = 65536

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.core.rmem_default = 1048576

net.core.rmem_max = 1048576

net.core.wmem_default = 262144

net.core.wmem_max = 262144

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.ip_local_port_range = 1024 65000

EOF

[Updated on: Wed, 18 July 2007 15:06]

Report message to a moderator

Re: port allocation error on Database 10g [message #252433 is a reply to message #252414] Wed, 18 July 2007 16:16 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
Yup, already added those parameters, and followed up with a "sysctl -p" to implement the changes.
Re: port allocation error on Database 10g [message #252434 is a reply to message #252433] Wed, 18 July 2007 16:17 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you create this database manually??
Re: port allocation error on Database 10g [message #252663 is a reply to message #252434] Thu, 19 July 2007 10:27 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
I have de/re-installed four or five times now, each time trying different things (creating the database manually, creating it with the DBCA during installation, etc.), and each time the end results has been exactly the same, same errors and everything else.

[Updated on: Thu, 19 July 2007 10:38]

Report message to a moderator

Re: port allocation error on Database 10g [message #262125 is a reply to message #252663] Fri, 24 August 2007 11:47 Go to previous messageGo to next message
smrti
Messages: 1
Registered: August 2007
Location: NYC
Junior Member
Maybe this is too late to be of help-- But deesto's problem is symptomatic of the machine's IP address being out of sync with the IP address that is registered with the DNS server. It looks like you are on Unix of some kind, so try this:

1. Check your hostname:

$ hostname
foo.example.com


2. Find out if your /etc/hosts file has an entry matching this hostname:

$ cat /etc/hosts
10.10.10.5 foo.example.com


3. Find out what your hostname is registered as in DNS:

$ nslookup foo.example.com

...or...

$ host foo.example.com
foo.example.com has address 10.10.10.6


Make sure the two IP addresses are the same and then try recreating the repository.

$ emca -config dbcontrol db




Re: port allocation error on Database 10g [message #262129 is a reply to message #262125] Fri, 24 August 2007 12:03 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Yes Its late Wink

But helpful.
Re: port allocation error on Database 10g [message #262130 is a reply to message #262125] Fri, 24 August 2007 12:10 Go to previous messageGo to next message
deesto
Messages: 36
Registered: March 2005
Location: NY, USA
Member
Better late than never! Wink I'd given up on this for a while, but your advice seems sane. If I get a chance to try again, I'll report back. Thank you.
Re: port allocation error on Database 10g [message #432257 is a reply to message #252298] Mon, 23 November 2009 05:01 Go to previous messageGo to next message
WillIm
Messages: 13
Registered: June 2008
Location: Kyrgyzstan, Bishkek
Junior Member
This thread seems to be pretty old, but the following bit of knowledge may be useful to consider:
The other day I've faced the same issue and the solution was hidden in file /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
ip-address hostname hostname.domain-name.local
127.0.0.1 hostname localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6


The reason was in incorrect ip-address, it was different from actual hostname ip address. I changed it to correct value and was able to configure EM.
Re: port allocation error on Database 10g [message #449240 is a reply to message #252298] Sun, 28 March 2010 11:59 Go to previous message
realfEZ
Messages: 1
Registered: March 2010
Junior Member
Thanks Wink my IP had changed...

best_regs
Previous Topic: Adding disk space to already mounted filesystem
Next Topic: 11g Download & Install
Goto Forum:
  


Current Time: Fri Mar 29 09:00:30 CDT 2024