ORA-01034:, ORA-01078: And LRM-00109: Solution

ORA-01034:, ORA-01078: And LRM-00109: Solution
Environment: Linux 5.4 Oracle 11.2.0.3 when connecting Oracle on Linux error: SQL> show parameter sgaORA-01034: ORACLE not availableProcess ID: 0 Session ID: 0 Serial number: 0 SQL> startupORA-01078: failure in processing system parametersLRM-00109: cocould not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorcal. ora 'above '.. /initorcal. ora's error indicates that the name (SID) of the database instance recognized by the current Oracle database is orcal. It may be that the SID setting during Oracle installation is inconsistent with the SID set in the environment variable.. Solution: 1. query the current data instance name (SID) [oracle @ oradb ~] $ Echo $ ORACLE_SIDorcal 2. view the SID configuration of the Environment Variable [oracle @ oradb ~] $ Cat. bash_profile #. bash_profile # Get the aliases and functionsif [-f ~ /. Bashrc]; then .~ /. Bashrcfi # User specific environment and startup programs PATH = $ PATH: $ HOME/bin export PATHexport 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_profileexport ORACLE_SID = orcl 4. Modify the/etc/oratab file and change the sid Name from orcal to orcl [oracle @ oradb ~] $ Vi/etc/orataborcl:/u01/app/oracle/product/11.2.0/db_1: N 5. Go to the $ ORACLE_HOME/dbs directory, for example, in my/u01/app/oracle/product/11.2.0/db_1/dbs, change all file names containing the original sid to the corresponding [oracle @ oradb ~] $ Cd/u01/app/oracle/product/11.2.0/db_1/dbs [oracle @ oradb dbs] $ lshc_orcal.dat init. ora lkORCAL orapworcal spfileorcal. ora [oracle @ oradb dbs] $ mv hc_orcal.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> startupORACLE instance started. database started successfully !!