RMAN异库恢复之EM(1)
用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 的解释.
Information in this document applies to any platform.
OR in some cases this may fail with following error in emca.log file
Ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the init.ora for the database
1. Create a password file:
2. Re-run EMCA to create the DB Control configuration files and repository. See Note 278100.1 for information on the commands to run.
/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.2Information 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
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
|
Back to top
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11780477/viewspace-686948/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11780477/viewspace-686948/