LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Oracle 11G error: listener refused the connection with the following error ora-12505 (https://www.linuxquestions.org/questions/linux-server-73/oracle-11g-error-listener-refused-the-connection-with-the-following-error-ora-12505-a-945051/)

apss_evaluator 05-15-2012 06:55 AM
Oracle 11G error: listener refused the connection with the following error ora-12505
 
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 (Post 4678756)
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


All times are GMT -5. The time now is 04:06 PM.