Oracle11gr2 Linux

静默安装：

./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)

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 监听器

---