Oracle Pawword file
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Oracle Pawword file

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    Oracle Pawword file

    Hi all,
    I need to get permisson to some users to connect from the same server running the database and from another server to connect to a database as sysdba.
    What I did is:
    1. used orapwd and created a new file pwd
    2. changed the prameter remote_login_passwordfile = exclusive
    3. create users and granted sysdba and sysoper to the users
    4. SQL>connect user/password as sysdba
    is possible
    but
    -sqlplus user/password@sid is not possible

    -quering of v$pwfile_users shows no rows.

    Any idea what is missing or wrong.

    //Hamhey
    Last edited by hamhey; 06-10-2003 at 03:15 AM.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: Oracle Pawword file

    Originally posted by hamhey

    I need to get permisson to some users to connect from the same server running the database and from another server to connect to a database as sysdba.
    What database version & OS is running on the servers?

    4. ...
    -sqlplus user/password@sid is not possible
    Where are you giving this? on the server hosting the database or on a different box?

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Code:
    SQL> connect sys as sysdba
    Enter password: *********
    Connected.
    SQL> select * from v$pwfile_users;
    
    USERNAME                       SYSDB SYSOP
    ------------------------------ ----- -----
    SYS                            TRUE  TRUE
    SANJAY                         TRUE  FALSE
    
    SQL> create user test identified by test;
    
    User created.
    
    SQL> grant sysdba to test;
    
    Grant succeeded.
    
    SQL> select * from v$pwfile_users;
    
    USERNAME                       SYSDB SYSOP
    ------------------------------ ----- -----
    SYS                            TRUE  TRUE
    SANJAY                         TRUE  FALSE
    TEST                           TRUE  FALSE
    
    SQL> conn test as sysdba
    Enter password: ****
    Connected.
    SQL> conn test/test
    ERROR:
    ORA-01045: user TEST lacks CREATE SESSION privilege; logon denied
    
    
    Warning: You are no longer connected to ORACLE.
    SQL> conn sys as sysdba
    Enter password: *********
    Connected.
    SQL> grant connect, resource to test;
    
    Grant succeeded.
    
    SQL> conn test/test
    Connected.
    SQL>
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    Hi Sanjay
    Do you mind give the steps how to create the password file.
    OS : Solaris 8 on Intel
    OORACLE: 8.1.5

    //Hamhey

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    May 2001
    Posts
    736
    can u restart the oracleSIDservice and check the V$pwfile_users view again.

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by akhadar
    can u restart the oracleSIDservice and check the V$pwfile_users view again.
    He is on Solaris (Intel)
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #8
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by hamhey
    OS : Solaris 8 on Intel
    OORACLE: 8.1.5
    Oracle 8.0.5 & 8.1.5 has a bug filed so that when you query v$pwfile_users it generates ORA-600 or returns no rows. Check this out for more info on metalink... http://metalink.oracle.com/metalink/...&p_id=142581.1

    HTH.

  9. #9
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    Hi,
    I followed the documentation as above and restarted the server no rows selected by quering the v$pwfile_user and the error message:
    Soldb SQL>select * from v$pwfile_users;
    ERROR:
    ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []



    no rows selected

    Soldb SQL>!
    $ oerr ora 00600
    00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
    // *Cause: This is the generic internal error number for Oracle program
    // exceptions. This indicates that a process has encountered an
    // exceptional condition.
    // *Action: Report as a bug - the first argument is the internal error number

    This is bug in oracle 8.1.5 as the descripting above.

    Any idea how to fix it.

    //Hamhey

  10. #10
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by hamhey
    Soldb SQL>select * from v$pwfile_users;
    ERROR:
    ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []
    Use a order by clause in your above query.

    Code:
    Connected to:
    Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production
    
    Input truncated to 31 characters
    BLAZE: SYS> select * from v$pwfile_users order by 1;
    
    USERNAME                       SYSDB SYSOP
    ------------------------------ ----- -----
    INTERNAL                       TRUE  TRUE
    SYS                            TRUE  TRUE
    
    BLAZE: SYS> grant sysdba to rgg;
    
    Grant succeeded.
    
    BLAZE: SYS>  select * from v$pwfile_users order by 1;
    
    USERNAME                       SYSDB SYSOP
    ------------------------------ ----- -----
    INTERNAL                       TRUE  TRUE
    RGG                            TRUE  FALSE
    SYS                            TRUE  TRUE
    
    BLAZE: SYS> 
    
    BLAZE: SYS>  select * from v$pwfile_users;
    ERROR:
    ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []
    
    
    
    no rows selected
    
    BLAZE: SYS>
    Last edited by ggnanaraj; 06-10-2003 at 04:26 AM.

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