6 Replies Latest reply: Feb 25, 2012 12:31 PM by Lubiez Jean-Valentin RSS

    Control fIle problem

    user5166350
      My oracle 11 g running on RED hat 5 .I have changed the control_files parameter values = ('/disk1/..../control1.ctl' , '/disk3/...../control2.ctl') in init$ORACLE_SID.ora file.
      When i start my database and instance the changed values is not there rather the old value appears.

      Edited by: user5166350 on Feb 25, 2012 10:07 AM
        • 1. Re: Control fIle problem
          912595
          I Hope your database is started.. If yes check what pfile or spfile is using your current instance...

          SQL>show parameter pfile;
          • 2. Re: Control fIle problem
            Shivananda Rao
            You have changed the value of control_files in the pfile but have you placed your controlfile in the location mentioned in the control_files.

            You need to do so, if not you would get the below error
            ORA-00205: error in identifying control file, check alert log for more info
            Place control1.ctl file in the location '/disk1/....' and control2.ctl in the location '/disk3/...' and then start the database.

            user5166350

            Handle: user5166350
            Status Level: Newbie
            Registered: Jan 24, 2012
            Total Posts: 10
            Total Questions: 5 (5 unresolved)
            Looks like forum is of no help to you :( Please close your previous questions as answered rather than leaving it open.
            Keep the forum clean.

            Edited by: Shivananda Rao on Feb 25, 2012 11:46 PM
            • 3. Re: Control fIle problem
              user5166350
              yes, after shutting down the db i have a exact replica of control files in the new location as control2.ctl

              the values of spfile and pfile is as follows:

              show parameter pfile

              NAME TYPE VALUE
              ------------------------------------ ----------- ------------------------------
              spfile string /oraeng/app/oracle/product/11.
              2.0/db/dbs/spfileoracl1.ora
              SQL> show parameter spfile

              NAME TYPE VALUE
              ------------------------------------ ----------- ------------------------------
              spfile string /oraeng/app/oracle/product/11.
              2.0/db/dbs/spfileoracl1.ora

              Edited by: user5166350 on Feb 25, 2012 10:17 AM
              • 4. Re: Control fIle problem
                Shivananda Rao
                If your database is started, post
                show parameter control_files
                You say you made changes to init$ORACLE_SID.ora (pfile), but your database is showing that it is started with spfile.
                Start your database with the pfile you made changes.
                SQL>startup pfile=<location of init$ORACLE_SID.ora file>
                If your issue is resolved, provide appropriate points and close the thread.
                • 5. Re: Control fIle problem
                  912595
                  user5166350 wrote:
                  yes, after shutting down the db i have a exact replica of control files in the new location as control2.ctl

                  the values of spfile and pfile is as follows:

                  show parameter pfile

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  spfile string /oraeng/app/oracle/product/11.
                  2.0/db/dbs/spfileoracl1.ora
                  SQL> show parameter spfile

                  NAME TYPE VALUE
                  ------------------------------------ ----------- ------------------------------
                  spfile string /oraeng/app/oracle/product/11.
                  2.0/db/dbs/spfileoracl1.ora

                  Edited by: user5166350 on Feb 25, 2012 10:17 AM
                  Use below:
                  SQL>create pfile='/oraeng/app/oracle/product/11.2.0/db/dbs/initorcl1.ora' from spfile;
                  
                  SQL>shutdown immediate;
                  
                  Edit pfile generated in /oraeng/app/oracle/product/11.2.0/db/dbs/initorcl1.ora
                  
                  Save the edited file
                  
                  SQL>startup nomount pfile='/oraeng/app/oracle/product/11.2.0/db/dbs/initorcl1.ora';
                  
                  SQL> create spfile from pfile='/oraeng/app/oracle/product/11.2.0/db/dbs/initorcl1.ora';
                  
                  SQL>shutdown immediate;
                  Then Start again
                  SQL>startup
                  Abobe step should pick up the correct spfile file....

                  Hope this help
                  • 6. Re: Control fIle problem
                    Lubiez Jean-Valentin
                    Hello,


                    As previously posted, the PFILE (initSID.ora) was modified but the Database may use the SPFILE.

                    So you may do as follow:
                    startup nomount
                    show parameter pfile
                    If you receive an answer like that:
                    SQL> show parameter pfile
                    
                    NAME                                 TYPE        VALUE
                    ------------------------------------ ----------- ------------------------------
                    spfile                               string      C:\APP\PRODUCT\11.2.0\DBHOME_1
                                                                     \DATABASE\SPFILEORION.ORA
                    Then your database use a SPFILE.

                    In this case, you may execute this:
                    create pfile from spfile;
                    Then your SPFILE is saved in the init<SID>.ora.

                    You modify the initSID.ora and save it.

                    Afterwards, you may execute this:
                    shutdown immediate
                    startup nomount pfile='<path>/init<SID>.ora'
                    create spfile from pfile;
                    shutdown immediate
                    startup
                    Hope this help.
                    Best regards,
                    Jean-Valentin