ORA 01033 Oracle initialization or shutdown in progress

[vijaya11]

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

[vkjpbasis]

Hi Vijya,

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

Regards

JP

[vijaya11]

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

[vijaya11]

Hi Experts,

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

Regards,

Vijaya

[kv_sapbasis]

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

[vijaya11]

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

[vijaya11]

Hi Prakash,

I will check and let you know.

Regards,

Vijaya

[vkjpbasis]

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)

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 message even the instance is up and running.

Regards

JP

[vkjpbasis]

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

JP

[vijaya11]

Hi Jayaprakash,

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

Regards,

Vijaya

[vkjpbasis]

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

JP

[vijaya11]

Hi Jayaprakash,

Thanks for your input.

We are not using stand by DB.

Thanks & Regards,

Vijaya

[vijaya11]

Hi Manu,

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

Thanks & Regards,

Vijaya

[manumohandas82]

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

[vkjpbasis]

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

[vijaya11]

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

[vijaya11]

I am attaching the error screen shot from SM21.

capture.jpg