ORACLE9.2.0 INIT.ORA

[ashley75]

HI ALL,

I used DBCA to create my database so Oracle didn't create the init.ora but ORacle create the spfile. So what I did was create the init.ora and here is what I got:


*.background_dump_dest='/home/oracle/admin/HULIST01/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/oradata/HULIST01/control01.ctl','/u02/oradata/HULIST01/con
trol02.ctl','/u01/oradata/HULIST01/control03.ctl'
*.core_dump_dest='/home/oracle/admin/HULIST01/cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='HULIST01'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=HULIST01XDB)'
...........................


1. The question is how come everything in the init.ora start with *.
2. I changed the value in the init.ora, if I startup the database using the pfile I get the new value for the database, but if I startup the database using the spfile, I still got the old value.

could someone please explain to me and give me some instruction of changing both location.

Thanks

[marist89]

http://www.dbasupport.com/oracle/ora9i/spfile.shtml

[stecal]

How do you make a new SPFILE based on the init.ora file? create spfile ='spfile_name_is_an_option' from pfile= 'file_name';

[ashley75]

Stecal,

Create spfile 'location of the file' from pfile 'location of the pfile';


what about I got *. when I create the init.ora file from the spfile????

Please advise

Thanks

[sreddy]

http://www.oracle.com/oramag/oracle/...o61asktom.html

[stecal]

What about you gots *.parameter_name? That's how it works and looks. It's normal. Nothing to worry about.

[ashley75]

Stecal,

here is the parameter in my init.ora show:

*.background_dump_dest='/home/oracle/admin/HULIST01/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/oradata/HULIST01/control01.ctl','/u02/oradata/HULIST01/con
trol02.ctl','/u01/oradata/HULIST01/control03.ctl'
*.core_dump_dest='/home/oracle/admin/HULIST01/cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='HULIST01'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=HULIST01XDB)'


so you are syaing the *. is normal ????

Sorry to be annoyed, I justwant to make sure that's the way it supposed to be in the init.ora in 9i

thanks


[Edited by ashley75 on 07-23-2002 at 05:20 PM]

[stecal]

Yes I am. I am not sure why Oracle prepends the asterisk, but maybe it is Oracle's way of telling itself that this file came from a binary file (namely, the spfile). I've seen other files on UNIX with leading asterisks (/etc/system, for example), but those are generally comment markers.

[jovery]

Hi,

I think the * means that the parameter applies to all instances if you are running RAC otherwise the parameter is prefixed with the instance name. It is to allow a single sp parameter file to be shared between multiple instances in a RAC setup.

Regards