{"id":1022,"date":"2012-08-15T15:44:38","date_gmt":"2012-08-15T07:44:38","guid":{"rendered":"http:\/\/rmohan.com\/?p=1022"},"modified":"2012-08-15T17:08:01","modified_gmt":"2012-08-15T09:08:01","slug":"how-to-setup-oracle-11g-db","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=1022","title":{"rendered":"How to setup Oracle 11g DB"},"content":{"rendered":"
To install Oracle 11g DB,\u00a0 just install the following packages at the startup and continue<\/div>\n

# yum install binutils gcc glibc glibc-devel cpp make setarch pdksh libaio libaio-devel compat-gcc-34 compat-gcc-34-c compat-libstdc-296 compat-libstdc-33 sysstat -y<\/p>\n

Creating groups and user for Oracle Installation:<\/div>\n

# groupadd oinstall
\n# groupadd dba
\n# useradd -m -g oinstall -G dba -d \/home\/oracle -s \/bin\/bash -c\u00a0 “Oracle Software Owner” oracle
\n# passwd oracle<\/p>\n

Installing Oracle DB:<\/div>\n

# mv 11g package to \/home\/oracle
\n# cd \/home\/oracle
\n# chown oracle *
\n# cd<\/p>\n

Now as oracle user execute the installation script<\/p>\n

# xhost +
\n# su – oracle
\nunzip both the packages, after unzip it, a folder called “database” is created.<\/p>\n

# cd database
\n# .\/runInstaller<\/p>\n

a graphical window will appear, Let me tell what all options to select in each window<\/p>\n

<\/div>\n
1st window:-Next2nd Window:-<\/p>\n

select Create and configure a database<\/p>\n

3rd Window:-<\/p>\n

select Server Class<\/p>\n

4th Window:-<\/p>\n

Single Instance database Installation<\/p>\n

5th Window:-<\/p>\n

Advanced Install<\/p>\n

6th Window:-<\/p>\n

select the language to install(english)<\/p>\n

7th Window:-<\/p>\n

enterprise edition<\/p>\n

8th Window:-<\/p>\n<\/div>\n

<\/div>\n
Oracle Base:-
\n\/home\/oracle\/app\/oracleSoftware Location:-
\n\/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_1<\/div>\n
<\/div>\n
9th Window:-Inventory Directory:-
\n\/home\/oracle\/app\/oraInventoryInventory Group name:-
\noinstall<\/p>\n

10th Window:-<\/p>\n

General Purpose<\/p>\n

11th Window:-<\/p>\n

Global Database Name:-
\norcl<\/p>\n

SID
\norcl<\/p>\n

12th Window:-<\/p>\n

select all default characters<\/p>\n

13th Window:-<\/p>\n

default option<\/p>\n

14th Window:-<\/p>\n

File System: \/home\/oracle\/app\/oracle\/oradata<\/p>\n

15th Window:-<\/p>\n

Do not enable Automated Backup<\/p>\n

16th Window:-<\/p>\n

use same password for all accounts: oracle<\/p>\n

17th Window:-<\/p>\n

DataBase Administrator group:- dba
\nDataBase Operator group:- oinstall<\/p>\n

18th Window:-<\/p>\n

if any error comes run the script and if packages error comes install those packages using yum.<\/p>\n

\u00a0fix and check again (tab) \/ and install packages needed using yum<\/div>\n
<\/div>\n
[
\nSetting Kernel Parameters…
\nfs.file-max = 65536
\nfs.file-max = 6815744
\nnet.ipv4.ip_local_port_range = 9000 65500
\nnet.core.rmem_max = 1048576
\nnet.core.rmem_max = 4194304
\nnet.core.wmem_max = 262144
\nnet.core.wmem_max = 1048576
\nfs.aio-max-nr = 1048576
\n]<\/div>\n

19th Window:-<\/p>\n

finish, installation start<\/p>\n

20th Window:-<\/p>\n

installing<\/p>\n

21th Window:-<\/p>\n

close<\/p>\n

Connecting to the Database, Now reboot server and login as oracle user. To login to our database, we run sqlplus. But before it, set Environment Variables. Add the below lines to .bash_profile file in the \/home\/oracle directory.<\/p>\n

# su \u2013 oracle\u00a0 [ login as oracle user ]<\/p>\n

Then export Oracle Path:- ( for 11g )<\/p>\n

vim .bash_profile
\nvim \/etc\/profile<\/p>\n<\/div>\n

<\/div>\n

Then export Oracle Path:-<\/p>\n

<\/div>\n

export ORACLE_BASE=\/home\/oracle\/app\/oracle
\nexport ORACLE_HOME=$ORACLE_BASE\/product\/11.2.0\/dbhome_1
\nexport ORACLE_SID=orcl
\nexport PATH=$PATH:$ORACLE_HOME\/bin
\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib
\nexport PATH=$ORACLE_HOME\/bin:$PATH<\/p>\n

This will Complete the basic steps in Oracle DB setup.<\/div>\n
<\/div>\n

Now you can start the database.<\/p>\n

$ lsnrctl start<\/p>\n

The above command starts the database listener. Below command starts the database<\/div>\n
<\/div>\n
$ dbstart[ \/etc\/oratab<\/div>\n
orcl:\/home\/oracle\/oracle\/product\/10.2.0\/db_1:Y ( change N to Y ) ]To start the Oracle Enterprise Manager execute the below command.<\/div>\n
<\/div>\n
$ emctl start dbconsole<\/div>\n
<\/div>\n
Now open a new terminal and access the newly created database using
\nsqlplus as oracle user.[ # su \u2013 oracle ]<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
$ sqlplus system\/oracle@orcl<\/div>\n
NOTE : oracle is the password set for the newly created database during installation<\/div>\n","protected":false},"excerpt":{"rendered":"

To install Oracle 11g DB, just install the following packages at the startup and continue <\/p>\n

# yum install binutils gcc glibc glibc-devel cpp make setarch pdksh libaio libaio-devel compat-gcc-34 compat-gcc-34-c compat-libstdc-296 compat-libstdc-33 sysstat -y<\/p>\n

Creating groups and user for Oracle Installation: <\/p>\n

# groupadd oinstall # groupadd dba # useradd -m -g oinstall -G dba -d […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1022"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1022"}],"version-history":[{"count":4,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1022\/revisions"}],"predecessor-version":[{"id":1024,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1022\/revisions\/1024"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}