1 2 3 Previous Next 37 Replies Latest reply: Jan 22, 2013 8:01 AM by 986383 Go to original post RSS
      • 30. Re: ORA-12514 When trying to add the secondary physical database
        teits
        Hi Shanaka,

        seems you have a lot mixed up! Advise that you read all the links/blog that are given to you in your threads.
        More importantly read Dataguard 11g documentation. http://docs.oracle.com/cd/E11882_01/server.112/e17022/concepts.htm#SBYDB00010

        you still did not executed the commands exactly as it was posted nonetheless your standby role should not be primary.

        Best regards and good luck
        Tobi
        • 31. Re: ORA-12514 When trying to add the secondary physical database
          894939
          Hi Todi,

          Thanks for the link , Can you please let me know what is the command I missed

          Thanks,
          Shanaka.
          • 32. Re: ORA-12514 When trying to add the secondary physical database
            teits
            Hello again,

            this should be executed in ONE terminal, on the primary DB terminal. and when you want to copy and paste, copy also the commands you executed. we are not there when you execute those commands ;) .
            $lsnrctl services
            $sqlplus sys/password@DGR   --EDITED: Connect to the standby DB. not primary db!. from your previous post DGR tns is for your standby. secondly do not edit the result or the command you execute. thks
            SQL>SELECT DB_UNIQUE_NAME,PRIMARY_DB_UNIQUE_NAME, DATABASE_ROLE FROM V$DATABASE;
            SQL> exit
            dgmgrl sys/password
            dgmgrl>ADD DATABASE dgr AS CONNECT IDENTIFIER IS DGR
            But i have seen that you have not configured your Dataguard properly(your standby should not be in primary ROLE). firstly, properly configure the data guard.
            FYI: this command
            sqlplus sys/password@DGR
            is to determine maybe you can connect to your standby DB from your primary.

            Tobi
            • 33. Re: ORA-12514 When trying to add the secondary physical database
              894939
              Hi Todi,

              When i tried to connect DR from PR I'm getting the same ora 12514

              -----------------------------------
              Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
              With the Partitioning, OLAP, Data Mining and Real Application Testing options
              oracledgp:oradgp 84> sqlplus sys/passw0rd@DGR

              SQL*Plus: Release 11.2.0.2.0 Production on Tue Nov 20 17:08:38 2012

              Copyright (c) 1982, 2010, Oracle. All rights reserved.

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



              Please find those command output below....

              From Primary

              SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
              oracledgp:oradgp 86>
              oracledgp:oradgp 86> lsnrctl services

              LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-NOV-2012 17:29:04

              Copyright (c) 1991, 2010, Oracle. All rights reserved.

              Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DGP.WORLD))
              Services Summary...
              Service "DGP_DGMGRL.oracledgp" has 1 instance(s).
              Instance "DGP", status UNKNOWN, has 1 handler(s) for this service...
              Handler(s):
              "DEDICATED" established:998 refused:0
              LOCAL SERVER
              The command completed successfully
              oracledgp:oradgp 87>

              Edited by: Shanaka Chandrasekera on Nov 20, 2012 4:01 AM
              • 34. Re: ORA-12514 When trying to add the secondary physical database
                894939
                Hi Todi,

                Hope now the issue is rectified to some extend , the service name which I put in tnsnames.ora should be same as the service name which listner has allocated . After edited accordingly the ORA-12514 has gone (SERVICE_NAME=DGP_DGMGRL.oracledgr).

                Now when I tried the same I got below

                DGMGRL> ADD DATABASE 'dgr' AS CONNECT IDENTIFIER IS oracledgr;
                Error: ORA-16831: operation disallowed on this standby database type

                Failed.


                Anyone have any idea on this error?

                Best Regards,
                Shanaka.
                • 35. Re: ORA-12514 When trying to add the secondary physical database
                  teits
                  Hi,

                  ON standby DB
                  $lsnrctl services
                  SQL>SELECT DB_UNIQUE_NAME,PRIMARY_DB_UNIQUE_NAME, DATABASE_ROLE FROM V$DATABASE;
                  Tobi
                  • 36. Re: ORA-12514 When trying to add the secondary physical database
                    894939
                    Hi Todi,

                    Please find them below

                    oracledgr:~ # su - oradgp
                    oracledgr:oradgp 49> lsnrctl services

                    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 22-NOV-2012 14:48:08

                    Copyright (c) 1991, 2010, Oracle. All rights reserved.

                    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DGP.WORLD))
                    Services Summary...
                    Service "DGP_DGMGRL.oracledgr" has 1 instance(s).
                    Instance "DGP", status UNKNOWN, has 1 handler(s) for this service...
                    Handler(s):
                    "DEDICATED" established:0 refused:0
                    LOCAL SERVER
                    The command completed successfully
                    oracledgr:oradgp 50> sqlplus sys as sysdba


                    SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 22 14:48:34 2012

                    Copyright (c) 1982, 2010, Oracle. All rights reserved.

                    Enter password:

                    Connected to:
                    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
                    With the Partitioning, OLAP, Data Mining and Real Application Testing options

                    SQL> SELECT DB_UNIQUE_NAME,PRIMARY_DB_UNIQUE_NAME, DATABASE_ROLE FROM V$DATABASE;

                    DB_UNIQUE_NAME PRIMARY_DB_UNIQUE_NAME DATABASE_ROLE
                    ................................... ...................................... ..................................
                    DGR PRIMARY

                    SQL>

                    Thanks,
                    Shanaka
                    • 37. Re: ORA-12514 When trying to add the secondary physical database
                      986383
                      Provide full permisson for listner.ora,sqlnet.ora and tnsnames.ora in network/admin and usr/sap/<SID>/SYS/profile/oracle.
                      Also use backup control file from primary to mount standby.
                      1 2 3 Previous Next