ORA-01034:, ORA-01078: And LRM-00109: solution, ora-01034ora-01078

ORA-01034:, ORA-01078: And LRM-00109: solution, ora-01034ora-01078

Environment: Linux 5.4 Oracle 11.2.0.3

When connecting to Oracle on Linux, an error is reported:

SQL>Show parameter sga
A ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

SQL>Startup
ORA-01078: failure in processing system parameters
LRM-00109: cocould not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorcal. ora'

The above error message '../initorcal. ora' indicates that the database instance name (I .e. SID) recognized by the current Oracle database is: orcal;
It may be caused by inconsistent SID settings during Oracle Installation with those set in environment variables.

Solution:

1. query the current data instance name (SID)
[Oracle @ oradb ~] $Echo $ ORACLE_SID
Orcal

2. view the SID configuration of the Environment Variable
[Oracle @ oradb ~] $Cat. bash_profile
#. Bash_profile

# Get the aliases and functions
If [-f ~ /. Bashrc]; then
.~ /. Bashrc
Fi

# User specific environment and startup programs

PATH = $ PATH: $ HOME/bin

Export PATH
Export ORACLE_SID = orcl

It is found that the Instance name orcal recognized by the system is inconsistent with the environment variable set to orcl. In this case, we need to modify the Instance name SID.

3. Modify the oracle ORACLE_SID environment variable, for example, change orcal to orcl.
[Oracle @ oradb ~] $Vi/home/oracle/. bash_profile
Export ORACLE_SID = orcl

4. Modify the/etc/oratab file and change the sid Name from orcal to orcl.
[Oracle @ oradb ~] $Vi/etc/oratab
Orcl:/u01/app/oracle/product/11.2.0/db_1: N

5. Go to the $ ORACLE_HOME/dbs directory, for example, my/u01/app/oracle/product/11.2.0/db_1/dbs
Modify all files whose names contain the original sid to the corresponding new sid
[Oracle @ oradb ~] $Cd/u01/app/oracle/product/11.2.0/db_1/dbs
[Oracle @ oradb dbs] $Ls
Hc_orcal.dat init. ora lkORCAL orapworcal spfileorcal. ora

[Oracle @ oradb dbs] $Mv hc_orcal.dat hc_orcl.dat
[Oracle @ oradb dbs] $Mv lkORCAL lkORCL
[Oracle @ oradb dbs] $Mv orapworcal orapworcl
[Oracle @ oradb dbs] $Mv spfileorcal. ora spfileorcl. ora

6. Start the database
[Oracle @ oradb dbs] $Sqlplus/as sysdba

SQL>Startup
ORACLE instance started.

Database started successfully !!

[Reference]Http://www.linuxidc.com/Linux/2015-02/114255.htm