Oracle Database Creation (3.2)

Owned by Jenni Wallin
Jun 08, 2023
2 min read

The creation of the database must be made by the oracle UNIX user, or another UNIX user with the same privileges, on the machine where Oracle is installed. The oracle UNIX user is assumed in this installation.

Make sure that all previously defined directories, specified in the values.yaml file, exist and are writable for the oracle user, then follow these steps: 

  1. Make sure the environment variables for Oracle are set. For further information, see Oracle As A Platform DB Settings(3.2). 
     
  2. Make sure the Oracle data directories exist. These directories must be owned by the Oracle user. The directory should be the same as what is declared in oracle.data in the values.yaml file.

  3. Configure and start an Oracle listener for the database instance. The working directory for the listener is $ORACLE_HOME/network/admin

    Edit the listener.ora file to match what is set in values.yaml. See Oracle As A Platform DB Settings(3.2) for an example.

    When the listener has been configured, it needs to be restarted:

    $ lsnrctl stop
    $ lsnrctl start

  4. Create the Oracle database instance. The working directory is oracle.

    $ source ./oracle_create_instance.sh

    Depending on the hardware and the size of the database, this command may take up to one hour to execute. If no error occurred, the database creation will now be completed and the rest of this section can be ignored.

    Hint!

    When the instance creation script has been executed, there are three log files in the /tmp directory that can be used for troubleshooting. The mz.log file contains Oracle responses from the database creation, the mzuser.log file contains Oracle responses from the user creation and the mz_db.log file contains Oracle responses from the table creations.

       

  5. If the script fails: 

    Cleanup the system before the next try:
    • Start SQL*Plus:
      $ sqlplus "/ as sysdba"
    • Terminate the bad instance:
      SQL> shutdown abort
      SQL> quit
    • Remove any files created by Oracle in any of the previously defined directories for Oracle data.

If there is a need to change any installation parameter defined in the file values.yaml, the Platform installation must be done again to get updated Oracle Database Definition files.