Friday, June 21, 2013

ORA-01031: insufficient privileges - ATG

ORA-01031: insufficient privileges

while setting up the CRS application there is a steps to create the OOTB CRS tables via "create scheam" option, when i invoke i got the ORA-01031: insufficient privileges error.

Solution:

Go to command prompt and Log in as sysdba and give the grant access to the schema(s)
C:> sqlplus sys as sysdba
SQL> grant connect, resource, dba, sysdba to <>;

No comments: