Oracle 11GR1进行创建数据库时出错解决一例

今天在as3上安装oracle11GR1，在进行到创造数据库时出现了如下图所示错误：

用dbca多次删除数据库再重次创建都不行。只好求百度了，查到如下：

---------------网上有如下描述---------------

报错:

SEVERE: Failed to allocate port(s) in the specified range for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM agent [1830-1849]

google搜的：

check the /etc/sysctl.conf file and check if contains following line:
net.ipv4.ip_local_port_range = 1024 65000

If not, then add that line save the file and reboot the system.
Also check the wheter some service is not running on required ports that was mentioned in the error messages.
You can check this issuing the "netstat -an | grep tcp | grep LISTEN" command.

 

上面的是10g, 不过oracle 11G上是port_range = 9000 65000

 

另一个网站上找的：

 

There can be number of reasons EMCA is not able to bind respective ports.

1. Network restrictions/firewall blocking the ports
2. Incorrectly configured hostname or the hosts file
3. Incorrect entry for loopback adapter in hosts file
4. Any other application using the port in the same range.

最后查的原因是 /etc/hosts 文件， 添加正确的主机名与IP即可。

---------------网上描述结束---------------

 

如网上描述的，检查/etc/sysctl.conf，没问题，网上描述最后一句提醒我，查看/etc/hosts发现ip与主机名没对，这时才想起我对这台机器改过ip，但没有修改/etc/hosts。把hosts文件修改后再运行dbca进行创建数据库，一切正常。

记下来，以防忘记了。