This discussion is archived
1 2 3 Previous Next 31 Replies Latest reply: Jan 17, 2013 4:36 AM by CKPT Go to original post RSS
  • 30. Re: not able to get data of primary in standby database (configured dataguard)
    974427 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

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