Monday, 24 July 2017

Further adventures with Oracle database - ORA-01078 and LRM-00109

Having installed Oracle 12c ( 12.2.0.1.0 ) today, I was somewhat concerned when I tried to start my database: -

sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Jul 24 14:04:56 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>
startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/initorcl.ora'
SQL> quit
Disconnected

I checked the offending directory: -

ls $ORACLE_HOME/dbs

init.ora

which made me think …..

So I re-ran the dbca command to see what was going on.

Guess what ?

I didn't have a database; I'd obviously installed the product BUT not created a database.

Once I created one, all is well: -

ls $ORACLE_HOME/dbs

hc_orcl.dat  init.ora  lkORCL  orapworcl  spfileorcl.ora

sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Jul 24 14:53:27 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production


No comments:

Yay, VMware Fusion and macOS Big Sur - no longer "NAT good friends" - forgive the double negative and the terrible pun ...

After macOS 11 Big Sur was released in 2020, VMware updated their Fusion product to v12 and, sadly, managed to break Network Address Trans...