Linux安装oracle

--root执行
groupadd -g 1010 oinstall
groupadd -g 1020 dba
useradd -g oinstall -g dba  -m oracle
passwd oracle

--root执行----
修改database的所有者 
找到oracle11g的解压目录执行
 chown -R oracle:dba database

--root执行
mkdir  -p /home/oracle/app
mkdir  -p /home/oracle/app/oracle
mkdir  -p /home/oracle/app/oradata
mkdir  -p /home/oracle/app/oracle/product

--root执行
vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

--root执行
vi /etc/pam.d/login
#session required /lib/security/pam_limits.so
session required pam_limits.so

--root执行
vi /etc/sysctl.conf
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
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 = 1048576

--root执行
sysctl -p

--root执行 可以不执行
 vi .bash_profile
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

--oracle执行  进入到/home/oracle目录下面执行
 vi .bash_profile
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib


--root执行
vi /etc/profile
if [ $USER = "oracle" ]; then
	if [ $SHELL = "/bin/ksh" ]; then
		ulimit -p 16384
		ulimit -n 65536
	else
		ulimit -u 16384 -n 65536
	fi
fi

reboot 系统 
重启后以oracle登录
执行安装，输入命令：./runInstaller

global database name orcl 
username：sys/system/scott
password ctllin

Enterprise Manager Database Control URL - (orcl) :
https://localhost:1158/em

/home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh
 执行root.sh输入 /home/oracle/app/oracle/product/11.2.0/dbhome_1
/home/oracle/oraInventory/orainstRoot.sh
RedHat 开放防火墙端口
1. cd到/sbin目录，执行命令:
iptables -I INPUT -p tcp --dport 1158 -j ACCEPT
iptables -I INPUT -p tcp --dport 1521 -j ACCEPT
2.service iptables save
3.service iptables restart


在oracle用户的图形界面oracle用户中，新开启一个终端，直接输入命令dbca会进入数据库图形界面
在oracle用户的图形界面oracle用户中，新开启一个终端，直接输入命令netmgr会进入监听配置图形界面
local->Service Nameing->(for exapmle orcl)orcl  Connetction Type:Dedicated Server


lsnrctl start 
sqlplus /nolog
startup     #shutdown immediate
conn as sysdba;
Enter user-name: system
Enter password:ctllin
alter user scott account unlock;
alter system register;
alter user scott identified by ctllin;

listener.ora 增加上
SID_LIST_LISTENER=
  (SID_LIST=
      (SID_DESC=
                      #BEQUEATH CONFIG
         (GLOBAL_DBNAME=orcl)
         (SID_NAME=orcl)
         (ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)
                      #PRESPAWN CONFIG
        (PRESPAWN_MAX=20)
        (PRESPAWN_LIST=
          (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
        )
       )
      )	
tnsnames.ora增加上 可以不配置
LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.42.19)(PORT = 1521))


scott/ctllin@192.168.42.19/orcl
scott/ctllin@192.168.42.19:orcl
scott/ctllin@127.0.0.1:orcl
scott/ctllin@127.0.0.1/ORCL

ORA-00845: MEMORY_TARGET not supported on this system
虚拟机装好后调小了内存，如果报此错误可以恢复内存大小

listener.ora
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.42.19)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /home/oracle/app

SID_LIST_LISTENER=
  (SID_LIST=
      (SID_DESC=
                      #BEQUEATH CONFIG
         (GLOBAL_DBNAME=orcl)
         (SID_NAME=orcl)
         (ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)
                      #PRESPAWN CONFIG
        (PRESPAWN_MAX=20)
        (PRESPAWN_LIST=
          (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
        )
       )
      )	

tnsnames.ora
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.42.19)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /home/oracle/app

SID_LIST_LISTENER=
  (SID_LIST=
      (SID_DESC=
                      #BEQUEATH CONFIG
         (GLOBAL_DBNAME=orcl)
         (SID_NAME=orcl)
         (ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)
                      #PRESPAWN CONFIG
        (PRESPAWN_MAX=20)
        (PRESPAWN_LIST=
          (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
        )
       )
      )	


create public database link orcldblink connect to scott IDENTIFIED BY ctllin
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.42.19)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';

drop public database link orcldblink;

select * from tablename@dblinkname