Help - Search - Members - Calendar
Full Version: Error during creating a clone database - ORA-01092: ORACLE instance terminated. Disconnection forced
Oracle DBA Forums > Oracle > Oracle Forum
coldstones
Hi

I have recieved a database template created in 10.2.04. I also have the same version on my PC. I use database configuration assistant and use this template to create my database. During the database creation it creates no of dbf files. But when the installation reaches to 40% I get the error alert as :

alter database "GWATERT" open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


I checked the dbcreationlog I found the following error:

H:\ORACLE\ORADATA\GWATERT\CONTROLFILE\O1_MF_7KBOPXH5_.CTL
H:\ORACLE\ORA10G\FLASH_RECOVERY_AREA\GWATERT\CONTROLFILE\O1_MF_7KBOPXOJ_.CTL
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1258291200 bytes
Fixed Size 1298280 bytes
Variable Size 301990040 bytes
Database Buffers 947912704 bytes
Redo Buffers 7090176 bytes
alter database "GWATERT" open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


I am also pasting the error from the alert log file as:
LOGFILE GROUP 1 ('D:\Oracle\oradata\GWATERT\redo01.log', 'D:\Oracle\oradata\GWATERT\redo02.log') SIZE 51200K,
GROUP 2 ('D:\Oracle\oradata\GWATERT\redo03.log', 'D:\Oracle\oradata\GWATERT\redo04.log') SIZE 51200K,
GROUP 3 ('D:\Oracle\oradata\GWATERT\redo05.log', 'D:\Oracle\oradata\GWATERT\redo06.log') SIZE 51200K RESETLOGS
Tue Jan 17 16:20:32 2012
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Tue Jan 17 16:20:32 2012
Errors in file e:\oracle\admin\viint\udump\gwatert_ora_3176.trc:
ORA-01565: error in identifying file 'D:\Oracle\oradata\GWATERT\O1_MF_SYSTEM_7J8MWXF8_.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

ORA-1503 signalled during: Create controlfile reuse set database "GWATERT"


From the trace file:

Dump file e:\oracle\admin\viint\bdump\gwatert_mman_3176.trc
Tue Jan 17 16:51:59 2012
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows XP Version V5.1 Service Pack 3
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2048M/3053M, Ph+PgF:2882M/4939M, VA:662M/2047M
Instance name: gwatert

Redo thread mounted by this instance: 1

Oracle process number: 4

Windows thread id: 3176, image: ORACLE.EXE (MMAN)


*** 2012-01-17 16:51:59.526
*** SERVICE NAME:() 2012-01-17 16:51:57.667
*** SESSION ID:(333.1) 2012-01-17 16:51:57.667
error 704 detected in background process
ORA-00704: Message 704 not found; No message file for product=RDBMS, facility=ORA


I am not sure why this error is being caused. So any feedback to resolve this will be highly appreciated.

Thanks,

PS: attaching the alert log and trace files in a zip file.
burleson
Hi,

>> ORA-01092

You have MISSING datafiles

http://www.dba-oracle.com/t_ora_01092_orac..._terminated.htm

******************************************
>> ORA-00704

The oerr shows this action for your ORA-00704 error:

http://www.dba-oracle.com/t_ora_00704_boot...ess_failure.htm

ORA-00704: bootstrap process failure

Cause: An error occurred when processing bootstrap data. Refer to the accompanying messages for more information about the cause of the problem. Action: Correct the problems mentioned in the other messages. If the problem persists, contact customer support.

**********************************************
>> WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command

Why is this?

Can you look at your create database command manually?

**************************************************
>> ORA-01565: error in identifying file 'D:\Oracle\oradata\GWATERT\O1_MF_SYSTEM_7J8MWXF8_.DBF'

You have a missing file . . .

Search for all the fikes mentioned in yoour post:

ORA-27041: unable to open file
OSD-04002: unable to open file

Or better still trash the mess and start over with a better procedure . . .

******************************************************
>> I use database configuration assistant and use this template to create my database.

That's your first mistake, replying ona GUI wizard! I detest them and never use them!

Start over and use this script to clone:

http://www.dba-oracle.com/oracle_tips_db_copy.htm

With the script you know exactly what is going on!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.