 port allocation error on Database 10g [message #252298] |
Wed, 18 July 2007 09:23  |
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 #252361 is a reply to message #252338] |
Wed, 18 July 2007 12:49  |
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 #252385 is a reply to message #252379] |
Wed, 18 July 2007 14:15 |
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.
|
|
|
|
|
|
|
|
| Re: port allocation error on Database 10g [message #252414 is a reply to message #252412] |
Wed, 18 July 2007 15:05 |
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 #262125 is a reply to message #252663] |
Fri, 24 August 2007 11:47 |
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 #432257 is a reply to message #252298] |
Mon, 23 November 2009 05:01 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
