OEL5.5???Oracle 11gr2???
???????????? ???????[ 2015/5/28 11:41:46 ] ?????????????
????6?????????????
?????????????
????# /sbin/sysctl -a | grep parameter_name
???????????????б??
????/proc/sys/kernel/sem 250 32000 100 128
????/proc/sys/kernel/shmall 2097152
????/proc/sys/kernel/shmmax 536870912
????/proc/sys/kernel/shmmni 4096
????/proc/sys/fs/file-max 6815744
????/proc/sys/net/ipv4/ip_local_port_range 9000 65500
????/proc/sys/net/core/rmem_default 262144
????/proc/sys/net/core/rmem_max 4194304
????/proc/sys/net/core/wmem_default 262144
????/proc/sys/net/core/wmem_max 1048576
????/proc/sys/fs/aio-max-nr 1048576
???????vi?????????????/etc/sysctl.conf???????????????????
????fs.aio-max-nr = 1048576
????fs.file-max = 6815744
????kernel.shmall = 2097152
????kernel.shmmax = 536870912
????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
???????????????????????reboot???????????????????????????Ч??
????# /sbin/sysctl -p
????7???Oracle???????????????????????
????# su - oracle
????$ ulimit -Sn
????1024
????$ ulimit -Hn
????65536
????$ ulimit -Su
????2047
????$ ulimit -Hu
????16384
????$ ulimit -Ss
????10240
????$ ulimit -Hs
????32786
??????????????????/etc/security/limits.conf?????β?????????
????oracle soft nproc 2047
????oracle hard nproc 16384
????oracle soft nofile 1024
????oracle hard nofile 65536
????oracle soft stack 10240
????oracle hard stack 32768
????8??????Oracle???????????
?????????????????????????
????# df -k
???????????????????????
????# mkdir -p /u01/app/
????# chown -R oracle:oinstall /u01/app/
????# chmod -R 775 /u01/app/
????9??????Oracle????????
???????????????????????У????????в??????????????????ν???????
????# xhost +
????$ su - oracle
????$ xhost +
????$ echo $SHELL
????$ . ./.bash_profile
????$ w
????$ export DISPLAY=local_host:0.0
????$ echo $SHELL
????$ echo $DISPLAY
????$ xclock
????????????ssh?????????????ν??棬????????????????
????$ export DISPLAY=local_host:0.0
????$ xclock
????????ORACLE_BASE??ORACLE_SID?????μ????÷?????????????????????????л???????????
????$ ORACLE_BASE=/u01/app/oracle
????$ ORACLE_SID=orcl
????$ export ORACLE_BASE ORACLE_SID
???????????ORACLE_HOME??TNS_ADMIN
????$unset ORACLE_HOME
????$unset TNS_ADMIN
????10?????Oracle??????
??????? vmware-tool???????????????????????????????????
???????vmware??????????????Oracle???????????????
???????linux unzip?????Oracle???????????/u01/???£????????????£?
????# unzip /mnt/hgfs/share_file_dir/linux.x64_11gR2_database_1of2.zip /u01/
????# unzip /mnt/hgfs/share_file_dir/linux.x64_11gR2_database_2of2.zip /u01/
????11?????Oracle???????????
????# su - oracle
????$ ./runInstaller
????????????????У????????oracle??????????oracle??????????????????????????????????????????????oracle???????
????12???????????Oracle?????
????$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
????$ cd $ORACLE_HOME/bin
????$ ./dbca
????????????????п????????????????????????????????????????????????????
????$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
????$ cd $ORACLE_HOME/bin
????$ ./netca
????13??????????????
????# su - oracle
????$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
??????????????????ORACLE_SID??????????????????????????
????$ export ORACLE_SID=orcl
????$ cd $ORACLE_HOME/bin
????$ ./sqlplus /nolog
????SQL> conn / as sysdba
????SQL> startup nomount;
????SQL> alter database mount;
????SQL> alter database open;
????/*
???????
????????????????????(mount)??????????????
????ORA-01102: cannot mount database in EXCLUSIVE mode
????????????
????1????ORACLE_HOME/dbs/???? "sgadef<sid>.dbf" ???????lk<db_name> ???????????????????????????????
????2??oracle?? pmon?? smon?? lgwr and dbwr?????δ????????
????3????????????????????????????????á?
?????????????
????1??????????
????SQL> shutdown immediate
????2??fuser -u lk<db_name> ????? lk<db_name> ????????????
????$ /sbin/fuser -u lkGLOBAL_ORCL
????3????? fuser -k lk<db_name> ?????Щ???????lk<db_name>?????
????$ /sbin/fuser -k lkGLOBAL_ORCL
????4?????????????????
????$ /sbin/fuser -u lkGLOBAL_ORCL
????5??????????????
????SQL> startup nomount;
????SQL> alter database mount;
????SQL> alter database open;
????*/
????14????????????????????????????????????????????????????????sqlplus??????
????# su - oracle
????$ echo "export ORACLE_SID=orcl" >> /home/oracle/.bash_profile
????$ echo "export ORACLE_BASE=/u01/app/oracle" >> /home/oracle/.bash_profile
????$ echo "export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1" >> /home/oracle/.bash_profile
????$ echo "export TNS_ADMIN=$ORACLE_HOME/network/admin" >> /home/oracle/.bash_profile
????$ echo "export PATH=$ORACLE_HOME/bin:$PATH" >> /home/oracle/.bash_profile
????15??????ο????
????https://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#CEGHFFGG
????https://docs.oracle.com/cd/E11882_01/server.112/e25494/create.htm#ADMIN002
????https://docs.oracle.com/cd/E11882_01/server.112/e25494/start.htm#ADMIN004
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
Oracle ??????????Oracle?????????????Oracle?????????????ORACLE_NUMBER????Scale?0??????????Oracle 11g R2 ????????????Oracle??????????????????Oracle ?????????(TSPITR)Oracle?????????????Oracle??????????????oracle??????????????Oracle12.2?????????μ????????Oracle???????????????????Oracle???????????????????Oracle????MySQL?????????????oracle????????????????Oracle RAC?е????IP
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????