Oracle 12c database creation on Amazon EC2 — Silent Installation

Before installing Oracle Database, your EC2 instance must have Oracle Software installed. Here is the link that guides you in the step-by-step installation of Oracle Software on Amazon EC2.

Let’s begin Oracle Database installation.

1. Let’s first copy our dbca.rsp file to our $HOME location and then open it in a vi editor for editing. The location of the response file is /Avani/database/response. Below are the changes we will do in our response file for our silent installation.

Note: Here I will only make basic mandatory changes that are required for the demo purpose.

gdbName=orcl

sid=orcl

templateName=General_Purpose.dbc

sysPassword=Demo$11

systemPassword=Demo$11

2. Now go to $ORACLE_HOME/bin and type the below command to initiate silent installation.

/Avani/dbhome_1/bin/dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp

3. Oracle Database Installation has been completed successfully.

4. Verify process status by issuing below command. Here we can see that orcl instance is up and running.

5. Check the instance entry in /etc/oratab.

6. Now, with an entry in our oratab file, we will set the environment variable by using oraenv command. To do that, we will run .oraenv which causes the oraenv script to be run.

7. Now, connect to SQL plus to connect the database and check its status.

8. Check listener status and start the listener.

9. You can issue the following command to let PMON register a server.

Now Oracle Database is installed, up and running! Start your DB activities!

If you find value in the knowledge shared, your applause on my post would be greatly appreciated!

Keep Learning!