Get the App
SLTechnology News&Howtos  ›  Database  › 

Install oracle12c and start the error report ORA-01078: failure in processing system parameters

Shulou Source: shulou.com Published: 2022-06-01 05:26:59 10月02日 Update

SQL > startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file'/ u01qapplash oracle.product12.2.0anddbhomeowners 1anddbsandinitdb12c.ora'

Because in the parameter file, export ORACLE_SID=db12c

But when dbca built the database, the database was named kobe, so the parameter file could not be found.

Method: change to kobe

Export ORACLE_SID=kobe

Take effect again

Recommendation: ORACLE_SID should be the same as the database created

Tags: Parameters data databases files names suggestions methods are in the Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei Microsoft Shulou Tech Info Shulou Technology Redmi