ORA-01033: ORACLE initialization or shutdown in progress
极品司机 2003-11-27 12:23:49 WinXP + Oracle920
突然掉电,重启后提示ORA-12154:TNS:无法处理服务名。
打开tnsnames.ora文件,发现没有包含SID(此处为HJSTEST)的块,于是加入:
HJSTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.68.29.106)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hjstest)
)
)
再重启后,提示:ORA-01033: ORACLE initialization or shutdown in progress