This problem I have came across when i was trying to configure Oracle 11g as an external database for vCenter Server deployment which i have somehow resolved.
Everytime you try to explicitly grant permission to a user you get this error ORA-01031 : insufficient priviledges.
In order to resolve this issue you have to look out for a file named sqlnet.ora in your system where you are trying to install this ORACLE 11g.
NOTE: This one solution worked for me.
Just open this file in notepad and close it and now try to login to the SQL*PLUS with the credentials of sysdba i.e
And after that try to grant the permissions to the user and you will be done.
In my next blog post will share after successful creation of database, will share USING EXTERNAL DATABASE as ORACLE 11G.
In order to resolve this issue you have to look out for a file named sqlnet.ora in your system where you are trying to install this ORACLE 11g.
NOTE: This one solution worked for me.
Just open this file in notepad and close it and now try to login to the SQL*PLUS with the credentials of sysdba i.e
And after that try to grant the permissions to the user and you will be done.
In my next blog post will share after successful creation of database, will share USING EXTERNAL DATABASE as ORACLE 11G.
No comments:
Post a Comment