静默安装:
./ runInstaller -silent -responseFile /database/response/db_install.rsp
./ dbca -silent -responseFile /database/response/dbca.rsp
./ netca -silent -responseFile /database/response/netca.rsp
环境变量: ~/.bashrc(/home/ oracle/.bashrc)
环境变量: ~/.bashrc(/home/ oracle/.bashrc)
export ORACLE_HOME_LISTNER=/opt/oracle/product/11.2.0/dbhome_1 #最后不能加“/”,否则本地sqlplus登陆不了
export ORACLE_HOME=/opt/oracle/product/ 11. 2. 0/dbhome_1 #最后不能加“ /”,否则本地sqlplus登陆不了
export ORACLE_SID=db1
PATH= $ORACLE_HOME/bin: $PATH
export PATH
开机启动:
# vi /etv/oratab 修改
$ORACLE_SID:$ORACLE_HOME:<N| Y>
# vi /etc/rc.local 添加
su - oracle -c"/opt/oracle/product/11.2.0/dbhome_1/bin/ dbstart /opt/oracle/product/11.2.0/dbhome_1"
# 这是dbstart的参数1 $ORACLE_HOME
ORA-00845: MEMORY_TARGET not supported on this system
# df -k
# mount -t tmpfs shmfs -o size=2G /dev/shm
让以后每次重启OS 都自动mount,修改文件 /etc/fstab 将tmpfs 修改成以下值:
tmpfs /dev/shm tmpfs defaults,size=2G 0 0
ORA-00205: error in identifying control file, check alert log for more info
# reboot //
/oracle/product/11.2.0/dbhome_1/listener.log: Permission denied
# chown oracle:oracle <listener.log|startup.log>
# DISPLAY
# xhost + TNS:net service name is incorrectly specified
export ORACLE_SID=db1
# 远程无法访问
# 远程无法访问
# lsnrctl status //监听器状态
vi /etc/sysconfig/iptables //防火墙
# 添加相应端口
/oracle/product/11.2.0/dbhome_1/bin/ dbca 数据库实例 /oracle/product/11.2.0/dbhome_1/bin/ netca 监听器
/oracle/product/11.2.0/dbhome_1/bin/ dbca 数据库实例 /oracle/product/11.2.0/dbhome_1/bin/ netca 监听器