echo "192.168.0.
53 itpuxtjdb">> /etc/hosts
cat /etc/hosts
echo "export LANG=en_US" >> ~/.bash_profile
cat ~/.bash_profile
source ~/.bash_profile
/usr/sbin/groupadd -g 50001 oinstall
/usr/sbin/groupadd -g 50002 dba
/usr/sbin/groupadd -g 50003 oper
/usr/sbin/groupadd -g 50004 asmadmin
/usr/sbin/groupadd -g 50005 asmoper
/usr/sbin/groupadd -g 50006 asmdba
/usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle
/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
id grid
id oracle
passwd grid
passwd oracle
mkdir -p /oracle/app/grid
mkdir -p /oracle/app/11.2.0/grid
chown -R grid:oinstall /oracle
mkdir -p /oracle/app/oraInventory
chown -R grid:oinstall /oracle/app/oraInventory
mkdir -p /oracle/app/oracle
chown -R oracle:oinstall /oracle/app/oracle
chmod -R 775 /oracle
mount /dev/cdrom /mnt
cd /etc/yum.repos.d
mkdir bk
mv *.repo bk/
echo "[EL]" >> /etc/yum.repos.d/itpux.repo
echo "name =Linux 6.x DVD" >> /etc/yum.repos.d/itpux.repo
echo "baseurl=file:///mnt" >> /etc/yum.repos.d/itpux.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/itpux.repo
echo "enabled=1" >> /etc/yum.repos.d/itpux.repo
cat /etc/yum.repos.d/itpux.repo
# From Public Yum or ULN
yum install binutils -y
yum install compat-libcap1 -y
yum install compat-libstdc++-33 -y
yum install gcc -y
yum install gcc-c++ -y
yum install glibc -y
yum install glibc-devel -y
yum install ksh -y
yum install libgcc -y
yum install libstdc++ -y
yum install libstdc++-devel -y
yum install libaio -y
yum install libaio-devel -y
yum install libXext -y
yum install libXtst -y
yum install libX11 -y
yum install libXau -y
yum install libxcb -y
yum install libXi -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
yum install unzip -y
vi /etc/security/limits.conf
#ORACLE SETTING
grid soft nproc 16384
grid hard nproc 16384
grid soft nofile 65536
grid hard nofile 65536
grid soft stack 32768
grid hard stack 32768
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft stack 32768
oracle hard stack 32768
oracle hard memlock 7000000
oracle soft memlock 7000000
echo "session required pam_limits.so" >> /etc/pam.d/login
cat /etc/pam.d/login
vi /etc/sysctl.conf
#ORACLE SETTING
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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 = 1048586
kernel.panic_on_oops = 1
kernel.shmmax = 503316480
kernel.shmall = 1228800
kernel.shmmni = 4096
vm.nr_hugepages = 2500
sysctl -p
cat /sys/kernel/mm/transparent_hugepage/defrag
[always] madvise never
cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
vi /etc/rc.d/rc.local
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
chmod +x /etc/rc.d/rc.local
#yum install numactl -y
vi /boot/grub/grub.conf
kernel /boot/vmlinuz-2.6.18-.....console=tty1 crashkernel=128M@16M numa=off
numactl --hardware
vi /etc/inittab
vi /etc/fstab
none /dev/shm tmpfs defaults,size=6144m 0 0
mount -o remount /dev/shm
echo "SELINUX=disabled" > /etc/selinux/config
echo "#SELINUXTYPE=targeted " >> /etc/selinux/config
setenforce 0
service iptables stop
chkconfig --level 35 iptables off
#grid�û��Ļ������
vi ~/.bash_profile
PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
umask 022
#alias sqlplus="rlwrap sqlplus"
export TMP=/tmp
export LANG=en_US
export TMPDIR=$TMP
ORACLE_SID=+ASM; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_BASE=/oracle/app/grid; export ORACLE_BASE
ORACLE_HOME=/oracle/app/11.2.0/grid; export ORACLE_HOME
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
# Oracle Settings oracle
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
export LANG=en_US
ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME
ORACLE_SID=itpuxtjdb; export ORACLE_SID
export ORACLE_UNQNAME=itpuxtjdb
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export
CLASSPATH
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG
-----------------------------------------------------------
fdisk -l|grep "/dev/sd*"
vi /etc/udev/rules.d/99-oracle-asmdevices.rules
for i in c d e f g h;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --
replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted
--replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\",
GROUP=\"asmadmin\", MODE=\"0660\""
done
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29a4e7b53c16d51ecd0b047301f",
NAME="asm-grid01", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c298add6f5df8c8143718b47afd2",
NAME="asm-grid02", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29e1d464318fba013747c1c5bdb",
NAME="asm-grid03", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c2936de68710175d6cb9012ff24a",
NAME="asm-grid04", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29a37adc78a8978829be76a5d9a",
NAME="asm-grid05", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c295490fd4f712c0a9b70052bf8c",
NAME="asm-grid06", OWNER="grid", GROUP="asmadmin", MODE="0660"
for i in i j k l m n o p q s r t;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --
replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted
--replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\",
GROUP=\"asmadmin\", MODE=\"0660\""
done
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29aadc9eb5782ae095f969c179e",
NAME="asm-system01", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c299350425d38599ab784961e71f",
NAME="asm-system02", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29790d60d236c4cfe4f6ecdf2dc",
NAME="asm-data101", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c2915d35086583895e6e33b81e44",
NAME="asm-data102", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c295dd2e68aa0ad5ad225a0c4846",
NAME="asm-data103", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29b07b9bfd58dd3ee2b4d442498",
NAME="asm-data104", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c297245333b2437bfed33fc79488",
NAME="asm-data105", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29a2faf8bd229ba14f048d0d6fb",
NAME="asm-data106", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c2993635ed95552d0e1d4b398617",
NAME="asm-data107", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29ca4c8185cc4e601e69d8bf992",
NAME="asm-data108", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c293ed84f2b8cd826e77ae4a82db",
NAME="asm-data109", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29c8f2378af33b56c40b3876427",
NAME="asm-data110", OWNER="grid", GROUP="asmadmin", MODE="0660"
for i in u v w y;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --
replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted
--replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\",
GROUP=\"asmadmin\", MODE=\"0660\""
done
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29ae0a4c2d1fbcc3f83452165c1",
NAME="asm-archive01", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29dcc04f307c1e69ae9e2764a55",
NAME="asm-archive02", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c298f5676a9ee43722c239543ba7",
NAME="asm-archive03", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/$name", RESULT=="36000c29fb27ceb8fe6e9c54da9552af9",
NAME="asm-archive04", OWNER="grid", GROUP="asmadmin", MODE="0660"
/sbin/udevadm control --reload-rules
/sbin/start_udev
ls -lsa /dev/asm*
pvcreate /dev/sdz /dev/sdab /dev/sdac /dev/sdaa
vgcreate backvg /dev/sdz /dev/sdab /dev/sdac /dev/sdaa
lvcreate -n backuplv -L 6000000M backvg
pvs
vgs
lvs
mkfs.ext4 /dev/backvg/backuplv
vi /etc/fstab
/dev/backvg/backuplv /backup ext4 defaults 0 0
mkdir /backup
mount /backup
CREATE TABLESPACE tjdata01 DATAFILE '+dgdata01' SIZE 50M autoextend off
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
alter TABLESPACE tjdata01 add datafile '+dgdata01' SIZE 50M autoextend off;
create user itpux01 identified by itpux01 default tablespace tjdata01;
grant dba to itpux01;
conn itpux01/itpux01;
create table fgtable01(
id number,
name varchar2(20)
);
insert into fgtable01 values(1,'itpux1');
insert into fgtable01 values(2,'itpux2');
commit;
select * from fgtable01;
select * from dba_profiles where profile='DEFAULT';
alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;
alter system set audit_trail=none scope=spfile;
