This is an Easy and Step-by-Step Guide to Install and Getting-Started on the Oracle 11g R2 Database for Mageia Linux 1, 2, 3, 4, 5 and Chauldron i686/x86_64 Desktop.
Relax and Take the Time to Reading, Understanding and Executing Carefully the Instructions Contained here.
To the Post Bottom you Find Links to Oracle 11g Database Troubleshooting Guides.
- Download the Database Release
Oracle 11g R2
- Open a Terminal Window
- Login as SuperUser:
su
- Make Network Configuration
Check you hostname and IP is on /etc/hosts
Get your hostname:
hostname
Get your IP:
You will Find your Ip under the Output "lo" Section.
/sbin/ifconfig
Check if Hostname and IP are already inserted into the Enabled Hosts File.
cat /etc/hosts
If It's Not Present then Insert it!
nano /etc/hosts
Insert: <IP HOSTNAME.DOMAINNAME HOSTNAME>
Example: '127.0.0.1 localhost.localdomain localhost'
Ctrl+x to Save and Exit from nano Editor :)
Add you Host IP to the List of Hosts Granted of Connection with the X Server
xhost +<yourIP>
Example: #xhost +127.0.0.1
- Install dependencies
urpmi libstdc++-devel binutils glibc glibc-devel libelf libelfutils-devel /
errelfutils pdksh gcc gcc-c++ libaio-devel libaio1 libgcc1 sysstat /
unixODBC libunixODBC-devel nano
- Add Groups and User
groupadd -g 502 oinstall
groupadd -g 503 dba
groupadd -g 504 oper
groupadd -g 505 asmadmin
useradd -u 502 -g oinstall -G dba,asmadmin,oper -s /bin/bash -m oracle
passwd oracle
- Create the directories where Oracle will be installed and give right ownership and permission
mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
- Set Kernel's Parameters
nano /etc/sysctl.conf
Add or amend the following lines in the /etc/sysctl.conf file.
#### Oracle 11g Kernel Parameters ####
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
Comment out these lines below than give an error
#net.bridge.bridge-nf-call-ip6tables = 0
#net.bridge.bridge-nf-call-iptables = 0
#net.bridge.bridge-nf-call-arptables = 0
nano /etc/security/limits.conf
Add the following lines to the /etc/security/limits.conf file.
#### oracle User Settings 4 Oracle 11g ####
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
mkdir /etc/selinux
nano /etc/selinux/config
Disable Secure Linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows.
SELINUX=disabled
Run the following command to Load the New Kernel Parameters.
/sbin/sysctl -p
- Unzip the Oracle 11g Database, Set oracle as Owner and Move it into the oracle's Home
cd </path/To/linux_11gR2*.zip>
unzip linux_11gR2_database_1of2.zip
unzip linux_11gR2_database_2of2.zip
chown -R oracle:oinstall database
mv database /home/oracle
- Add Paths to Oracle's .bashrc
Login as Oracle
su oracle
Edit .bashrc file nano /home/oracle/.bashrc
Insert:
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=<HOSTNAME>; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=<DBSID>; export ORACLE_SID
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
Substitute HOSTNAME and DBSID with the Values you Will Use During Software Installation
In this Example Respectively:
- HOSTNAME = 127.0.0.1
- DBSID = SID
Load New .bashrc Settings
source ~/.bashrc
Last and Optional to Add Full Env-Integration edit also oracle's .bash_profile
nano ~/.bash_profile
Inserting
if [ -f ~/.bashrc ]; then
source ~/.bashrc
fi
- Install the Oracle 11g Software
cd /home/oracle/database
./runInstaller
If you Get: "Check if the DISPLAY variable is set. Failed". Look Link Below.
Link2+ Oracle 11g Database Troubleshooting
On the first screen If you Do Not Dispose of an Oracle Subscription Just Leave Blank eMail and Un-Check the Demand of Security Update Support then Click on Next
Then Confirm on Warning and Follow.
On "Select Installation Option" Select "Install database software only" and Click on Next
On Step 3 Leave Default "Single instance database installation" and Click on Next
On Step 4 Select your Language and Click on Next
On Step 5 Leave Default Enterprise Edition and Click on Next
On "Installation Location" Set All As Here Below and Click on Next
- Oracle Base: /u01/app/oracle
- Software Location: /u01/app/oracle/product/11.2.0/dbhome_1
These are the Same Settings Inserted into the .bashrc File...
On "Create Inventory" if you Setup the Path on .bashrc Like Here Leave Default and Click on Next
On "Operating System Groups" if you Setup the Path on .bashrc Like Here Leave Default and Click on Next
On "Prerequisite Checks" you will Get Easily a "Warning Message" about some Missing Requirements
Just Check: "Ignore All" and Follow Up with Installation...
On the "Summary" Click on "Save Response File" to Take Note of Settings and then Click on Finish
The Installation Product Procedure should Start...
-
Solve Error in invoking target install of makefile ctx/lib/ins_ctx.mk
Right Before the End of Process a Pop-Up Window will Show the Path to Two Configuration Scripts you Need to Execute on Terminal!
Last Oracle Should Confirm you of a Successful Installation End.) 
-
Create and Run a Listener for Oracle 11g
-
Create a Database for Oracle 11g
After you Should Access the
"Enterprise Manager" on Browser by the URL shown on the Last Screen.
On a Localhost for Example you Should Access the Enterprise Manager by the Address:
https://127.0.0.1:1158/em
And you can
Login with:
User Name:
SYS
Password:
oracleDatabasePassword
From the Drop-down below
Select >>
Connect as SYSDBA
You Should be Able to Access the Database by the Enterprise Manager!
How-to Start and Stop All the Oracle 11g Database Components
- Start the Oracle Listener, Database and Manager
- Login as Oracle User
su oracle
- Start the Listner:
lsnrctl start
- Start the Database process:
sqlplus '/ as sysdba'
Insert YourOracleAccountPassword
>startup
Wait until the database is Up!
ORACLE instance started.
...
Database opened.
Exit from sqlplus
>exit
- Start Database Manager Console
emctl start dbconsole
- Access the Oracle Database Manager on Browser
https://127.0.0.1:1158/em
- Stop the Oracle Database
- Stop the Database process:
sqlplus '/ as sysdba'
>shutdown immediate
>exit
- Stop the Listner:
lsnrctl stop
If you have
Multiple Oracle Databases Before to Start a New one you have to Set the Database
SID:
export ORACLE_SID=<dbSID>
Oracle 11g Database Troubleshooting Guides
Enjoy this "Step by Step" Clear Installation and Getting Started...
Goodk Luck! :)
Check the DB Summary...
Click on Finish
