This is a step by step guide for creating a new Oracle 11gr2 server using Oracle Enterprise Linux 6.4 in an attended install. This guide includes joining the server to an established windows active directory domain.
Step 1.
Download the install software from the oracle cloud delivery system.
http://edelivery.oracle.com/linux
Step 2.
Start up the server with the DVD in place. I always run the provided media test since I don’t like surprises.
Step 3.
Work your way through the screens using the appropriate language and keyboard choices, accepting the default values. This guide assumes basic storage, and addressing all the possible storage scenarios is outside of the scope of this guide.
Step 4.
- Enter a fully qualified host name. If you do not have an established domain to join, use [machine].localdomain
- Click Configure Network
- Select the network connection you will be using for this server, and chose “Edit”
- If you are not using DHCP, click on the IPv4 Settings tab and change the Method Drop down to ‘Manual’, then click ‘Add’ to provide the relevant information. Once complete, click apply, then close.
Step 5.
Select the appropriate Time zone
Step 6.
Select ‘Use All Space’, and then check ‘Review and modify partitioning layout’
- Follow these guidelines for setting your swap size:
| RAM | Swap Space |
|---|---|
| Between 1 GB and 2 GB | 1.5 times the size of the RAM |
| Between 2 GB and 16 GB | Equal to the size of the RAM |
| More than 16 GB | 16 GB |
- Write Changes to disk
Step 7.
Confirm your selections for partitions. If in doubt, go with ext4 file system. Keep in mind that if you are planning to use ASM, you need to leave those devices as raw volumes.
Step 8.
Chose Basic Server, and select the Customize Now option
Step 9.
For a gnome desktop, select the following options:
- Desktops
- Desktop
- Desktop Platform
- Fonts
- General Purpose Desktop
- Graphical Administration Tools
- X Windows System
Click Next
Step 10.
After the machine reboots, chose to connect later for updates and ULN registration.
Step 11.
Create non-admin user.
Step 12.
Log in with Non-admin user.
Step 13.
Disable SELinux and firewall
- su to root
-
vi /etc/selinux/config
- Set SELINUX = disabled
-
service ipchains stop
-
service iptables stop
-
chkconfig ipchains off
-
chkconfig iptables off
- reboot server
Step 14.
Install VNC Server
yum install tigervnc*
Edit vncservers file:
# vi /etc/sysconfig/vncservers
Uncomment the two lines below and edit it with your own username:
VNCSERVERS=”2:myusername”VNCSERVERARGS[2]=”-geometry 800×600 -nolisten tcp -nohttpd -localhost”
Set the password for vncserver user:
# vncpasswd Password: myvncpassword Verify: myvncpassword
Start the VNCServer:
# service vncserver start
Step 15.
Set up authentication to join windows domain using winbind. The GUI tool will catch most of this, but sometimes you’ll need to double check the config files if you fail to join the domain.
net ads join –U username
in /etc/krb5.conf:
default_realm = EXAMPLE.COM
dns_lookup_realm = true
dns_lookup_kdc = true
ticket_lifetime = 24h
renew_lifetime = 7d
forwardable = yes
[realms]
EXAMPLE.COM = {
default_domain = example.com
}
[domain_realm]
.example.com = EXAMPLE.COM
example.com = EXAMPLE.COM
in /etc/samba/smb.conf:
workgroup = example
realm = EXAMPLE.COM
security = ads
idmap uid = 10000-500000
idmap gid = 10000-500000
template shell = /bin/bash
winbind use default domain = true
winbind offline logon = false
winbind nested groups = yes
encrypt passwords = yes
Test your ad connection. As root:
chkconfig winbind on --starts winbind on reboot service winbind start wbinfo -g --polls the DC for domain groups
Step 16.
Set up NTFS drivers:
- determine kernel:
uname -m
- go get the proper repositores and install
Oracle Enterprise Linux 4.x x86:
# wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el4.rf.i386.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el4.rf.i386.rpmOracle Enterprise Linux 4.x x86_64:
# wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el4.rf.x86_64.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el4.rf.x86_64.rpmOracle Enterprise Linux / Oracle Linux 5.x x86:
# wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el5.rf.i386.rpmOracle Enterprise Linux / Oracle Linux 5.x x86_64:
# wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el5.rf.x86_64.rpmOracle Linux 6.x x86:
# wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.i686.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.i686.rpmOracle Linux 6.x x86_64:
# wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
Install the NTFS driver:Oracle Enterprise Linux 4.x:
# yum install dkms dkms-fuse fuse fuse-ntfs-3g Oracle Enterprise Linux / Oracle Linux 5.0 – 5.2:
# yum install dkms dkms-fuse fuse fuse-ntfs-3g Oracle Enterprise Linux / Oracle Linux 5.3:
NTFS support under Oracle Enterprise Linux 5.3 is broken and you should consider to upgrade to the 5.4 or later. (https://bugzilla.redhat.com/show_bug.cgi?id=481495)
Oracle Enterprise Linux / Oracle Linux 5.4 – 5.x:
As of Oracle Enterprise Linux 5.4 the the kernel fuse module (dkms, dkms-fuse) is included in the kernel and should not be installed.
# yum install fuse fuse-ntfs-3g Oracle Enterprise Linux / Oracle Linux 6.x:
# yum install fuse fuse-ntfs-3g
From this point on, you will be able to attach to network shares, mount usb drives with the ntfs file system, and use your AD user groups for administration. Our next steps are to create the local users and groups needed for DBA work.
Step 1.
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol6.repo
# yum install oracle-rdbms-server-11gR2-preinstall
# yum update
Step 2.
create dba user groups:
groupadd -g 501 oinstall groupadd -g 502 dba groupadd -g 503 oper groupadd -g 504 asmadmin groupadd -g 506 asmdba groupadd -g 505 asmoper
Step 3.
Change password for user oracle
Step 4.
reboot the server
Step 5.
Login with user oracle. Set up /home/oracle/.bash_profile with oracle specific settings:
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=pit-qa11gr2-2.confluence.com; export ORACLE_HOSTNAME
#ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME –set if you always have the same starting db
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
#ORACLE_SID=DB11G; export ORACLE_SID –Set if you have the same starting db every time
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
Step 6.
Log out, and log back in with oracle to ensure your .bash_profile is working
Your server is now ready for database instillation.