Following is the how to for installing Oracle Database 12C on Ubuntu 13.10
Note : I’m not running this installation on a production environment as Ubuntu 13.10 is not supported by Oracle. I needed to have a local database to play with on my local laptop.
If you want to install Oracle 11G R2 then check this How to Install Oracle 11G R2 Enterprise Edition Database Ubuntu 12.10 / 12.04
Step 1 : Hosts File
The “/etc/hosts” file must contain a fully qualified name for the server.
Sample file is as follows
Step 2 : Oracle Installation Prerequisites
Run following commands to install dependencies
Restart machine
Again check if there is any update
Run following to install dependencies
Step 3 : Create user and groups
The following steps must be performed to set the password for the “oracle” user.
Step 4 : Symbolic link, Kernel parameters and shell configuration as per the Oracle 12c Documentation
Make ourself as Red Hat by running following command
We need to create some soft links to start the installation. To do so run the following commands,
To change the shell configuration for oracle user run following commands
Run following command to change the kernel parameters
Note: kernel.shmmax = max possible value, e.g. size of physical memory in bytes. In my case machine is having 2GB so we are specifying 1GB. Adjust the parameter as per your configuration
Load new kernel parameters, by running following,
We need to do changes in start-up script, run following commands as root
Step 5 : Download Oracle 12C database for Linux
Download Oracle 12C database from Oracle Download Center for Linux.
I have downloaded both the zip in /u01/binaries.
Login as an oracle user
We need to extract both the zip to start the installation. To unzip run,
You will see database folder after extracting the binaries
Step 6 : Installation of Oracle 12C database for Linux
Before doing the installation we need to give proper permission to the extracted file, to do the same run following command
Start installation using following command
Next we go though the installation, I have skipped Oracle Support Password provision as I don’t want to receive updates.
As the Ubuntu is not supported OS we need to we are seeing the below error, just click on Yes button to go ahead.
In Selection Installation Option choose Create and configure a database and click on Next to go further
In System Class screen select Server Class and click on Next to go further
In Grid Installation Option screen select Single instance database installation and click on Next to go further
In Select Install Type screen select Advanced install and click on Next to go further
In Select Product Language screen select appropriate language and and click on Next to go further
In Select Database Edition screen I am selecting Enterprise Edition due to space issue. Click Next to go further.
In Specify Installation Location screen, I kept it as default and click Next to go further
In Create Inventory screen, I kept it as default and click Next to go further
In Select Configuration Type screen, select General Purpose / Transaction Processing and click Next to proceed further.
In Specify Database Identifiers screen, let it be default and click Next to go further. Here we need to remember the Oracle system identifier (SID)
In Specify Configuration Options configure as below:
Under Memory select Enable Automatic Memory Management: TRUE
Under Character sets select Use Unicode (AL32UTF8)
Leave default settings under Specify Database Storage Options and click Next to go further.
Leave default settings under Specify Management Options and click Next to go further.
Leave default settings under Specify Recovery Options and click Next to go further.
In Specify Schema Passwords screen I choose Use the same password for all accounts because of laziness. Click Next to go further.
Skip the warning by clicking Yes
Leave the default option under Privileged Operating System group and click Next to go further.
Save the summary for future use and click Next to go further.
Oops we got links proc gen_pcscfg procob error
In installation error logs you will see following error.
For the same you need do following
Create a backup copy of /u01/app/oracle/product/12.1.0/dbhome_1/lib/stubs
Delete folder
Create a backup copy of /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/env_rdbms.mk
Open /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/env_rdbms.mk file in vi. Search for RMAN_LINKLINE. You will see following lines.
Now change it to as follows
And click on retry button.
Further you wee see error for all_no_orcl
In the logs for above error I have observed following line
So I checked the ldd output of /u01/app/oracle/product/12.1.0/dbhome_1/lib//libnnz12.so file.
Run following command to rectify this
Now see the linking again
Further do following
Take a backup of /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/ins_rdbms.mk
cp -rip /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/ins_rdbms.mk /u01/app/oracle/product/12.1.0/dbhome_1<span style="color: #0