Silent Installation and Configuration Oracle RDBMS

In this article, We will see the step by step Silent Installation and Configuration Oracle RDBMS (INSTALL_DB_SWONLY) for standalone server.

As we all know we have GUI tool for the installation and configuration of Oracle RDBMS, with the tool we can easily perform our steps, but what will happen if we don’t have GUI option, In that case you need to go for the silent installation.

I am assuming that you have already installed the Linux machine in Virtual Box, if you don’t have then please Click Here to see the full installation of the machine.

Before start our activity I would like to say that I have done the prerequisites part in my previous article Silent Installation and Configuration GRID Infrastructure (HA_CONFIG), If you missed that article please Click Here.

I will start with unzip the RDBMS file which we have copied.

So, Now lets start the Silent Installation and Configuration Oracle RDBMS (INSTALL_DB_SWONLY)

Unzip the Oracle RDBMS file:

Login from Oracle user and unzip both the below files.

[oracle@test u03]$ ll
total 2487228
drwxr-xr-x 3 oracle oinstall 4096 Oct 19 15:51 app
drwxrwxrwx 2 oracle oinstall 16384 Oct 19 15:34 lost+found
-rwxr-x— 1 oracle oinstall 1395582860 Oct 19 16:09 p13390677_112040_Linux-x86-64_1of7.zip
-rwxr-x— 1 oracle oinstall 1151304589 Oct 19 16:10 p13390677_112040_Linux-x86-64_2of7.zip

[oracle@test u03]$ unzip p13390677_112040_Linux-x86-64_1of7.zip
extracting: database/install/addLangs.sh
inflating: database/install/addNode.sh
inflating: database/install/unzip
inflating: database/install/runInstaller.sh
creating: database/install/images/
inflating: database/install/images/billboards.gif
inflating: database/install/attachHome.sh
inflating: database/install/.oui
creating: database/install/resource/
inflating: database/install/resource/cons_ja.nls
inflating: database/install/resource/cons_de.nls
inflating: database/install/resource/cons_ko.nls
inflating: database/install/resource/cons.nls
inflating: database/install/resource/cons_pt_BR.nls
inflating: database/install/resource/cons_fr.nls
inflating: database/install/resource/cons_es.nls
inflating: database/install/resource/cons_zh_CN.nls
inflating: database/install/resource/cons_it.nls
inflating: database/install/resource/cons_zh_TW.nls

[oracle@test u03]$ unzip p13390677_112040_Linux-x86-64_2of7.zip
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup25.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup17.23.1.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup17.2.1.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup50.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup7.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup17.17.1.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup9.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup32.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup35.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup49.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup47.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup40.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup17.20.1.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup56.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup24.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup17.16.1.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup23.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup16.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup11.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup17.21.1.jar
inflating: database/stage/Components/oracle.rdbms/11.2.0.4.0/1/DataFiles/filegroup18.jar

After Unzipping of the file a new folder will get created called database.

[oracle@test u03]$ ls -lrt
total 2487232
drwxr-xr-x 7 oracle oinstall 4096 Aug 27 2013 database
drwxrwxrwx 2 oracle oinstall 16384 Oct 19 15:34 lost+found
drwxr-xr-x 3 oracle oinstall 4096 Oct 19 15:51 app
-rwxr-x— 1 oracle oinstall 1395582860 Oct 19 16:09 p13390677_112040_Linux-x86-64_1of7.zip
-rwxr-x— 1 oracle oinstall 1151304589 Oct 19 16:10 p13390677_112040_Linux-x86-64_2of7.zip

Edit the db_install.rsp to start the silent Installation:

To get this db_install.rsp you need to go to the below folders.

database—->response—->db_install.rsp

Now you get the response file, next step is to copy the content of this file to other file and then edit file as per your requirement.

Note:- Please don’t modify or edit original file.

[oracle@test response]$ cp db_install.rsp /tmp/rdbms_install.rsp

I have copied the content in the new file which is located under /tmp directory.

Below are some parameters that you must specify before start the installation as per your requirement.

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=test
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=u01/oracle/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u03/app/oracle/product/11.2.0/db_1
ORACLE_BASE=/u03/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true

Execution of the silent Installation and Configuration Oracle RDBMS command:

[oracle@test database]$ ./runInstaller -silent -responseFile /tmp/rdbms_install.rsp -showProgress
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 120 MB. Actual 3741 MB Passed
Checking swap space: must be greater than 150 MB. Actual 6498 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-10-20_10-39-31PM. Please wait …[oracle@test database]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2019-10-20_10-39-31PM.log

Prepare in progress.
………………………………………….. 9% Done.

Prepare successful.

Copy files in progress.
………………………………………….. 14% Done.
………………………………………….. 20% Done.
………………………………………….. 26% Done.
………………………………………….. 31% Done.
………………………………………….. 36% Done.
………………………………………….. 41% Done.
………………………………………….. 46% Done.
………………………………………….. 51% Done.
………………………………………….. 56% Done.
………………………………………….. 63% Done.
………………………………………….. 68% Done.
………………………………………….. 73% Done.
………………………………………….. 78% Done.
………………………………………….. 83% Done.
…………………………
Copy files successful.

Link binaries in progress.
……….
Link binaries successful.

Setup files in progress.
………………………………………….. 88% Done.
………………………………………….. 94% Done.

Setup files successful.
The installation of Oracle Database 11g was successful.
Please check ‘/u01/app/oraInventory/logs/silentInstall2019-10-20_10-39-31PM.log’ for more details.

Execute Root Scripts in progress.

As a root user, execute the following script(s):
1. /u03/app/oracle/product/11.2.0/db_1/root.sh

………………………………………….. 100% Done.

Execute Root Scripts successful.
Successfully Setup Software.

Execution of root.sh command from root user:

[root@test ~]# /u03/app/oracle/product/11.2.0/db_1/root.sh
Check /u03/app/oracle/product/11.2.0/db_1/install/root_test_2019-10-20_22-50-54.log for the output of root script

[root@test ~]# cat /u03/app/oracle/product/11.2.0/db_1/install/root_test_2019-10-20_22-50-54.log
Performing root user operation for Oracle 11g

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u03/app/oracle/product/11.2.0/db_1
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Finished product-specific root actions.

So, Now we have completed successfully our Silent Installation and Configuration Oracle RDBMS (INSTALL_DB_SWONLY).

Database Creation through DBCA (Silent Method):

[oracle@test bin]$ ./dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName testdb -sid testdb -sysPassword sys -systemPassword sys -emConfiguration NONE -datafileDestination /u03/app/oracle/oradata -storageType FS -characterSet AL32UTF8
Copying database files
1% complete
3% complete
10% complete
17% complete
24% complete
35% complete
Creating and starting Oracle instance
37% complete
42% complete
47% complete
52% complete
53% complete
56% complete
58% complete
Registering database with Oracle Restart
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
96% complete
100% complete
Look at the log file “/u03/app/oracle/cfgtoollogs/dbca/testdb/testdb.log” for further details.

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
TESTDB READ WRITE PRIMARY

[oracle@test bin]$ ps -ef | grep pmon
oracle 5095 1 0 23:33 ? 00:00:00 ora_pmon_testdb
oracle 5277 29810 0 23:36 pts/2 00:00:00 grep pmon
grid 27488 1 0 20:40 ? 00:00:01 asm_pmon_+ASM

Now, we have successfully completed our database creation through DBCA with Silent method.

Hope this blog will help you!!

If this article is useful for you please comment, share with your friends.

In case of any issues please send your query in below comment section.

For more articles please do visit below links: –

Oracle Physical Standby Dataguard in 11g | Karan Rajpoot

Oracle SQL Developer Installation in Linux | Karan Rajpoot

ORA-01119: error in creating datafile | Karan Rajpoot

Oracle 12c Grid binary installation | Karan Rajpoot

If you want to download Oracle virtual box or VMware Workstation Player, Please click on below links:-

Oracle Virtual Box

VMware Workstation Player

Karan

Hi, Myself Karan Rajpoot, I am an Oracle DBA and Professional Blogger. I have created this blog to share all the useful content related to the Technology world.

Leave a Reply

Close Menu