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

Thread: alert log

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    What are the naming conventions for alert logs? Are they named after instance names?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    alert_ORACLE_SID.log where ORACLE_SID is your SID. For example:
    alter_dev815nt.log
    where dev815nt is the ORACLE_SID
    Jeff Hunter

  3. #3
    Join Date
    Aug 2000
    Posts
    163

    Cool

    1)since there is an alert log for each instance in your example oracle sid is the name of the instance. Is it correct?
    2)Is it being assigned by default and dba should not ever rename it? When is that name being created/assigned?
    Thank you.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    [QUOTE][i]Originally posted by mary [/i]
    [B]1)since there is an alert log for each instance in your example oracle sid is the name of the instance. Is it correct? [/B][/QUOTE]
    Yes
    [QUOTE][B]
    2)Is it being assigned by default and dba should not ever rename it? When is that name being created/assigned?
    Thank you. [/B][/QUOTE]
    No, you should never rename it. It is maintained by Oracle and is created when the database is created.
    Jeff Hunter

  5. #5
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    You can delete the Alert file when it gets too big (Oracle will recreate it when it does not find it - you can do so even when the instance is up and running); You can actually make a copy of it; rename it and keep it for future reference.

    - Rajeev

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