Question Re: ORA 01033 Oracle initialization or shutdown in progress in Technology Q&A

ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Thu, 20 Dec 2018 07:19:17 GMT

Hi Experts,

Sorry for asking the same question(available in SDN).I have gone through the many threads but couldn't not able to find the solution.

My Issue is:

In our DEV system while running the database backup the Database(Oracle 12) is restarting with the

ORA 01033 Oracle initialization or shutdown in progress.

Could you please explain why we are getting this issue.(i am learning the BASIS)

Thanks in Advance.

Thanks & Regrads,

Vijaya

Re: ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Thu, 20 Dec 2018 07:22:21 GMT

I am attaching the error screen shot from SM21.

capture.jpg

Re: ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Thu, 20 Dec 2018 07:26:26 GMT

Please find the below system details.

EHP7 FOR SAP ERP 6.0

SAP NETWEAVER 7.4

Operating System Windows NT

Database ORACLE 12.1.0.2.0

Re: ORA 01033 Oracle initialization or shutdown in progress

Former Member — Thu, 20 Dec 2018 16:11:25 GMT

Hi Vijaya,

If the oracle alerts comes during backup of archive files then check the BRARCHIVE must be called on the standby page with the "-m" option

Regards

Jayaprakash Kuppusamy

Re: ORA 01033 Oracle initialization or shutdown in progress

manumohandas82 — Thu, 20 Dec 2018 22:37:34 GMT

is it a remote database connection? Did u trigger an offline backup

Re: ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Fri, 21 Dec 2018 05:53:09 GMT

Hi Manu,

Yes, it is a remote connection and we triggered Incremental Offline Backup.

Thanks & Regards,

Vijaya

Re: ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Fri, 21 Dec 2018 05:55:25 GMT

Hi Jayaprakash,

Thanks for your input.

We are not using stand by DB.

Thanks & Regards,

Vijaya

Re: ORA 01033 Oracle initialization or shutdown in progress

Former Member — Fri, 21 Dec 2018 10:47:39 GMT

Hi Vijaya,

Please let us know your BR*tools version and patch level, for Ehp7 the version is 740... if its less than 7.40 Patch 1,

we can upgrade and see the results. also refer the SAP note 1838852 - Corrections in BR*Tools 7.20 Patch 31 / 7.40 Patch 1

Regards

Re: ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Fri, 21 Dec 2018 12:06:41 GMT

Hi Jayaprakash,

Our BR*Tools version is 740 and the patch level is 34.

Regards,

Vijaya

Re: ORA 01033 Oracle initialization or shutdown in progress

Former Member — Fri, 21 Dec 2018 14:34:14 GMT

Hi Vijaya,

Since your SAP system running on your windows operating system, please check and let us know which your user you have used to start the oracle instance check in (services.MSC)

You have to ensure that the Oracle environment (ORACLE_HOME, ORACLE_SID, ORACLE_BASE) is identical to the user which you used to start , If ORACLE_HOME differs, you will get an ORA-01033: ORACLE initialization or shutdown in progress error when starting SAP.

Regards

Re: ORA 01033 Oracle initialization or shutdown in progress

Former Member — Fri, 21 Dec 2018 15:33:07 GMT

Hi Vijaya,

Since your SAP system running on windows operating system, please check and let us know which your user you have used to start the oracle instance check in (services.MSC)

Regards

Re: ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Mon, 24 Dec 2018 05:23:35 GMT

Hi Prakash,

I will check and let you know.

Regards,

Vijaya

Re: ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Wed, 26 Dec 2018 10:42:52 GMT

Hi Prakash,

The user which are using to access the database have all the permissions for accessing the services.

and when the load is high(running morning batch jobs and DB backup both are at same time) on database at that time the DB is restarting.

Regards,

Vijaya

Re: ORA 01033 Oracle initialization or shutdown in progress

kv_sapbasis — Wed, 26 Dec 2018 20:40:07 GMT

Are you running an offline backup - if so DB will be mounted for a consistent copy, i.e not open for transactions. This is expected behavior.

https://help.sap.com/saphelp_nw73/helpdata/en/47/0936e6cc995bebe10000000a1553f7/frameset.htm

Re: ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Wed, 02 Jan 2019 08:47:44 GMT

Hi Experts,

Small correction in my request...we are triggering Incremental Online Backup.

Regards,

Vijaya

Re: ORA 01033 Oracle initialization or shutdown in progress

vijaya11 — Mon, 07 Jan 2019 06:19:29 GMT

Hi ,

The issue got resolved.

Solution is, previously by mistakenly we triggered the incremental offline backup due to this we got the subjected issue.

Now we corrected.(incremental online backup).

Thanks for your valuable inputs and time.

Regards,

Vijaya

Re: ORA 01033 Oracle initialization or shutdown in progress

Former Member — Mon, 07 Jan 2019 15:00:41 GMT

Hi Vijya,

Good to know the issue is identified and fixed, great!

Regards