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

Thread: ORA-01031 Insufficient privilege when connecting from client

Threaded View

  1. #17
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi Supower,

    Thank you very much.

    My problem got resolved with your help.

    I have also kept the SQL.AUTHENTICATION... in sqlnet.ora because without that it was giving problem in starting the database where I use connect internal/intpwd as sysdba;

    I did the foll. to fix the problem.

    1. Shutdown database, its services
    2. Rename existing password file.
    3. create the new password file with internal password.
    4. Connect to internal as sysdba.
    5. alter user sys identified by syspwd;
    6. grant sysdba to sys;
    7. alter user system identified by systempwd;
    8. grant sysdba to system;

    After this, I am now able to connect to sys and system as sysdba.

    Thanks a lot.
    Last edited by samdba; 01-09-2003 at 02:18 PM.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

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