12c用户环境变量，不一样的

创建目录
mkdir /home/oracle/scripts

创建setEnv.sh文件
cat > /home/oracle/scripts/setEnv.sh <<EOF

cat > /home/oracle/scripts/setEnv.sh <<EOF
# Oracle Settings
export TMP=/tmp
export TMPDIR=\$TMP

export ORACLE_HOSTNAME=ol7-122.localdomain
export ORACLE_UNQNAME=cdb1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/12.2.0.1/db_1
export ORACLE_SID=cdb1

export PATH=/usr/sbin:/usr/local/bin:\$PATH
export PATH=\$ORACLE_HOME/bin:\$PATH

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
EOF

把创建的文件放到.bash_profile
echo “. /home/oracle/scripts/setEnv.sh” >> /home/oracle/.bash_profile

cat > /home/oracle/scripts/start_all.sh <<EOF
#!/bin/bash
. /home/oracle/scripts/setEnv.sh

export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES

dbstart $ORACLE_HOME
EOF


cat > /home/oracle/scripts/stop_all.sh <<EOF
#!/bin/bash
. /home/oracle/scripts/setEnv.sh

export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES

dbshut $ORACLE_HOME
EOF


查看创建的脚本



附加数据库安装






























设置成开机自启动

vim /u01/app/oracle/product/12.2.0.1/db_1/bin/dbstart

ORACLE_HOME_LISTNER=$ORACLE_HOME

vim /u01/app/oracle/product/12.2.0.1/db_1/bin/dbshut

ORACLE_HOME_LISTNER=$1改为ORACL{E}_{H}OM{E}_{L}ISTNER=$ORACLE_HOME

vim /etc/rc.d/rc.local
su oracle -lc “/u01/app/oracle/product/12.2.0.1/db_1/bin/lsnrctl start”
su oracle -lc /u01/app/oracle/product/12.2.0.1/db_1/bin/dbstart

ll /u01/app/oracle/product/12.2.0.1/db_1/bin/lsnrctl
ll /u01/app/oracle/product/12.2.0.1/db_1/bin/dbstart

chmod +x rc.local

关闭数据库
/home/oracle/scripts/stop_all.sh


/home/oracle/scripts/start_all.sh