ORA-01033:ORACLE initialization or shutdown

下面是百度链接,(点击打开链接)已经非常详细了,在其中可能会出现这样的问题:


现在提供一点解决方法:

1.以conn sys/as sysdba 登录

2.口令是你设置的密码


3.这样就可以链接上了,可以按照百度上的教程一步一步走了。

-------------------------------------------------------------------

点击打开链接

-----------------------------------------------------------------

4.在  alter database open; 会出现相应的错误提示(每个人的可能都不一样):


   这是原文大大的:


所以这里解决的问题是:把你错误的数据库文件删除就可以了。

如我的:


最后只要:alter datadase open; 就可以了,你可以打开你的sql developer 试一试了。



说明:为什么我不走这一步:


个人我也是没看懂,感觉是多余的,如果你知道的话欢迎留言交流评价。谢谢


















展开阅读全文

求助:ORA-01033: ORACLE initialization or shutdown in progress

12-06

前些天,oracle报错了,然后我重启了下linux~~,然后,就出现问题了~~rnrnoracle@localhost oracle]$ sqlplus "/ as sysdba"rnrnSQL*Plus: Release 8.1.7.0.0 - Production on ÐÇÆÚËÄ 12ÔÂ 6 14:15:27 2007rnrn(c) Copyright 2000 Oracle Corporation. All rights reserved.rnrnrnConnected to:rnOracle8i Enterprise Edition Release 8.1.7.0.1 - ProductionrnWith the Partitioning optionrnJServer Release 8.1.7.0.1 - ProductionrnrnSQL> connectrnEnter user-name: sxydrnEnter password:rnERROR:rnORA-01033: ORACLE initialization or shutdown in progressrnrnrnWarning: You are no longer connected to ORACLE.rnrnrn我进行了如下操作:rnrnrn[oracle@localhost oracle]$ sqlplus "/ as sysdba"rnrnSQL*Plus: Release 8.1.7.0.0 - Production on ÐÇÆÚËÄ 12ÔÂ 6 14:22:08 2007rnrn(c) Copyright 2000 Oracle Corporation. All rights reserved.rnrnrnConnected to:rnOracle8i Enterprise Edition Release 8.1.7.0.1 - ProductionrnWith the Partitioning optionrnJServer Release 8.1.7.0.1 - ProductionrnrnSQL> shutdownrnORA-01109: database not openrnrnrnDatabase dismounted.rnORACLE instance shut down.rnSQL> startup mount;rnORACLE instance started.rnrnTotal System Global Area 1625862304 bytesrnFixed Size 73888 bytesrnVariable Size 642670592 bytesrnDatabase Buffers 983040000 bytesrnRedo Buffers 77824 bytesrnDatabase mounted.rnSQL> alter database open;rnalter database openrn*rnERROR at line 1:rnORA-01589: must use RESETLOGS or NORESETLOGS option for database openrnrnrnSQL> alter database open RESETLOGS;rnalter database open RESETLOGSrn*rnERROR at line 1:rnORA-01194: file 1 needs more recovery to be consistentrnORA-01110: data file 1: '/u01/oracle/oradata/ora8i/system01.dbf'rnrnrnSQL> recover database;rnORA-00283: recovery session canceled due to errorsrnORA-01610: recovery using the BACKUP CONTROLFILE option must be donernrnrnSQL> recover database using backup controlfile;rnORA-00279: change 103493658 generated at 11/16/2007 02:30:24 needed for threadrn1rnORA-00289: suggestion : /u01/oracle/product/8.1.7/dbs/arch1_1179302.dbfrnORA-00280: change 103493658 for thread 1 is in sequence #1179302rnrnrnSpecify log: =suggested | filename | AUTO | CANCELrnautornORA-00308: cannot open archived logrn'/u01/oracle/product/8.1.7/dbs/arch1_1179302.dbf'rnORA-27037: unable to obtain file statusrnLinux Error: 2: No such file or directoryrnAdditional information: 3rnrnrnrn怎么办? 论坛

oracle的奇怪的问题:ORA-01033: ORACLE initialization or shutdown in progress

01-09

rn最近我的oracle8.1.6(win2000上)连接数据库时常出现提示:rnORA-01033: ORACLE initialization or shutdown in progressrn如果进入dos用svrmgrl命令执行rnconnect internalrnshutdown normal(或abort)rn再 startup rn提示:rnErrors in file D:\Oracle\admin\testorac\bdump\testoracSMON.TRC:rnORA-00604: error occurred at recursive SQL level 1rnORA-01115: IO error reading block from file 1 (block # 6041)rnORA-01110: data file 1: 'D:\ORACLE\ORADATA\TESTORAC\SYSTEM01.DBF'rnORA-27091: skgfqio: unable to queue I/OrnOSD-04006: ReadFile() 失败,无法自文件读取rnO/S-Error: (OS 1450) 滚动条范围不可大于 MAXLONG。rnrn难道我的硬盘有问题了?我把数据文件SYSTEM01.DBF复制了一份,复制过程rn中没出问题,停止数据服务testorac,用复制的文件替换原来的数据文件rn仍然如此;看样不应该是硬盘问题;rnrn难道是,我以前用system用户登录,在system方案下建了一些表(gis系统的一些图rn保存成的表),难道是表空间不够了,我在DBA Studio中给system方案加个rn数据文件system02.ora(难道是数据文件名起的不标准的问题,不过错误提示中没提rn到这个文件)rn结果还是时好时坏,常出 ORA-01033:错误rnrn.trc文件中还出过另一个数据库服务的数据文件不能读的提示,rnORA-01110: data file 1: 'D:\ORACLE\ORADATA\ccgis\....'rn我把那个服务在服务管理中将其(ccgis服务)终止,或将其改为手动启动后重起rn这样进入svrmgrl时提示rnora-12560:tns:协议适配器错误rn用connect internal 命令时要口令,输入啥都还要口令rn这是怎么回事,我已经在Net8 Assistant和Net8 Configuration Assistant中rn删掉ccgis服务啦,tnanames.ora中只有TESTORAC名的服务;rn后来,我在Database Configuration Assistant把ccgis数据库删除,删除时提示数据没打开,我点rn“忽略”,继续把ccgis服务删除,重启计算机,rn进入svrmgrl时还提示rnora-12560:tns:协议适配器错误rnrn我想把数据用exp导出,在dos窗口下执行exp时,也提示rnora-12560:tns:协议适配器错误rnrnrn另外,在已经可以连接进入数据库的时候,我在sql*plusrn中执行一个update语句,提示:rnERROR 位于第 1 行:rnORA-01115: 从文件 8 读取块时出现 IO 错误 (块 # 10345)rnORA-01110: 数据文件 8: 'D:\ORACLE\ORADATA\TESTORAC\OEM_REPOSITORY.ORA'rnORA-27091: skgfqio: 无法进行 I/O 操作rnOSD-04006: ReadFile() 失败,无法自文件读取rnO/S-Error: (OS 1450) 滚动条范围不可大于 MAXLONG。rnrn出错后还可以继续使用select 语句rnrnORA-01033: ORACLE initialization or shutdown in progressrnora-12560:tns:协议适配器错误rn这两个问题怎么回事?怎么解决?rn望各位高手指教 论坛

没有更多推荐了,返回首页