数据库没有启动,你要先在服务里面把数据库服务启动了或者手工启动sqlplus /nolog
sql>connect /as sysdba
sql>startup
sql>connect /as sysdba
sql>startup
解决方案 »
- ocp 一道题的疑惑
- 请教,这种情况下oracle的数据怎么恢复?
- 提取话费清单时遇见的一个sql问题
- 大家看看那里写错了
- oracle 数据库自启动的问题
- 启动 lsnrctl,大约一分钟后,8080断口被占,怎么停止?
- 在Oracle8.0.3里,有个SQL语句一直有问题,但在9.2里却运行正常,高手请指教一二。
- 关于Sqlldr的返回结果的读取
- oracle8 "Enterprise Manager"的一个问题
- 大家注意了,yzysoftware (无心插柳)和strongsortware(不是我的错) 有严重的倒分嫌疑。
- 请教PL/SQL及存储过程中的小问题
- 新建的数据库的字符集和原卸载库的一样. IMP的时候为什么还提示字符集不对??
ERROR: ORA-01017: invalid username/password; logon denied
SQL> connect /as sys/sys
ERROR: ORA-01017: invalid username/password; logon denied
SQL> connect sys/sys
ERROR: ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment.
SCO System V/386 Error: 2: No such file or directory
SQL> startup
unknown command "startup" - rest of line ignored.
SQL>
c:\svrmgr
svrmgr>connect internal
svrmgrl>startup
Enter password:
ERROR: ORA-01033: ORACLE initialization or shutdown in progress登陆的时候出错,怎么办啊?
svrmgrl>startup;
Connected to an idle instance.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 4585996 bytes
Fixed Size 41880 bytes
Variable Size 4126324 bytes
Database Buffers 409600 bytes
Redo Buffers 8192 bytes
Database mounted.
ORA-01157: cannot identify data file 6 - file not found
ORA-01110: data file 6: '/usr/ora734/app/oracle/data/oradata/ora734/demo.dbf'
SVRMGR> exit
Server Manager complete.
$ sqlplusSQL*Plus: Release 3.3.4.0.0 - Production on Thu Oct 21 16:56:03 2004Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.Enter user-name: sys
Enter password:
ERROR: ORA-01033: ORACLE initialization or shutdown in progress
svrmgrl>alter database datafile 了'/usr/ora734/app/oracle/data/oradata/ora734/demo.dbf' offline drop;svrmgrl>startup
shutdown immediate
startup mount
alter database datafile '/usr/ora734/app/oracle/data/oradata/ora734/demo.dbf' offline drop
alter database open