本机实例监听都启动了,PL/SQL中SCOTT及其他账户均可登陆,sqlplus中就不行:C:\Users\e>sqlplus/nologSQL*Plus: Release 10.2.0.3.0 - Production on 星期三 8月 1 12:49:03 2012Copyright (c) 1982, 2006, Oracle. All Rights Reserved.SQL> connect scott
输入口令:
ERROR:
ORA-12560: TNS: 协议适配器错误为什么改为远程登陆就可以了呢,原来不这样的呀 C:\Users\e>sqlplus scott/scott@localhost:1521/orclSQL*Plus: Release 10.2.0.3.0 - Production on 星期三 8月 1 12:50:14 2012Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining optionsORA文件:ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = e-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
输入口令:
ERROR:
ORA-12560: TNS: 协议适配器错误为什么改为远程登陆就可以了呢,原来不这样的呀 C:\Users\e>sqlplus scott/scott@localhost:1521/orclSQL*Plus: Release 10.2.0.3.0 - Production on 星期三 8月 1 12:50:14 2012Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining optionsORA文件:ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = e-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
解决方案 »
- 怎么用sql判断1个字段中的记录比指定的字符串少那个?
- 从ORACLE 9I升级到11.2G后ATE数据提交时会变慢
- 新手求教ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小
- 怎么删除.dbf文件?
- oracle下时间冲突检测问题
- 关于Oracle建表的一些问题,请教有经验的人!!!!!!!!
- java.sql.SQLException: ORA-01000: maximum open cursors exceeded
- 再请教一个初级问题
- 请指点。。。谢谢!!!!!!!
- 在用oracle的时候,常说系统表,请问下,有那些常用的或重要的系统表?
- 大家帮我看下,这个语句怎么错了啊?
- 问下时间变量怎么赋值,,,新手,,,,在线等!! 着急
解决办法:
cmd命令行上:
C:\> set ORACLE_SID=instance名字
C:\Users\e>set ORACLE_SID=orcl在图形界面环境变量里添加个环境变量ORACLE_SID,值也是orcl,就可以了C:\Users\e>sqlplus/nologSQL*Plus: Release 10.2.0.3.0 - Production on 星期四 8月 2 10:34:40 2012Copyright (c) 1982, 2006, Oracle. All Rights Reserved.SQL> connect sys/ as sysdba
输入口令:
已连接。
SQL>3KS LS 晚上结T