I have sought all discussion in term of ORA-01031 and no good solution for me:
my case is:
OS=WINDOW SERVER 2005
I was able to drop repository and recreate it again. However, I can not configure the newly created repository and got error message like:
CONFIG: SQLEngine connecting with SID: MDORCL3, oracleHome: C:\app\lium\product\11.2.0\dbhome_1, and user:
Nov 9, 2012 11:10:33 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: ORA-01031: insufficient privileges
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges
Can some Guru and experts to comment or provide some suggestions? I have been working with DB running without DBconsole to monitor it for too long. Getting scared more and more for something going on.
Appreciate any tips!
Are you getting this error while configuring db control? What is the command you are using to configure db control? Was sys password changed and you have to regenerate password file?
Please try connecting to the database via sqlplus using the following command:
sqlplus sys/<password>@"(DESCRIPTION=(ADDRESS=(HOST=..)(PORT=..)(PROTOCOL=TCP))(CONNECT_DATA=(SID=..)))" as sysdba
Does the connection go through?
I have created another OS username with administrator and ORA_DBA role and login use that name and successfully configured repository. The old user what I used appeared in OS as domainnet\user may not be recognized in DB. The newly created user is just without "domainnet". I guess that is the reason, though I am not 100% sure. Thanks for all the replies from oracle community.