如下:System parameter file is /space/oracle/product/9i/network/admin/listener.ora
Log messages written to /space/oracle/product/9i/network/log/listener.log
Trace information written to /space/oracle/product/9i/network/trace/listener.trc
Trace level is currently 0Started with pid=15387
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=gdf_nav2_shg))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Solaris Error: 125: Address already in use
11-JAN-2005 21:43:29 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
11-JAN-2005 21:44:14 * ping * 0
11-JAN-2005 21:44:53 * (CONNECT_DATA=(SID=GDF)(GLOBAL_NAME=gdf_nav2_shg)(CID=(PROGRAM=)(HOST=chinasun)(USER=oradba))) * (ADDRESS=(PROTOCOL=tcp)(HOST=140.231.238.165)(PORT=42193)) * establish * GDF * 0TNSLSNR for Solaris: Version 9.2.0.4.0 - Production on 12-JAN-2005 20:06:13
Log messages written to /space/oracle/product/9i/network/log/listener.log
Trace information written to /space/oracle/product/9i/network/trace/listener.trc
Trace level is currently 0Started with pid=15387
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=gdf_nav2_shg))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Solaris Error: 125: Address already in use
11-JAN-2005 21:43:29 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
11-JAN-2005 21:44:14 * ping * 0
11-JAN-2005 21:44:53 * (CONNECT_DATA=(SID=GDF)(GLOBAL_NAME=gdf_nav2_shg)(CID=(PROGRAM=)(HOST=chinasun)(USER=oradba))) * (ADDRESS=(PROTOCOL=tcp)(HOST=140.231.238.165)(PORT=42193)) * establish * GDF * 0TNSLSNR for Solaris: Version 9.2.0.4.0 - Production on 12-JAN-2005 20:06:13
解决方案 »
- 请教一下牛人,循环问题。。。。
- 查询相同txid的条数
- 存储过程里,参数和变量的区别是?
- 关于大的影音文件存入Oracle数据库后,上传速度变慢问题
- 系统重装了,那个oracle数据库源文件怎么恢复?
- 如何利用 同义词 进行远程访问
- 如何判断pl/sql中读取的文件不为空?
- 改了一下机器名,然后我把名字又改回去,但控制台启动不了,怎么办啊?
- DBA在哪里可以执行sql语句?
- 关于oralce一条查询语句的优化问题
- 创建回滚段时minextents 和 maxextents 的值是什么意呀是什么的最大值和最小值呀。
- 2008下的oracle10g,注册表HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE下没有\HOME0
对solaris不熟悉,是不是舰艇端口已经被占用了呢?(端口冲突)
可能是listener已经起过了,把监听shutdown ,重来
2.检查ip地址
这个监听配的有问题吧
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.X.X)(PORT = XXXX))
)
(CONNECT_DATA =
(SERVICE_NAME = XXXX)
)
)
你监听和服务器配的有问题
现在解决了.
我用的是9i.
后来我是先在net manager中配置,在到.ora文件中修改.
oradba 用户 :lsnrctl start
sqlplus ”/as syadba“
SQL: startup
方法lsnrctl start..
sqlnet.log中的信息如下 :
***********************************************************************
Fatal NI connect error 12547, connecting to:
(LOCAL=NO) VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 25-7月 -2012 09:56:26
Tracing not turned on.
Tns error struct:
ns main err code: 12547
TNS-12547: TNS: 丢失连接
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0********************************************************************************
listener.log中昨天最后一条错误信息是:TNS-12547: TNS: 丢失连接
今天的全是
26-7月 -2012 10:48:13 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\Oracle 10r2forWindows\plsql\plsqldev.exe)(HOST=ISS110501000044)(USER=qianyi))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.38.144.191)(PORT=1922)) * establish * orcl * 12514
TNS-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
昨天还能用的。今天不知道登录怎么就出现ora-01034和ora-27101错误了。