Novice just hit the road, have to do with the video, but appear as the topic described in the case, ask god to help small white, specific details are as follows,
SQL> Startup
ORACLE instance started.

The Total System Global Area 209715200 bytes
Fixed Size of 1218580 bytes
Variable Size of 155191276 bytes
The Database Buffers 50331648 bytes
Redo Buffers 2973696 bytes
The Database mounted.
ORA - 01092: ORACLE instance terminated. Disconnection forced

INIT. ORA scripts for:
[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=200 m
*. Undo_management='auto'
*. Undo_tablespace='SYS_UNDOTS'
*. User_dump_dest='/u01/app/admin/ulp udump'

With the alert. The log 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 the opened at the log sequence 11
Current log# seq# 11 mem# 0:1/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
The Errors in the file/u01/app/admin/ulp udump/ulp_ora_8832 TRC:
ORA - 00704: the bootstrap process failure
ORA - 39700: the database must be the opened with the UPGRADE option
Thu Dec 22 13:35:44 2016
Error 704 happened during the db open, shutting down the database
USER: terminating the instance due to error 704
The Instance terminated by the USER, the pid=8832
ORA - 1092 signalled during: the ALTER DATABASE OPEN...

CodePudding user response:

Perform startup upgrade command to open the database:

http://candon123.blog.51cto.com/704299/381841/

CodePudding user response:

1, to 10, the default is to start from the spfile, so, see pfile (init. Ora) useless
2, the log tip:
The Errors in the file/u01/app/admin/ulp udump/ulp_ora_8832 TRC:
ORA - 00704: the bootstrap process failure
ORA - 39700: the database must be the opened with the UPGRADE option

So, with startup upgrade start, and then see what tips

CodePudding user response:

refer to the second floor jdsnhan response:

1, to 10, the default is to start from the spfile, so, see pfile (init. Ora) useless
2, the log tip:
The Errors in the file/u01/app/admin/ulp udump/ulp_ora_8832 TRC:
ORA - 00704: the bootstrap process failure
ORA - 39700: the database must be the opened with the UPGRADE option

So, with startup upgrade start, and then see what tip

CodePudding user response:

refer to the second floor jdsnhan response:

1, to 10, the default is to start from the spfile, so, see pfile (init. Ora) useless
2, the log tip:
The Errors in the file/u01/app/admin/ulp udump/ulp_ora_8832 TRC:
ORA - 00704: the bootstrap process failure
ORA - 39700: the database must be the opened with the UPGRADE option

So, with startup upgrade start, and then see what tip

Oh, amazing thing happened, I tried before this command, can appear the same error, but the line was successfully launched the database, but I close the database, after open again, the same mistake happened again, maybe I need to start every time?

CodePudding user response:

reference 1st floor sych888 response:

perform startup upgrade command to open the database:

http://candon123.blog.51cto.com/704299/381841/

I perform Catupgrade this, was interrupted for a few seconds, specific error is as follows:
SQL> @/u01/app/oracle/RDBMS/admin/catupgrd SQL
DOC> # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
DOC> # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
DOC> The following statement will cause an "ORA - 01722: invalid number"
DOC> The error if the user running this script is not SYS. Disconnect
DOC> And reconnect with the AS SYSDBA.
DOC> # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
DOC> # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
DOC> #

No rows selected

DOC> # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
DOC> # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
DOC> The following statement will cause an "ORA - 01722: invalid number"
DOC> The error if the database server version is not correct for this script.
DOC> Shutdown ABORT and the use of a company's script or a company's server.
DOC> # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
DOC> nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull