Oracle Database 11g Installation

0.

/etc/sysctl.conf

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

sysctl -p

vi /etc/security/limits.conf

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

nano /etc/selinux/config

SELINUX=disabled
Once the change is complete, restart the server.

groupadd oinstall
groupadd -g 502 dba
useradd -g oinstall -G dba oracle

1.

[oracle@oblicoredb ~]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2013 21:03:49

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/oblicoredb/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                18-SEP-2013 21:03:53
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oblicoredb/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully

2.

[oracle@oblicoredb ~]$ env | grep ORACLE
export ORACLE_UNQNAME=OBLC
export ORACLE_SID=OBLC
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOSTNAME=oracledb.mss.globul.bg
export ORACLE_TERM=xterm
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

2.1

Control files: /pm/q/d/controln.ctl
• Redo log files: /pm/q/d/redon.log
• Data files: /pm/q/d/tn.dbf
The variables used in these file names are:
• pm: Mount point name (as described previously)
• q: String distinguishing the Oracle data from all other files (commonly named ORACLE or
oradata)
• d: Value of the initialization parameter DB_NAME (the database name)
• t: Oracle tablespace name
• n: Two-digit string

 select * from nls_session_parameters;

$ORACLE_BASE/product/11.1.0/db_1

#Oracle Net Configuration Assistant:
tnsnames.ora

./runInstaller –record -destinationFile <filename>

netca