#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    2
    Rep Power
    0

    Angry How to resotre Initialization Parameters


    Hi all,

    I modified some of the initialization parameters of a particular instance in the oracle server. I logged in to the oracle instance using the Instance Manager, and changed some of the initialization parameters. When I tried to apply the changes, it failed. The oracle instance started but did not get mounted or opened. I had saved the older configuration to a dump file. Is there any way that I can restore those parameters back to their original values so that I could get this instance working again.

    thanks
    asif
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2002
    Posts
    693
    Rep Power
    26
    they aren't in the dump file they are in a file init<sid>.ora file, if you have a backup of that file then: shutdown the db, restore the file and restard db.

IMN logo majestic logo threadwatch logo seochat tools logo