[nandra]

All,

Iam a DB2 UDB DBA and my manager asked me to create a oracle database for some new initiative.

Our sysadmins installed Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 in linux.

but having issues while starting up the oracle.

SQL> startup
ORACLE instance started.

Total System Global Area 100663296 bytes
Fixed Size 1217884 bytes
Variable Size 88083108 bytes
Database Buffers 8388608 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

Can anyone help me here. Really appreciate ur help.

Thanks in advance.

[anacedent]

locate alert_SID.log file.
It will contain a report of the failure; which includes the fully qualified pathname of the trace file.

Post back here both the tail -80 alert_SID.log & head -200 of the trace file.

[nandra]

Thanks for the quick response. Here are the details

LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 62914560
control_files = /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control1, /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control2
db_block_buffers = 1024
log_buffer = 2927616
log_checkpoint_interval = 10000
db_files = 80
db_file_multiblock_read_count= 8
global_names = TRUE
instance_name = awqmdb
parallel_max_servers = 5
background_dump_dest = /home/oracle/admin/awqmdb/bdump
user_dump_dest = /home/oracle/admin/awqmdb/udump
max_dump_file_size = 10240
core_dump_dest = /home/oracle/admin/awqmdb/cdump
db_name = awqmdb
PMON started with pid=2, OS id=15696
PSP0 started with pid=3, OS id=15698
MMAN started with pid=4, OS id=15700
DBW0 started with pid=5, OS id=15702
LGWR started with pid=6, OS id=15704
CKPT started with pid=7, OS id=15706
SMON started with pid=8, OS id=15708
RECO started with pid=9, OS id=15710
MMON started with pid=10, OS id=15712
MMNL started with pid=11, OS id=15714
Wed Jul 2 14:26:24 2008
ALTER DATABASE MOUNT
Wed Jul 2 14:26:28 2008
Setting recovery target incarnation to 1
Wed Jul 2 14:26:28 2008
Successful mount of redo thread 1, with mount id 3773061392
Wed Jul 2 14:26:28 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Jul 2 14:26:28 2008
ALTER DATABASE OPEN
Wed Jul 2 14:26:28 2008
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Wed Jul 2 14:26:28 2008
Started redo scan
Wed Jul 2 14:26:28 2008
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Wed Jul 2 14:26:28 2008
Started redo application at
Thread 1: logseq 22, block 2, scn 572888
Wed Jul 2 14:26:28 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 22 Reading mem 0
Mem# 0 errs 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log2awqmdb.dbf
Wed Jul 2 14:26:28 2008
Completed redo application
Wed Jul 2 14:26:28 2008
Completed crash recovery at
Thread 1: logseq 22, block 3, scn 592890
0 data blocks read, 0 data blocks written, 1 redo blocks read
Wed Jul 2 14:26:28 2008
Thread 1 advanced to log sequence 23
Thread 1 opened at log sequence 23
Current log# 1 seq# 23 mem# 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log1awqmdb.dbf
Successful open of redo thread 1
Wed Jul 2 14:26:28 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jul 2 14:26:28 2008
SMON: enabling cache recovery
Wed Jul 2 14:26:28 2008
Errors in file /home/oracle/admin/awqmdb/udump/awqmdb_ora_15722.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Wed Jul 2 14:26:28 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 15722
ORA-1092 signalled during: ALTER DATABASE OPEN...


head -200 alert_awqmdb.log
Tue Jul 1 17:09:13 2008
Starting ORACLE instance (normal)
Tue Jul 1 17:09:13 2008
System parameter db_block_buffers enabled without VLM on.
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as /home/oracle/app/oracle/product/10.2.0/db_1/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 62914560
control_files = /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control1, /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control2
db_block_buffers = 1024
log_buffer = 2927616
log_checkpoint_interval = 10000
db_files = 80
db_file_multiblock_read_count= 8
global_names = TRUE
instance_name = awqmdb
parallel_max_servers = 5
background_dump_dest = /home/oracle/admin/awqmdb/bdump
user_dump_dest = /home/oracle/admin/awqmdb/udump
max_dump_file_size = 10240
core_dump_dest = /home/oracle/admin/awqmdb/cdump
db_name = awqmdb
PMON started with pid=2, OS id=17750
PSP0 started with pid=3, OS id=17752
MMAN started with pid=4, OS id=17754
DBW0 started with pid=5, OS id=17756
LGWR started with pid=6, OS id=17758
CKPT started with pid=7, OS id=17760
SMON started with pid=8, OS id=17762
RECO started with pid=9, OS id=17764
MMON started with pid=10, OS id=17766
MMNL started with pid=11, OS id=17768
Tue Jul 1 17:09:13 2008
ALTER DATABASE MOUNT
Tue Jul 1 17:09:17 2008
Setting recovery target incarnation to 1
Tue Jul 1 17:09:17 2008
Successful mount of redo thread 1, with mount id 3772991929
Tue Jul 1 17:09:17 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Jul 1 17:09:17 2008
ALTER DATABASE OPEN
Tue Jul 1 17:09:17 2008
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Tue Jul 1 17:09:18 2008
Started redo scan
Tue Jul 1 17:09:18 2008
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Tue Jul 1 17:09:18 2008
Started redo application at
Thread 1: logseq 16, block 2, scn 452672
Tue Jul 1 17:09:18 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 16 Reading mem 0
Mem# 0 errs 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log2awqmdb.dbf
Tue Jul 1 17:09:18 2008
Completed redo application
Tue Jul 1 17:09:18 2008
Completed crash recovery at
Thread 1: logseq 16, block 3, scn 472674
0 data blocks read, 0 data blocks written, 1 redo blocks read
Tue Jul 1 17:09:18 2008
Thread 1 advanced to log sequence 17
Thread 1 opened at log sequence 17
Current log# 1 seq# 17 mem# 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log1awqmdb.dbf
Successful open of redo thread 1
Tue Jul 1 17:09:18 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jul 1 17:09:18 2008
SMON: enabling cache recovery
Tue Jul 1 17:09:18 2008
Errors in file /home/oracle/admin/awqmdb/udump/awqmdb_ora_17770.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Tue Jul 1 17:09:18 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 17770
ORA-1092 signalled during: ALTER DATABASE OPEN...
Tue Jul 1 17:18:29 2008
Starting ORACLE instance (normal)
Tue Jul 1 17:18:29 2008
System parameter db_block_buffers enabled without VLM on.
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as /home/oracle/app/oracle/product/10.2.0/db_1/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 62914560
control_files = /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control1, /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control2
db_block_buffers = 1024
log_buffer = 2927616
log_checkpoint_interval = 10000
db_files = 80
db_file_multiblock_read_count= 8
global_names = TRUE
instance_name = awqmdb
parallel_max_servers = 5
background_dump_dest = /home/oracle/admin/awqmdb/bdump
user_dump_dest = /home/oracle/admin/awqmdb/udump
max_dump_file_size = 10240
core_dump_dest = /home/oracle/admin/awqmdb/cdump
db_name = awqmdb
PMON started with pid=2, OS id=17802
PSP0 started with pid=3, OS id=17804
MMAN started with pid=4, OS id=17806
DBW0 started with pid=5, OS id=17808
LGWR started with pid=6, OS id=17810
CKPT started with pid=7, OS id=17812
SMON started with pid=8, OS id=17814
RECO started with pid=9, OS id=17816
MMON started with pid=10, OS id=17818
MMNL started with pid=11, OS id=17820
Tue Jul 1 17:18:29 2008
ALTER DATABASE MOUNT
Tue Jul 1 17:18:33 2008
Setting recovery target incarnation to 1
Tue Jul 1 17:18:33 2008
Successful mount of redo thread 1, with mount id 3772966373
Tue Jul 1 17:18:33 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Jul 1 17:18:33 2008
ALTER DATABASE OPEN MIGRATE
Tue Jul 1 17:18:33 2008
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Tue Jul 1 17:18:33 2008
Started redo scan
Tue Jul 1 17:18:33 2008
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Tue Jul 1 17:18:33 2008
Started redo application at
Thread 1: logseq 17, block 2, scn 472676
Tue Jul 1 17:18:33 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 17 Reading mem 0
Mem# 0 errs 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log1awqmdb.dbf
Tue Jul 1 17:18:33 2008
Completed redo application
Tue Jul 1 17:18:33 2008
Completed crash recovery at
Thread 1: logseq 17, block 3, scn 492678
0 data blocks read, 0 data blocks written, 1 redo blocks read

[anacedent]

close enough.
I requested the top of the trace file not alert_SID.log
head -200 /home/oracle/admin/awqmdb/udump/awqmdb_ora_15722.trc

SMON: enabling cache recovery
Wed Jul 2 14:26:28 2008
Errors in file /home/oracle/admin/awqmdb/udump/awqmdb_ora_15722.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Wed Jul 2 14:26:28 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 15722
ORA-1092 signalled during: ALTER DATABASE OPEN...

I'll guess what has happened.
V10.2.0.1 was installed.
Somebody decided to apply a patch to V10.2.0.2 or higher & did not complete the documented upgrade procedure.

ORA-39700: database must be opened with UPGRADE option

Find the patchset release notes & complete the installation of it.

[LKBrwn_DBA]

ORA-39700: database must be opened with UPGRADE option

As anacedent mentions, it seems the sofware was installed and upgraded but the database was not upgraded, ...and...then the database was terminated with Control-C during startup.

Try the following:

sqlplus '/as sysdba'
shutdown abort;
startup upgrade
@?/rdbms/admin/catupgrd.sql

Maybe will work

PS: Backup everything NOW!

[nandra]

I tried the option and found the following issue.

Function created.

No errors.
SELECT version_script AS file_name FROM DUAL
*
ERROR at line 1:
ORA-20000: Upgrade not supported from version
ORA-06512: at "SYS.VERSION_SCRIPT", line 50


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[LKBrwn_DBA]

ORA-39700: database must be opened with UPGRADE option

It is still asking to upgrade, do you actually have a database created? What version?

Execute the RDA (Remote diagnostics utility), which will gather all information about the OS and RDBMS; then open a service request w/Oracle (and have an Oracle DBA available).