Thursday 5 September 2019

HOW TO INSTALL ORACLE 11G DATABASE SOFTWARE IN LINUX

             HOW TO INSTALL  ORACLE 11G DATABASE SOFTWARE IN LINUX !!


[root@localhost ~]#useradd oracle
[root@localhost ~]#groupadd oinstall
[root@localhost ~]#groupadd dba
[root@localhost ~]#usermod -g oinstall -G dba oracle

[root@localhost apps] mkdir -p oracle/oracle_base/rdbms/product/11.2.0/db_home/

[root@localhost oradata]# mkdir datafiles redologs controlfiles udump bdump cdump
[root@localhost oradata]#ls
controlfiles  datafiles  redologs udump bdump cdump

[root@localhost apps]#  mkdir -p oradump/software


[root@localhost /]# chown -R oracle:oinstall apps

drwxr-xr-x.   5 oracle oinstall  4096 Nov 19  2018 apps
dr-xr-xr-x.   2 root   root      4096 Aug 30 12:28 bin
dr-xr-xr-x.   5 root   root      4096 Nov 20  2018 boot


[root@localhost apps]# cd oradump/software/
[root@localhost software]# ll
total 2487208
-rwxr-xr-x. 1 oracle oinstall 1395582860 Aug 30 12:39 p13390677_112040_Linux-x86-64_1of7.zip
-rwxr-xr-x. 1 oracle oinstall 1151304589 Aug 30 12:42 p13390677_112040_Linux-x86-64_2of7.zip

[root@localhost software]# unzip p13390677_112040_Linux-x86-64_1of7.zip


[root@localhost software]# unzip p13390677_112040_Linux-x86-64_2of7.zip

[root@localhost software]# su - oracle

[oracle@localhost ~]$ cd /apps/oradump/software/
[oracle@localhost software]# ls

database
p13390677_112040_Linux-x86-64_2of7.zip
p13390677_112040_Linux-x86-64_1of7.zip

[oracle@localhost software]$ cd database/
install      response  runInstaller  stage
readme.html  rpm       sshsetup      welcome.html

[oracle@localhost database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 13238 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3999 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-08-30_01-02-45PM. Please wait ...[oracle@localhost database]$











By typing the ( yum install package_name)  utility install the required packages;

[root@localhost software]# yum install elfutils-libelf-devel*Complete!
[root@localhost software]#





 Login as root and install the above packages ;



[root@localhost ~]# /apps/oracle/oraInventory/orainstRoot.sh
[root@localhost ~]# /apps/oracle/oracle_base/rdbms/product/11.2.0/db_home/root.sh


[oracle@localhost ~]$ vi .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_HOME=/apps/oracle/oracle_base/rdbms/product/11.2.0/db_home
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=orcl


[oracle@localhost ~]$ . .bash_profile
[oracle@localhost ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 30 15:05:14 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> exit

[oracle@localhost ~]$ cd /apps/oracle/oracle_base/rdbms/product/11.2.0/db_home/dbs
[oracle@localhost dbs]$ ls
createdatabase.sql  init.ora  initorcl.ora


[oracle@localhost ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 30 15:15:56 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/apps/oracle/oracle_base/rdbms/product/11.2.0/db_home/dbs/initorcl.ora'
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size     2254952 bytes
Variable Size   503318424 bytes
Database Buffers 1627389952 bytes
Redo Buffers     4923392 bytes
SQL> @/apps/oracle/oracle_base/rdbms/product/11.2.0/db_home/dbs/createdatabase.sql;

Database created.


SQL> select name,open_mode from v$database;

NAME   OPEN_MODE
--------- --------------------
ORCL   READ WRITE

SQL>




                                         The simplest way to create database is done !!


No comments:

Post a Comment

HOW TO RESIZE SGA AND PGA SIZE IN ORACLE

                                               TO INCREASE SGA SIZE: SQL> show parameter sga NAME      TYPE        VALUE ---...