10 Replies Latest reply: Dec 24, 2013 1:07 AM by TSharma-Oracle RSS

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

    817202

      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