Description:-
In this article we are going to see step by step installing oracle software and creating Repository Database Using Template
Note:- Click the below link to complete OEM Cloud Control 13c Installation
Step:-1 Click Here Oracle Cloud-Build VM Machine For Enterprise Manager Cloud Control 13c
Step:-2 Click Here Oracle Cloud-Creating Repository Database Using Template
Step:-3 Click Here Oracle Cloud-OEM Cloud Control 13c Installation
High Level Steps:-
- Install Vncserver for installing oracle binaries and OEM software
- Installing oracle 12c binaries
- Move DB template to /tmp folder and unzip
- Start creating Repository Database Using Template
- Check the status of OMS database
Let’s start Demo:-
Step:1 install vncsever local and VM instance
Click here: – install vncserver in oracle VM instance
Step:2 unzip oracle 12.1 software start install
[oracle@dbwroem u01]$ ls -lrt
total 12489808
drwxr-xr-x. 7 oracle oinstall 4096 Jul 7 2014 database
Step:3 Start installation
[oracle@dbwroem ~]$ . .bash_profile
[oracle@dbwroem ~]$ cd /u01/database/
[oracle@dbwroem database]$ ./runInstaller
Step:-4 Select install database software only
Step:-5 select single instance database installation
Step:-6 Leave as it is
Step:-7 Select Enterprise Edition
Step:-8 Double check the installation folder
Step:-9 Leave as it is
Step:-10 Leave as it is
Step:-11 ignore swap size
Step:-12 Start install
Step:-13 installation in progress
Step:-14 Execute the below scripts as Root User
[root@dbwroem u01]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@dbwroem u01]# /u01/app/oracle/product/12.1.0.2/db_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.1.0.2/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …
Creating /etc/oratab file…
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.
Oracle software installation completed successfully
Creating Repository Database Using Template
Step:-1 Copy the db template to /tmp folder
[oracle@dbwroem ~]$ cd /u01
[oracle@dbwroem u01]$ mv 12c_DB_template.zip /tmp
Step:-2 Unzip template
[oracle@dbwroem u01]$ cd $ORACLE_HOME/assistants/dbca/templates
[oracle@dbwroem templates]$ unzip /tmp/12c_DB_template.zip
Archive: /tmp/12c_DB_template.zip
inflating: shpool_12.1.0.2.0_Database_SQL_for_EM13_3_0_0_0.sql
inflating: 12.1.0.2.0_Database_Template_for_EM13_3_0_0_0_Large_deployment.dbc
inflating: 12.1.0.2.0_Database_Template_for_EM13_3_0_0_0_Medium_deployment.dbc
inflating: 12.1.0.2.0_Database_Template_for_EM13_3_0_0_0_Small_deployment.dbc
inflating: 12.1.0.2.0_Database_Template_for_EM13_3_0_0_0.dfb
inflating: 12.1.0.2.0_Database_Template_for_EM13_3_0_0_0.ctl
inflating: set_repo_param_12_1_0_2_0_Database_SQL_for_EM13_3_0_0_0_Large_deployment.sql
inflating: set_repo_param_12_1_0_2_0_Database_SQL_for_EM13_3_0_0_0_Medium_deployment.sql
inflating: set_repo_param_12_1_0_2_0_Database_SQL_for_EM13_3_0_0_0_Small_deployment.sql
Step:-3 Select the “Create Database” option and click the “Next” button.
Step:-4 Select the “Advanced Mode” option and click the “Next” button.
Step:-5 Select appropriate template for your EM installation Small (my choice), Medium or Large then click “Next” button.
Step:-6 Enter the Global Database Name and SID, then click the “Next” button.
Step:-7 Both options “Configure Enterprise Manager (EM) Database Express” and “Register with Enterprise Manager (EM) Cloud Control” must be unchecked. Click “Next” button.
Step:-8 Enter the SYS and system password.Click the “Next” button.
Step:-9 Enter the listener details and click the the “Next” button.
Step:-10 Specify the location where to install new database. Then click “Next” button.
Step:-11 Leave as it is
Step:-12 If we you need to change the memory settings and character sets.But I am accepting the memory defaults and character as “AL32UTF8” option.
Step:-13 Click the “Next” button
Step:-14 Click the “Finish” button to create the database.
Step:-15 Database creation in progress
Database creation is completed.
Step:-16 Login into putty session check status of database
[oracle@dbwroem ~]$ . .bash_profile
[oracle@dbwroem ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 18 11:56:13 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select host_name,instance_name from v$instance;
HOST_NAME INSTANCE_NAME
—————- ————————-
dbwroem dbwroem
Successfully completed creating Repository Database Using Template
Connect with me:–
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/hariprasathdba