Results 1 to 11 of 11
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: Oracle 8.1.6 Lost Some Entries in init.ora file on restart

    I have an Oracle 8.1.6 EE dataabase running on a Windows 2000 (SP4) server. This past weekend, one of the LAN techs restarted the server after performing some routine maintenance (updating Dell OpenManage).

    When I checked the server today, I found that the Auto Archive log file setting was set to 'FALSE' when it had previously been set to 'TRUE'. Also, the format for the file name and the default location for the file name were not what I had set them to be.

    Doesn't Oracle 'remember' these values when I configure them in the init.ora file?

    Regards,

    hmscott
    Have you hugged your backup today?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > Doesn't Oracle 'remember' these values when I configure them in the init.ora file?
    Yes, Oracle does remember.
    Oracle is too dumb to unilaterally "decide" to use new/different values.
    Somebody changed something & Oracle is just doing what it was told to do.
    Can 8.1.6 use spfiles?
    Are you really, really sure you are looking in the right places?
    When things do not appear to be as the should, they probably aren't (as they should be).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > Doesn't Oracle 'remember' these values when I configure them in the init.ora file?
    Yes, Oracle does remember.
    Oracle is too dumb to unilaterally "decide" to use new/different values.
    Somebody changed something & Oracle is just doing what it was told to do.
    Can 8.1.6 use spfiles?
    Are you really, really sure you are looking in the right places?
    When things do not appear to be as the should, they probably aren't (as they should be).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Okay, well maybe I am missing something here. As I recall, there are two parameter files, one called a pfile and stored in \oracle\admin\[SID]\pfile. The other is stored in \Oracle\Ora81\sysman\ifiles.

    What I am sure of is this:
    The first file (which I refer to -- perhaps incorrectly -- as the pfile) has the relevant lines commented out:
    Code:
    # Uncommenting the line below will cause automatic archiving if archiving has
    # been enabled using ALTER DATABASE ARCHIVELOG.
    # log_archive_start = true
    # log_archive_dest_1 = "location=E:\Oracle\oradata\PJTS\archive"
    # log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
    The second file (which I refer to -- again, perhaps incorrectly -- as the ifile) had these entries:
    Code:
    log_archive_start = true
    log_archive_dest_1 = "location=E:\Oracle\oradata\PJTS\archive"
    log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
    but currently it has only this entry:
    Code:
    log_archive_dest_1 = "LOCATION=E:\Oracle\Ora81\RDBMS"
    I know what it was before, because I saved a copy of it.

    So perhaps I am missing something here? Which parameters file is Oracle using?

    Thanks,

    hmscott


    Quote Originally Posted by anacedent
    > Doesn't Oracle 'remember' these values when I configure them in the init.ora file?
    Yes, Oracle does remember.
    Oracle is too dumb to unilaterally "decide" to use new/different values.
    Somebody changed something & Oracle is just doing what it was told to do.
    Can 8.1.6 use spfiles?
    Are you really, really sure you are looking in the right places?
    When things do not appear to be as the should, they probably aren't (as they should be).
    Have you hugged your backup today?

  5. #5
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Seems to me like the LAN tech (or 'someone else') has been tinkering!

    If you have the original settings then set them back to what they were.
    There may be a reason why the LAN tech (or 'someone else') switched off the autoarchiving - I'd ask him (whilst strongly resisiting the urge to point out that unscheduled changes to a database setup can be hazardous to one's health).
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    was OEM used to restart the db?
    if you use OEM, the pfile has to be stored on the machine that is
    running the OMS.

    If you normally use OEM, and someone then logs onto the db server itself and restarts the db, then you are going to have missing parameters most likely (ie: normally you use OEM, the LAN tech ended up using command-line on the actual db server or vice-versa).
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Dec 2002
    Posts
    1,245
    No, we don't have OEM installed. The machine was simply rebooted. I should note that we did not properly shut down Oracle prior to reboot. I say we, because I was present and I COULD have, but I did not (mostly because I don't know any better).

    Regards,

    hmscott

    Quote Originally Posted by The_Duck
    was OEM used to restart the db?
    if you use OEM, the pfile has to be stored on the machine that is
    running the OMS.

    If you normally use OEM, and someone then logs onto the db server itself and restarts the db, then you are going to have missing parameters most likely (ie: normally you use OEM, the LAN tech ended up using command-line on the actual db server or vice-versa).
    Have you hugged your backup today?

  8. #8
    Join Date
    Dec 2002
    Posts
    1,245
    I really doubt that this LAN tech (or any of the others) would fool with any of the settings on the DB servers; it would be very much out of character for them to do so.

    I'm thinking it's some oversight on my part (or point of ignorance), but I'm struggling to understand what my specific failing is...

    Regards,

    hmscott

    Quote Originally Posted by cis_groupie
    Seems to me like the LAN tech (or 'someone else') has been tinkering!

    If you have the original settings then set them back to what they were.
    There may be a reason why the LAN tech (or 'someone else') switched off the autoarchiving - I'd ask him (whilst strongly resisiting the urge to point out that unscheduled changes to a database setup can be hazardous to one's health).
    Have you hugged your backup today?

  9. #9
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Look at the date / timestamp on the init files in question ... It appears they
    were changed by someone, somewhere ... These changes will not be noticed
    until the database is stopped/started ... You can also make some changes to the dynamic parameters on the fly, but they will NOT appear on the next stop/start of the database unless they are in the initxxx.ora parameter file...

    HTH
    Gregg

  10. #10
    Join Date
    Dec 2002
    Posts
    1,245
    Okay, perhaps I changed the dynamic parameters the last time we restarted this server (which was at least three months back).

    One question of curiosity:
    What happens if I make entries in the pfile/ifile that are in conflict with each other? In other words, what if I specify
    Code:
    log_archive_start = true
    in the pfile, but I specify (for whatever reason)
    Code:
    log_archive_start = false
    in the ifile. Which setting takes precedence?

    Regards,

    hmscott

    Quote Originally Posted by gbrabham
    Look at the date / timestamp on the init files in question ... It appears they
    were changed by someone, somewhere ... These changes will not be noticed
    until the database is stopped/started ... You can also make some changes to the dynamic parameters on the fly, but they will NOT appear on the next stop/start of the database unless they are in the initxxx.ora parameter file...

    HTH
    Gregg
    Have you hugged your backup today?

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >in the ifile. Which setting takes precedence?
    AFAIK, the last one in, wins.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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