Home » Server Options » Data Guard » LOG_ARCHIVE_DEST_2 Error (oracle EE 10.2.0.1.0,RHEL AS 4)
LOG_ARCHIVE_DEST_2 Error [message #473587] Mon, 30 August 2010 08:31 Go to next message
sps1986
Messages: 4
Registered: July 2010
Location: Chennai
Junior Member
Dear All



We are trying to configuration the Dataguard in Oracle Database 10g Enterprise Edition Release 10.2.0.1.0. While we check the lsnr configuration the following error has occured.

SQL> select name from v$database;

NAME
---------
ACCLDATA

SQL> select status,error from v$archive_dest;

STATUS    ERROR
--------- -----------------------------------------------------------------
VALID
ERROR     ORA-12514: TNS:listener does not currently know of service
          requested in connect descriptor

INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE

STATUS    ERROR
--------- -----------------------------------------------------------------
INACTIVE

10 rows selected.



Kindly help me


sps1986
Re: LOG_ARCHIVE_DEST_2 Error [message #473592 is a reply to message #473587] Mon, 30 August 2010 09:14 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
icon2.gif  Re: LOG_ARCHIVE_DEST_2 Error [message #509557 is a reply to message #473587] Sun, 29 May 2011 21:22 Go to previous messageGo to next message
rk44
Messages: 18
Registered: June 2010
Junior Member
once check your listener and service name r pinging r not..bcz databases communication is done by oraclenet
Re: LOG_ARCHIVE_DEST_2 Error [message #509561 is a reply to message #509557] Sun, 29 May 2011 23:22 Go to previous message
Michel Cadot
Messages: 67294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and do NOT use IM speak.
Use complete words and complete sentences as well as correct english.
Your post is NOT understandable.

Regards
Michel
Previous Topic: step backup
Next Topic: how to check dataguard synchronization
Goto Forum:
  


Current Time: Sun Aug 09 22:02:40 CDT 2020