This discussion is archived
10 Replies Latest reply: Nov 6, 2009 2:13 AM by Nicolas.Gasparotto RSS

ORA-00704: bootstrap process failure ORA-39700: database must be opened wit

615123 Newbie
Currently Being Moderated
Hi,

I have oracle 10.2.0.1.0 installed on redhat 4 linux i take cold backup of my database and want to copy it on windows 2008 server 64 bit having oracle 10.2.0.3.0 installed.

i recreate my controlfiles but when i start database i got this error i need to upgrade. i do it.
SQL> CREATE CONTROLFILE REUSE DATABASE "NEO" RESETLOGS  ARCHIVELOG
  2      MAXLOGFILES 16
  3      MAXLOGMEMBERS 3
  4      MAXDATAFILES 100
  5      MAXINSTANCES 8
  6      MAXLOGHISTORY 292
  7  LOGFILE
  8    GROUP 1 (
  9      'C:\oracle\product\10.2.0\oradata\neo\redo01.log',
 10      'C:\oracle\product\10.2.0\oradata\neo\redo01_1.log'
 11    ) SIZE 50M,
 12    GROUP 2 (
 13      'C:\oracle\product\10.2.0\oradata\neo\redo02.log',
 14      'C:\oracle\product\10.2.0\oradata\neo\redo02_1.log'
 15    ) SIZE 50M,
 16    GROUP 3 (
 17      'C:\oracle\product\10.2.0\oradata\neo\redo03.log',
 18      'C:\oracle\product\10.2.0\oradata\neo\redo03_1.log'
 19    ) SIZE 50M
 20  -- STANDBY LOGFILE
 21  DATAFILE
 22    'C:\oracle\product\10.2.0\oradata\neo\system01.dbf',
 23    'C:\oracle\product\10.2.0\oradata\neo\undotbs01.dbf',
 24    'C:\oracle\product\10.2.0\oradata\neo\sysaux01.dbf',
 25    'C:\oracle\product\10.2.0\oradata\neo\users01.dbf'
 26  CHARACTER SET WE8ISO8859P1
 27  ;

Control file created.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade resetlogs;
SP2-0714: invalid combination of STARTUP options
SQL> startup upgrade;
ORACLE instance started.

Total System Global Area  289406976 bytes
Fixed Size                  1290184 bytes
Variable Size              96469048 bytes
Database Buffers          184549376 bytes
Redo Buffers                7098368 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
This is my alert log file

rrors in file c:\oracle\product\10.2.0\admin\neo\udump\neo_ora_2860.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

Fri Nov 06 00:15:42 2009
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
ARC1 started with pid=17, OS id=7264
Fri Nov 06 00:15:43 2009
Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_pmon_6268.trc:
ORA-00704: bootstrap process failure

Fri Nov 06 00:15:44 2009
Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_reco_5760.trc:
ORA-00704: bootstrap process failure

Fri Nov 06 00:15:44 2009
Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_lgwr_3900.trc:
ORA-00704: bootstrap process failure

Fri Nov 06 00:15:44 2009
Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_dbw0_7956.trc:
ORA-00704: bootstrap process failure

Fri Nov 06 00:15:44 2009
Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_ckpt_3192.trc:
ORA-00704: bootstrap process failure

Fri Nov 06 00:15:44 2009
Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_smon_7112.trc:
ORA-00704: bootstrap process failure

Fri Nov 06 00:15:45 2009
Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_mman_6644.trc:
ORA-00704: bootstrap process failure

Fri Nov 06 00:15:46 2009
Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_psp0_5708.trc:
ORA-00704: bootstrap process failure

Instance terminated by USER, pid = 2860
ORA-1092 signalled during: alter database open resetlogs...



Please suggest how to upgrade and open database with resetlogs.

Thanks
umesh
  • 1. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    You'er doing
    1. database move across plateform
    2. an upgrade
    That cannot work so simple as you did.
    Please, read carefully the following thread :
    Database Migration

    You should :
    1. manage a database conversion (if possible regarding the endianess of your both OS)
    2. an upgrade

    Nicolas.
  • 2. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    615123 Newbie
    Currently Being Moderated
    Thanks for you reply

    But i did it on two local servers one is redhat 4 another windows xp both have oracle 10.2.0.1.0 and it is done that's why i am doing to for live.

    Here the only difference is My source server have oracle 10.2.0.1.0 and destination have oracle 10.2.0.3.0. If i install oracle 10.2.0.1.0 on destination will it work.

    please suggest.

    Thanks
    umesh
  • 3. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    Umesh Sharma wrote:
    Thanks for you reply

    But i did it on two local servers one is redhat 4 another windows xp both have oracle 10.2.0.1.0 and it is done that's why i am doing to for live.
    That is wrong way to move database across plateform.
    Here the only difference is My source server have oracle 10.2.0.1.0 and destination have oracle 10.2.0.3.0. If i install oracle 10.2.0.1.0 on destination will it work.

    please suggest.
    I already suggested.

    As I said in the thread I linked above, check the DATABASE CONVERT doc :
    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm#CHDCFFDI

    Nicolas.
  • 4. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    Niall Litchfield Journeyer
    Currently Being Moderated
    N. Gasparotto wrote:
    Umesh Sharma wrote:
    Thanks for you reply

    But i did it on two local servers one is redhat 4 another windows xp both have oracle 10.2.0.1.0 and it is done that's why i am doing to for live.
    That is wrong way to move database.
    Here the only difference is My source server have oracle 10.2.0.1.0 and destination have oracle 10.2.0.3.0. If i install oracle 10.2.0.1.0 on destination will it work.

    please suggest.
    I already suggested.

    Nicolas.
    To do what you are trying to do you should perform the upgrade first on the source and only then do the cross platform move. It's likely that this isn't the best way of achieving your business goals though, but you haven't told us what those are. (or if both servers are running 64bit Oracle).

    Niall Litchfield
    http://www.orawin.info/
  • 5. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    615123 Newbie
    Currently Being Moderated
    Thanks for reply.

    If i use RMAN Cross-Platform Transportable Databases then is it ok to have two different oracle versions on source or destination like

    My source server have oracle 10.2.0.1.0 and destination have oracle 10.2.0.3.0.
  • 6. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    Could you manage an upgrade on source ? Probably the simplest way.
    Or you could try to upgrade the database once it is converted and up on target OS.

    Nicolas.
  • 7. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    615123 Newbie
    Currently Being Moderated
    Thanks for your reply

    Actually i don't have license for oracle 10g. than can you please tell me the process of upgrade.
  • 8. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    Umesh Sharma wrote:
    Thanks for your reply

    Actually i don't have license for oracle 10g. than can you please tell me the process of upgrade.
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm

    Nicolas.
  • 9. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    615123 Newbie
    Currently Being Moderated
    Thanks for your support

    i do it using RMAN RMAN Cross-Platform Transportable Databases and facing the same problem i.e. main issue is different version of oracle .

    have a look.
    SQL> startup nomount
    ORACLE instance started.
    
    Total System Global Area  289406976 bytes
    Fixed Size                  1290184 bytes
    Variable Size              96469048 bytes
    Database Buffers          184549376 bytes
    Redo Buffers                7098368 bytes
    SQL> CREATE CONTROLFILE REUSE DATABASE "NEO" RESETLOGS  NOARCHIVELOG
      2      MAXLOGFILES 16
      3      MAXLOGMEMBERS 3
      4      MAXDATAFILES 100
      5      MAXINSTANCES 8
      6      MAXLOGHISTORY 292
      7  LOGFILE
      8    GROUP 1 (
      9      'C:\oracle\product\10.2.0\oradata\neo\redo01.log',
     10      'C:\oracle\product\10.2.0\oradata\neo\redo01_1.log'
     11    ) SIZE 50M,
     12    GROUP 2 (
     13      'C:\oracle\product\10.2.0\oradata\neo\redo02.log',
     14      'C:\oracle\product\10.2.0\oradata\neo\redo02_1.log'
     15    ) SIZE 50M,
     16    GROUP 3 (
     17      'C:\oracle\product\10.2.0\oradata\neo\redo03.log',
     18      'C:\oracle\product\10.2.0\oradata\neo\redo03_1.log'
     19    ) SIZE 50M
     20  -- STANDBY LOGFILE
     21  DATAFILE
     22    'C:\oracle\product\10.2.0\oradata\neo\data_D-NEO_I-1778762914_TS-SYSAUX_F
    NO-3_0skt4iua',
     23    'C:\oracle\product\10.2.0\oradata\neo\data_D-NEO_I-1778762914_TS-SYSTEM_F
    NO-1_0rkt4ith',
     24    'C:\oracle\product\10.2.0\oradata\neo\data_D-NEO_I-1778762914_TS-UNDOTBS1
    _FNO-2_0tkt4iv3',
     25    'C:\oracle\product\10.2.0\oradata\neo\data_D-NEO_I-1778762914_TS-USERS_FN
    O-4_0qkt4irg'
     26  CHARACTER SET WE8ISO8859P1
     27  ;
    
    Control file created.
    
    SQL> ALTER DATABASE OPEN RESETLOGS;
    ALTER DATABASE OPEN RESETLOGS
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
    alert log file
    ORA-00704: bootstrap process failure
    ORA-39700: database must be opened with UPGRADE option
    
    Fri Nov 06 01:36:00 2009
    Error 704 happened during db open, shutting down database
    USER: terminating instance due to error 704
    Fri Nov 06 01:36:00 2009
    Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_pmon_7244.trc:
    ORA-00704: bootstrap process failure
    
    Fri Nov 06 01:36:01 2009
    Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_reco_1128.trc:
    ORA-00704: bootstrap process failure
    
    Fri Nov 06 01:36:01 2009
    Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_smon_4080.trc:
    ORA-00704: bootstrap process failure
    
    Fri Nov 06 01:36:01 2009
    Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_ckpt_4256.trc:
    ORA-00704: bootstrap process failure
    Finally i need to upgrade my source database.

    Thanks
    umesh
  • 10. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    Without being licensed, and without access to Metalink, you cannot get the patchset 10.2.0.3 to manage the upgrade on RHEL.
    So, you probably should think about an other way, like export/import.

    Nicolas.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points