This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 有没有DX做oracle9i DBA的？有问题请教OEM中启动DB时报错：LISTENER不能解析服务名。是因为INSTANCE还没有启动吗？该如何解决？谢谢
-sharon911(若无其事);
2003-11-9
{87}
(#1456723@0)
-
nobody works with ORACLE?
-sharon911(若无其事);
2003-11-10
(#1458130@0)
-
No. TNS can not solve service name, means you did not configure your TNSNAMES.ORA correctly, the script is trying to connect to the DB, but could not find how.
-whom(别拿俺们村长不当干部);
2003-11-10
(#1458140@0)
-
the DB is down before I start it, how can TNS recognize the DB?
另：用SQL*PLUS启动没问题。
-sharon911(若无其事);
2003-11-10
(#1458349@0)
-
试试这个步骤.assume Oracle run on UNIX:
from serverside:
> logon oracle
> lsnrctl status (check listener is shutdown or startup, if it's down, run lsnrctl start)
> ps -ef|grep ckpt (see oracle instance startup or not, I assume it's not, so you want to startup database from OEM)
from clientside: (assume it's windows)
go to dos prompt: c:\oracle\network\admin
tnsping INSTANCE_NAME (if same error, change tnsnames.ora and sqlnet.ora accordingly).
关键点在于server端的listener SID与client端的 SID一定要匹配
-whatwhenwherewhy(一生何求);
2003-11-10
{510}
(#1458200@0)
-
same error,检查了无数遍确认listener和tnsname.ora配置没有问题。sqlnet.ora/是默认配置，需要改动么？
-sharon911(若无其事);
2003-11-10
(#1458347@0)
-
谢了，莫名其妙的又好了
-sharon911(若无其事);
2003-11-10
(#1458383@0)
-
What you can do...1. Make sure the instance is up
2. Make sure the listener is up
3. Make sure your instance is handled by your listener
4. Make sure have a correct name in your tnsname.ora (if you are using it). Remember the Full DB name should match with the DB name.
5. I remember if you are using OEM, the domain name is another element which could impact your startup
-handd(大熊猫®);
2003-11-11
{358}
(#1459294@0)
-
thks,I figured it out
-sharon911(若无其事);
2003-11-11
(#1459987@0)