Home » RDBMS Server » Server Administration » listener Issue
listener Issue [message #261654] Thu, 23 August 2007 04:12 Go to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
hi

i am running oracle server 10.2.0.1.0.

The database named CUS was running fine till today morning.

Now no clients are able to connect stating the error Listener not open.

But the server is up and running
CUS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = chn82690.ad.company.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CUS)
    )
  )



i have this entry in the tnsnames.ora.can anyone tell me what needs to be done?
Re: listener Issue [message #261656 is a reply to message #261654] Thu, 23 August 2007 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But the server is up and running

And the listener (lsnrctl status)?
Is the database in restricted mode (select logins from v$database)?

Regards
Michel
Re: listener Issue [message #261657 is a reply to message #261654] Thu, 23 August 2007 04:24 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

And also check listener.log file.
icon14.gif  Re: listener Issue [message #262008 is a reply to message #261657] Fri, 24 August 2007 06:03 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Thanks guys its fine now Smile
Re: listener Issue [message #262018 is a reply to message #262008] Fri, 24 August 2007 06:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What was the problem?
What was the solution?

Regards
Michel
Re: listener Issue [message #262306 is a reply to message #261654] Sun, 26 August 2007 01:53 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

A simple correction.
Quote:
select logins from v$database)?

It will be ,

select logins from v$instance
Re: listener Issue [message #262311 is a reply to message #262306] Sun, 26 August 2007 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course, thanks for the correction.

Regards
Michel
Re: listener Issue [message #262439 is a reply to message #262311] Mon, 27 August 2007 00:59 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
The listener control was not started i guess...i restarted
Re: listener Issue [message #262571 is a reply to message #262439] Mon, 27 August 2007 10:31 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
amul wrote on Sun, 26 August 2007 23:59
The listener control was not started i guess...i restarted



Listener Control??
Previous Topic: Dupilcate database
Next Topic: Alter System Reset................
Goto Forum:
  


Current Time: Sun Dec 04 02:28:48 CST 2016

Total time taken to generate the page: 0.06478 seconds