9 Replies Latest reply: Jul 3, 2013 3:29 PM by alex2012 RSS

    PRKO-2017 : Service oratservice does not exist for database orat.

    alex2012

      Hi Friends,

       

      I have an Oracle RAC 10gr2 (10.2.0.5), running on Linux RH5, in this environment I have just one database, shared by 3 nodes.

      This is working very well.

       

      But, I have a service (oratservice), that is useless. (it's just a dirt)

       

      [oracle@srvordb06 scripts]$ ./rac_crs_stat

      HA Resource                                        Target     State

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

      ora.orat.db                                        ONLINE     ONLINE on srvordb07

      ora.orat.orat1.inst                                ONLINE     ONLINE on srvordb06

      ora.orat.orat2.inst                                ONLINE     ONLINE on srvordb07

      ora.orat.orat3.inst                                ONLINE     ONLINE on srvordb08

      ora.orat.oratservice.cs                            OFFLINE    OFFLINE

      ora.orat.oratservice.orat1.srv                     ONLINE     UNKNOWN on srvordb07

      ora.orat.oratservice.orat2.srv                     ONLINE     UNKNOWN on srvordb07

      ora.orat.oratsrv.cs                                ONLINE     ONLINE on srvordb06

      ora.orat.oratsrv.orat1.srv                         ONLINE     ONLINE on srvordb06

      ora.orat.oratsrv.orat2.srv                         ONLINE     ONLINE on srvordb07

      ora.srvordb06.ASM1.asm                             ONLINE     ONLINE on srvordb06

      ora.srvordb06.LISTENER_SRVORDB06.lsnr              ONLINE     ONLINE on srvordb06

      ora.srvordb06.gsd                                  ONLINE     ONLINE on srvordb06

      ora.srvordb06.ons                                  ONLINE     ONLINE on srvordb06

      ora.srvordb06.vip                                  ONLINE     ONLINE on srvordb06

      ora.srvordb07.ASM2.asm                             ONLINE     ONLINE on srvordb07

      ora.srvordb07.LISTENER_SRVORDB07.lsnr              ONLINE     ONLINE on srvordb07

      ora.srvordb07.gsd                                  ONLINE     ONLINE on srvordb07

      ora.srvordb07.ons                                  ONLINE     ONLINE on srvordb07

      ora.srvordb07.vip                                  ONLINE     ONLINE on srvordb07

      ora.srvordb08.ASM3.asm                             ONLINE     ONLINE on srvordb08

      ora.srvordb08.LISTENER_SRVORDB08.lsnr              ONLINE     ONLINE on srvordb08

      ora.srvordb08.gsd                                  ONLINE     ONLINE on srvordb08

      ora.srvordb08.ons                                  ONLINE     ONLINE on srvordb08

      ora.srvordb08.vip                                  ONLINE     ONLINE on srvordb08

      [oracle@srvordb06 scripts]$

       

       

      This service had been created pointing to orat database, but this database had been removed, and now I can't remove this service.

      When I try remove this service the I receive the following error:

      PRKO-2017 : Service oratservice does not exist for database orat.

       

      How can I remove this one ?

       

      Thank you !

        • 1. Re: PRKO-2017 : Service oratservice does not exist for database orat.
          DK2010

          Hi,

           

          You can use the fource option at the end, something like

           

          srvctl remove service -s <service_name> -f

           

          HTH

          • 2. Re: PRKO-2017 : Service oratservice does not exist for database orat.
            Tushar Thakker

            Did you remove the database using "srvctl remove database" , "srvctl remove instance" or using dbca? If you have removed manually without updating the cluster registry, it will still look for the same. Use either of these options and the issue will be solved.

             

            Regards

            Tushar

            • 3. Re: PRKO-2017 : Service oratservice does not exist for database orat.
              alex2012

              I've already tried with the force option, but does not work.

              • 4. Re: PRKO-2017 : Service oratservice does not exist for database orat.
                alex2012

                I removed by command, and now I can not remove by dbca because the service "oratservice" no longer has database.

                How can I change the cluster registry ? maybe in this way I can remove this service.


                Thanks !

                • 5. Re: PRKO-2017 : Service oratservice does not exist for database orat.
                  DK2010

                  Hi,

                   

                  Kind of bug in 10.2.0.5 ,Then You need to do as per the MOS ID:Service Created From root Login gives PRKO-2017 Upon Removal [ID 833349.1]

                   

                  HTH

                   

                  • 6. Re: PRKO-2017 : Service oratservice does not exist for database orat.
                    Jolly Roger

                    try using

                     

                    crs_unregister  ora.orat.oratservice.orat2.srv

                    crs_unregister ora.orat.oratservice.orat1.srv

                    crs_unregister  ora.orat.oratservice.cs

                    • 7. Re: PRKO-2017 : Service oratservice does not exist for database orat.
                      alex2012

                      Hi Jolly,

                       

                      BEFORE OF CHANGES:

                      [oracle@srvordb06 scripts]$ ./rac_crs_stat

                      HA Resource                                        Target     State

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

                      ora.orat.db                                        ONLINE     ONLINE on srvordb07

                      ora.orat.orat1.inst                                ONLINE     ONLINE on srvordb06

                      ora.orat.orat2.inst                                ONLINE     ONLINE on srvordb07

                      ora.orat.orat3.inst                                ONLINE     ONLINE on srvordb08

                      ora.orat.oratservice.cs                            OFFLINE    OFFLINE  <=============

                      ora.orat.oratservice.orat1.srv                     ONLINE     UNKNOWN on srvordb07

                      ora.orat.oratservice.orat2.srv                     ONLINE     UNKNOWN on srvordb07

                      ora.orat.oratsrv.cs                                ONLINE     ONLINE on srvordb06

                      ora.orat.oratsrv.orat1.srv                         ONLINE     ONLINE on srvordb08

                      ora.orat.oratsrv.orat2.srv                         ONLINE     ONLINE on srvordb06

                      ora.srvordb06.ASM1.asm                             ONLINE     ONLINE on srvordb06

                      ora.srvordb06.LISTENER_SRVORDB06.lsnr              ONLINE     ONLINE on srvordb06

                      ora.srvordb06.gsd                                  ONLINE     ONLINE on srvordb06

                      ora.srvordb06.ons                                  ONLINE     ONLINE on srvordb06

                      ora.srvordb06.vip                                  ONLINE     ONLINE on srvordb06

                      ora.srvordb07.ASM2.asm                             ONLINE     ONLINE on srvordb07

                      ora.srvordb07.LISTENER_SRVORDB07.lsnr              ONLINE     ONLINE on srvordb07

                      ora.srvordb07.gsd                                  ONLINE     ONLINE on srvordb07

                      ora.srvordb07.ons                                  ONLINE     ONLINE on srvordb07

                      ora.srvordb07.vip                                  ONLINE     ONLINE on srvordb07

                      ora.srvordb08.ASM3.asm                             ONLINE     ONLINE on srvordb08

                      ora.srvordb08.LISTENER_SRVORDB08.lsnr              ONLINE     ONLINE on srvordb08

                      ora.srvordb08.gsd                                  ONLINE     ONLINE on srvordb08

                      ora.srvordb08.ons                                  ONLINE     ONLINE on srvordb08

                      ora.srvordb08.vip                                  ONLINE     ONLINE on srvordb08

                       

                      AFTER:

                       

                      [oracle@srvordb06 scripts]$ crs_unregister  ora.orat.oratservice.cs   <===== WORKED !!

                      [oracle@srvordb06 scripts]$ ./rac_crs_stat

                      HA Resource                                        Target     State

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

                      ora.orat.db ONLINE     ONLINE on srvordb07

                      ora.orat.orat1.inst                                ONLINE     ONLINE on srvordb06

                      ora.orat.orat2.inst                                ONLINE     ONLINE on srvordb07

                      ora.orat.orat3.inst                                ONLINE     ONLINE on srvordb08

                      ora.orat.oratservice.orat1.srv                     ONLINE     UNKNOWN on srvordb07

                      ora.orat.oratservice.orat2.srv                     ONLINE     UNKNOWN on srvordb07

                      ora.orat.oratsrv.cs                                ONLINE     ONLINE on srvordb06

                      ora.orat.oratsrv.orat1.srv                         ONLINE     ONLINE on srvordb08

                      ora.orat.oratsrv.orat2.srv                         ONLINE     ONLINE on srvordb06

                      ora.srvordb06.ASM1.asm                             ONLINE     ONLINE on srvordb06

                      ora.srvordb06.LISTENER_SRVORDB06.lsnr              ONLINE     ONLINE on srvordb06

                      ora.srvordb06.gsd                                  ONLINE     ONLINE on srvordb06

                      ora.srvordb06.ons                                  ONLINE     ONLINE on srvordb06

                      ora.srvordb06.vip                                  ONLINE     ONLINE on srvordb06

                      ora.srvordb07.ASM2.asm                             ONLINE     ONLINE on srvordb07

                      ora.srvordb07.LISTENER_SRVORDB07.lsnr              ONLINE     ONLINE on srvordb07

                      ora.srvordb07.gsd ONLINE     ONLINE on srvordb07

                      ora.srvordb07.ons                                  ONLINE     ONLINE on srvordb07

                      ora.srvordb07.vip                                  ONLINE     ONLINE on srvordb07

                      ora.srvordb08.ASM3.asm                             ONLINE     ONLINE on srvordb08

                      ora.srvordb08.LISTENER_SRVORDB08.lsnr              ONLINE     ONLINE on srvordb08

                      ora.srvordb08.gsd                                  ONLINE     ONLINE on srvordb08

                      ora.srvordb08.ons                                  ONLINE     ONLINE on srvordb08

                      ora.srvordb08.vip                                  ONLINE     ONLINE on srvordb08

                       

                      But if I try with the others, don't work :

                       

                      [oracle@srvordb06 scripts]$ crs_unregister  ora.orat.oratservice.orat1.srv

                      CRS-0214: Could not unregister resource 'ora.orat.oratservice.orat1.srv'.   <==== NOT OK

                       

                      [oracle@srvordb06 scripts]$ crs_unregister  ora.orat.oratservice.orat2.srv

                      CRS-0214: Could not unregister resource 'ora.orat.oratservice.orat2.srv'.  <==== NOT OK

                       

                      [oracle@srvordb06 scripts]$

                       

                      Best Regards !

                       

                      Alex.

                      • 8. Re: PRKO-2017 : Service oratservice does not exist for database orat.
                        alex2012

                        Hi DK2010

                         

                        Thanks for you feedback, but my services had not been created by root user.

                        They are created by oracle account.

                         

                        regards,

                         

                        Alex.

                        • 9. Re: PRKO-2017 : Service oratservice does not exist for database orat.
                          alex2012

                          Hi Guys, I found the solution :

                           

                           

                          [root@srvordb06 ~]# crs_stop -f ora.orat.oratservice.orat1.srv

                          Attempting to stop `ora.orat.oratservice.orat1.srv` on member `srvordb07`

                          Stop of `ora.orat.oratservice.orat1.srv` on member `srvordb07` succeeded.

                           

                          [root@srvordb06 ~]# crs_unregister  ora.orat.oratservice.orat1.srv

                           

                          [root@srvordb06 ~]# crs_stop -f ora.orat.oratservice.orat2.srv

                          Attempting to stop `ora.orat.oratservice.orat2.srv` on member `srvordb07`

                          Stop of `ora.orat.oratservice.orat2.srv` on member `srvordb07` succeeded.

                           

                          [root@srvordb06 ~]# crs_unregister  ora.orat.oratservice.orat2.srv

                          [root@srvordb06 ~]#

                           

                          The problem is that when service has status = UNKOWN, the Oracle RAC can not remove it, So, I need stop theseservices to offline.

                          So, using crs_stop -f, you can stop and remove it with success !

                           

                          [oracle@srvordb06 scripts]$ ./rac_crs_stat

                          HA Resource                                        Target     State

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

                          ora.orat.db                                        ONLINE     ONLINE on srvordb07

                          ora.orat.orat1.inst                                ONLINE     ONLINE on srvordb06

                          ora.orat.orat2.inst                                ONLINE     ONLINE on srvordb07

                          ora.orat.orat3.inst                                ONLINE     ONLINE on srvordb08

                          ora.orat.oratsrv.cs                                ONLINE     ONLINE on srvordb06

                          ora.orat.oratsrv.orat1.srv                         ONLINE     ONLINE on srvordb08

                          ora.orat.oratsrv.orat2.srv                         ONLINE     ONLINE on srvordb06

                          ora.srvordb06.ASM1.asm                             ONLINE     ONLINE on srvordb06

                          ora.srvordb06.LISTENER_SRVORDB06.lsnr              ONLINE     ONLINE on srvordb06

                          ora.srvordb06.gsd                                  ONLINE     ONLINE on srvordb06

                          ora.srvordb06.ons                                  ONLINE     ONLINE on srvordb06

                          ora.srvordb06.vip                                  ONLINE     ONLINE on srvordb06

                          ora.srvordb07.ASM2.asm                             ONLINE     ONLINE on srvordb07

                          ora.srvordb07.LISTENER_SRVORDB07.lsnr              ONLINE     ONLINE on srvordb07

                          ora.srvordb07.gsd                                  ONLINE     ONLINE on srvordb07

                          ora.srvordb07.ons                                  ONLINE     ONLINE on srvordb07

                          ora.srvordb07.vip                                  ONLINE     ONLINE on srvordb07

                          ora.srvordb08.ASM3.asm                             ONLINE     ONLINE on srvordb08

                          ora.srvordb08.LISTENER_SRVORDB08.lsnr              ONLINE     ONLINE on srvordb08

                          ora.srvordb08.gsd                                  ONLINE     ONLINE on srvordb08

                          ora.srvordb08.ons                                  ONLINE     ONLINE on srvordb08

                          ora.srvordb08.vip                                  ONLINE     ONLINE on srvordb08

                          [oracle@srvordb06 scripts]$

                           

                          Now, is everything ok. Thanks for your help !

                           

                          Alex.