emca -deconfig dbcontrol db -repos drop
emca config dbcontrol db -repos create
首先进行删除,然后再安装,可能会报错,看一下日志。
昨天刚刚解决了一个,根据日志提示删除了一个用户就可以了。
要看错误日志。 是查看alert.log日志吗?里面咋没有提示呢? 回复 oraunix 的帖子
提示这么多错误看不懂啊
Do you wish to continue? : y
Dec 5, 2010 3:03:41 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgt oollogs/emca/ll/emca_2010-12-05_03-02-35-PM.log.
Dec 5, 2010 3:04:28 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be p erformed. Some of the possible reasons may be:
1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
Dec 5, 2010 3:04:28 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 5, 2010 3:04:28 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Dec 5, 2010 3:05:55 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep /bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST =stu160.up.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ll))) -repos_user SYSMAN -action drop -verbose -output_file /u01/app/oracle/product/10.2.0/db_1/cfgtooll ogs/emca/ll/emca_repos_drop_2010-12-05_03-04-28-PM.log
Dec 5, 2010 3:05:55 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error dropping the repository
Dec 5, 2010 3:05:55 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/e mca/ll/emca_repos_drop_<date>.log for more details.
Dec 5, 2010 3:05:55 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error dropping the repository
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ll /emca_2010-12-05_03-02-35-PM.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/p roduct/10.2.0/db_1/cfgtoollogs/emca/ll/emca_2010-12-05_03-02-35-PM.log for more details.
tail -n 20 emca_repos_drop_2010-12-05_03-04-28-PM.log
17 DBMS_OUTPUT.PUT_LINE('DropRep: Tablespaces like MGMT% do not exist');
18 WHEN OTHERS THEN
19 err := SQLCODE;
20 DBMS_OUTPUT.PUT_LINE('DropRep: Error ' || SQLCODE || ' received dropping table');
21 end;
22 commit;
23end;
24/
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Return code = 0.
Done.
Unquiescing DB ...
Temp File - /tmp/fzdUHx0Jl3/FLEh6PxKGt.sql.
Return code = 0.
Done.
Dropping Repository failed. Please check file /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ll/emca_repos_drop_2010-12-05_03-04-28-PM.log for detailed errors.
1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
使用hostname和观察/etc/hosts文件,看一下是否一致。 回复 oraunix 的帖子
hostname
stu160.up.com
cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 stu160.up.com stu160 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.136.160stu160.up.com stu160
应该没有错吧? 你安装Oracke的时候从来不看官方的安装文档吗?
文档里面清晰的写着该怎么配置hosts文件。
重建一下,上面是删除的错误日志。
页:
1
[2]