SYS用户不能登录OEM，急急急，请高手指教

[RRRR100]

我用SYS用户登录时，提示：
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
我监听器服务也启动了啊，昨天还好好的，今天就不行了，请高手指点指点

[minitoy]

ip变没？

[RRRR100]

没有啊，我用的是无线路由动态分配的IP，但是安装的时候我已经将MICROSOFT LOOPBACK ADAPTER 设置为系统的主网络适配器 ，并分配了静态IP 192.168.0.1

[心中的彩虹]

[Quote=引用楼主 rrrr100 的回复:]
我用SYS用户登录时，提示：
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by t……
[/Quote]
HOST=你的主机名

ip要静态的 不变的 你一变肯定会有问题

[RRRR100]

我的IP地址也没变啊，还是和昨天一样，因为我安装时，在进行‘产品特定的先决条件检查’时，‘正在进行网络配置检查’的状态栏为‘未执行’，所以我按书上说的，将MICROSOFT LOOPBACK ADAPTER 设置为系统的主网络适配器 ，并分配了静态IP 192.168.0.1，结果就OK拉，可以用，今天就不行了，这是什么原因哦？？

[iqlife]

TNSPING下你的服务名，看是什么错误

[zhaolinzzu]

原来本机的ip发生改变后，就出现了上述问题，改变数据库的监听ip地址:
把(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
改成
(ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))

再重启下监听器就可以了。
http://hi.baidu.com/_apple_may_/blog/item/caeb62ab8a18acf61e17a29d.html

[RRRR100]

楼上的朋友们还是不行了，开始好像登EM登进去了，一刷新就又显示数据库关闭了，现在一输用户名和密码
还出现一个空白网页，上面就写一行字：Authentication failed!null
继续求救。。。。。。

[RRRR100]

[Quote=引用 5 楼 java3344520 的回复:]
TNSPING下你的服务名，看是什么错误
[/Quote]

我是新手不懂，请问怎么 ‘TNSPING下你的服务名’，我想试试看

[snail506891]

如果主机地址是本地的,建议配置(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

[xharvard]

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.
Action:
- Wait a moment and try to connect a second time.

- Check which services are currently known by the listener by executing: lsnrctl services <listener name>

- Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.

- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.

- Check for an event in the listener.log file.

摘自联机文档，LZ可以按上面的方法试试。

[RRRR100]

我刚刚把电脑设成了静态IP，请问在oracle中要更改哪些文件啊？？？