Results 1 to 5 of 5

Thread: orapwd tool

  1. #1
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Exclamation Unanswered: orapwd tool

    Hi

    I installed 9i on XP for trying out all the DBA utilities for my OCP.

    Currently, I have 3 users on the system
    1. scott
    2. SYS
    3. SYSTEM

    First thing I want to know where does ORACLE store this information, specifically what file in what directory.

    Also orapwd is a utility for creating a file which would contain entries for distinct DBA and DBAOPER users. If I run orapwd, would my information for SYS (DBA) and SYSTEM (DBAOPER) would get changed somehow ?

    Thanx and Regards
    Aruneesh

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: orapwd tool

    Originally posted by aruneeshsalhotr
    Hi

    I installed 9i on XP for trying out all the DBA utilities for my OCP.

    Currently, I have 3 users on the system
    1. scott
    2. SYS
    3. SYSTEM

    First thing I want to know where does ORACLE store this information, specifically what file in what directory.

    Also orapwd is a utility for creating a file which would contain entries for distinct DBA and DBAOPER users. If I run orapwd, would my information for SYS (DBA) and SYSTEM (DBAOPER) would get changed somehow ?

    Thanx and Regards
    Aruneesh
    First go back & (re?)read the Concepts manual.
    You have three users in the DATABASE; as opposed to "the system".
    It is NOT clear exactly what you are looking for regarding
    "this information".
    You might want to start by
    SQL> SELECT * FROM DBA_USERS;
    -- where you'll see all the users which exist with in the database.

    HTH & YMMV

  3. #3
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Users of DB

    Hi

    Ofcourse I meant DB by system. There are 3 users of the DB right now.
    I want to know where does oracle store information about the users, as currently apart from the PFILE, there is no password file existing.

    According to the document of orapwd, it creates a password file in $ORACLE_HOME/dbs.

    Since there exists nothing there, there is got to a placeholder for the 3 DB accounts.

    Thanx and Regards
    Aruneesh

  4. #4
    Join Date
    Sep 2003
    Location
    Netherlands
    Posts
    8
    No originaly there is no password file, no mather how much users you will create.

    All accounts (username, password etc) are stored in de datadictionary (see the view dba_users).

    With a password file you can mark some users for extra privs (sysoper and sysdba).

    You create this file so you can connect to the instance even when it is not running (Goal: to start a database as a different user than internal)

    But please read the manual about orapwd file.

    Gtx,
    Jeroen
    Last edited by jeroenjongman; 09-10-03 at 11:49.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    Keep in mind that the passwordfile is ONLY created and used when you are doing remote_login_passwordfile set to exclusive and you run the ORAPWD executable.

    this is done solely to remotely log in as SYSDBA. If you are logging in on the same machine that the database is running on, then you do not need this at all.

    Otherwise if you just want info on users then use dba_users view. Password is encrypted however.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •