@H_403_3@遇到pl/sql登录总是提示错误,百度了很久最后发现一篇博文。按照上面的步骤一步步操作下来果然正确了。@H_403_3@
====== ======= ===== ==== === BEGIN ==== === ==== ==== ===== ==== ===== @H_403_3@@H_403_3@
1、@H_403_3@@H_403_3@进入sql/plus:@H_403_3@@H_403_3@
2、输入 账号 密码 登录oracle(使用高权限用户登录)@H_403_3@@H_403_3@
@H_403_3@已连接@H_403_3@@H_403_3@
3、sql> @H_403_3@shutdown normal@H_403_3@@H_403_3@
@H_403_3@ORA-01109: 数据库未打开@H_403_3@@H_403_3@@H_403_3@@H_403_3@
@H_403_3@@H_403_3@@H_403_3@@H_403_3@
@H_403_3@Total System Global Area
612368384 bytes
@H_403_3@Fixed Size
1332348 bytes
@H_403_3@Variable Size
183151492 bytes
@H_403_3@Database Buffers
423624704 bytes
@H_403_3@Redo Buffers
4259840 bytes
6、sql> alter database open;
@H_403_3@*
8、sql> alter database open;
@H_403_3@*
9、sql> alter database datafile 7 offline drop;【6位数据文件中的7】
10、sql>alter database open;【一直循环直到不再报错】
11、sql> shutdown normal
12、sql> startup
@H_403_3@ORACLE 例程已经启动
Total System Global Area
612368384 bytes
Fixed Size
1332348 bytes
Variable Size
183151492 bytes
Database Buffers
423624704 bytes
Redo Buffers 4259840 bytes