10 Replies Latest reply: Dec 23, 2013 11:07 PM by TSharma-Oracle RSS

DMON: Failed to connect to remote database sbyorcl. Error is ORA-12514

vk82 Explorer
Currently Being Moderated

Hi All,

 

I am facing problem while adding physical standby database in data guard broker configuration. The error which i am getting is as:

 

DGMGRL> add database sbyorcl as connect identifier is sbyorcl;

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

 

While checking the log file for DG it says:-

 

DMON: Failed to connect to remote database sbyorcl. Error is ORA-12514

DMON: Failed to get properties from remote database sbyorcl.  Error is ORA-12514

835047062 DMON: ADD_DATABASE: (error=ORA-12514)

 

my listener.ora file looks like:-

 

[oracle@pc01 admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = orcl_DGMGRL.us.oracle.com)

      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)

      (SID_NAME = orcl)

    )

  )

 

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pc01.us.oracle.com)(PORT = 1521))

  )

 

 

My tnsnames.ora file looks like:

 

[oracle@pc01 admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = orcl_DGMGRL.us.oracle.com)

      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)

      (SID_NAME = orcl)

    )

  )

 

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pc01.us.oracle.com)(PORT = 1521))

  )

 

[oracle@pc01 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

SBYORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = pc02.us.oracle.com)(PORT = 12001))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = sbyorcl)

    )

  )

 

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pc01.us.oracle.com)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

 

 

My Standby Listener file looks like:-

 

[oracle@pc02 admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

LISTENER1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pc02.us.oracle.com)(PORT = 12001))

  )

 

SID_LIST_LISTENER1 =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = sbyorcl_DGMGRL.us.oracle.com)

      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)

      (SID_NAME = sbyorcl)

    )

  )

 

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pc02.us.oracle.com)(PORT = 1521))

  )

 

 

Tnsnames.ora file looks like:-

 

[oracle@pc02 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

SBYORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = pc02.us.oracle.com)(PORT = 12001))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = sbyorcl)

    )

  )

 

ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = pc01.us.oracle.com)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

LISTENER1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pc02.us.oracle.com)(PORT = 12001))

  )

 

 

On primary database:-

 

[oracle@pc01 admin]$ tnsping orcl

 

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 24-DEC-2013 22:26:21

 

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

 

Used parameter files:

/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = pc01.us.oracle.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))

OK (0 msec)

 

 

[oracle@pc01 admin]$ tnsping sbyorcl

 

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 24-DEC-2013 22:26:41

 

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

 

Used parameter files:

/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = pc02.us.oracle.com)(PORT = 12001))) (CONNECT_DATA = (SERVICE_NAME = sbyorcl)))

OK (0 msec)

 

 

On Standby DB:-

 

[oracle@pc02 admin]$ tnsping orcl

 

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 24-DEC-2013 22:27:05

 

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

 

Used parameter files:

/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = pc01.us.oracle.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))

OK (10 msec)

 

 

[oracle@pc02 admin]$ tnsping sbyorcl

 

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 24-DEC-2013 22:27:24

 

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

 

Used parameter files:

/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = pc02.us.oracle.com)(PORT = 12001))) (CONNECT_DATA = (SERVICE_NAME = sbyorcl)))

OK (0 msec)

 

 

 

 

Any idea over the same to sort out my problem. Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points