Handling process that Oracle cannot start

Oracle DatabaseIf a fault occurs during the operation, the work may be affected. To solve the problem in a timely manner, we will solve the OracleUnable to start.

Cause: After the server is restarted, another database instance cannot be started and different errors are reported.

Solution Process:

1. First modify the default ORACLE_SID

[Root @ localhost root] # su-oracle

[Root @ localhost root] export ORACLE_SID = blogjava

2. log on to the database and start the database.

[Oracle @ localhost oracle] $ sqlplus/nolog

SQL> conn/as sysdba

Connected.

SQL> startup;

Error: ORA-01078: failure in processing system parameters

LRM-00109: cocould not open parameter file '/oracle/product/9.2/dbs/initblogjava. ora'

3. Create the initblogjava. ora File

[Oracle @ localhost oracle] $ vi '/oracle/product/9.2/dbs/initblogjava. ora

Enter spfile =/oracle/product/9.2/dbs/spfileblogjava. ora in the file.

Note: Be sure to create it on an oracle user, otherwise there will be an error with insufficient permissions (ORA-01031: insufficient privileges.

4. Create a spfile File

[Oracle @ localhost oracle] $ sqlplus/nolog

SQL> conn/as sysdba

Connected.

SQL> create spfile from pfile = '/oracle/admin/blogjava/pfile/init. ora ';

After the spfileblogjava. ora is generated in/oracle/product/9.2/dbs /.

5. Start the database

[Oracle @ localhost oracle] $ sqlplus/nolog

SQL> conn/as sysdba

Connected.

SQL> startup;

Started successfully!
At this point, the Oracle database startup failure problem is solved. I hope you can master the knowledge described in this article. If you encounter similar problems, you can easily solve them.