请教各位大师们

   小弟不明白,tnsnames.ora里的service_name是从哪里来的?如果是从监听器那里,可是设置监听器的时候并没有指定service_name呀?还是它和db_global_name相同呢?真的搞不懂啊
标签: 暂无标签
原始人

写了 32 篇文章,拥有财富 297,被 1 人关注

转播转播 分享分享 分享淘帖
回复

使用道具

P6 | 发表于 2010-12-8 11:05:48
你安装Oracke的时候从来不看官方的安装文档吗?
文档里面清晰的写着该怎么配置hosts文件。
重建一下,上面是删除的错误日志。
回复

使用道具

P4 | 发表于 2010-12-6 20:45:11
回复 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

应该没有错吧?
回复

使用道具

P6 | 发表于 2010-12-6 13:26:18
1) EM is configured with different hostname then physical host. Set environment      variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
使用hostname和观察/etc/hosts文件,看一下是否一致。
回复

使用道具

P4 | 发表于 2010-12-5 15:13:06
回复 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.
回复

使用道具

P4 | 发表于 2010-12-5 14:48:15
是查看alert.log日志吗?里面咋没有提示呢?
回复

使用道具

P6 | 发表于 2010-12-2 14:03:41
先删除在安装
emca -deconfig dbcontrol db -repos drop
emca config dbcontrol db -repos create
首先进行删除,然后再安装,可能会报错,看一下日志。
昨天刚刚解决了一个,根据日志提示删除了一个用户就可以了。
要看错误日志。
回复

使用道具

P6 | 发表于 2010-11-30 09:31:51
先删除一下,然后再重建。
回复

使用道具

P4 | 发表于 2010-11-30 09:14:03
那你也最好删一次,就使用上面的命令即可。
回复

使用道具

P4 | 发表于 2010-11-28 18:32:07
回复 chenyu 的帖子

数据库是手动创建的,根本就没有oem,咋删呢?
回复

使用道具

12下一页
您需要登录后才可以回帖 登录 | 加入社区

本版积分规则

意见
反馈