ora-12514???
oracle 9+solaris8启动lsnrctl start 后,始终没有监听到服务
如下图
$ lsnrctl status
LSNRCTL for Solaris: Version 9.2.0.3.0 - Production on 11-12月-2003 17:44:54
Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 9.2.0.3.0 - Production
Start Date 11-12月-2003 17:08:42
Uptime 0 days 0 hr. 36 min. 11 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /usr/home/oracle/app/oracle/product/9i/network/log/lis
tener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
The listener supports no services
The command completed successfully
这是怎么回事??
ora-12514???
我用tnsping 命 令做,显示如下,我也看不懂SunOS 5.8
login: oracle
Password:
Last login: Wed Dec3 10:44:30 from 192.168.4.110
Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001
$ tnsping testrca
TNS Ping Utility for Solaris: Version 9.2.0.3.0 - Production on 11-12月-2003 17:
44:23
Copyright (c) 1997 Oracle Corporation.All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.4.150)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = testrca)))
OK (0 msec)
$
ora-12514???
这是我的tnsnames.ora文件内容,谁帮我看看,怎么解决,# TNSNAMES.ORA Network Configuration File: /usr/home/oracle/app/oracle/product/9i/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
TESTRCA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.150)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testrca)
)
)
KMCDB3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.150)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = kmcdb3)
)
)
KMCDB2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.150)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = kmcdb1)
)
)
KMCDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.150)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = kmcdb1)
)
)
ora-12514???
你的listener.ora文件呢?ora-12514???
侦听不正常需要看服务端的listener.ora不是tnsnames.oraora-12514???
怎么会没有监听呢?ora-12514???
噢,明天我再粘上我的listener.ora文件吧,今天下班了,机房没人。ora-12514???
我的机器上没有listener.ora,原来照样监听是可以监听到服务的,自从昨天一个程序把机器整死,重启后,监听就不能使了。知道是怎么回事么?ora-12514???
太怪了,今天我手工写了一个listener.ora,把机器重启了2遍,居然又能监听到服务了,怪。数据库启动了3个。我写的listener.ora文件里只有一个服务名,可我照样可以监听3个服务。有谁知道这是为什么么???? 不知道你具体发生的是什么原因
页:
[1]
2