7 Replies Latest reply: Dec 10, 2012 11:49 PM by Osama_Mustafa RSS

    CRS-0254

    user3266490
      Hi,

      Db :11.2.0.3

      Os : aix6

      We getting the eror in the follwoing error after upgrafe from 11.2.0.1 to 11.2.0.3.

      :/u01/app/oracle/11.2.0.1/product/ginfra/grid_home/bin: ./srvctl remove database -d IT64 -f
      PRKO-3077 : Failed to remove database IT0364: PRCD-1032 : Failed to remove database resource IT0364
      PRCR-1028 : Failed to remove resource ora.it0364.db
      PRCR-1072 : Failed to unregister resource ora.it0364.db
      CRS-0254: The CRS message catalog entry is missing.
      ------------------------------------------------------------
      ora....UP01.dg ora....up.type ONLINE    ONLINE    itse...21
      ora....UP01.dg ora....up.type ONLINE    ONLINE    itse...21
      ora....UP01.dg ora....up.type ONLINE    ONLINE    itse...21
      ora....ER.lsnr ora....er.type ONLINE    ONLINE    itse...21
      ora.asm        ora.asm.type   ONLINE    ONLINE    itse...21
      ora.cssd       ora.cssd.type  ONLINE    ONLINE    itse...21
      ora.diskmon    ora....on.type OFFLINE   OFFLINE
      ora.evmd       ora.evm.type   ONLINE    ONLINE    itse...21
      ora.it64.db  ora....se.type ONLINE    OFFLINE
      ora.ons        ora.ons.type   ONLINE    ONLINE    itse...21
      thanks
        • 1. Re: CRS-0254
          Osama_Mustafa
          Try as OS user (typically oracle ) which DBCA was executed at moment creation of database:
          srvctl remove db -d name1
          ASM remove database error
          • 2. Re: CRS-0254
            user3266490
            Hi,

            Thanks for your reply.

            We tried but showing the below error.


            PRCD-1027 : Failed to retrieve database IT64
            PRCD-1229 : An attempt to access configuration of database IT64 was rejected because its version 11.2.0.1.0 differs from the program version 11.2.0.3.0. Instead run the program from /u01/app/oracle/11.2.0.1/product/rdbms/oracle_home.

            Thanks & Regards,
            VN
            • 3. Re: CRS-0254
              Osama_Mustafa
              Error occurred while trying to check the status of the database using srvctl command in 11.2.0.3.0 version , To resolve this issue shutdown all instances and use old oracle home's srvctl to remove the database configuration first
              srvctl remove instance -d <Databasename> -i <instancename>
              • 4. Re: CRS-0254
                user3266490
                Hi,

                Thanks for your reply.

                We executed below things from old home(11.2.0.1).It works.

                :/u01/app/oracle/11.2.0.1/product/ginfra/grid_home/bin: export ORACLE_HOME=/u01/app/oracle/11.2.0.1/product/ginfra/gridhome
                grid@itseelm-ax2051:/u01/app/oracle/11.2.0.1/product/ginfra/grid_home/bin: ./srvctl config database -d IT64 Database unique name: IT64
                Database name: IT64
                Oracle home: /u01/app/oracle/11.2.0.1/product/rdbms/oracle_home
                Oracle user: grid
                Spfile: +IT64_DATAGROUP01/IT64/spfileIT64.ora
                Domain:
                Start options: open
                Stop options: immediate
                Database role: PRIMARY
                Management policy: AUTOMATIC
                Disk Groups: IT64_DATAGROUP01
                Services:

                But we unable to get a downtime to execute srvctl remove instance -d <Databasename> -i <instancename>.
                Is there any alternate method without shut the database.It's a non rac database.

                Thanks & Regards,
                Vn
                • 5. Re: CRS-0254
                  Osama_Mustafa
                  Well you tell me , you need to remove database without Shutdown !!!!
                  • 6. Re: CRS-0254
                    user3266490
                    Hi,

                    Thanks for your reply.
                    I found the below command i oracle documentation.

                    srvctl upgrade database -d  -o

                    Can i execute while the database is up?

                    Thanks & Regards,
                    Vn

                    Edited by: user3266490 on Dec 11, 2012 3:18 AM
                    • 7. Re: CRS-0254
                      Osama_Mustafa
                      user3266490 wrote:
                      Hi,

                      Thanks for your reply.
                      I found the below command i oracle documentation.

                      srvctl upgrade database -d  -o

                      Can i execute while the database is up?

                      Thanks & Regards,
                      Vn

                      Edited by: user3266490 on Dec 11, 2012 3:18 AM
                      the above command to upgrade srvctl command to newer version .