在windows下仅仅使用参数文件不能连接oracle数据库?
问题描述:
windows xp/7 + oracle 10gR2/11gR2
新建参数文件INITora1.ORA:db_name=ora1
在设置好环境变量oracle_sid(set oracle_sid=ora1)后,
通过sqlplus / as sysdba进行连接时报监听错误(ORA-12560: TNS:protocol adapter error),
当前用户属于ora_dba系统组,
sqlnet.ora支持操作系统认证:SQLNET.AUTHENTICATION_SERVICES = (NTS)
在没有指定@连接时,根本不走监听,为何还报监听错误?
在linux下实验时,无此问题。
解决方法:
win下需要创建sid相关服务。
重现与解决步骤:
C:\>set oracle_sid=ora1
C:\>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue May 15 11:08:46 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
C:\>oradim -new -sid ora1 -startmode manual -pfile D:\oracle\product\10.2.0\db_1\database\INITora1.ORA
Instance created.
C:\>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue May 15 11:09:34 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL>
REF:
1. sqlplus / as sysdba no connect after change oracle xe sid and service name
https://forums.oracle.com/forums/thread.jspa?threadID=2252543