LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
LinkBack Search this Thread
Old 05-15-2012, 06:55 AM   #1
apss_evaluator
LQ Newbie
 
Registered: Mar 2012
Posts: 12

Rep: Reputation: Disabled
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

Last edited by apss_evaluator; 05-15-2012 at 06:57 AM.
 
Old 05-15-2012, 07:04 AM   #2
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,717

Rep: Reputation: 635Reputation: 635Reputation: 635Reputation: 635Reputation: 635Reputation: 635
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.
 
Old 05-16-2012, 02:12 AM   #3
apss_evaluator
LQ Newbie
 
Registered: Mar 2012
Posts: 12

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by kbp View Post
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
 
Old 05-16-2012, 05:34 AM   #4
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,717

Rep: Reputation: 635Reputation: 635Reputation: 635Reputation: 635Reputation: 635Reputation: 635
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle redhat6.1 x86 install Oracle 11g r2 error. reconcil Linux - Newbie 3 11-03-2011 10:11 AM
Putty fatal error: Network error: connection refused (ubunty server 6.06.1) gerardnijboer Ubuntu 2 03-18-2010 03:46 PM
error while installing oracle 11g in CentOs 5.3 veeravicky Linux - Software 3 03-09-2010 06:53 PM
ORA-01034: ORACLE not available ORA-27101? suresheva31 Linux - General 0 10-18-2004 01:49 PM
no listener error when trying to connect to oracle 10g on linux from windows client kheldar Linux - Networking 1 07-25-2004 04:00 AM


All times are GMT -5. The time now is 10:31 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration