LinuxQuestions.org
Visit Jeremy's Blog.
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
 
Search this Thread
Old 05-15-2012, 07:55 AM   #1
apss_evaluator
Member
 
Registered: Mar 2012
Posts: 57

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 07:57 AM.
 
Old 05-15-2012, 08:04 AM   #2
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 644Reputation: 644Reputation: 644Reputation: 644Reputation: 644Reputation: 644
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, 03:12 AM   #3
apss_evaluator
Member
 
Registered: Mar 2012
Posts: 57

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, 06:34 AM   #4
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

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


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 11:11 AM
Putty fatal error: Network error: connection refused (ubunty server 6.06.1) gerardnijboer Ubuntu 2 03-18-2010 04:46 PM
error while installing oracle 11g in CentOs 5.3 veeravicky Linux - Software 3 03-09-2010 07:53 PM
ORA-01034: ORACLE not available ORA-27101? suresheva31 Linux - General 0 10-18-2004 02:49 PM
no listener error when trying to connect to oracle 10g on linux from windows client kheldar Linux - Networking 1 07-25-2004 05:00 AM


All times are GMT -5. The time now is 09:11 AM.

Main Menu
Advertisement
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