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

Thread: Internal password Urgent

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87

    Angry

    Hi
    We have Three databases( 8.1.5) running on solaris 2.7on a single box.
    Did used orapwd utility to create multiple password files
    at the creation of database.And in init ora file the
    parameters inculded were remote_password_file=exclusive.
    After we login to unix server with oracle account
    we try to connect internal thro svrmgrl we are not prompted
    for password--Now due to security aspects we dont want this to happen.
    We want this to be implemented..so i would like to know
    what all im missing here to enable password for internal for that instance.
    utility i used for password creation was
    ./orapwd file=$ORACLE_HOME/dbs/orapwsid password=sdev
    Pls advice on this
    thanks
    sat

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You have to issue this command in $O_H/dbs

    orapwd file=orapwsid password=****** entries=30

    init parm should be set as follows and bounce db to bring orapwd in effect.
    remote_login_passwordfile = exclusive
    <font face=courier>
    Usage: orapwd file=<fname> password=<password> entries=<users>

    where
    file - name of password file (mand),
    password - password for SYS and INTERNAL (mand),
    entries - maximum number of distinct DBA and OPERs (opt),
    There are no spaces around the equal-to (=) character.
    </font>

    Let me tell you, you will not be prompted for connect internal if user is on the box and user included in password file with sysdba privileges. User will be prompted only when not included in the password file.

    'orapwd' is just for remote authentication and 'connect internal' is gonna go away from next release.

    Hope this helps.

    [Edited by sreddy on 01-19-2001 at 12:08 PM]

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