groupadd oinstall groupadd dba useradd -g oinstall -g dba -m oracle echo "142857" | passwd --stdin oracle mkdir -p /data/{oraInventory,oracle,install} chown -R oracle:oinstall /data/{oraInventory,install} id oracle
cat /proc/version uname -r vi /etc/redhat-release redhat-7
vi /etc/sysctl.conf net.ipv4.icmp_echo_ignore_broadcasts = 1 net.ipv4.conf.all.rp_filter = 1 fs.file-max = 6815744 fs.aio-max-nr = 1048576 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max= 4194304 net.core.wmem_default= 262144 net.core.wmem_max= 1048576
fs.file-max: 设置最大打开文件数 kernel.shmall: 共享内存的总量,8G内存设置:2097152*4k/1024/1024 kernel.shmmax: 最大共享内存的段大小 kernel.shmmni: 整个系统共享内存端的最大数 net.ipv4.ip_local_port_range: 可使用的IPv4端口范围
vi /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 -------------------------------------------------------------------------------- #oracle的变量 cat <<END >>/home/oracle/.bash_profile export ORACLE_BASE=/data/oracle export ORACLE_HOME=/data/oracle/11.2.0/db_1 export ORACLE_SID=orcl export ORACLE_TERM=xterm export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export LANG=C export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK END
source /home/oracle/.bash_profile
export ORACLE_BASE=/data/oracle #oracle数据库安装目录 export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 #oracle数据库路径 export ORACLE_SID=orcl #oracle启动数据库实例名 export ORACLE_TERM=xterm #xterm窗口模式安装 export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH #添加系统环境变量 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib #添加系统环境变量 export LANG=C #防止安装过程出现乱码 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK #设置Oracle客户端字符集,必须与Oracle安装时设置的字符集保持一致
./runInstaller -jreLoc /home/jdk -------------------------------------------------------------------------------- 直接下一步 到typical installation Oracle base: /data/oracle/ Sofeware location: /data/oracle/... database file localtion: /data/oracle 中途continue两次
执行两个sh oraInventory/orainstRoot.sh 11.2/db_1/dbs/root.sh
localhost:1158/em/ sys "yourcode"
#登录 su - oracle or su oracle sqlplus sys/xq AS sysdba sqlplus / as sysdba
#一点简单操作 create user xq identified by 123456; grant connect,resource,dba,sysdaba to xq; connect xq/123456;or conn xq/123456; show user; select*from all_users; create table xq(xq number); insert into xq values(1); update xq set xq=2; delete from xq;
#dbstart/shut 生效 vi $ORACLE_HOME/bin/dbstart 80 =$ORACLE_HOME
vi $ORACLE_HOME/bin/dbshut 50 =$ORACLE_HOME
vi /etc/oratab Y
dbshut dbstart
vi /etc/rc.d/init.d/oracle #ORACLE_HOME和ORACLE_USER等根据实际情况可以修改 #!/bin/bash # oracle: Start/Stop Oracle Database 11g R2 # chkconfig: 345 90 10 # description: The Oracle Database is an Object-Relational Database Management System. # . /etc/rc.d/init.d/functions LOCKFILE=/var/lock/subsys/oracle ORACLE_HOME=/data/database/11.2.0 ORACLE_USER=oracle case "$1" in ‘start‘) if [ -f $LOCKFILE ]; then echo $0 already running. exit 1 fi echo -n $"Starting Oracle Database:" su - $ORACLE_USER -c "$ORACLE_HOME/bin/lsnrctl start" su - $ORACLE_USER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" su - $ORACLE_USER -c "$ORACLE_HOME/bin/emctl start dbconsole" touch $LOCKFILE ;; ‘stop‘) if [ ! -f $LOCKFILE ]; then echo $0 already stopping. exit 1 fi echo -n $"Stopping Oracle Database:" su - $ORACLE_USER -c "$ORACLE_HOME/bin/lsnrctl stop" su - $ORACLE_USER -c "$ORACLE_HOME/bin/dbshut" su - $ORACLE_USER -c "$ORACLE_HOME/bin/emctl stop dbconsole" rm -f $LOCKFILE ;; ‘restart‘) $0 stop $0 start ;; ‘status‘) if [ -f $LOCKFILE ]; then echo $0 started. else echo $0 stopped. fi ;; *) echo "Usage: $0 [start|stop|status]" exit 1 esac exit 0
chmod 755 /etc/init.d/oracle
service oracle stop
service oracle start
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|