Samuel's Project Nash

이 간단한 걸 한참 찾아 해맸네요.. ㅜㅜ

SELECT *
FROM sys.dba_tab_partitions
WHERE table_name = 'TABLE_NAME'

[auto_db_backup.sh]————————————————————-
#! /bin/bash
WEEKAGO=`date -d “-7 days” +%Y%m%d`
NOW=`date +%Y%m%d`
/oracle/product/9.2.0/bin/sqlplus /nolog <
connect / as sysdba
shutdown
exit
EOF
tar -cvf /work/db_backup/oradata_$NOW.tar /oradata
tar -cvf /work/app_backup/iepcs_tw_$NOW.tar /usr/local/tomcat4/webapps/ROOT
rm -f /work/db_backup/*_$WEEKAGO.tar
rm -f /work/app_backup/*_$WEEKAGO.tar
/oracle/product/9.2.0/bin/sqlplus /nolog <
connect / as sysdba
startup
exit
EOF
——————————————————————————–

[auto_ftp_send_data.sh]————————————————————-
#! /bin/bash
NOW=`date +%Y%m%d`
ftp -vn <
open 165.244.124.134
user pop “popadmin”
prompt
put /work/db_backup/oradata_$NOW.tar /oradata_$NOW.tar
bye
EOF
——————————————————————————–

[auto_ftp_send_apps.sh]————————————————————-
#! /bin/bash
NOW=`date +%Y%m%d`
ftp -vn <
open 165.244.124.134
user pop “popadmin”
prompt
put /usr/local/httpd/conf/httpd.conf /$NOW_httpd.conf
put /usr/local/httpd/workers.properties /$NOW_workers.properties
put /usr/local/tomcat4/conf/server.xml /$NOW_server.xml
put /usr/local/tomcat4/webapps/ROOT/WEB-INF/web.xml /$NOW_web.xml
put /home/oracle/.bash_profile /$NOW_oracle_bash_profile
put /work/app_backup/iepcs_tw_$NOW.tar /$NOW_iepcs_tw.tar
bye
EOF
——————————————————————————–

[crontab]———————————————————————–
0 23 * * * /home/oracle/auto_db_backup.sh
10 23 * * 0 /home/oracle/auto_ftp_send_data.sh
50 23 * * * /home/oracle/auto_ftp_send_apps.sh
분 시 일 월 요일 명령
——————————————————————————–

Setting Shared Memory

(root 계정으로 진행)
1. # cat /proc/sys/kernel/shmmax
2147483648
# echo 2147483648 > /proc/sys/kernel/shmmax
# sysctl -w kernel.shmmax=2147483648
# echo “kernel.shmmax=2147483648″ >> /etc/sysctl.conf
2. # cat /proc/sys/kernel/shmmni
4096
# echo 4096 > /proc/sys/kernel/shmmni
# sysctl -w kernel.shmmni=4096
# echo “kernel.shmmni=4096″ >> /etc/sysctl.conf
3 $ getconf PAGE_SIZE
4096
# cat /proc/sys/kernel/shmall
2097152
# echo 2097152 > /proc/sys/kernel/shmall
# sysctl -w kernel.shmall=2097152
# echo “kernel.shmall=2097152″ >> /etc/sysctl.conf

Creating Oracle User Accounts

4. su – root
groupadd dba # group of users to be granted with SYSDBA system privilege
groupadd oinstall # group owner of Oracle files
useradd -c “Oracle software owner” -g oinstall -G dba oracle
passwd oracle

Creating Oracle Directorieser

5. su – root
mkdir -p /u01/app/oracle/product/9.2.0
(mkdir -p /oracle/product/9.2.0)
chown -R oracle.oinstall /u01
(chown -R oracle.oinstall /oracle)
(chown -R oracle.oinstall /ora-data)

mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chmod 755 /var/opt/oracle

Setting Oracle Environments

6.
(oracle 계정으로 진행 # su – oracle)
# Set the LD_ASSUME_KERNEL environment variable only for Red Hat 9, 
# RHEL AS 3, and RHEL AS 4 !!
# Use the “Linuxthreads with floating stacks” implementation instead of NPTL:
export LD_ASSUME_KERNEL=2.4.1 # for RH 9 and RHEL AS 3
export LD_ASSUME_KERNEL=2.4.19 # for RHEL AS 4

# Oracle Environment
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=test
export ORACLE_TERM=xterm
# export TNS_ADMIN= Set if sqlnet.ora, tnsnames.ora, etc. are not in $ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export DISPLAY=127.0.0.1:0.0

# Set shell search paths
export PATH=$PATH:$ORACLE_HOME/bin

JDK
According to the JDK documentation, install JDK under /usr/local. Then create a symbolic link to the JDK under /usr/local/java: 
7. su – root
bzip2 -dc jdk118_v3-glibc-2.1.3.tar.bz2 | tar xf – -C /usr/local
ln -s /usr/local/jdk118_v3 /usr/local/java

8. radhat 9에 /usr/bin/gcc296을 gcc로 링크한다.
# su – root
# mv /usr/bin/gcc /usr/bin/gcc323
# ln -s /usr/bin/gcc296 /usr/bin/gcc
# mv /usr/bin/g++ /usr/bin/g++323 # if g++ doesn’t exist, then gcc-c++ was not installed
# ln -s /usr/bin/g++296 /usr/bin/g++

Uncompress and unpack downloaded files: For Oracle9i (9.2.0): 

8. # cd /work
# zcat ship_9204_linux_disk1.cpio.gz | cpio -idmv
9. # zcat ship_9204_linux_disk2.cpio.gz | cpio -idmv
10. # zcat ship_9204_linux_disk3.cpio.gz | cpio -idmv

11. # startx <- x윈도우 실행하고
# cd /oracle/Disk1
# ./runoraInstaller
11.1 오라클 인스톨러 실행중 한글이 깨져서 보일때
11.1.1 Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/fonts
위의 경로에 batang.ttc gulim.ttc mingliu.ttc (windows font) 세 파일을 복사해넣는다.
11.1.2 Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/fonts/fonts.dir
의 내용을 edit하여 다음 3라인을 추가한다. 
batang.ttc -ms-batang-medium-r-normal–0-0-0-0-c-0-ksc5601.1987-0 
gulim.ttc -ms-gulim-medium-r-normal–0-0-0-0-c-0-ksc5601.1987-0 
mingliu.ttc -ms-mingliu-medium-r-normal–0-0-0-0-c-0-ksc5601.1987-0
11.1.3 Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib
위의 경로에 font.properties.ko 파일을 추가한다

12. 오라클 인스톨러 실행중에 
‘/tmp/orainstRoot.sh’를 root 계정으로 실행하고 continue하란다.. 시키는데로 하자
12.1 인스톨 중, 끝부분에서 Linking 을 할때(84%) 쯤에, Error in invoking target install of makefile /Oracle/product/9.2.0/ctx/lib/ins_ctx.mk 에러메세지가 발생한다면
12.1.1 $vi $ORACLE_HOME/ctx/lib/env_ctx.mk 를 에디트
“INSO_LINK =” 이 부분에 “$(LDLIBFLAG)dl” 추가
예)
INSO_LINK = 
-L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)dl $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa 
$(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi 
$(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)

13. sys/sysadmin
14. system/sysadmin

15. #sqlplus /nolog
sql>connect sys/sysadmin as sysdba
sql>quit
#lsnrctl
lsnrctl>start
lsnrctl>quit