[SOLVED] Oracle 11G error: listener refused the connection with the following error ora-12505

apss_evaluator · 05-15-2012, 06:55 AM

Hello Guys

I've just configured Oracle 11G in CentOS 6.2 using the step by step procedure in http://www.server-world.info/en/note...=oracle11g&f=2

The test database is ok and we can connect through it using oracle client. The problem is, after I decided to change the hostname (name of the server) I encountered this error:
listener refused the connection with the following error ora-12505

when I tried again to connect in oracle client. I've already checked the all including the hosts file. One more thing when I'm trying to check / netstat the port 1521 eventually after my second test it dissapears.

Is there any configuration that needs to be adjusted? sorry for my english grammar and thanks in advance

kbp · 05-15-2012, 07:04 AM

You can't just change the hostname once oracle is installed, the database won't be accessible (as you found). Change the hostname back and you'll regain access to the database, I'm not sure on the actual change/s required in the db but the process is:

1. do something in the db to match the new hostname
2. shut down the database
3. change the hostname
4. bring the database back up

Sorry I can't provide the details, but a if you have a metalink login you should be able to find the process.

apss_evaluator · 05-16-2012, 02:12 AM

Quote:

Originally Posted by kbp

You can't just change the hostname once oracle is installed, the database won't be accessible (as you found). Change the hostname back and you'll regain access to the database, I'm not sure on the actual change/s required in the db but the process is:

1. do something in the db to match the new hostname
2. shut down the database
3. change the hostname
4. bring the database back up

Sorry I can't provide the details, but a if you have a metalink login you should be able to find the process.

Hello,

Is there any other options to fix this? I changed back the server's hostname but still it has the same issue. I noticed that the port 1521 is not listening even though I've already configured it correctly and the oracle server is running

kbp · 05-16-2012, 05:34 AM

Have you tried restarting the listener?

from memory, as the oracle user:

Code:

lsnrctl status
# should give you something like:
# (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.domain.tld)(PORT=1521)))
# if the output is incorrect then try:
lsnrctl stop
lsnrctl start