11.5.10.2 Installation

  • From: Tony Sheks <asheks@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Tue, 10 Mar 2009 12:41:36 +0000 (GMT)

Hi All, 

I am trying a fresh install of 11.5.10.2 on OEL5 and I have an error which I 
cannot resolve!

Basically I downloaded the media from edelivery and it seems that one of the 
datafiles is corrunpt. Now edelivery have removed (11.5.10.2) from it's 
download list? Does anyone know where I can get (11.5.10.2) to download, its 
not on OTN/Metalink either.

Any suggestions will be greatful!!
Error below..........

Total System Global Area  581506668 bytes
Fixed Size                   452204 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
 
 
BEGIN dbms_backup_restore.zeroDbid(0); END;
 
*
ERROR at line 1:
ORA-00210: cannot open the specified controlfile
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
 
 
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
 
Total System Global Area  581506668 bytes
Fixed Size                   452204 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
CREATE CONTROLFILE REUSE SET DATABASE "VIS"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01159: file is not from same database as previous files - wrong database id
ORA-01110: data file 31: '/u01/oracle/visdata/tx_data5.dbf'
 
 
alter database open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted
 
 
alter tablespace TEMP add tempfile '/u01/oracle/visdata/tmp1.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open
 
 
ALTER DATABASE RENAME GLOBAL_NAME TO "VIS.com"
                                     *
ERROR at line 1:
ORA-01109: database not open
 
 
declare lib_ver varchar2(3);
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
 
 
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
exit_code=1
 
Checking for errors ...
 
ORA-01503: CREATE CONTROLFILE failed
ORA-01159: file is not from same database as previous files - wrong database id
ORA-01110: data file 31: '/u01/oracle/visdata/tx_data5.dbf' 
ORA-01507: database not mounted 
ORA-01109: database not open 
ORA-01109: database not open 
ORA-01507: database not mounted 
ORA-00205: error in identifying controlfile, check alert log for more info 
ORA-00210: cannot open the specified controlfile
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1 
ORA-01503: CREATE CONTROLFILE failed
ORA-01159: file is not from same database as previous files - wrong database id
ORA-01110: data file 31: '/u01/oracle/visdata/tx_data5.dbf' 
ORA-01507: database not mounted 
ORA-01109: database not open 
ORA-01109: database not open 
The database has not been successfully created. Shutting down the instance ...
 
SQL*Plus: Release 9.2.0.6.0 - Production on Sun Mar 8 07:20:22 2009
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Connected.
ORACLE instance shut down.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Cannot create control file for VIS
    RW-50010: Error: - script has returned an error:   1
RW-50004: Error code received when running external process.  Check log file 
for details.
Running Database Install Driver for VIS instance


Tony!!



      

Other related posts:

  • » 11.5.10.2 Installation - Tony Sheks