Installation Docs -
http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=
11g Linux Installation Guide pdf
http://oss.oracle.com/el5/oracle-validated/
My favorite database installation note:
The Oracle Client Quick Installation Guide does not contain the kernel info below
Installing 9iR2 on Linux- (Fedora Core 2)
find an open port:
netstat -vatn |grep 1521
Start the listener. If there isn't one, create a listener with netca
$ORACLE_HOME/bin/netca
Install a database:
$ORACLE_HOME/bin/dbca
lsnr
$ORACLE_HOME/bin/netca
# free
- OR -
# cat /proc/swaps
- OR -
# cat /proc/meminfo | grep MemTotal
As root, make a file that will act as additional swap space, let's say about 300MB:
# dd if=/dev/zero of=tempswap bs=1k count=300000
Now we should change the file permissions:
# chmod 600 tempswap
Finally we format the "partition" as swap and add it to the swap space:
# mke2fs tempswap
# mkswap tempswap
# swapon tempswap
# ipcs -lm ------ Shared Memory Limits -------- max number of segments = 4096 max seg size (kbytes) = 32768 max total shared memory (kbytes) = 8388608 min seg size (bytes) = 1
Configuring the Linux Kernel Parameters
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144
cat >> /etc/sysctl.conf <<EOF
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144
EOF /sbin/sysctl -p
Run the following commands as root to verify your settings:
/sbin/sysctl -a | grep shm
/sbin/sysctl -a | grep sem
/sbin/sysctl -a | grep file-max
/sbin/sysctl -a | grep ip_local_port_range
/sbin/sysctl -a | grep rmem_default
/sbin/sysctl -a | grep rmem_max
/sbin/sysctl -a | grep wmem_default
/sbin/sysctl -a | grep wmem_max
Setting shell limits for the oracle user
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF
cat >> /etc/pam.d/login <<EOF
session required pam_limits.so
EOF
cat >> /etc/sysctl.conf <<EOF
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144
EOF
/sbin/sysctl -p
Log into Linux as oracle. Set the environment.
Set the Oracle environment variables:
$ . oraenv ORACLE_SID = [demo1] ? demo1 The Oracle base for ORACLE_HOME=/u01/oracle/<sid>/11.1.0/ is /u01/oracle/<sid> - I don't see the point to all those directories listed in the line below. It's just that much more to type if you have to type it for some reason. If someone can please tell me the point I will gladly change my ways. monique@appsdbainfo.com
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 is /u01/app/oracle
connecting to the database: ORACLE_HOME=/u01/oracle/<sid>/11.2.0 ORACLE_SID=RMAN export ORACLE_HOME ORACLE_SId sqlplus / as sysdba If you don't export the ORACLE_SID or set the env, you may get the following error when you try to connect to the database: ORA-12162: TNS:net service name is incorrectly specified
Using Oracle Enterprise Manager 11g Database Control
https://ds1.orademo.org:1158/em (You may have to use the IP address instead of the host name if your database server isn’t in your DNS.)
User Name: SYSTEM
Password: <The password you chose during installation>
Connect As: sysdba
Starting and Stopping Oracle Enterprise Manager Database Control:
$ emctl start dbconsole
$ emctl stop dbconsole
Starting and Stopping the Listener:
The listener accepts connection requests from clients and creates connections to the database once the credentials have been authenticated. Before you can use OEM, the listener must be up. Don't make the mistake of not using the SID when you start and stop the listener. Even if you are using the default port of 1521...causes issues.
$ lsnrctl start
$ lsnrctl stop
Just because:
Make sure you name your database using UPPER case letters. LOWER Case will cause an issue when you try to reinstall the EM dbconsole on a cloned instance. Don't know of any other issues it will cause, other than make your passwd file look silly ..the sid in the password file will need to be in lowercase for the dbconsole recreate to work among other things, and like I said, that looks silly.
Make your database name: $ ORACLE_SID as short as possible. You will have to type it alot....and don't name it test_orcldb_01 and put it on host oracledb_01.venus.com. Name it TEST and put it on earthdb01.venus.com. The unique name is the sid.domain.
cd If you have 3 test databases on different hosts, you can name them all TEST. .if you must, and even use the same port on all of them, You can't have 3 databases named TEST on the same host and have them all started at the same time. Also, you don't use the same port on the same host for different databases, but that goes without saying.