Oracle : Editing init.ora file

To edit init.ora

Step 1: Go to oracle/ora92/database/

Step 2: Edit INIT.ORA file ex: open INITDEV11I.ORA add audit_trail=DB and save

Step 3: Connect as sys@db as sysdba

Step 4: Run "shutdown immediate"

Step 5: Run "create sp file from pfile"

Step 6: Run "startup"

Step 7: Disconnect from sql*plus

Comments