EMCA Fails with ORA-01031 when password file is not configured

In manual creation of database or upgrade of database from old version results in no orapwd file.

In this case our database was upgraded to 10gR2 from the default EBS 10.5.2 database which is 9i.

While trying to make Enterprise manager work I encountered the  error,

“OC4J Configuration issue. ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_ sid not found.”

So then trying to create the DB Control configuration files and repository  using “emca -config dbcontrol db -repos recreate”, the following message was captured in the  emca_repos_drop_.log:

“Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))(CON ECT_DATA=(SERVICE_NAME=sid))):
ORA-01031: insufficient privileges (DBD ERROR: OCISessionBegin) “

The ORA-01031: insufficient privileges error has been attributed to the REMOTE_LOGIN_PASSWORDFILE not being set correctly in the 10g database.  
There is also no password fle..   
To resolve this problem, Ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the init.ora for the database.

Create a password file:

$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=mypass entries=5

Windows:

C:\> orapwd file=%ORACLE_HOME%\database\pwd%ORACLE_SID% password= mypass entries=5

NOTE: The password will be "mypass" in the above examples

Re-run EMCA to create the DB Control configuration files and repository.

<ORACLE_HOME>/bin/emca -config dbcontrol db -repos recreate

Metalink Ref:

  1. DOC 358201.1 -EMCA Fails With ‘ORA-0103
  2. DOC 278100.1 -Howto Drop, Create, Recreate DB Control in 10g DB
Advertisements

About this entry