用rman恢复数据库到异机后,重新创建EM.遇到的第一个错误.
/home/oracle 11:43 $cat  /oracle/database/product/10.2.0/db_1/cfgtoollogs/emca/testdb1/emca_repos_drop_2011-02-10_11-25-29-上午.log
[10-02-2011 11:25:29] Enter SYS user's password :
[10-02-2011 11:25:29]
[10-02-2011 11:25:29] Enter repository user password :
[10-02-2011 11:25:29]
[10-02-2011 11:25:29] Getting temporary tablespace from database...
[10-02-2011 11:25:30] Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=testdb1))): ORA-01031: insufficient privileges (DBD ERROR: OCISessionBegin)
/home/oracle 11:43 $

下面是 metalink 的解释.

EMCA Fails With Error 'ORA-01031: insufficient privileges' When Database Password File Is Not Configured [ID 358201.1]
		Modified 03-JAN-2011     Type PROBLEM     Status PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

---

Applies to:

Enterprise Manager Grid Control - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

After installing Oracle 10.2.0.1 and manually creating a new database (did not use DBCA). emctl start dbconsole fails with the following error:

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

The 10.2 database was created successfully but there is no hostname_sid directory under ORACLE_HOME.  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) "

OR in some cases this may fail with following error in emca.log file

Oct 1, 2008 2:08:19 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocked mgmt_view account
Oct 1, 2008 2:08:19 PM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked mgmt_view account
Oct 1, 2008 2:08:19 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 1, 2008 2:08:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: dev11g, oracleHome: /oracle/product/11.1.0/db, and user: SYS
Oct 1, 2008 2:08:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Oct 1, 2008 2:08:20 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: ORA-01031: insufficient privileges
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges

Cause

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..  

Solution

To resolve this problem,

Ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the init.ora for the database
1.  Create a password file:

Unix: $ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=sys entries=5
Windows: C:\> orapwd file=%ORACLE_HOME%\database\pwd%ORACLE_SID%.ora password= sys entries=5

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

2.  Re-run EMCA to create the DB Control configuration files and repository.  See Note 278100.1 for information on the commands to run.

References

NOTE:333567.1 - EMCA Fails With Erros While Creating the Repository Due to Missing Execute Privilege on UTL_FILE and Other Packages

Related Products Enterprise Management > Enterprise Manager Consoles, Packs, and Plugins > Enterprise Manager Grid Control > Enterprise Manager Grid Control Keywords EMCA; DBCONSOLE; J2EE; OC4J Errors ORA-24344; ORA-6512; ORA-1031

Back to top