Windows server 2008 R2(win7)登陆sqlplus错误:ORA-12560和ORA-12557,错误截图如下:
问题情景描述1:Windows系统只安装oracle11g,未安装client,此时在cmd不能登陆sqlplus。
解决方法:
(1)查看注册表是否含有ORACLE_SID=xxxx,(xxxx代表实例名,一般安装默认是orcl), ORACLE_HOME=E:\oracle\product\11.2.0\dbhome_1
(注:E:\
官网中关于ORA-12560的解释:
ORA-12560: TNS:protocol adapter error
Cause: A generic protocol adapter error occurred.
Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level