ORAPWD Utility
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORAPWD Utility

  1. #1
    Join Date
    Jul 2007
    Location
    India
    Posts
    21

    ORAPWD Utility

    Hi..,

    1)
    I 've created a user & provided the roles as follow:
    Grant connect,resource,sysdba to U10 identified by U10;

    2)
    And the remote_login_passwordfile parameter value is EXCLUSIVE

    3)
    I 've executed the following command at
    d:\oracle\product\10.2.0\db_1\database
    as follows:
    orapwd file=orapwpwdorcl.ora password=pass1234 force=y

    4)
    Select username From v$pwfile_users;
    SYS
    U10

    On my client machine
    ************************************
    I 've connected using U10 user with following :
    u10/u10@orcl as sysdba
    OR
    sys/anypassword@orcl as sysdba

    After this I 've executed as follows:
    >Shut Immediate

    The DB is shut downed

    But what is the usage of "Password" "which is created using ORAPWD" utility..
    Without that same password(which is generated using ORAPWD utility..) also am able to connecting the server if I 've specified "as sysdba"

    Problem might be what can u please explain..?

    Thanks In Advance

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    can you connect to oralce with

    Connect U10/anypass@orcl as sysdba?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Jul 2007
    Location
    India
    Posts
    21
    Yes, am able to connect using the same..

  4. #4
    Join Date
    Sep 2007
    Location
    Mexico
    Posts
    19
    Hi,

    That is an Oracle's big security hole, but there is a way you may close that door. Insert this line within sqlnet.ora ($ORACLE_HOME/network/admin)

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

  5. #5
    Join Date
    Sep 2002
    Posts
    376
    Quote Originally Posted by OracleDisected
    Hi,

    That is an Oracle's big security hole, but there is a way you may close that door. Insert this line within sqlnet.ora ($ORACLE_HOME/network/admin)

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    This holds good only in Windows server ??
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Quote Originally Posted by OracleDisected
    Hi,

    That is an Oracle's big security hole, but there is a way you may close that door. Insert this line within sqlnet.ora ($ORACLE_HOME/network/admin)

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    That applies only when connection is made through bequeth protocol, not in this case where he is trying to connect using TCP.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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