《oracle11.2.0.4安装及手动建库forcentos7》由会员分享,可在线阅读,更多相关《oracle11.2.0.4安装及手动建库forcentos7(16页珍藏版)》请在金锄头文库上搜索。
1、unzip p13390677_112040_Linux-x86-64_1of7.zip unzip p13390677_112040_Linux-x86-64_2of7.zipAdd groups-required groups/usr/sbin/groupadd -g 501 oinstall/usr/sbin/groupadd -g 502 dba/usr/sbin/groupadd -g 503 operAdd user Oracle/usr/sbin/useradd -u 502 -g oinstall -G dba,oper oracleChange password for us
2、erpasswd oracleAdd kernel parameters to /etc/sysctl.confkernel.shmmni = 4096 kernel.shmmax = 4398046511104kernel.shmall = 1073741824kernel.sem = 250 32000 100 128fs.aio-max-nr = 1048576fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 419
3、4304net.core.wmem_default = 262144net.core.wmem_max = 1048586Apply kernel parameters/sbin/sysctl -pAdd following lines to set shell limits for user oracle in file /etc/security/limits.conforacle soft nproc 131072oracle hard nproc 131072oracle soft nofile 131072oracle hard nofile 131072oracle soft co
4、re unlimitedoracle hard core unlimitedoracle soft memlock 50000000oracle hard memlock 50000000# mkdir -p /ora01/app/oracle/product/11.2.0/db_1# chown -R oracle.dba /ora01# chmod 775 -R /ora01#su oracle$vi .bash_profileexport TMP=/tmpexport ORACLE_HOSTNAME=export ORACLE_UNQNAME=ORA11Gexport ORACLE_BA
5、SE=/ora01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=ORA11GPATH=/usr/sbin:$PATH:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;alias cdob=cd $ORACLE_BASEalias cdoh=cd $ORACLE_HOMEali
6、as tns=cd $ORACLE_HOME/network/adminalias envo=env | grep ORACLEumask 022Check which packages are installed and which are missingrpm -q -qf %NAME-%VERSION-%RELEASE(%ARCH)n binutils elfutils-libelf elfutils-libelf-devel gcc gcc-c+ glibc glibc-common glibc-devel glibc-headers ksh libaio libaio-devel l
7、ibgcc libstdc+ libstdc+-devel make sysstat unixODBC unixODBC-develNOTE Im using x86_64 version of packagesrpm -Uvh elfutils-libelf-devel*.x86_64.rpmrpm -Uvh libaio-devel*.x86_64.rpmrpm -Uvh unixODBC*.x86_64.rpmrpm -Uvh ksh*.x86_64.rpm$ export DISPLAY=192.168.209.1:0.0$ ./runInstallerJust click “Yes”
8、 button to continue with installation.To fix this error edit $ORACLE_HOME/sysman/lib/ins_emagent.mk, search for the line$(MK_EMAGENT_NMECTL)and replace the line with$(MK_EMAGENT_NMECTL) -lnnz11then click “Retry” button# /ora01/app/oraInventory/orainstRoot.shChanging permissions of /ora01/app/oraInve
9、ntory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /ora01/app/oraInventory to oinstall.The execution of the script is complete.# /ora01/app/oracle/product/11.2.0/db_1/root.shPerforming root user operation for Oracle 11g The following
10、 environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /ora01/app/oracle/product/11.2.0/db_1Enter the full pathname of the local bin directory: /usr/local/bin: Copying dbhome to /usr/local/bin .Copying oraenv to /usr/local/bin .Copying coraenv to /usr/local/bin .Creating /etc/oratab file
11、.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.创建密码文件(作用:允许远程用密码方式以 sysdba 身份登陆数据库,密码文件可有可无)-
12、切换到存放密码文件的目录oracleprod $ cd $ORACLE_HOME/dbsorapwd file=orapwORA11G password=oracleoracleprod dbs$ cat init.ora |grep -v #|grep -v $ initPROD.ora$ cat initORA11G.ora db_name=ORA11Gmemory_target=500mprocesses = 150audit_file_dest=/ora01/app/oracle/admin/ora11g/adump#audit_trail =dbdb_block_size=8192d
13、b_domain=#db_recovery_file_dest=/flash_recovery_area#db_recovery_file_dest_size=2G#diagnostic_dest=dispatchers=(PROTOCOL=TCP) (SERVICE=ORCLXDB)open_cursors=300 remote_login_passwordfile=EXCLUSIVEundo_tablespace=UNDOTBS1control_files = (/ora01/app/oracle/oradata/ORA11G/ora_control1.ctl,/ora01/app/ora
14、cle/oradata/ORA11G/ora_control2.ctl)compatible =11.2.0$ mkdir -p $ORACLE_BASE/admin/ora11g/adump$ mkdir -p $ORACLE_BASE/oradata/ORA11G/通过 pfile 创建 spfile12345678910111213141516-验证当前环境变量oracleprod dbs$ echo $ORACLE_SIDORA11Goracleprod dbs$ -通过 pfile 创建 spfileoracleprod dbs$ sqlplus / as sysdbaSQL*Plu
15、s: Release 11.2.0.4.0 Production on Fri Feb 28 16:34:35 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL create spfile from pfile;File created.6:数据库启动到 nomount(默认情况下,oracle 会使用 spfile 启动数据库)12345678910111213oracleprod dbs$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 28 17:20:28 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL startup nomount;ORACLE instance started.Total System Global Area 1068937216 bytesFixed Size 2260088 b