ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘…

Geeks, please accept the hero post of 2021 Microsoft x Intel hacking contest>>>

After I installed oracle19c in Linux, when I started the database, the xshell command line window reported this error. After looking at several solutions, I summarized as follows

Literally, there is no initsanshi.ora file in the DBS directory, which is composed of init & lt; sid>. Ora, Sanshi is my sid

Enter the command to view Sid in xshell

echo $ORACLE_SID

The SID that can see me is Sanshi

Then go to $oracle_ Under the home/admin/ignite/pfile directory

cd $ORACLE_HOME/admin/ignite/pfile

If you can’t find the file, go to this directory

cd $ORACLE_BASE/admin

In short, find the location of the admin file, and then enter the pfile directory

At this point, we find the init.ora.6302019164552 file, copy it to the DBS directory, and change the name of the file

cp init.ora.6302019164552  /u01/app/oracle/product/19.2.0/db_1/dbs/initsanshi.ora 
SQL> startup

Note that the copy to location is the location of your own Linux DBS. There may be some differences between my location and your own Sid

Similar Posts: