小弟不明白，tnsnames.ora里的service_name是从哪里来的？如果是从监听器那里，可是设置监听器的时候并没有指定service_name呀？还是它和db_global_name相同呢？真的搞不懂啊

你安装Oracke的时候从来不看官方的安装文档吗？
文档里面清晰的写着该怎么配置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.160  stu160.up.com      stu160

应该没有错吧？

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 的帖子

提示这么多错误看不懂啊
Do you wish to continue? [yes(Y)/no(N)]: 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;
23  end;
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
[05-12-2010 15:05:55] Return code = 0.
[05-12-2010 15:05:55] Done.
[05-12-2010 15:05:55] Unquiescing DB ...
[05-12-2010 15:05:55] Temp File - /tmp/fzdUHx0Jl3/FLEh6PxKGt.sql.
[05-12-2010 15:05:55]  Return code = 0.
[05-12-2010 15:05:55] Done.
[05-12-2010 15:05:55] 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.

是查看alert.log日志吗？里面咋没有提示呢？

先删除在安装
emca -deconfig dbcontrol db -repos drop
emca config dbcontrol db -repos create
首先进行删除，然后再安装，可能会报错，看一下日志。
昨天刚刚解决了一个，根据日志提示删除了一个用户就可以了。
要看错误日志。

先删除一下，然后再重建。

那你也最好删一次，就使用上面的命令即可。

回复 chenyu 的帖子

数据库是手动创建的，根本就没有oem，咋删呢？