断网后 oracel就出现错误: ORA-01033: ORACLE ????????
查询lsnrctl status之后,数据库的状态为 BLOCKED. 在网上搜了 改tnsnames.ora和listener.ora 没用。 试过:SQL>shutdown immediate 停止服务
SQL>startup http://zhidao.baidu.com/question/88051058.html
http://blog.csdn.net/zhch152/article/details/7398420#comments
按照这两个做了,都没用呀 怎么解决呀
查询lsnrctl status之后,数据库的状态为 BLOCKED. 在网上搜了 改tnsnames.ora和listener.ora 没用。 试过:SQL>shutdown immediate 停止服务
SQL>startup http://zhidao.baidu.com/question/88051058.html
http://blog.csdn.net/zhch152/article/details/7398420#comments
按照这两个做了,都没用呀 怎么解决呀
startup然后把tnsnames.ora文件贴出来,
# Generated by Oracle configuration tools.INTRAIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11-d28440c97e05)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Intrain)
(UR=A)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11-d28440c97e05)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
我用这个查的 lsnrctl status