Roy,
I imagine its so that it can only be changed by someone who is validated against the
database with the correct permissions.
Kind Regards,
Adrian
-Original Message-
Sent: 16 July 2003 23:40
To: Multiple recipients of list ORACLE-L
sync with INIT.ORA ?)
I can definitely appreciate
Hi,
I really need some helps to configure my database with audit_trail option. I
have tried some but fail so far. My database is Oracle 9.2. I have read all
email related to spfile. Can somebody provides simple steps for me to update my
specified initialization parameter in init.ora?
(1) Manually
Well, I thought I answered your question earlier. Here are the steps, in
more detail.
I assume your database instance name is ORCL; replace with the actual.
(1) With your database open, issue a command as sys
SQL create pfile from spfile.
(2) Go to the directory $ORACLE_HOME/dbs and make sue the
Arup,
Thank you very much. It works fine now. But my Oracle database instance name is
bluejayt not ORCL. See the following message:
$ ps -ef | grep bluejayt
oracle 5796 1 0 13:01:08 ?0:00 ora_s000_bluejayt
oracle 5790 1 0 13:01:08 ?0:00 ora_reco_bluejayt
oracle
Kirti wrote
The other parameters that will get you in the same trouble
are related to the special buffer pools.. I ran into this
issue with 9iR1 and decided to stay away from SPFILE stuff...
The failure of Oracle (programmers) checking for such
exclusiveness (?) tells their background.
Hi,
The java_pool_size can also be edited through sqlplus just use
'scope=spfile' (You'll need to bounce though). No need to open pfile edit
and create spfile.
Quite frankly I like to think that using SQL*Plus to edit the spfile
directly gives me added benefit of a syntax check (Ran a very very
Not only that but this sort of thing should be avoidable.
SQL alter system set db_cache_size=10m scope=both;
System altered.
time passes
SQL alter system set db_block_buffers=1000 scope=spfile;
System altered.
SQL shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL
Niall
I think that was the intention of the COMMENT parameter. As you point
out, that isn't foolproof. An improvement might be if Oracle tagged each
change with a date stamp.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday,
oh i forgot its binary but not THAT binary.
joe
Niall Litchfield wrote:
Not only that but this sort of thing should be avoidable.
SQL alter system set db_cache_size=10m scope=both;
System altered.
time passes
SQL alter system set db_block_buffers=1000 scope=spfile;
System altered.
SQL
This can be solved by creating the PFILE again from the SPFILE; and this
doesn't need the instance to be up. However, you did drive the nail home,
Niall, with this example.
Part of the problem could be avoided by restricting the ALTER SYSTEM, SYSDBA
or SYSOPER privileges; but in a large shop with
The other parameters that will get you in the same trouble are related to the special
buffer
pools.. I ran into this issue with 9iR1 and decided to stay away from SPFILE stuff...
The failure of Oracle (programmers) checking for such exclusiveness (?) tells their
background.
Doesn't it?
I
I can definitely appreciate the benefits of dynamic parameters, and of being able to
persist the values of those parameters accross shutdown/startup cycles. But I would
have guessed that oracle could have gotten both of those features together without
going to a binary parameter file--couldn't
And create pfile from spfile; does a similar job.
I'm rapidly beginning to think that spfiles are just not worth it. Now
how to reverse the policy decision having mandated them for 9i installs
:(
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Absolutely! The idea of spfile as a uneditable file but maintained at the
runtime and the pfile is a text file but not maintained is confusing and
error prone - especially for junior DBAs who suddenly find that they changed
something on the init.ora but the effect was not there after the startup.
You'll appreciate spfiles if you're using RAC.
-Original Message-
Sent: Tuesday, July 15, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L
And create pfile from spfile; does a similar job.
I'm rapidly beginning to think that spfiles are just not worth it. Now how
to reverse the
And how, exactly?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 7:29 PM
You'll appreciate spfiles if you're using RAC.
-Original Message-
Sent: Tuesday, July 15, 2003 2:09 PM
To: Multiple recipients of list
I don't appreciate spfile's much either, except in some cases of test
instances, wheres quite easy to type alter system command followed by
startup force to test effects of some parameters... But it all can be done
old fashioned way as well.
In RAC env I still use normal old-fashioned pfile
Spfile is shared and can be modified dynamically without bouncing the
instances.
Eg. Alter system set db_cache_size = 800m scope = [ memory | spfile | both ]
sid = *
Without spfile, you can still make this change dynamically in memory, but
you would have to manually update init.ora file to
The ability to change the system parameters without bouncing the system is
not provided by spfile, neither in RAC nor single instance databas. It
depends upon the the parameter that can be changed dynamically or not.
I guess you wanted to convey the impression that the using spfiles the
Arup
My understanding is that Oracle felt if it was going to be a 24x7x365
database, it had to have more parameters that could be changed online. Some
parameters were made changeable in Oracle9i, with hints of more to come.
If the future is online changes, it doesn't make sense to rely on
Dennis,
My understanding is that Oracle felt if it was going to be a 24x7x365
database, it had to have more parameters that could be changed online
I couldn't agree more. 9i had more parameters that can be changed online;
hope there are more in line.
it doesn't make sense to rely on the
USE shortcut like soft link for unix
-Original Message-
Sent: 15 July 2003 10:59
To: Multiple recipients of list ORACLE-L
Guys,
i have a 9iR2/win2k test instance.
i just renamed CONTROL01.CTL once and tried to start the instance.
SQLstartup
But it gave a ORA-00205 error.
so i removed
make spfile from pfile;
something like that.
I would suggest just deleting it altogether. :)
- Kirti
--- Prem Khanna J [EMAIL PROTECTED] wrote:
Guys,
i have a 9iR2/win2k test instance.
i just renamed CONTROL01.CTL once and tried to start the instance.
SQLstartup
But it gave
Try OEM it has a couple of ways to help you do this.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:19 PM
make spfile from pfile;
something like that.
I would suggest just deleting it altogether. :)
-
As user sys, issue
CREATE SPFILE FROM PFILE;
This will create the spfile. You must have started the database using the
pfile to use this command.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 10:59 PM
Thanx a lot Arup,Kirti,Arun and others.
It worked
Thanx a lot once again.
i accidentally deleted my mails.
sorry i couldn't thank everyone in person.
Thanx and Regards,
Jp.
15-07-2003 13:25:15, Arunkumar [EMAIL PROTECTED] wrote:
Fire the following commands .
1) startup
26 matches
Mail list logo