1 2 3 Previous Next 31 Replies Latest reply: Jan 17, 2013 6:36 AM by CKPT Go to original post RSS
      • 30. Re: not able to get data of primary in standby database (configured dataguard)
        974427
        no.... cant connect

        at standby

        SQL> conn sys/oracle@prod as sysdba
        ERROR:
        ORA-12514: TNS:listener does not currently know of service requested in connect
        descriptor

        at prod

        SQL> conn sys/oracle@stand as sysdba
        ERROR:
        ORA-12514: TNS:listener does not currently know of service requested in connect
        descriptor
        • 31. Re: not able to get data of primary in standby database (configured dataguard)
          CKPT
          971424 wrote:
          no.... cant connect

          at standby

          SQL> conn sys/oracle@prod as sysdba
          ERROR:
          ORA-12514: TNS:listener does not currently know of service requested in connect
          descriptor

          at prod

          SQL> conn sys/oracle@stand as sysdba
          ERROR:
          ORA-12514: TNS:listener does not currently know of service requested in connect
          descriptor
          Am confused on your Listener entries, Where is connect descriptor of standby for the listener?
          listener.ora
          LISTPROD =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.98)(PORT = 1523))
          )
          )
          
          SID_LIST_LISTENER =
          (SID_LIST =
          (SID_DESC =
          (GLOBAL_DBNAME = PROD.WORLD)
          (ORACLE_HOME = D:\Oracle11g\app\Administrator\product\11.1.0)
          (SID_NAME = PROD)
          )
          (SID_DESC =
          (GLOBAL_DBNAME = AUX.WORLD)
          (ORACLE_HOME = D:\Oracle11g\app\Administrator\product\11.1.0)
          (SID_NAME = AUX)
          )
          )
          
          LISTSTAND =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.98)(PORT = 1522))
          )
          )
          
          LISTTEST =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.98)(PORT = 1521))
          )
          )
          Assuming your standby listener is "LISTSTAND" where is "SID_LIST_LISTENER" related to the Standby Listener?
          I would suggest you to review http://edstevensdba.wordpress.com/2011/03/19/ora-12514/ how to setup listener/tnsnames and modify accordingly.
          1 2 3 Previous Next