Solved: Changing oracle_profile path

Former Member · ‎04-26-2009

Hi Gurus,

Last week the initSID.ora went missing from the OS. The DB jobs(ArchLogs,OnlineBackup,CheckDB) that were scheduled failed.

DBA generated the initSID.ora & put that in the Database DIR. It is working now. He suggested me to use SPfile instead of the initSID.ora for future.

Questions

1. What could have made the file missing from that location?

2. Would it be fine to change the Oracle_profile location to SPfile?How to change this parameter?

3. Does any other configuration need to made in SAP to incorporate this change?

Appreciate your help

SAP version: 4.6C

DB: 9.2

OS: Windows Server 2003

Thanks

Puneeth

Former Member · ‎04-26-2009

Hi

Adding more you can also check this Note 596423

Regards

Uday

Former Member · ‎04-26-2009

Thanks Bhushan

Nice info.

To summarize from above links

1. initSID.ora can still be used

2. SAP recommends to use SPfile for databases 9i & above

Our SAPDBA is 6.20 patch 135

SAP recommends it for SAPDBA/BRTools 6.20 patch 103 & above

Former Member · ‎04-26-2009

Hello Puneeth

You should go through some links for concepts

Note 601157 - Oracle9i: Server Parameter File

thanks

Bhudev

Changing oracle_profile path