Re: Changing init(instance).ora ?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Mon, 29 Nov 1999 13:45:17 +0200
Message-ID: <81tp05$6ci$1@ctb-nnrp1.saix.net>

Dave wrote in message <81tk32$f1e$1_at_lure.pipex.net>...
>Oracle 7.3.3/Solaris 2.5.1
>
>Is it OK to be changing the init(instance).ora file
>once an Oracle system is up and running.

Yep. Those changes will only come into effect when the database is bounced though.

>Can I shutdown the database, change
>these value and bring it back up with no problems?

Yep, assuming of course that the changes you've made are valid ones. Incorrect parameters will cause the Oracle instance to refuse to start.

It's always a good idea to comment out the previous setting (if it already exists), add the new setting, and then add today's date and comments as to why this change was done. This kind of thing is invaluable for the DBA that inherits the database after you get onto other things.

regards,
Billy Received on Mon Nov 29 1999 - 05:45:17 CST