DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 17

Thread: ORA-01031 Insufficient privilege when connecting from client

Threaded View

  1. #14
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    *******************************************
    Now, I am able to connect internal as sysdba but not to sys as sysdba. So, what happens is whatever password I use in creating the oracle password file, it is able to connect as sysdba.
    **********************************************

    It looks ok.

    **************************************
    Now even with commented SQLNET.AUTHENTICATION... I am not able to connect to sys or system as sysdba.
    ***************************************

    Did you shutdown oracle service when you create passwd file ?

    Try shutdwon database, shutdwon oracle service (wins), recreate passwd file, start oracle service, start db and
    sqL> alter user sys identifiy by PASSWD(same as your passwd file).
    Last edited by supower; 01-09-2003 at 12:49 PM.

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