Search code examples
oracle-databaseoracle12cdatabase-administration

Oracle missing initSID.ora


I learning to use Oracle database, and I just installed Oracle Database 12c Release 2 on my Ubuntu 18.04.

I login as sysdba with this following command:

sqlplus / as sysdba

So far all thing working and I got this message:

Connected to an idle instance.

Now, I want to start my server with this following command:

SQL> STARTUP

But, the thing that make me confuse are I got this error message:

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12/dbhome_1/dbs/initSID.ora'

I checking it out on that directory, and the initSID.ora was missing.

So, where I can find the missing file..?, how to fix it..?


Solution

  • Finally I figure out this by following @Tejash----ORA-00980 instructions to create a database.