环境:
OS:Centos 7
DB:11.2.0.4
1.关闭数据库和监听器以及em
[oracle@11g lib]$ lsnrctl stop
[oracle@11g lib]$ emctl stop dbconsole
SQL> connect / as sysdba
Connected.
SQL> shutdown immediate
2.关闭
[oracle@11g lib]$ cd $ORACLE_HOME/rdbms/lib [oracle@11g lib]$ make -f ins_rdbms.mk dv_off ioracle /usr/bin/ar d /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/libknlopt.a kzvidv.o /usr/bin/ar cr /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/kzvndv.o chmod 755 /u01/app/oracle/product/11.2.0.4/db_1/bin - Linking Oracle rm -f /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/oracle gcc -o /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/oracle -m64 -z noexecstack -L/u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/ -L/u01/app/oracle/product/11.2.0.4/db_1/lib/ -L/u01/app/oracle/product/11.2.0.4/db_1/lib/stubs/ -Wl,-E /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/opimai.o /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/ssoraed.o /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv11 -Wl,--no-whole-archive /u01/app/oracle/product/11.2.0.4/db_1/lib/nautab.o /u01/app/oracle/product/11.2.0.4/db_1/lib/naeet.o /u01/app/oracle/product/11.2.0.4/db_1/lib/naect.o /u01/app/oracle/product/11.2.0.4/db_1/lib/naedhs.o /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/config.o -lserver11 -lodm11 -lcell11 -lnnet11 -lskgxp11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lvsn11 -lcommon11 -lgeneric11 -lknlopt `if /usr/bin/ar tv /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap11" ; fi` -lslax11 -lpls11 -lrt -lplp11 -lserver11 -lclient11 -lvsn11 -lcommon11 -lgeneric11 `if [ -f /u01/app/oracle/product/11.2.0.4/db_1/lib/libavserver11.a ] ; then echo "-lavserver11" ; else echo "-lavstub11"; fi` `if [ -f /u01/app/oracle/product/11.2.0.4/db_1/lib/libavclient11.a ] ; then echo "-lavclient11" ; fi` -lknlopt -lslax11 -lpls11 -lrt -lplp11 -ljavavm11 -lserver11 -lwwg `cat /u01/app/oracle/product/11.2.0.4/db_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0.4/db_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lztkg11 `cat /u01/app/oracle/product/11.2.0.4/db_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0.4/db_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `if /usr/bin/ar tv /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo11"; fi` -L/u01/app/oracle/product/11.2.0.4/db_1/ctx/lib/ -lctxc11 -lctx11 -lzx11 -lgx11 -lctx11 -lzx11 -lgx11 -lordimt11 -lclsra11 -ldbcfg11 -lhasgen11 -lskgxn2 -lnnz11 -lzt11 -lxml11 -locr11 -locrb11 -locrutl11 -lhasgen11 -lskgxn2 -lnnz11 -lzt11 -lxml11 -loraz -llzopro -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged -lippsmerged -lippcore -lippcpemerged -lippcpmerged -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lsnls11 -lunls11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lasmclnt11 -lcommon11 -lcore11 -laio `cat /u01/app/oracle/product/11.2.0.4/db_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0.4/db_1/lib -lm `cat /u01/app/oracle/product/11.2.0.4/db_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/11.2.0.4/db_1/lib test ! -f /u01/app/oracle/product/11.2.0.4/db_1/bin/oracle || mv -f /u01/app/oracle/product/11.2.0.4/db_1/bin/oracle /u01/app/oracle/product/11.2.0.4/db_1/bin/oracleO mv /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib/oracle /u01/app/oracle/product/11.2.0.4/db_1/bin/oracle chmod 6751 /u01/app/oracle/product/11.2.0.4/db_1/bin/oracle
3.启动数据库、监听和em
然后启动数据库、监听器和em
lsnrctl start
emctl start dbconsole##若已经配置的情况下
启动数据库
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
这个时候查看安装情况
SQL> set linesize 1000;
SQL> select * from v$option where parameter like '%Vault%';
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Oracle Database Vault FALSE
sys用户创建用户并授权是可以成功的.
SQL> create user hxl01 identified by oracle;
User created.
SQL> grant dba to hxl01;
Grant succeeded.