Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2004
    Posts
    24

    Unanswered: orapwd authententication

    hi,

    I created my password file by using orapwd utility.

    orapwd file=filename password=password entries=max_value

    then I set the REMOTE_LOGIN_PASSWORDFILE to exclusive
    in my parameter file.

    The problem I am facing is how to add users so that they can administer
    the database.
    Also I am unable to figure out how this password file is assigned to database instance
    and how database instance chooses the pfile.


    Regards
    Uma

  2. #2
    Join Date
    Jan 2004
    Location
    Hyderabad, India
    Posts
    37
    Hi,

    If you set the REMOTE_LOGIN_PASSWORDFILE to exclusive, then oracle first start looking at $ORACLE_HOME/dbs (in unix) or ORACLE_HOME\database (in Windows) for pwd<SID>.ora file. If that file is not present, it will search for a file called 'pwd.ora'

    So first we need to create the password file using orapwd like

    D:\> ORAPWD file=D:\ORANT\DATABASE\PWDORCL.ORA password=ORACLE

    Adding users to password file is done by granting them the sysdba or sysoper system privilege.

    SVRMGR> grant sysdba to system;
    SVRMGR> grant sysoper to test_user;
    SVRMGR> grant sysoper to test_user2;

    Removing users from the password file is done by revoking the corresponding privileges from the specific users;

    SVRMGR> revoke sysoper from test_user2;

    To list the users recorded in password file, query v$pwfile_users
    Regards
    Suneel

  3. #3
    Join Date
    Jan 2004
    Posts
    24
    Originally posted by suneel.kumar
    Hi Suneel,

    Thanks a lot for your suggestion.
    If I encounter any other problems regarding orapwd utility
    I will report to you.


    Regards
    Uma.Movva





    If you set the REMOTE_LOGIN_PASSWORDFILE to exclusive, then oracle first start looking at $ORACLE_HOME/dbs (in unix) or ORACLE_HOME\database (in Windows) for pwd<SID>.ora file. If that file is not present, it will search for a file called 'pwd.ora'

    So first we need to create the password file using orapwd like

    D:\> ORAPWD file=D:\ORANT\DATABASE\PWDORCL.ORA password=ORACLE

    Adding users to password file is done by granting them the sysdba or sysoper system privilege.

    SVRMGR> grant sysdba to system;
    SVRMGR> grant sysoper to test_user;
    SVRMGR> grant sysoper to test_user2;

    Removing users from the password file is done by revoking the corresponding privileges from the specific users;

    SVRMGR> revoke sysoper from test_user2;

    To list the users recorded in password file, query v$pwfile_users

  4. #4
    Join Date
    Jan 2004
    Posts
    24
    Originally posted by movva_uma
    Hi Suneel,

    Thankz for your suggestion.
    Actually I am new to this Oracle.Following the steps
    I could create the password file by using orapwd utility
    but I don't know how to start svrmgr to grant sysdba and
    sysoper priviledge to other users.

    Please help

    Thank You
    Uma.Movva

  5. #5
    Join Date
    Jan 2004
    Posts
    24
    Originally posted by movva_uma


    Hi ,


    Now I am able to start svrmgr
    But when I grant the sysdba priviledge to a user
    ORA-01012 not logged on is displayed on my screen.
    I started the user session to whom I wanted to give the
    priviledge but still the same error message

    Please suggest me the way to grant the priviledge

    Regards
    Uma.Movva
    Hi Suneel,

    Thankz for your suggestion.
    Actually I am new to this Oracle.Following the steps
    I could create the password file by using orapwd utility
    but I don't know how to start svrmgr to grant sysdba and
    sysoper priviledge to other users.

    Please help

    Thank You
    Uma.Movva

  6. #6
    Join Date
    Jan 2004
    Location
    Hyderabad, India
    Posts
    37
    Hi,

    After starting SVRMGRL, first you should connect to database with a user having SYSDBA privs ( usually SYS / INTERNAL). After connecting , then try granting the SYSDBA /SYSOPER privs..

    But i feel, in your case you just grant DBA role to the user u wish to grant. And while connecting to the db use 'AS SYSDBA' from the host. It will work..

    Follow the steps:

    1. Svrmgrl> Connect sys as sysdba;
    give the password
    svrmglr> grant dba to scott;

    -------------------

    After this if u want to login as scott with sysdba privs, then

    svrmgrl> connect scott as sysdba
    enter the password.
    Regards
    Suneel

  7. #7
    Join Date
    Jan 2004
    Posts
    24
    Originally posted by suneel.kumar
    Hi Suneel,


    Through your suggestion i could start the service and grant the priviledge to other users using pw file.But I want to know more
    abt Service Manager.Could you suggest any site for the above.

    Thank you for your valuable suggestion

    Regards
    Uma.Movva

    After starting SVRMGRL, first you should connect to database with a user having SYSDBA privs ( usually SYS / INTERNAL). After connecting , then try granting the SYSDBA /SYSOPER privs..

    But i feel, in your case you just grant DBA role to the user u wish to grant. And while connecting to the db use 'AS SYSDBA' from the host. It will work..

    Follow the steps:

    1. Svrmgrl> Connect sys as sysdba;
    give the password
    svrmglr> grant dba to scott;

    -------------------

    After this if u want to login as scott with sysdba privs, then

    svrmgrl> connect scott as sysdba
    enter the password.

  8. #8
    Join Date
    Jan 2004
    Location
    Hyderabad, India
    Posts
    37
    SVRMGRL is a oracle tool to do dba operations like starting/shutdown the databases and for recovery. This tool is no longer available in oracle 9i.

    you will get the information about svrmglr in any database adminstrator guide.
    Regards
    Suneel

  9. #9
    Join Date
    Jan 2004
    Posts
    24

    OCP certification

    Originally posted by suneel.kumar
    Hi Suneel,

    Thank you for your suggestion.
    I am new to this Oracle and recently cleared Introduction to
    Oracle 9iQL and Fundamentals I and hence got the OCA
    certification.I want to know whether to write the other two
    papers to get OCP.And what value OCP certification will add.


    Apart from this I want to know whether learning Solaris will be
    useful or I have to learn any other o.s if so please write about it.


    Regards
    Uma.Movva




    SVRMGRL is a oracle tool to do dba operations like starting/shutdown the databases and for recovery. This tool is no longer available in oracle 9i.

    you will get the information about svrmglr in any database adminstrator guide.

  10. #10
    Join Date
    Jan 2004
    Location
    Hyderabad, India
    Posts
    37
    Hi

    When you have completed OCA, its better to complete OCP also. knowledge on Solaris/linux is essential for dba..
    Regards
    Suneel

  11. #11
    Join Date
    Jan 2004
    Posts
    24
    Originally posted by suneel.kumar
    Hi Suneel,

    Thank you for your suggestion.
    If I encounter any problems I will report to you.

    Regards
    Uma.Movva




    When you have completed OCA, its better to complete OCP also. knowledge on Solaris/linux is essential for dba..

  12. #12
    Join Date
    Jan 2004
    Posts
    24
    Originally posted by suneel.kumar

    Hi Suneel,

    As SVRMGRL is no longer used in Oracle 9i ,I want to know the tool
    that is used for administrative tasks(like granting sysdba priviledges)
    in Oracle 9i.

    Regards
    Uma.Movva
    SVRMGRL is a oracle tool to do dba operations like starting/shutdown the databases and for recovery. This tool is no longer available in oracle 9i.

    you will get the information about svrmglr in any database adminstrator guide.

Posting Permissions

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