以SYSTEM用户连接数据库的时候出现如下错误如何解决? 那你用sqlplus,不加连接字符串试试:sqlplus system/manager 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 可以连接 连接后出现如下:提示Connected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - ProductionSQL> jxc(gameheart)可否把你的QQ给我,我到QQ给你说,那样快些,谢谢啦 看来本地连接没有问题,你ping一下本地的ip地址看能否ping通,如果ping通,再tnsping你的连接字符串看是什么错误. 这个你多试试就行,有可能是你的http的端口占了,,或是tns服务没启动,或是单位为控制上网给封了80端口。或是你的网络根本就不通。反正多试试呗! 这个问题可能是你的监听程序运行不正常,你试一下:tnsping service_name并把你的 tsnping 信息贴出来,如果不行,可以用如下命令停掉 listener 在将其重启:c:\lsnrctl stopc:\lsnrctl start 我停掉后重启时候出错了。C:\>lsnrctl startLSNRCTL for 32-bit Windows: Version 9.0.1.1.115Copyright (c) 1991, 2001, Oracle Corporation.Starting tnslsnr: please wait...Service OracleOraHome90TNSListener already ruTNS-12536: TNS:operation would block TNS-12560: TNS:protocol adapter error TNS-00506: Operation would block 32-bit Windows Error: 997: Unknown error 我重装了数据库:现在连接的时候提示TNS;NO LISTENER 可我在服务里面确实把监听器的服务启动起来了 现在:我TNSPING 服务名:提示如下: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCO21)))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 61: Unknown errorConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOThe command completed successfully运行C:\LSNRCTL STOP 提示如下:Connecting to (DESCRIPTION=(ADDRESS=(PROTOCO21)))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 61: Unknown errorConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOThe command completed successfully运行C:\LSNRCTL START 提示如下:Connecting to (DESCRIPTION=(ADDRESS=(PROTOCO21)))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 61: Unknown errorConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOThe command completed successfully 请教高手/专家:ORACLR中,用自定义函数作为字段默认值 关于SQL99标准 请教这里的高手朋友 高手请进!关于并发死锁的问题 if(条件) sql语句怎么写? 大家好,快快帮助我,谢谢。 Oracle的HTTP服务器和本机的默认Web站点的端口冲突,如何解决? select 数据库记录(简单问题) 请问MS SQL 中的top(n)在Oracle中用什么表示???(在线等) 进来拿分 急,关于多值查询 net8无法安装,
连接后出现如下:提示Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - ProductionSQL>
tnsping service_name
并把你的 tsnping 信息贴出来,如果不行,可以用如下命令停掉 listener 在将其重启:
c:\lsnrctl stopc:\lsnrctl start
C:\>lsnrctl startLSNRCTL for 32-bit Windows: Version 9.0.1.1.1
15Copyright (c) 1991, 2001, Oracle Corporation.Starting tnslsnr: please wait...Service OracleOraHome90TNSListener already ru
TNS-12536: TNS:operation would block
TNS-12560: TNS:protocol adapter error
TNS-00506: Operation would block
32-bit Windows Error: 997: Unknown error
可我在服务里面确实把监听器的服务启动起来了
现在:我TNSPING 服务名:提示如下:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCO
21)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCO
The command completed successfully
运行C:\LSNRCTL STOP 提示如下:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCO
21)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCO
The command completed successfully
运行C:\LSNRCTL START 提示如下:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCO
21)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCO
The command completed successfully