error running catpatch.sql in migrate mode 1

[droodle]

hi i've got this far ...


SQL> connect / as sysdba
Connected.
SQL> startup migrate
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
SQL>
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup migrate
ORACLE instance started.

Total System Global Area 588062840 bytes
Fixed Size 454776 bytes
Variable Size 268435456 bytes
Database Buffers 318767104 bytes
Redo Buffers 405504 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;

STATUS
------------
OPEN MIGRATE

SQL> startup D:\oracle\Oracle.9.2\rdbms\admin\catpatch
SP2-0714: invalid combination of STARTUP options
SQL> startup D:\oracle\Oracle.9.2\rdbms\admin\catpatch.sql
SP2-0714: invalid combination of STARTUP options
SQL> startup @D:\oracle\Oracle.9.2\rdbms\admin\catpatch.sql
SP2-0714: invalid combination of STARTUP options
SQL> STARTUP D:\oracle\Oracle.9.2\rdbms\admin\catpatch
SP2-0714: invalid combination of STARTUP options
SQL>


am i using the correct syntax ?

also how do i exit migrate mode once its finished ? thanks.

 

[droodle]

ok i've got it running with

SQL> START D:\oracle\Oracle.9.2\rdbms\admin\catpatch

but how to i exit migrate mode and startup the db again ?

thanks.

 

[appi]

Hi droodle,

easy way ....
-- shutdown immediate
-- startup (without migrate)
or
-- startup pfile=.....
This it is

regards
uwe