ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN异库恢复之EM(1)

RMAN异库恢复之EM(1)

Linux操作系统 作者:startforever 时间:2014-11-20 14:19:00 0 删除 编辑
用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

Show Related Information 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 topBack to top


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28743704/viewspace-1340285/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-03-22

  • 博文量
    106
  • 访问量
    65534