oracle 10g手动建库，启动时ORA-01092: ORACLE instance termin ...

Question

新手刚上路，跟着视频一起做，却出现如题所描述的情况，请大神帮忙小白，具体详情如下，
SQL> startup
ORACLE instance started.Total System Global Area  209715200 bytes
Fixed Size                    1218580 bytes
Variable Size                  155191276 bytes
Database Buffers           50331648 bytes
Redo Buffers                    2973696 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forcedINIT.ORA脚本为：
[oracle@DBSERVER ~]$ cat /u01/app/oracle/dbs/initulp.ora 
*.background_dump_dest='/u01/app/admin/ulp/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oradata/ULP/controlfile/o1_mf_d5kngpng_.ctl'#Oracle managed file
*.core_dump_dest='/u01/app/admin/ulp/cdump'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oradata/'
*.db_create_online_log_dest_1='/u01/app/oradata/'
*.db_name='ulp'
*.sga_max_size=200m
*.undo_management='auto'
*.undo_tablespace='SYS_UNDOTS'
*.user_dump_dest='/u01/app/admin/ulp/udump'再贴上alert.log日志：
Thu Dec 22 13:35:44 2016
Completed crash recovery at
Thread 1: logseq 10, block 238, scn 218324
0 data blocks read, 0 data blocks written, 1 redo blocks read
Thu Dec 22 13:35:44 2016
Thread 1 advanced to log sequence 11
Thread 1 opened at log sequence 11
  Current log# 1 seq# 11 mem# 0: /u01/app/oradata/ULP/onlinelog/o1_mf_1_d5kngpto
_.log
Successful open of redo thread 1
Thu Dec 22 13:35:44 2016
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Dec 22 13:35:44 2016
SMON: enabling cache recovery
Thu Dec 22 13:35:44 2016
Errors in file /u01/app/admin/ulp/udump/ulp_ora_8832.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Thu Dec 22 13:35:44 2016
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 8832
ORA-1092 signalled during: ALTER DATABASE OPEN...

Answer 1

执行startup upgrade命令以打开数据库：http://candon123.blog.51cto.com/704299/381841/

Answer 2

1、对于10，默认是启动自spfile，所以，看pfile（init.ora）没用
2、日志中提示：
Errors in file /u01/app/admin/ulp/udump/ulp_ora_8832.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option所以，用startup upgrade 启动，再看什么提示

Answer 3

我执行Catupgrade这个的时候，几秒钟就被中断了，具体错误如下：
SQL> @/u01/app/oracle/rdbms/admin/catupgrd.sql
DOC>######################################################################
DOC>######################################################################
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error if the user running this script is not SYS.  Disconnect
DOC> and reconnect with AS SYSDBA.
DOC>######################################################################
DOC>######################################################################
DOC>#no rows selectedDOC>######################################################################
DOC>######################################################################
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error if the database server version is not correct for this script.
DOC> Shutdown ABORT and use a different script or a different server.
DOC>######################################################################
DOC>######################################################################
DOC>#no rows selectedDOC>#######################################################################
DOC>#######################################################################
DOC>   The following statement will cause an "ORA-01722: invalid number"
DOC>   error if the database has not been opened for UPGRADE.
DOC>
DOC>   Perform a "SHUTDOWN ABORT"  and
DOC>   restart using UPGRADE.
DOC>#######################################################################
DOC>#######################################################################
DOC>#no rows selectedDOC>#######################################################################
DOC>#######################################################################
DOC> The following statements will cause an "ORA-01722: invalid number"
DOC> error if the SYSAUX tablespace does not exist or is not
DOC> ONLINE for READ WRITE, PERMANENT, EXTENT MANAGEMENT LOCAL, and
DOC> SEGMENT SPACE MANAGEMENT AUTO.
DOC>
DOC> The SYSAUX tablespace is used in 10.1 to consolidate data from
DOC> a number of tablespaces that were separate in prior releases.
DOC> Consult the Oracle Database Upgrade Guide for sizing estimates.
DOC>
DOC> Create the SYSAUX tablespace, for example,
DOC>
DOC>  create tablespace SYSAUX datafile 'sysaux01.dbf'
DOC>      size 70M reuse
DOC>      extent management local
DOC>      segment space management auto
DOC>      online;
DOC>
DOC> Then rerun the catupgrd.sql script.
DOC>#######################################################################
DOC>#######################################################################
DOC>#no rows selected
no rows selected
no rows selected
no rows selected
no rows selected
Session altered.
Session altered.
Table created.
1 row deleted.
1 row created.
Commit complete.
TIMESTAMP
------------------------------------------------------------
COMP_TIMESTAMP UPGRD__BGN 2016-12-26 10:12:30 2457749 36750
Table created.
Index created.
Table created.
Index created.
Table created.
Index created.
Index created.
Table created.
Index created.
Table created.
Index created.
Table altered.
Index created.
Table created.
Index created.
Table created.
Index created.
Table created.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table created.
Index created.
1 row deleted.
1 row created.
Commit complete.
Table created.
Table truncated.
1 row created.
Table created.
Index created.
Table created.
Index created.
Table created.
Table altered.
Index created.
Table created.
Index created.
Table created.
Index created.
Table created.
Index created.
Sequence created.
Table created.
Index created.
Sequence created.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Index created.
Table altered.
44 rows updated.
44 rows updated.
Table altered.
Table created.
Index created.
Index created.
Index created.
Table created.
Index created.
Index created.
Table created.
Sequence created.
Table created.
Index created.
Index created.
Table created.
Index created.
Table created.
Index created.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
Table altered.
0 rows deleted.
Table created.
Index created.
Table created.
Index created.
Table created.
Index created.
Index created.
Sequence created.
Table created.
Index created.
1 row deleted.
1 row created.
Commit complete.
0 rows deleted.
0 rows deleted.
Commit complete.
Table altered.
Table altered.
Table created.
Index created.
Table created.
Index created.
Table created.
Table altered.
Table altered.
System altered.
no rows selected
0 rows updated.
System altered.
Table created.
Index created.
Table created.
Index created.
0 rows deleted.
Commit complete.
System altered.
0 rows deleted.
Commit complete.
System altered.CREATE OR REPLACE FUNCTION version_script
*
ERROR at line 1:
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@DBSERVER orcl]$