what is a password file and init.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: what is a password file and init.ora

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    8
    How important is the password file in order to connect to an oracle database from the client. How does it get created and what name does it have? How do i create it.

    Also, i find the entry in the init.ora file "Remote_password_file=Exclusive" and in some cases
    "Remote_password_file=Shared" ,

    what do they mean?

    Prasad

  2. #2
    Join Date
    Jan 2001
    Posts
    8
    Sorry, forgot to mention,
    i am using oracle 8.0.4 on Win NT with Sp6.
    Prasad

  3. #3
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    A password file is used to connect a user as sysdba to the database using server manager or to connect internal using svrmgrl. It is not used on client side connections only on server side connections.

    The exectuable is ORAPWD, if you open a DOS session and type ORAPWD or ORAPWD80, not sure which is for Win NT it will show you the syntax that must be needed to create a password file and what each switch means.

    Password files aren't that important unless yuo have users that can access Server Manager that you don't want to have access because all the needs to be done is for them to type connect internal and they are in with rights to shutdown the database or make major changes.

    If you are going to set up a password file you must set Remote_password_file=Exclusive in your inti file and shutdown and restart the database for it to take effect. If not set Remote_password_file=none.
    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    [url]http://www.dbasupport.com/forums/showthread.php?threadid=6005[/url]

  5. #5
    Join Date
    Jun 2000
    Location
    Singapore
    Posts
    6
    Hi,

    REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file and how many databases can use the password file. Setting the parameter to NONE signifies that Oracle should ignore any password file (and therefore privileged users must be authenticated by the operating system). Setting the parameter to EXCLUSIVE signifies that the password file can be used by only one database and the password file can contain names other than SYS and
    INTERNAL. Setting the parameter to SHARED allows more than one database to use a password file. However, the only users recognized by the password file are SYS and INTERNAL.

    Cheers,
    trandt@yahoo.com

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