DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORACLE9.2.0 INIT.ORA

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    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



  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    How do you make a new SPFILE based on the init.ora file? create spfile ='spfile_name_is_an_option' from pfile= 'file_name';

  4. #4
    Join Date
    Jan 2002
    Posts
    474
    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

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

  6. #6
    Join Date
    May 2002
    Posts
    2,645
    What about you gots *.parameter_name? That's how it works and looks. It's normal. Nothing to worry about.

  7. #7
    Join Date
    Jan 2002
    Posts
    474
    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]

  8. #8
    Join Date
    May 2002
    Posts
    2,645
    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.

  9. #9
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width