无法打开SCOTT

显示全部楼层 · 2006-4-17 13:46:34

C:\Documents and Settings\sky>sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 5月 2
Copyright (c) 1982, 2004, Oracle.All rights reserved.
SQL> conn scott/tiger
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

SQL>
求各大虾帮帮忙

千问 · 2006-4-17 13:46:34

是数据库没有起来吧
用SYS连接看看

千问 · 2006-4-17 13:46:34

用SYS连了，然后怎样做啊？

千问 · 2006-4-17 13:46:34

然后startup

千问 · 2006-4-17 13:46:34

SQL> conn sys as sysdba
Enter password:
Connected.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shu immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
SQL> conn scott/tiger
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

Warning: You are no longer connected to ORACLE.
SQL>

千问 · 2006-4-17 13:46:34

服务里启动了oracle?
1.conn sys as sysdba
2.shutdownimmediate
3. startup

千问 · 2006-4-17 13:46:34

还是不行啊
神啊，救救我吧