Re: How to change initialization parameters?
Date: Mon, 29 Mar 1999 20:05:27 -0500
Message-ID: <7dqiva$gj0$1_at_news1.epix.net>
Hi Quingshan,
All the initialization parameters are stored in the INIT<sid>.ORA file. When
<sid> stands for Oracle system ID. Under instance manager not all the
parameters can be changed. Some of the parameteres requires the DB instance
to be shutdown and brought up to come into effect. Both SYS and INTERNAL
users should be able to change these parameters. Ensure that the users have
SYSDBA authorization.
Hope this helps.
Archana R.
Qingshan Luo wrote in message <36FC217A.DBC78FD8_at_inpart.com>...
>I tried to change Oracle initialization parameters using the Instance
>Manager, log in as both 'SYS' and 'SYSTEM'. When I clicked the 'Apply'
>button after change, it complains about insufficient previlege. What
>user should I use to do that? Is there a text file somewhere to
>configure those parameters?
>
>Thanks a lot!
>
>--
>Qingshan Luo Email: qluo_at_inpart.com
>Parametric Technology Corporation Phone: 408-873-3537
>12900A Saratoga Avenue FAX: 408-873-3550
>Saratoga, CA 95070 Web: http://www.inpart.com
>
>
Received on Tue Mar 30 1999 - 03:05:27 CEST