这个问题谁见过？

chj733

这也遇的到???我这边带IP的都行,呵呵
CMSSDB_192.168.0.22

wang_and_yang

我试验的结果是“啥样的tnsname.ora配置都行’，点（.），横（－）均可，没问题

BUAA_FLY

最初由 warehouse 发布
[B]

不要直接修改tnsnames.ora，有时候直接修改可能不好用，比如有空格了之类的东西，你通过net manager建，保证能够tnsping ! [/B]

NET MANAGER不会使用，使用NETCA的本地服务名配置
却报这个错误
C:\>netca
Oracle Net Services 配置:
ServiceAliasException: 无法列出 Net 服务名: TNS-04404: 没有错误
  caused by: oracle.net.config.ConfigException: TNS-04414: 文件错误
  caused by: TNS-04610: 没有其他文字, 已到达 NV 对结尾
Exception occurred during event dispatching:
java.lang.NullPointerException
        at oracle.net.ca.ConfigureServiceAlias.getNetServiceNames(Unknown Source
)
        at oracle.net.ca.NetCA.prepareNextPage(Unknown Source)
        at oracle.net.ca.NetCA.wizardValidatePage(Unknown Source)
        at oracle.ewt.wizard.WizardPage.processWizardValidateEvent(Unknown Sourc
e)
        at oracle.ewt.wizard.WizardPage.validatePage(Unknown Source)
        at oracle.ewt.wizard.BaseWizard.validateSelectedPage(Unknown Source)
        at oracle.ewt.wizard.BaseWizard.doNext(Unknown Source)
        at oracle.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)
        at oracle.ewt.button.PushButton.processActionEvent(Unknown Source)
        at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
        at oracle.ewt.button.PushButton.activate(Unknown Source)
        at oracle.ewt.lwAWT.AbstractButton.processMouseReleased(Unknown Source)
        at oracle.ewt.lwAWT.AbstractButton.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Component.java:4897)
        at java.awt.Container.processEvent(Container.java:1569)
        at oracle.ewt.lwAWT.LWComponent.processEventImpl(Unknown Source)
        at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Component.java:3615)
        at java.awt.Container.dispatchEventImpl(Container.java:1627)
        at java.awt.Component.dispatchEvent(Component.java:3477)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483
)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)

        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
        at java.awt.Container.dispatchEventImpl(Container.java:1613)
        at java.awt.Window.dispatchEventImpl(Window.java:1606)
        at java.awt.Component.dispatchEvent(Component.java:3477)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:201)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:151)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:141)
        at java.awt.Dialog$1.run(Dialog.java:540)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:201)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:151)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)

        at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
用户终止了 Oracle Net Services 配置。退出代码是-1

这个问题估计是没有的解决了。。。。。

crous

最初由 BUAA_FLY 发布
[B]

   我这个只能使用PROD1，别的都不可以，即使是没有‘.’和'_'。
我刚才又测试过一个

修改TNSNAMES.ORA成为prod2

create database link system_link4 connect to system identified by system using 'prod2'

select * from user_tables@system_link4

ERROR at line 1:
ORA-12154: TNS:could not resolve the connect identifier specified

修改TNSNAMES.ORA成为pro

create database link system_link45connect to system identified by system using 'pro'

select * from user_tables@system_link5

ERROR at line 1:
ORA-12154: TNS:could not resolve the connect identifier specified [/B]

语法应该是using后面跟service_name，而你的service_name是prod1，不是prod,pro或者其它什么的。

shiri512003

[php]ServiceAliasException: 无法列出 Net 服务名:[/php]
//os?db version?
use netmgr instead,and then  netca will be ok.
刚处理一例完全相同案例,

keyneszhanghui

顶一下