How to install the oracle 12c software for testing purpose

 The contents are of my own testing and deployments. Not guaranteed that these might work in your environment. Please test before usage.


 Summary: In this session, I will teach you How to install 12c software and database in oracle database.

Step1:

Download the VMware workstation from google from the below link 

https://www.vmware.com/in/products/workstation-player/workstation-player-evaluation.html


Step2:

Once downloaded please open the software



Step3: 

Click next and check the hardware compatibility 



Step4:

Browse the iso image to that location.



Step5:Give the VM name your wish 




Step6:then select your process based on your laptop RAM



Step7:

increase the RAM size with 2GB based on Your RAM



Step8:

Select the using host-only network



Step9:

Select LSI logic is Recommended 




Step10:

Select SCSI DISk type



Step11:Create the new VM disk



Step12:

You can give the VMware disk capacity of 80GB

it's based on your harddisk size but it should be min 50gb above,



Step13:

Click on next 



Step14:Cliek finish and wait for the release!!




Step15:installation going ...



Step16:Select your language



Step17:Then go below the click on manual configuration 



Step18:

Change your domain



If all is done above you can transfer the DB software to the Linux machine


Now you can follow the below steps as root user.

1)add the below groups

groupadd -g 54321 install

groupadd -g 54322 dba

groupadd -g 54323 oper

groupadd -g 54324 backupdba

groupadd -g 54325 dgdba

groupadd -g 54326 kmdba

groupadd -g 54327 asmdba

groupadd -g 54328 asmoper

groupadd -g 54329 asmadmin

useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba oracle

passwd oracle



2)vim /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

172.20.10.10    oracle.localdomain      oracle.localdomain



3)Add the following line at the end of the fstab file:(using vim /etc/fstab)

none                    /dev/shm                tmpfs   size=4096M      0 0


4)Using any text editor, create or edit the vim /etc/sysctl.conf file, and add or edit lines 

similar to the following:


kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmall = 4294967296

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500


5).Run the following command to change the current kernel parameters:(using terminal)

/sbin/sysctl -p

6)Add following lines to set shell limits for user oracle in file vim /etc/security/limits.conf


# shell limits for users oracle 12gR1

oracle   soft   nofile   1024

oracle   hard   nofile   65536

oracle   soft   nproc    16384

oracle   hard   nproc    16384

oracle   soft   stack    10240

oracle   hard   stack    32768

oracle   hard   memlock  134217728

oracle   soft   memlock  134217728


7)cd /run/media/root/OL-7.2 Server.x86_64/Packages or /run/media/root/OL-7.6 Server.x86_64/Packages

rpm -ivh createrepo-0.9.9-23.el7.noarch.rpm
rpm -ivh vsftpd-3.0.2-10.el7.x86_64.rpm

8)[root@oracle Packages]# rpm -ivh createrepo-0.9.9-23.el7.noarch.rpm

warning: createrepo-0.9.9-23.el7.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Preparing...                          ################################# [100%]

        package createrepo-0.9.9-23.el7.noarch is already installed

[root@oracle Packages]# rpm -ivh vsftpd-3.0.2-10.el7.x86_64.rpm

warning: vsftpd-3.0.2-10.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Preparing...                          ################################# [100%]

        package vsftpd-3.0.2-10.el7.x86_64 is already installed

[root@oracle Packages]#


9) cp -r /run/media/ramesh/OL-7.2 Server.x86_64/Packages/ /var/ftp/pub/


10)

cd /var/ftp/pub/

createrepo -v Packages

cd


11)Create Yum repository:
Create and Add the following lines to the /etc/yum.repos.d/server.repo file:(using vim /etc/yum.repos.d/server.repo)

[server]
name=oracle12c
baseurl=file:///var/ftp/pub/Packages
gpgcheck=0
enabled

After insert the lines save the file using press ESC and type :wq then press enter.

12)
And to remove file
cd /etc/yum.repos.d
rm -rvf public*


13)
yum clean all
yum list all

14)Install the packages:(using terminal)


yum install binutils* -y

yum install compat* -y

yum install elfutils* -y

yum install gcc* -y

yum install glibc* -y

yum install ksh* -y

yum install libaio* -y

yum install libgcc* -y

yum install libstdc++* -y

yum install make* -y

yum install sysstat* -y

yum install unix* -y


15) For the initial setup of the ASM Disks, execute these commands:(using terminal) 
# Create the directory in which the flat files will reside

mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01
chmod -R 775 /u01


16) For the initial setup of the ASM Disks, execute these commands:(using terminal) 
# Create the directory in which the flat files will reside

mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01
chmod -R 775 /u01

17)Change the setting of SELinux to permissive by editing the "vim /etc/selinux/config" file, making sure the SELINUX flag is set as follows.

SELINUX=permissive

18)If you have the Linux firewall enabled, you will need to disable or configure it, as shown here or here. The following is an example of disabling the firewall.

systemctl stop firewalld
systemctl disable firewalls

If you are done with all the above steps Please login the server and unzip those files (root user)


[root@oracle ~]# cd /u01/

[root@oracle u01]#

[root@oracle u01]#

[root@oracle u01]# ls -lrth

total 2.6G

-rwxrwxr-x. 1 oracle oinstall 968M Nov  9  2021 V46095-01_2of2.zip

-rwxrwxr-x. 1 oracle oinstall 1.6G Nov  9  2021 V46095-01_1of2.zip

drwxrwxr-x. 3 oracle oinstall   19 Mar 22 19:52 app

[root@oracle u01]#


 run the ./runinstaller as an oracle user:

Step1:select the first option to install the software





Step2:select the desktop option only



step3:Provide the all the details below 



step4:Press next



step5



Step6

Run both scripts as root user and finish the installation

Step7:

Finally, click and finish all the steps then log in to the server  and invoke the dbca software

Step8:Please select the create database 



Step9:once select SID and password Please click next





Step10:Once all is done please click close.

Step11:

Now click on finish the setup and login to the server !!



                                        Thanks for your time guys all the best!!









0 Comments

DELETE Statement in ORACLE DB— Step by Step Internal Flow with classroom example.

Imagine your Oracle database like a school, and you’re Teacher decides to remove a student (row) from the classroom(table). Let’s see how the journey works step by step: 1)Classroom = Oracle Table 2)Students = Rows (Records) 3)Class Teacher = Oracle Server Process 4)Attendance Register = Data Dictionary User fires DELETE statement: DELETE FROM students WHERE grade = 'D'; Internal Processing Steps: Client Process Sends DELETE Statement to Server Process The teacher receives a request to remove a student from the classroom. Syntax Check (Parsing) The teacher checks if the request is grammatically correct — proper command, keywords, and a semicolon. Semantic Check Teacher verifies if the classroom exists and whether the condition (like grade = 'D') makes sense. Object Resolution Teacher confirms that the ‘students’ classroom (table) exists in the school records (data dictionary). Optimization Decides the fastest way to find those students — by roll number, grade, or al...