Tuesday, February 23, 2010

ORA-01031 Insufficient privileges

ORA-01031 Insufficient privileges

Possible Causes and Solutions

Generally, some security violation has occurred. Check the following: If the remote_login_passwordfile parameter is not set, or is set to none: 1. Make sure you are logged in as the Oracle user (or equivalent) if you are running in UNIX. 2. Make sure you are logged in to a Windows account that is a member of the ORA_DBA group. If the remote_login_passwordfile parameter is set, then make sure you are logging in with the correct password. If you cannot remember the password for your database, you can 1. Use the orapwd utility to create an Oracle database password file. 2. Add the Windows user you are signed in as to the ORA_DBA group.

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...