Step by Step Installation of Oracle 10g in CentOS 5.6

Minimum Hardware Requirements.

OS:- CentOS 5.6
Memory:- 1 GB
Harddisk:- 20 GB


Installing rpm packages which are required for Oracle installation
Application:- Graphical Internet
Development:-Development Libraries, Development Tools, GNOME Software Development
Java Development, Legacy Software Development, X Software Development
From X Software Development----go to option and check on---libXp-devel and openmotif
Servers:-Server Configuration Tools,Web Server, Windows File Server
Base System:-Administration Tools,Base, Java,  Legacy Software Support, System Tools,X Window system
From Legacy Software Support---select compat
From System Tools--select sysstat
During the Installation: Disable the firewall and SELinux.


For ORACLE:

1.Verify that following packages are installed. 

binutils.i386
compat-gcc-7.3-2.96.128.i386
compat-gcc-c++-7.3-2.96.128.i386
compat-libstdc++-7.3-2.96.128.i386
compat-libstdc++-devel-7.3-2.96.128.i386
cpp.i386
gcc.i386
gcc-c++.i386
glibc.i386
glibc-common.i386
glibc-devel.i386
glibc-headers.i386
libstdc++.i386
libstdc++-devel.i386
libaio
libaio-devel.i386
libXp.i386
pdksh.i386
setarch.i386

sysstat.i386

rpm -q binutils compat-gcc-7.3-2.96.128 compat-gcc-c++-7.3-2.96.128 

compat-libstdc++-7.3-2.96.128 compat-libstdc++-devel-7.3-2.96.128 

cpp gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libstdc++ 

libstdc++-devel libaio libaio-devel libXp pdksh setarch sysstat 

installing the rpm:- libaio-devel-0.3.106-3.2.i386.rpm

2.Edit  /etc/hosts file
Add hostname and ip address eg. 192.168.11.30   oracletest.com.np

3. Edit /etc/sysctl.conf

kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.sem = 250 32000 100 128
net.ipv4.tcp_rmem = 4096 262144 524288
net.ipv4.tcp_wmem = 4096 262144 524288
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
net.ipv4.tcp_syn_retries = 2
net.ipv4.tcp_retries2 = 3
net.ipv4.tcp_keepalive_time = 30
net.ipv4.tcp_keepalive_intvl = 60
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.ip_local_port_range = 1024 65000

4. Run the following command to change the kernel parameters

/sbin/sysctl -p

5. Add the following security parameter in /etc/security/limits.con

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

6. Edit /etc/pam.d/login and add following line

session required pam_limits.so

7. SElinux and firewall should be turned off modify /etc/selinux/config 

SELINUX=disabled

8.Creating following users and Groups
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle
 

9.Create directory to house oracle and change ownership

#mkdir -p /u01/app/oracle/product/10.2.0/db_1
#chown -R oracle.oinstall /u01

10.edit /etc/redhat-release

OR

runinstaller ignoresysprereqs

11.Edit the /home/oracle/.bash_profile
add the following lines

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=testdb; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
fi
 

12.Log into the oracle user. Execute command xterm to verify DISPLAY environmental variable set properly else

 

Connect to Internet from Vmware Workstation ACE Edition (Ver. 6)

I have Red Hat Enterprise Linux 5  installed which is guest OS on a Vista host.

1) During new virtual machine, select NAT on Network type














2) In Redhat, type the command:  [root@localhost ~]# service network restart

Creating of  Oracle VM Virtual Box version 6.18

Click on machine---->New------> Type Name eg Window Server 2019-->choose the version  then click next

Memory Size [e.g. 2048]

Hard Disk: Create a hard Disk now...>Virtual box disk 

Installation of Bootable Windows

No bootable Medium found ! system halted

For ISO

solution: setting:bootable optical in 1st order

 

 

3) VMware® Workstation Pro 26H1 and Host Machine Windows 11 and virtual OS Redhat Enterprise Linux 8.10

Problem: Doesn't show IP address (127.0.0.1)

 

 

Solution: cmd-->services.msc-->

Ensure these are Running:

• VMware DHCP Service
• VMware NAT Service

If stopped → Right-click → Start, then reconnect the adapter in VM Settings 

In Linux 

#ifconfig

#systemctl restart NetworkManager 

 

 

4) SSH Connection between Mobaxterm Vmware

 

 

 

 

Package Managenent

yum is a software package manager that installs, updates, and removes packages on  RPM-based systems. It automatically computes dependencies and figures out what things should occur to install packages. yum makes it easier to maintain groups of machines without having to manually update each one using rpm.
Features include:

• Support for multiple repositories
• Simple configuration
• Dependency calculation
• Fast operation
• RPM-consistent behavior
• Package group support, including multiple-repository groups
• Simple interface

yum uses an online repository by default, but you can also configure it to use a local repository of packages.

Change the IP address on RedHat.

Temporary Address

1)Open Terminal
2) ifconfig -a  
to list all network interface card on the current PC.
3) Type ifconfig eth0 [IP ADDRESS] netmask 255.255.255.0 up 
to configure IP Address on interface eth0.
4)route add default gw [Gateway Address]
to configure gateway

Permanemt Address

1) Open Terminal
2)# vi/etc/sysconfig/network-scripts/ifcfg-eth0
3)Modify the file by press ‘i’ to enter insert mode. Change BOOTPROTO to static and add IP Address and Net mask
             BOOTPROTO=static
             IPADDR=192.168.1.20
             NETMASK=255.255.255.0
Save the configuration file by press ESC + ‘:’ and type ‘wq’ to write and quit the editor.
4) Restart the network interface card. Type
# service network restart
#chkconfig on
5)Review the configuration. Type
#ifconfig

Assigning Multiple IP Address to a same NIC

Upto 256 IP Addrress can be assigned to the same NIC

# cd /etc/sysconfig/network-scripts
# vi ifcfg-eth0:0
DEVICE:eth0:0
BOOTPROTO=static
IPADDR=192.168.1.1
NETMASK=255.255.255.0
ONBOOT=yes

#service network restart

# ifconfig

Assigning Range of IP Addresses to the same NIC

# vi /etc/sysconfig/network-scripts/ifcfg-eth0-range0

IPADDR_START=192.168.1.2

IPADDR_END=192.168.1.31
CLONENUM_START=2

#service network restart

#ifconfig
#chkconfig network on

LAMP on ubutnu 9.10 and above.

L------Linux Operation System.
A------Web Server.
M----- Relational Database Management System.
P------Object-Oriented Scripting Language.

# sudo apt-get install php5 mysql-server apache2
or
# sudo apt-get install lamp-server

Then in browser (check apache)
http://localhost

For Mysql
/var/www$ mysql -u root -P
passwd-----

mysql > exit

For PHP
$ sudo vi /var/www/info.php

add
<?php
phpinfo( );
?>
save and exit
Then restart apache.
# /etc/init.d/apache2 restart.

Then in browser
http://localhost or IP /info.php

To full manage the LAMP Server Database, install phpmyadmin
# sudo apt-get install phpmyadmin

To log in to phpmyadmin, open the browser and type

http://localhost/phpmyadmin or http://ip/phpmyadmin

System Restart

• # init 6
• shutdown -r now

System Shutdown

shutdown  [option] [ time ]

time----now--- immediately
+N------------after N minutes
HH:MM-------At the specified time

-h-----halt
-r-----reboot
-c----to cancel schedule shutdown

example: # shutdown -h now
              # shutdown +30
              # shutdown 08:00

# shutdown -c

•   # init 0
•   # shutdown -h now