# LISTENER.ORA Network Configuration File: /opt/app/oracle/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/oracle/9.2.0)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.15)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)------------------------------------------------
# TNSNAMES.ORA Network Configuration File: /opt/app/oracle/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.TEST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.18.15)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=test)
)
)---------------以上是我的配置,监听器的启动是成功的
LSNRCTL> start
Starting /opt/app/oracle/9.2.0/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /opt/app/oracle/9.2.0/network/admin/listener.ora
Log messages written to /opt/app/oracle/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.18.15)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.18.15)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 25-APR-2009 18:29:34
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /opt/app/oracle/9.2.0/network/admin/listener.ora
Listener Log File /opt/app/oracle/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.18.15)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
但是我连接的时候却提示ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
请个各位帮忙解决一下,先谢了
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/app/oracle/9.2.0)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.15)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)------------------------------------------------
# TNSNAMES.ORA Network Configuration File: /opt/app/oracle/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.TEST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.18.15)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=test)
)
)---------------以上是我的配置,监听器的启动是成功的
LSNRCTL> start
Starting /opt/app/oracle/9.2.0/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /opt/app/oracle/9.2.0/network/admin/listener.ora
Log messages written to /opt/app/oracle/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.18.15)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.18.15)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 25-APR-2009 18:29:34
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /opt/app/oracle/9.2.0/network/admin/listener.ora
Listener Log File /opt/app/oracle/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.18.15)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
但是我连接的时候却提示ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
请个各位帮忙解决一下,先谢了
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = boway)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_2)
(SID_NAME = ORCL)
)
)
#监听器的名字,一台数据库可以有不止一个监听器
#再向下面是监听器监听的协议,ip,端口等,这里使用的tcp1521端口,并且使#用的是主机名
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = boway)(PORT = 1521))
)对比一下监听的配置,就可以知道你少些了东西.
ORA-03113: end-of-file on communication channel的错误??
什么意思??
从本地 登陆上去
show parameters instance_name;
show parameters db_name;
sid 对应的是instance_name
GLOBAL_DBNAME 对应的是 db_name;
------------------------------------ ----------- ------------------------------
db_name string oracssf
SQL> show parameters instance_name;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string oracssf
SQL>
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORACSSF)
(ORACLE_HOME = /opt/app/oracle/9.2.0)
(SID_NAME = ORACSSF)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.15)(PORT = 1521))
)
# TNSNAMES.ORA Network Configuration File: /opt/app/oracle/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools. TEST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.18.15)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=ORACSSF)
)
)