Listener help [message #344375] |
Fri, 29 August 2008 10:01 |
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 #344419 is a reply to message #344417] |
Fri, 29 August 2008 14:14 |
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 |
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 #344601 is a reply to message #344375] |
Sat, 30 August 2008 23:29 |
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 |
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!
|
|
|
|