我用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)))
我监听器服务也启动了啊,昨天还好好的,今天就不行了,请高手指点指点
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)))
我监听器服务也启动了啊,昨天还好好的,今天就不行了,请高手指点指点
把(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
改成
(ADDRESS = (PROTOCOL = TCP)(HOST = 计算机名)(PORT = 1521))再重启下监听器就可以了。
http://hi.baidu.com/_apple_may_/blog/item/caeb62ab8a18acf61e17a29d.html
还出现一个空白网页,上面就写一行字:Authentication failed!null
继续求救
我是新手不懂,请问怎么 ‘TNSPING下你的服务名’,我想试试看
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可以按上面的方法试试。