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