监听无法启动！

tonywi888 · 发表于 2008-4-14 13:52

不是RAC 就是一台机器

randoming · 发表于 2008-4-14 13:55

非法关机了配置文件没了

tonywi888 · 发表于 2008-4-14 14:38

顶起

五“宅”一生 · 发表于 2008-4-14 15:01

重起一下listener。不行就重新配置一下。

tonywi888 · 发表于 2008-4-14 15:24

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jsxt.gucas.ac.cn)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date             14-APR-2008 08:41:04
Uptime                   0 days 6 hr. 28 min. 5 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File       /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jsxt.gucas.ac.cn)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "cmsdb" has 1 instance(s).
  Instance "cmsdb", status UNKNOWN, has 1 handler(s) for this service...
Service "jsxtdb" has 1 instance(s).
  Instance "jsxtdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

显示监听起了啊
但是em起不来，sqlplus 连接
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

tonywi888 · 发表于 2008-4-14 15:25

sqlnet.log

Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jsxt.gucas.ac.cn)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=jsxtdb.gucas)(CID=(PROGRAM=sqlplus)(HOST=jsxt.gucas.ac.cn)(USER=oracle))))

  VERSION INFORMATION:
      TNS for Linux: Version 10.2.0.1.0 - Production
      TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
  Time: 14-APR-2008 08:48:42
  Tracing not turned on.
  Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

muzijiang · 发表于 2008-4-14 15:36

是不是数据库实例名改过， tnsping呢，能通吗

tonywi888 · 发表于 2008-4-14 15:39

原帖由 muzijiang 于 2008-4-14 15:36 发表
是不是数据库实例名改过， tnsping呢，能通吗

没有,两个实例都可以ping通.周六还能连,周日就不行了.

tonywi888 · 发表于 2008-4-14 16:18

大家帮帮忙啊急啊!

tonywi888 · 发表于 2008-4-14 17:13