新手剛上路，跟著視頻一起做，卻出現如題所描述的情況，請大神幫忙小白，具體詳情如下，
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 forced
INIT.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...
uj5u.com熱心網友回復：
執行startup upgrade命令以打開資料庫：http://candon123.blog.51cto.com/704299/381841/
uj5u.com熱心網友回復：
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 啟動，再看什么提示
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
喔，神奇的事情發生了，這個命令之前我試過，會出現同樣的報錯，但這次行居然成功啟動了資料庫，但我關閉資料庫，再重新開啟后，又同樣的錯誤發生了，難不成我每次都需要這樣啟動嗎？
uj5u.com熱心網友回復：
我執行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 selected
DOC>######################################################################
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 selected
DOC>#######################################################################
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 selected
DOC>#######################################################################
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]$
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/109233.html
標籤：基礎和管理