Skip to Content
0
Former Member
Apr 26, 2009 at 01:50 AM

Changing oracle_profile path

44 Views

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