1 2 Previous Next 26 Replies Latest reply on Jul 27, 2016 5:33 AM by Beauty_and_dBest

    Listener_ifile.ora

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2.4

      OL6

      11gR2

       

      I am configuring dataguard for our EBS database.

       

      The docs said to create  listener_ifile.ora file at the standby server.

      A sample <TNS_ADMIN>/listener_ifile.ora file

       

        ##################################################################

        #

        # Created to define net services to support a Oracle Data Guard physical

        # standby environment.

        #

        ################################################################## 

        Standby LISTENER.ORA file when server is running as standby

        dg12s =

        (ADDRESS_LIST =

        (ADDRESS=(PROTOCOL=TCP)

        (HOST= <standby DB host>)

        (PORT= <same as production>)

        )

        )

        SID_LIST_dg12s =

        (SID_LIST =

        (SID_DESC =

        (ORACLE_HOME=    ) (GLOBAL_NAME=dg12s)
        (SID_NAME=dg12)
        )
        )

       

        STARTUP_WAIT_TIME_dg12s = 0
        CONNECT_TIMEOUT_dg12s = 10 TRACE_LEVEL_dg12s = OFF

       

        LOG_DIRECTORY_dg12s = <same as production>
        LOG_FILE_dg12s = STDBY
        TRACE_DIRECTORY_dg12s = <same as production>
        TRACE_FILE_dg12s = STDBY
        ADMIN_RESTRICTIONS_dg12s = OFF

      #############################################

       

      Does this listener_ifile.ora file overrides the contents of the Listener.ora itself? or Can I remove the Listener.ora?

       

      Please help...

       

       

      Kind regards,

      jc

        • 1. Re: Listener_ifile.ora
          yoonas

          Hi,

           

          ifile files are an extension to your existing config files like (listener.ora,sqlnet..).

          I file are intact even if your configuration files gets changed by autoconfig.  If you manually add entry to listener.ora file this file gets over written when you run autoconfig.

           

          As far as i know its not a copy of original listener file so that you can delete original and keep ifile only. you can use ifile your for manual configuration so that your manually added entries are persistent even after running autoconfig.

           

          Regards,

          Yoonas

          1 person found this helpful
          • 2. Re: Listener_ifile.ora
            Beauty_and_dBest

            Thanks yoonas,

             

            I have Listener.ora and inside it (last line)  is an ifile location >  IFILE=/home/oraprod/PROD/11.2.0/network/admin/PROD_drdb/listener_ifile.ora

             

            The contents of my ifile are my standby dbname information.

             

            But when I connect to prod, I have this error:

             

            [oraprod@drdb PROD_drdb]$ sqlplus apps/apps@prod

             

            SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 26 12:48:57 2016

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

             

            ERROR:

            ORA-12154: TNS:could not resolve the connect identifier specified

             

            Enter user-name: ^C

            [oraprod@drdb PROD_drdb]$ tnsping prod

             

            TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 26-JUL-2016 12:49:15

            Copyright (c) 1997, 2013, Oracle.  All rights reserved.

             

            Used parameter files:

            /home/oraprod/PROD/11.2.0/network/admin/PROD_drdb/sqlnet_ifile.ora

             

            Used TNSNAMES adapter to resolve the alias

            Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp) (HOST= proddb.unit.local) (PORT= 1521) (CONNECT_DATA=(SID=PROD)))

            TNS-12533: TNS:illegal ADDRESS parameters

             

            :

             

            But the issue is I can not open it resetlogs, simulating a disaster scenario

             

             

            Kins regards,:

            • 3. Re: Listener_ifile.ora
              yoonas

              12533, 00000, "TNS:illegal ADDRESS parameters"

              // *Cause: An illegal set of protocol adapter parameters was specified. In

              // some cases, this error is returned when a connection cannot be made to the

              // protocol transport.

              // *Action: Verify that the destination can be reached using the specified

              // protocol. Check the parameters within the ADDRESS section of

              // TNSNAMES.ORA.  Legal ADDRESS parameter formats may be found in the

              // Oracle operating system specific documentation for your platform.

              // Protocols that resolve names at the transport layer (such as DECnet object

              // names) are vulnerable to this error if not properly configured or names are

              // misspelled.

              Make sure you have formatted tns entry properly

               

              copy a working entry from tnsnames and modify required parameters

               

              (DESCRIPTION=

              (ADDRESS=

              (PROTOCOL=tcp)

              (HOST= proddb.unit.local)

              (PORT= 1521)

              (CONNECT_DATA=

              (SID=PROD)))

               

               

               

              If I counted it right, you have nonclosed paranthesis

              • 4. Re: Listener_ifile.ora
                Beauty_and_dBest

                Thanks, the sample I copied from metalink notes has missing one.

                • 5. Re: Listener_ifile.ora
                  yoonas

                  Oracle could wrong too .

                  You can let the owner of that note (the note where you copied from) know about this issue. Correcting this one on the source could save time of many.

                  1 person found this helpful
                  • 6. Re: Listener_ifile.ora
                    Pavan Kumar

                    Hi,

                     

                    Just sharing info --as thread is answered

                    Doc: https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams081.htm#REFRN10070

                    Use IFILE to embed another parameter file within the current parameter file -- so it provides another way - like subset of file for lisetner.ora staged at different location

                     

                    - Pavan Kumar N

                    1 person found this helpful
                    • 7. Re: Listener_ifile.ora
                      Beauty_and_dBest

                      Thanks Pavan, Yoonas,

                       

                       

                      I am now activating my standby, which was restored from RMAN backup.

                      I try to test if archive logs are shipped but they are not.

                      I check the alert log in my standby server and I see errors. Why is that I have missing logfiles when I just restored it from backup?

                       

                      ORA-00313: open failed for members of log group 2 of thread 1

                      ORA-00312: online log 2 thread 1: '/home/oraprod/PROD/data/log02b.dbf'

                      ORA-27037: unable to obtain file status

                      Linux-x86_64 Error: 2: No such file or directory

                      Additional information: 3

                      ORA-00312: online log 2 thread 1: '/home/oraprod/PROD/data/log02a.dbf'

                      ORA-27037: unable to obtain file status

                      Linux-x86_64 Error: 2: No such file or directory

                      Additional information: 3

                      Clearing online redo logfile 2 /home/oraprod/PROD/data/log02a.dbf

                      Clearing online log 2 of thread 1 sequence number 30940

                      Errors in file /home/oraprod/PROD/11.2.0/admin/PROD_drdb/diag/rdbms/prod2/PROD/trace/PROD_mrp0_21797.trc:

                      ORA-00313: open failed for members of log group 2 of thread 1

                      ORA-00312: online log 2 thread 1: '/home/oraprod/PROD/data/log02b.dbf'

                      ORA-27037: unable to obtain file status

                      Linux-x86_64 Error: 2: No such file or directory

                      Additional information: 3

                       

                       

                      Please help...

                       

                      Kind regards,

                      • 8. Re: Listener_ifile.ora
                        Pavan Kumar

                        Hi,

                         

                        1. I hope they are online redo logs

                        2. You need to configure SRL (standby redo logs) and ORL on standby database

                         

                        - Pavan Kumar N

                        1 person found this helpful
                        • 9. Re: Listener_ifile.ora
                          Beauty_and_dBest

                          Thanks Pravan,

                           

                          I select primary and standby and the both SRL & ORL are existing in primary.

                           

                          SQL>  select GROUP#||', '||STATUS||', '||TYPE||', '||MEMBER||', '||IS_RECOVERY_DEST_FILE FROM V$LOGFILE;

                           

                          GROUP#||','||STATUS||','||TYPE||','||MEMBER||','||IS_RECOVERY_DEST_FILE

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

                          2, , ONLINE, /home/oraprod/PROD/data/log02a.dbf, NO

                          2, , ONLINE, /home/oraprod/PROD/data/log02b.dbf, NO

                          1, , ONLINE, /home/oraprod/PROD/data/log01a.dbf, NO

                          1, , ONLINE, /home/oraprod/PROD/data/log01b.dbf, NO

                          3, , STANDBY, /home/oraprod/PROD/data/stby1.log, NO

                          4, , STANDBY, /home/oraprod/PROD/data/stby2.log, NO

                          5, , STANDBY, /home/oraprod/PROD/data/stby3.log, NO

                           

                          7 rows selected.

                           

                           

                          Why did RMAN not able to back it up?

                           

                          Kind regards,

                          • 10. Re: Listener_ifile.ora
                            Pavan Kumar

                            Rman will not backup the Online redo logs, Its just archives it and backups (since ORL constantly getting changed  )

                             

                            - Pavan Kumar N

                            • 11. Re: Listener_ifile.ora
                              Beauty_and_dBest

                              Its so weird the note 1491855.1 did not mention to add both ORL  at standby server

                               

                              Can I add it now? even if it is recorded in the v$logfiles?

                              • 12. Re: Listener_ifile.ora
                                Pavan Kumar

                                Pls refer to note 740675.1 and go ahead

                                • 13. Re: Listener_ifile.ora
                                  Beauty_and_dBest

                                  ALTER DATABASE ADD LOGFILE GROUP 1 ('/home/oraprod/PROD/data/log01a.dbf','/home/oraprod/PROD/data/log01b.dbf') SIZE 1G

                                  *

                                  ERROR at line 1:

                                  ORA-01156: recovery or flashback in progress may need access to files

                                  • 14. Re: Listener_ifile.ora
                                    Pavan Kumar

                                    You need to cancel the mrp and then try - pls check doc once more

                                    1 2 Previous Next