This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Jul 31, 2013 9:11 AM by Abufazal Go to original post RSS
  • 15. Re: [DataGuard][Error 12514]  Error received logging on to the standby
    Piotr91 Newbie
    Currently Being Moderated

    OK, I have created (on standby) listener.ora file with contest as follows:

     

    SID_LIST_LISTENER =

      (SID_LIST =

        (SID_DESC =

          (GLOBAL_DBNAME = primdb1)

          (ORACLE_HOME = /u01/app/oracle/product/11gR2/dbhome_1)

          (SID_NAME = primdb1)

        )

      )

     

    LISTENER =

      (DESCRIPTION_LIST =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST =10.132.28.33)(PORT = 1521))

        )

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

        )

      )

     

    ADR_BASE_LISTENER = /u01/app/oracle

     

    [oracle@rh1 dbhome_1]$ bin/lsnrctl start

     

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 31-JUL-2013 10:35:26

     

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

     

    Starting /u01/app/oracle/product/11gR2/dbhome_1/bin/tnslsnr: please wait...

     

    TNSLSNR for Linux: Version 11.2.0.1.0 - Production

    System parameter file is /u01/app/oracle/product/11gR2/dbhome_1/network/admin/listener.ora

    Log messages written to /u01/app/oracle/diag/tnslsnr/rh1/listener/alert/log.xml

    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.132.28.33)(PORT=1521)))

    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

     

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.132.28.33)(PORT=1521)))

    STATUS of the LISTENER

    ------------------------

    Alias                     LISTENER

    Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

    Start Date                31-JUL-2013 10:35:26

    Uptime                    0 days 0 hr. 0 min. 0 sec

    Trace Level               off

    Security                  ON: Local OS Authentication

    SNMP                      OFF

    Listener Parameter File   /u01/app/oracle/product/11gR2/dbhome_1/network/admin/listener.ora

    Listener Log File         /u01/app/oracle/diag/tnslsnr/rh1/listener/alert/log.xml

    Listening Endpoints Summary...

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.132.28.33)(PORT=1521)))

      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

    Services Summary...

    Service "primdb1" has 1 instance(s).

      Instance "primdb1", status UNKNOWN, has 1 handler(s) for this service...

    The command completed successfully

     

    Something is wrong, I guess. Is my listener.ora file correct?

  • 16. Re: [DataGuard][Error 12514]  Error received logging on to the standby
    mseberg Guru
    Currently Being Moderated

    Hello;

     

    Would expect the GLOBAL_DBNAME to be:

     

     

     

    (GLOBAL_DBNAME = primdb1_DGMGRL.your.host.com)

     

     

     

     

    Might add :

     

     

    INBOUND_CONNECT_TIMEOUT_ = 120

     

     

     

    As a new line under ADR_BASE_LISTENER

     

    Make sure you restart the listener.

     

     

    Data Guard Listener Example

     

    Best Regards

     

     

    mseberg

  • 17. Re: [DataGuard][Error 12514]  Error received logging on to the standby
    Piotr91 Newbie
    Currently Being Moderated

    (GLOBAL_DBNAME = primdb1_DGMGRL.your.host.com)

    I don't get the .your.host.com. Do I need to add there an ip address of my primary db server or I have to add to my primary db server  /etc/hosts and then replace .your.host.com with name I have specified for my primdb server in /etc/hosts/?

    And could you explain why do I need to add 'DGMGRL' after SID of my primary db?

     

    Thanks.

  • 18. Re: [DataGuard][Error 12514]  Error received logging on to the standby
    mseberg Guru
    Currently Being Moderated

    Hello;

     

    I always use DNS instead of IP address. But the /etc/hosts should cover you as well.

     

    DGMGRL is an entry for Data Guard Broker. You may not use it, but by adding it now you don't have to change the listener again. Mostly your listener looks like it should fly.

     

    I assume the standby is already in MOUNT.

     

    Until you can do the following:

     

    sqlplus sys/pass@Standby as sysdba (from the primary system)

     

    and

     

    sqlplus sys/pass@primary as sysdba (from the standby system)

     

    You will not be able to ship redo.

     

    Best Regards

     

    mseberg

  • 19. Re: [DataGuard][Error 12514]  Error received logging on to the standby
    Abufazal Journeyer
    Currently Being Moderated

    What name should have the password file on standby server?

    On standby and primary server ORACLE_SID=primdb1. The db_unique_name=stbydb1 for standby and db_unique_name=primdb1 for primary.

    orapwd file=$ORACLE_HOME/dbs/orapwd<ORACLE_SID>.ora password=<password> entries=<maximum number of distict DBA>

     

    Therefor for primary it would be,

     

    orapwd file=$ORACLE_HOME/dbs/orapwprimdb1.ora password=<intended password> entries=10 (example)

     

    Once created, copy the file to standby server to $ORACLE_HOME/dbs location of standby database and rename the file as orapwstbydb1.ora

  • 20. Re: [DataGuard][Error 12514]  Error received logging on to the standby
    Piotr91 Newbie
    Currently Being Moderated

    Solved. I'm ashamed of the fact that the only issue was with the name of password file. I have used password file naming for Windows while working on Linux. The file listener.ora was unnecessary.

    Thank you, Abufazal.

  • 21. Re: [DataGuard][Error 12514]  Error received logging on to the standby
    Abufazal Journeyer
    Currently Being Moderated

    Glad to know, its working now.

1 2 Previous Next

Legend

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