Linux安装oracle

--root执行groupadd -g 1010 oinstallgroupadd -g 1020 dbauseradd -g oinstall -g dba  -m oraclepasswd oracle--root执行----修改database的所有者 找到oracle11g的解压目录执行 chown -R oracle:dba database--root执行mkdir  -p /home/oracle/appmkdir  -p /home/oracle/app/oraclemkdir  -p /home/oracle/app/oradatamkdir  -p /home/oracle/app/oracle/product--root执行vi /etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536--root执行vi /etc/pam.d/login#session required /lib/security/pam_limits.sosession required pam_limits.so--root执行vi /etc/sysctl.conffs.file-max = 6815744fs.aio-max-nr = 1048576kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576--root执行sysctl -p--root执行 可以不执行 vi .bash_profileexport ORACLE_BASE=/home/oracle/appexport ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1export ORACLE_SID=orclexport PATH=$PATH:$HOME/bin:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib--oracle执行  进入到/home/oracle目录下面执行 vi .bash_profileexport ORACLE_BASE=/home/oracle/appexport ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1export ORACLE_SID=orclexport PATH=$PATH:$HOME/bin:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib--root执行vi /etc/profileif [ $USER = "oracle" ]; thenif [ $SHELL = "/bin/ksh" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifireboot 系统 重启后以oracle登录执行安装，输入命令：./runInstallerglobal database name orcl username：sys/system/scottpassword ctllinEnterprise 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.shRedHat 开放防火墙端口1. cd到/sbin目录，执行命令:iptables -I INPUT -p tcp --dport 1158 -j ACCEPTiptables -I INPUT -p tcp --dport 1521 -j ACCEPT2.service iptables save3.service iptables restart在oracle用户的图形界面oracle用户中，新开启一个终端，直接输入命令dbca会进入数据库图形界面在oracle用户的图形界面oracle用户中，新开启一个终端，直接输入命令netmgr会进入监听配置图形界面local->Service Nameing->(for exapmle orcl)orcl  Connetction Type:Dedicated Serverlsnrctl start sqlplus /nologstartup     #shutdown immediateconn as sysdba;Enter user-name: systemEnter password:ctllinalter 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/orclscott/ctllin@192.168.42.19:orclscott/ctllin@127.0.0.1:orclscott/ctllin@127.0.0.1/ORCLORA-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/appSID_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/appSID_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 ctllinusing '(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