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:
- [Solved] Linux Start database Error: could not open parameter file init**.ora
- [Solved] Oracle Error: SGA_MAX_SIZE cannot be set to more than MEMORY_TARGET
- How to Solve Error: ORA-27101: shared memory realm does not exist
- How to Solve Ora-01109 Error: database not open
- [Solved] The instance cannot be started due to the attribute change of the oracle file under the grid user
- Oracle: db_12.2.0.1.0_Linux-x86-64: dbca Customized mode:ORA-07202: sltln: invalid parameter to sltln.
- [Solved] Linux Oracle bash: “sqlplus / as sysdba”: command not found
- Monitoring ora XXX error message in Oracle alert file in Linux concurrent mail Perl script
- SDK location not found. Define location with sdk.dir in the local.properties file or with an AND…
- Linux Install Tomcat Error: service tomcat does not support chkconfig