3 Replies Latest reply on Oct 8, 2010 8:52 PM by Anselmo Borges

    ORA-00119,ORA-00132 during duplicate target database for standby in 11gR2

    Toaduser
      I am running
      duplicate target database for standby from active database
      command from RMAN.

      I went thru step-by-step on how to create a standby database from the textbook i got from my Oracle Univ. 11g Data Guard course. I set up all the listener.ora and tnsnames.ora files using netmgr, but I'm getting local_listener error.

      Here's what I am running in rman:

      run {
      allocate channel prmy1 type disk;
      allocate channel prmy2 type disk;
      allocate channel prmy3 type disk;
      allocate channel prmy4 type disk;
      allocate auxiliary channel stby type disk;
      duplicate target database for standby from active database
      spfile
      parameter_value_convert 'kyledb','kylerep'
      set db_unique_name='kylerep'
      set db_file_name_convert='/kyledb/','/kylerep/'
      set log_file_name_convert='/kyledb/','/kylerep/'
      set control_files='/oradata/kylerep/control01.ctl'
      set log_archive_max_processes='4'
      set fal_client='kylerep'
      set fal_server='kyledb'
      set standby_file_management='AUTO'
      set log_archive_config='dg_config=(kyledb,kylerep)'
      set log_archive_dest_1='service=kyledb ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=kyledb'
      ;
      }

      And here's the error i get:

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 07/12/2010 17:33:28
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-04014: startup failed: ORA-00119: invalid specification for system parameter LOCAL_LISTENER
      ORA-00132: syntax error or unresolved network name 'LISTENER_KYLEDB'

      result of
      SQL>show parameter local_listener;

      is

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      local_listener string LISTENER_KYLEDB


      entry in my listener.ora is

      SID_LIST_KYLEDB_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (GLOBAL_DBNAME = kyledb.kyledev.usms.doj.gov)
      (ORACLE_HOME = /app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = kyledb)
      )
      )

      ADR_BASE_KYLEDB_LISTENER = /app/oracle

      KYLEDB_LISTENER =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kyledev.usms.doj.gov)(PORT = 7898))
      )


      and entry in tnsnames.ora file is

      KYLEREP =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kyledbdev.usms.doj.gov)(PORT = 7898))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = kylerep.kyledbdev.usms.doj.gov)
      )
      )

      KYLEDB =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kyledev.usms.doj.gov)(PORT = 7898))
      )
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = kyledb.kyledev.usms.doj.gov)
      )
      )

      LISTENER_KYLEDB =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kyledev.usms.doj.gov)(PORT = 7898))


      Can anyone help me figure out what went wrong?

      Thanks in advance....
        • 1. Re: ORA-00119,ORA-00132 during duplicate target database for standby in 11gR2
          ZahKar
          Log in as sysdba and try this:
          alter system set local_listener='(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = kyledev.usms.doj.gov)(PORT = 7898)))' scope=both;
          After that see if you can duplicate database.

          KYLEDB_LISTENER is just an alias for this listener which is used in LSNRCTL utility for convenience. Oracle or RMAN doesn't know any thing about it. What they can understand is the real listener configurations:
          (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = kyledev.usms.doj.gov)(PORT = 7898)))
          • 2. Re: ORA-00119,ORA-00132 during duplicate target database for standby in 11gR2
            Toaduser
            I ended up putting nothing in the local_listener parameter in the primary database, and that seemed to resolve the problem for now..... it went past that point.
            • 3. Re: ORA-00119,ORA-00132 during duplicate target database for standby in 11gR2
              Anselmo Borges
              I had the same problem,

              I Define TNS_ADMIN environment on script an resolve my problem.


              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              RMAN-03002: failure of startup command at 10/08/2010 17:21:15
              RMAN-04014: startup failed: ORA-00119: invalid specification for system parameter LOCAL_LISTENER
              ORA-00132: syntax error or unresolved network name 'LISTENER_DESENV2'

              In my shell increase the Environment:

              ## VARIAVEIS
              export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
              export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db1
              export PATH=$ORACLE_HOME/bin:$PATH
              export TNS_ADMIN=/u01/app/oracle/product/10.2.0/asm1/network/admin
              export ORACLE_SID=$1

              ## CHAMADA RMAN
              rman target / log=/u02/backup/db$1/bkp_cold-$1.log cmdfile=/home/oracle/script/rman/cold_backup/cold_backup.rcv

              After this:
              RMAN> run{
              2> shutdown immediate;
              3> startup force mount;
              4> backup database include current controlfile tag 'BKP_COLD_FULL';
              5> alter database open;
              6> delete obsolete;
              7> }
              8>
              9>
              using target database control file instead of recovery catalog
              database closed
              database dismounted
              Oracle instance shut down

              Oracle instance started
              database mounted

              Total System Global Area 1073741824 bytes

              Fixed Size 2089400 bytes
              Variable Size 264244808 bytes
              Database Buffers 801112064 bytes
              Redo Buffers 6295552 bytes

              .
              .
              .


              Hope this helps and sorry for my terrible English! =)