[Oracle] Linux系统下Oracle数据库的安装和启动关闭操作教程

df -H

du -sh /tmp/

groupadd dba -g 111
groupadd oinstall -g 110
useradd oracle -u -110 -g 110 -G 111
passwd oracle --stdin

su - oracle
vi .bash_profile

export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/10g
export ORACLE_SID=orcl
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

su
mkdir /u01/oracle
chown oracle:oinstall /u01/oracle/ -R

sysctl -a|grep sem|sed 's/32/100/2' >> /etc/sysctl.conf
sysctl -a|grep ip_local|sed -e 's/32768/1024' -e 's/61/65/' >> /etc/sysctl.conf
sysctl -a|grep rmem_d|sed 's/109568/262144' >> /etc/sysctl.conf
sysctl -a|grep rmem_ma|sed 's/131071/262144' >> /etc/sysctl.conf
sysctl -a|grep wmem_ma|sed 's/131071/262144' >> /etc/sysctl.conf
sysctl -a|grep wmem_de|sed 's/109568/262144' >> /etc/sysctl.conf
sysctl -a|grep file-m|sed 's/83702/65536' >> /etc/sysctl.conf
sysctl -p

xhost +
su - oracle
runinstall

[oracle@~]$ export LC_CTYPE="en_US.UTF-8"

>select OPEN_MODE from v$database;

oracle not available  ------- oracle没启动实例
oracle not mounted   ------- oracle在nomount阶段
oracle mounted   ------- oracle在mount阶段
oracle read write   ------- oracle在open阶段

>startup [force] [pfile=xxx] nomount;

#tail -f /u01/oracle/admin/orcl/bdump/alert_orcl.log

db mount ------------------ >alter database mount;

>show parameter control_file;

>alter database open;

>shutdown [normal|transactional|immediate|abort]

shutdown [normal|transactional|immediate|abort]

head -n 6 /etc/init.d/network >/etc/init.d/oracle10g
vi /etc/init.d/oracle10g

ORACLE_HOME=/u01/oracle/10g
if [ !-f $ORACLE_HOME/bin/dbstart ]
then
echo "oracle cannot start"
exit
fi
if [ ! -f $ORACLE_HOME/bin/lsnrctl ]
then
echo "lsnrctl cannot start"
exit
fi
case "$1" in
'start')
echo "starting oracle 10g ...."
su - oracle -c "$ORACLE_HOME/bin/dbstart"
#su - oracle -c "$ORACLE_HOME/bin/emctl start dbconsole" ------>start oem
;;
'stop')
echo "stopping oracle 10g ...."
#su - oracle -c "$ORACLE_HOME/bin/emctl stop dbconsole" ------>stop oem
su - oracle -c "$ORACLE_HOME/bin/dbshut"
;;
*)
echo "usage $0: start|stop"
;;
esac

chmod a+x /etc/init.d/oracle10g
chkconfig oracle10g on