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

Thread: alert log message

  1. #1
    Join Date
    Nov 2000
    Posts
    175
    Hi Everyone,

    I am running oracle on aix 4.3.3. I just completed an upgrade from 8.0.6 to 8.1.7 on a production database. I am a little confused, I keep getting the following message everytime I bounce the database. Does anyone know, will I always get this message? Is this ok or is this a problem?

    Thu Aug 30 11:55:16 2001
    Updating 8.1.7.0.0 NLS parameters in sys.props$
    -- adding 8.1.7.0.0 NLS parameters.
    Completed: alter database open


    Thanks,
    Kathy

  2. #2
    Join Date
    Jun 2001
    Posts
    87
    Be thankful its not a critical ora error. On the face of it, it seems harmless, but I am not an experienced DBA.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The issue is a missing row in sys.props$ for NLS_DUAL_CURRENCY. If the database can be opened READ/WRITE, there is a workaround. It involves inserting the row into sys.props$ as follows:

    1) Open the database for read/write
    2) set transaction use rollback segment system;
    3) insert into sys.props$ values ('NLS_DUAL_CURRENCY', '$',
    'Dual currency symbol');
    4) commit;
    5) shutdown and restart the database in read only mode.

    You should ensure you have a complete backup before performing this operation.

    Good luck,

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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