drop user sysman cascade;
drop user dbsnmp cascade;
drop role MGMT_USER;
drop user MGMT_VIEW cascade;
drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym SETEMVIEWUSERCONTEXT;
-- 实在不行在执行
一: 执行:emca -repos create 时报如下错误:
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-04042: procedure, function, package, or package body does not exist
ORA-06512: at line 11
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:841)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:306)
at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:360)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:182)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
Jul 24, 2008 5:11:53 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Jul 24, 2008 5:11:53 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at C:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\test1\emca_repos_create_<date>.log for more details.
Jul 24, 2008 5:11:53 PM oracle.sysman.emcp.EMConfig perform
建立相关的包和存储过程:
1:sql> @$ORACLE_HOME/rdbms/admin/dbmspool.sql
Package created.
2. Create the dbmspool package body:
SQL> @$ORACLE_HOME/rdbms/admin/prvtpool.plb
View created.
Package body created.
3. Grant execution privilege on the package:
SQL> grant execute on dbms_shared_pool to sysman;
Grant succeeded.
SQL> grant execute on dbms_shared_pool to dba;
Grant succeeded.
emca -repos create ---ok
二: emca -config dbcontrol db
报没有DBSNMP用户:(我开始时删除) 执行以下重建该用户:
@$ORACLE_HOME/rdbms/admin/catsnmp.sql
要删除执行以下sql:
$ORACLE_HOME/rdbms/admin/catnsnmp.sql
emca -config dbcontrol db ---ok
相关命令:
Oracle10G的EM采用了web方式,并且分成了2个产品,database control和grid control。Grid control需要下载单独的光盘安装。ITPUB
在用DBCA建库的时候,可以选择是否启用dbcontrol,启用的话需要在数据库中建立一个sysman的schema,用于保存EM的一些数据,这个就是EM的资料库(repository)。使用命令行工具emca可以创建,修改,重建或者删除dbcontrol的配置。
由于要在数据库中建EM资料库,数据库和监听都必须已经启动并正常工作。
常用的命令:
emca -repos create 创建一个EM资料库
emca -repos recreate 重建一个EM资料库
emca -repos drop 删除一个EM资料库
emca -config dbcontrol db 配置数据库的Database Control
emca -deconfig dbcontrol db 删除数据库的Database Control配置
emctl start dbconsole 启动EM console服务
emctl stop dbconsole 停止EM console服务
emca -reconfig ports命令重新配置db control和agent的端口。通过查看$ORACLE_HOME/install/portlist.ini文件可以知道当前dbcontrol正在使用的端口,默认dbcontrol http端口1158,agent端口3938
如果要重新配置端口,可以使用如下命令:
emca -reconfig ports -dbcontrol_http_port 1159
emca -reconfig ports -agent_port 3939