Home » Server Options » Data Guard » Listener help (Oracle 10.2.0.1.0 - Linux)
Listener help [message #344375] Fri, 29 August 2008 10:01 Go to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Hi!
First of all I'll give you my technical information.
Database: Oracle 10g
OS: Linux
I'm trying to implement Data Guard, but I don't seem to get it working.
When I run the following query 'select error from v$archive_dest where dest_name='LOG_ARCHIVE_DEST_2';'
It shows "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
The output of the command 'lsnrctl status' is...
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-AUG-2008 13:35:56

Copyright 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.12.15)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 28-AUG-2008 10:39:54
Uptime 0 days 2 hr. 56 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/app/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /u02/app/oracle/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.xx)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "xxx" has 2 instance(s).
Instance "xxx", status UNKNOWN, has 1 handler(s) for this service...
Instance "xxx_stby", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Why all those "UNKNOWN" status??

Thanks in advance
Re: Listener help [message #344402 is a reply to message #344375] Fri, 29 August 2008 13:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Status is UNKNOWN because the database is down.
Re: Listener help [message #344404 is a reply to message #344402] Fri, 29 August 2008 13:29 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Let me tell you the database is not down.
Re: Listener help [message #344414 is a reply to message #344375] Fri, 29 August 2008 13:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter system register;

Regards
Michel
Re: Listener help [message #344415 is a reply to message #344404] Fri, 29 August 2008 13:59 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
danyromimd wrote on Fri, 29 August 2008 14:29
Let me tell you the database is not down.

Well let me tell you, you should provide the FULL output of lsnrctl status next time. The UNKNOWN status is because you have static entries in your listener.ora file (which by the way are unnecessary).
Re: Listener help [message #344416 is a reply to message #344414] Fri, 29 August 2008 14:03 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
> alter system register;

Didn't work
Re: Listener help [message #344417 is a reply to message #344416] Fri, 29 August 2008 14:07 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
danyromimd wrote on Fri, 29 August 2008 14:29
Let me tell you the database is not down.


danyromimd wrote on Fri, 29 August 2008 15:03
Didn't work

Pretty rude considering you are getting FREE help !!!!
Re: Listener help [message #344418 is a reply to message #344416] Fri, 29 August 2008 14:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Set local_listener to value for the listener: '(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.12.15)(PORT=1521))' and reexecute the command.

Regards
Michel
Re: Listener help [message #344419 is a reply to message #344417] Fri, 29 August 2008 14:14 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Please!! I feel so sorry! I didn't mean to be rude... I'm spanish speaking and sometimes I say what I realy don't mean to... I beg your pardon, I'll try to be carefull in my writing next time.
Re: Listener help [message #344424 is a reply to message #344418] Fri, 29 August 2008 14:58 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
You're a genius!!!!
This is my lsnrctl statut output now...

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-AUG-2008 16:51:40

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.12.15)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 28-AUG-2008 10:39:54
Uptime 1 days 6 hr. 11 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/app/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /u02/app/oracle/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.11.12.15)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "xxx" has 3 instance(s).
Instance "xxx", status UNKNOWN, has 1 handler(s) for this service...
Instance "xxx", status READY, has 1 handler(s) for this service...
Instance "xxx_stby", status UNKNOWN, has 1 handler(s) for this service...
Service "comdoc3XDB" has 1 instance(s).
Instance "comdoc3", status READY, has 1 handler(s) for this service...
Service "grisu" has 1 instance(s).
Instance "xxx", status READY, has 1 handler(s) for this service...
Service "grisu_XPT" has 1 instance(s).
Instance "xxx", status READY, has 1 handler(s) for this service...
The command completed successfully

---------------------

Now look at the bold part... this is supposed to be the standby database listener... al least the one that I'm trying to configure... I guess I'm doing something wrong... or that I have a wrong idea of what I have to do....
Ah! Yet somethig else....
When I run the following query 'select error from v$archive_dest where dest_name='LOG_ARCHIVE_DEST_2';'
It shows "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
What can I do about this?
THANK YOU!!!
Re: Listener help [message #344426 is a reply to message #344375] Fri, 29 August 2008 15:16 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
https://metalink.oracle.com/metalink/plsql/f?p=130:10:4700315354124402767::::alltext,knowledge,numHits:ORA-12514,TRUE,100
There are numerous NOTES on Metalink regarding this error code.
One of them likely has the solution to your problem.
Re: Listener help [message #344601 is a reply to message #344375] Sat, 30 August 2008 23:29 Go to previous messageGo to next message
sonumalhi
Messages: 62
Registered: April 2008
Member
Does this lsnrctl status output is for your standby server or primary.
this error is due to Standby server listener don't have entry for standby database.
So when rfs process is trying to connect to standby to ship the logs it is unable to connect to standby.

Mehtab

Re: Listener help [message #344870 is a reply to message #344601] Mon, 01 September 2008 08:17 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member

> this lsnrctl status output is for your standby server or >primary.

This is the status for the primary server.

> this error is due to Standby server listener don't have entry >for standby database.
>So when rfs process is trying to connect to standby to ship the >logs it is unable to connect to standby.

I thought I had already configured it.... Would you tell me how it oughts to be done?

Thank you!
Re: Listener help [message #344909 is a reply to message #344375] Mon, 01 September 2008 15:32 Go to previous message
danyromimd
Messages: 73
Registered: August 2008
Member
Thanks a lot to all af you who helped me solve this problem... IT FINALLY WORKS!!!!
Previous Topic: ORA-16796 when addin physical database
Next Topic: standby_archive_dest full
Goto Forum:
  


Current Time: Tue Dec 06 10:21:35 CST 2016

Total time taken to generate the page: 0.12320 seconds