solaris10u10 x86-64 oracle11.2.0.3 64bit client 检查软件环境 [root@MLCDBSERVER2@/]>pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibms SUNWsprot \ SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt [root@MLCDBSERVER2@/]>pkgadd -d . SUNWi1cs SUNWi15cs [root@MLCDBSERVER2@/tmp]>pkgadd -d ActivePerl-5.8.8.819-x86-solaris-2.10-cc-267479.pkg [root@MLCDBSERVER2@/]>mkdir -p /var/opt/oracle [root@MLCDBSERVER2@/]>vi /var/opt/oracle/oraInst.loc inventory_loc=/u01/app/oraInventory inst_group=oinstall 配置系统登录显示变量 [root@MLCDBSERVER2@/]>vi /etc/profile #add PS1='[$LOGNAME@`hostname`@$PWD]>';export PS1 [root@MLCDBSERVER2@/]>/usr/sbin/usermod -s /usr/bin/bash root 创建oracle用户和组 [root@MLCDBSERVER2@/]>mkdir -p /home/oracle [root@MLCDBSERVER2@/]>/usr/sbin/groupadd oinstall [root@MLCDBSERVER2@/]>/usr/sbin/groupadd -g 502 dba [root@MLCDBSERVER2@/]>/usr/sbin/groupadd -g 503 oper [root@MLCDBSERVER2@/]>/usr/sbin/useradd -u 502 -g oinstall -G dba -d /home/oracle -s /usr/bin/bash oracle [root@MLCDBSERVER2@/]>passwd oracle biierg_oracle [root@MLCDBSERVER2@/]>chown oracle:oinstall /home/oracle [root@MLCDBSERVER2@/]>mkdir /app/oracle [root@MLCDBSERVER2@/]>chown oracle:oinstall /app/oracle [root@MLCDBSERVER2@/]>chmod -R 775 /app/oracle [root@MLCDBSERVER2@/]>chown oracle:oinstall /var/opt/oracle 配置oracle环境变量 [root@MLCDBSERVER2@/]>su - oracle [oracle@MLCDBSERVER2@/home/oracle]>vi .bash_profile PERL_HOME=/opt/ActivePerl-5.8;export PERL_HOME ORACLE_BASE=/app/oracle;export ORACLE_BASE ORACLE_HOME=${ORACLE_BASE}/product/client/11.2.0.3;export ORACLE_HOME ORACLE_ADMIN=${ORACLE_BASE}/admin;export ORACLE_ADMIN TNS_ADMIN=/var/opt/oracle;export TNS_ADMIN ORACLE_HOSTNAME=MLCDBCLIENT.biierg-inner.com;export ORACLE_HOSTNAME PATH=${PERL_HOME}/bin PATH=${PATH}:${OFSDB_HOME}/bin PATH=$PATH:${ORACLE_HOME}/lib:${ORACLE_HOME}/bin:${ORACLE_BASE}/admin/bin PATH=$PATH:/usr/sbin:/usr/bin:/usr/local/bin:/usr/openwin/bin PATH=$PATH:/opt/SUNWcluster/bin:/usr/X/bin:/usr/ccs/bin:/usr/ccs/lib PATH=$PATH:/usr/bin/nsr:/usr/sbin/nsr PATH=$PATH:/opt/csw/bin export PATH LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/ccs/lib:/usr/lib ; export LD_LIBRARY_PATH MANPATH=/opt/SUNWcluster/man:/usr/share/man:${PERL_HOME}/man;export MANPATH PS1='[$LOGNAME@`hostname`@$PWD]>';export PS1 [oracle@MLCDBSERVER2@/home/oracle]>. .bash_profile [oracle@MLCDBSERVER2@/home/oracle]> 配置responseFile 开始安装oracle软件 [oracle@MLCDBSERVER2@/tmp/client]>./runInstaller -silent -responseFile /tmp/client_install.rsp 配置netca [oracle@MLCDBSERVER2@/tmp/client]>netca /silent /responsefile /tmp/netca.rsp 修改tnsnames.ora [oracle@MLCDBSERVER2@/var/opt/oracle]>vi tnsnames.ora MLC010C1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.247.53.19)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MLC010C1) ) ) [root@MLCDBSERVER2@~]>cp /home/oracle/.bash_profile . [root@MLCDBSERVER2@~]>. .bash_profile
深入oracle,去透析oracle每个角落。
DBA、SQL开发技术人的集市,QQ高级群群号35448096