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

Thread: init.ora

  1. #1
    Join Date
    May 2002
    Posts
    232
    Hii, i was installed 9ias with oracle8i.
    But when try to configure portal,sys password problem.
    I heard some other experts ,thay are saying to disable the
    O7_DICTIONARY_ACCESSIBILITY parameter in init.ora parameter file.
    But i did'n't get init.ora file.
    where does it exists< Because i have Oracle9i origin database and i have Oracle9ias with oracle8i on another m/c.
    plss help me where will i get that file.
    thanks
    kavitha

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    The file normally is in $ORACLE_HOME/dbs and the file name is initsid.ora

    Yes it is advised to disable O7_DICTIONARY_ACCESSIBILITY because if it is enabled and you grant DELETE ANY to the user he/she gets privilege on SYS schme also.

    Sanjay

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