建立井工区过程中总是出错,运行大约十几分钟后会弹出提示信息“Call DBA and review $HOME/<project_name>_imp.log and $HOME/run/crtprj.err to help identify problem. No to the IMP and ORA error message.”
重新试了很多遍,总是出现这个问题。生成了很多个dbs文件,但是没有建成功的井工区在openwoks--administration中找不到,所以就到oracle目录下将建立错误的*.dbs文件删除了。
删除了*.dbs文件后,发现oracle数据库打不开了,并且其他工区也都没法进入了。
从网上查找了一些解决办法,但是依然没有成功。下面是依据查到的解决办法进行的尝试,不知道哪块出问题了,请高手指点。
1、手动启动(dbstart)查看出错信息
%dbstart
Database “1mb250a”already started.
Database”1mb250a” possibly left running Then system went dowm (system crash?)
Notify Database Administrator
SQL*Plus:Release 8 .1 .6 .0 .0 - Production on Sat Jan 2 15:10:55 2010
(c)Copyright 1999 Oracle Corporation.All rights reserved
SQL>Connected.
SQL>ORACLE instance shut down.
SQL>Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production with the Partitioning option
JSerer Release 8.1.6.1.0一Production
SQL*Plus:Release 8 .1 .6 .0 .0一Production on Sat Jan 2 15:10.56 2010
(c)Copyright 1999 Oracle Corporation.All rights reserved
SQL>Connected to an idle instance
SQL>ORACLE instance started.
丁otal system Global Area 222299760 bytes
Fixed Size 1256 bytes
Variable Size 79478784 bytes
Database Buffers 15}286}00 bytes
Redo Buffers 10}}960 bytes
Database mounted.
ORA-01157:cannot identify/lock data file 20一see DBWR trace file
ORA一01110:data file 20:
'/export/home/oraclel/OraHomel/owprojects/BBW1225020521.dbs'
SQL> Disconnected
Database”1mb2500a”Warm started
2、
%su - oracle
Sun microsystem Inc sunos5.8 .........
% svrmgrl
..................
......................
SVRMGRL> connect internal
connectd
SVRMGRL>startup nomount
ORA-01081:cannot start already -running ORACLE -shut it down first.
(到这里就出错了,可是我的oracle不是关了吗,之前我已经dbshut了,还是会弹出这个提示信息)
3、下面这些步骤是从网上搜到的剩下的步骤 ,有没有高手给详细的介绍一下每一布是什么意思啊?
connect internal
connect internal
startup nomount
alter database mount exclusive;
4.从数据库中删除出错信息中列出的全路径文件
alter database dataafile '/pb/OpenWorks/oracle/dbs/OWEX0.dbs'
offline drop;
5.打开数据库 alter database open;
6.drop tablespace OWEX including contents cascade constraints;
drop user OWEX cascade;
drop role manage_OWEX;
drop role interp_OWEX;
drop role l_interp_OWEX;
drop role browse_OWEX
7.从工区数据库中删除OWEX
alter session set current_schema=owsys;
delete from ow_sys_project where project_name='OWEX';
delete from ow_sys_prj_user where project_name='OWEX'; delete from owsysp.ow_sysp_prj_security where
project_name='OWEX';
commit
8.重新dbshut数据库后,再次dbstart,数据库应该正常启动,如果有OWEX 工区的备份文件,restore 即可。
[ 此帖被yatouupc在2010-01-04 16:38重新编辑 ]