Oracle Server local First connection DB instance is empty, startup failed ORA01078

Today, after installing Oracle in the CentOS virtual machine, you are ready to connect the instance on the Oracle server (CentOS virtual machine) and display it as an idle instance, start command start failed. The error is as follows:

[Email protected] ~]$ Sqlplus/nolog

Sql*plus:release 10.2.0.1.0-production on Tue Jul 21 15:16:31 2015

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Sql> Conn/as SYSDBA

Connected to an idle instance.

Sql> Startup

Ora-01078:failure in processing system parameters

Lrm-00109:could not open parameter file '/opt/oracle/product/10.2/db_1/dbs/initorcl.ora '

Judging from the error content is not found to the corresponding initialization file Initoracl.ora

cd/opt/oracle/product/10.2/db_1/dbs/Enter the file directory and ls-l view the file directory under the following file:

hc_pks.dat initdw.ora init.ora lkpks orapwpks spfilepks.ora

Observing the above file notice that Spfilepks.ora remembered that the creation of the database was established by the instance named PSK, which differs from the ORACLE_SID=ORCL in the ORACLE user environment variable, which could be the result of the above error.

Decide to modify the ORACLE user environment variable oracle_sid=pks,oracle user under use command export ORACLE_SID=PKS. After modification, reconnect the instance successfully without error, the problem solved smoothly!

Oracle Server local First connection DB instance is empty, startup failed ORA01078