스터디그룹 > ORACLE,MYSQL DB관련 > [proc] proc Pro*C 리눅스에서 설치법, 설정, 파일참조

리눅스에서 설치법, 설정, Pro*C 개발, 웹과 연동등에 대해서 간략하면서도 필요한 내용이 잘 설명되어있습니다.

원래의 출처
http://otn.oracle.co.kr/tech/linux/seminar/index.html

[ 리눅스를 위한 오라클 Oracle8i(version 8.1.5) 설치 ]
- KDE Linux Booting -

0. 커널 컴파일
   [root:/usr/src/linux/include/asm]$ shmparam.h
   [root:/usr/src/linux/include/linux]$ sem.h
SHMMAX 4294967295
SHMMIN 1
SHMMNI 100
SHMSEG 10
SEMMNS 200
SEMMNI 100
SEMMSL PROCESSES+10
SEMOPM 100
SEMVMX 32767

1. 다운로드(www.blackdown.org)
   download/hongkong/JDK-1.1.7/i386/glibc/v3/jdk_1.1.7-v3-glibc-x86.tar.gz
   jre_1.1.7-v3-glibc-x86.tar.gz

2. jdk, jre 설치
   [root:/usr/local]$ tar -xvzf jdk_1.1.7-v3-glibc-x86.tar.gz
   jre_1.1.7-v3-glibc-x86.tar.gz
   [root:/usr/local]$ jdk117_v3, jre117_v3
   [root:/usr/local]$ ln -s jdk117_v3 jdk, ln -s jre117_v3 jre

3. 그룹, 유저 생성
   [root:]$ groupadd -g 5000 dba
   [root:]$ useradd -g dba -d /home/oracle -s /bin/bash -c Oracle8i -n oracle
   [root:]$ passwd oracle

4. 경로 설정 파일 편집(bashrc Edit)
   [root:/etc]$ vi bashrc
   export JRE_HOME=/usr/local/jre
   export JAVA_HOME=/usr/local/jdk
   export JSDK_HOME=/usr/local/jsdk
   export ORACLE_HOME=/home/oracle
   export OSDK_HOME=/home/osdk
   export ORACLE_SID=ORCL
   export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
   export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib

   export PATH=$JRE_HOME/bin:$JAVA_HOME/bin:$JSDK_HOME/bin:$ORACLE_HOME/bin:$PATH
   export CLASSPATH=$CLASSPATH:$JRE_HOME/lib/rt.jar:$JAVA_HOME/lib/classes.zip:$JSDK_HOME/lib/jsdk.jar:$OSDK_HOME/lib/classes111.zip:$ORACLE_HOME/jdbc/lib/classes111.zip:$ORACLE_HOME/jdbc/lib/nls_charset11.zip:$ORACLE_HOME/sqlj/lib/translator.zip:.
   [root:/etc]$ source bashrc
   [root:/etc]$ java -version
   [root:/etc]$ javap oracle.jdbc.driver.OracleDriver

5. display, mount RunInstaller
   [root:]$ su - oracle
   [oracle:]$ umask 022
   [oracle:]$ DISPLAY=localhost:0.0
   [oracle:]$ export DISPLAY
   [root:]$ xhost + localhost
   [root:]$ mount -t iso9660 /dev/cdrom /mnt/cdrom
   [oracle:/mnt/cdrom/ora815se]$ ./runInstaller
   or gnome Linux [oracle:/mnt/cdrom/ora815se/install/linux]$ ./runIns.sh

6. runInstaller..
   [root:]$ chmod a+w tmp
   [root:/tmp/OraInstall]$ ./orainstRoot.sh
   Inventory create = /home/oracle/Inventory
   [root:/home/oracle]$ chmod a+x root.sh
   [root:/home/oracle]$ ./root.sh

-----------------------------------------------------------------------
[ 데모 데이타베이스 생성 ]

1. [oracle: /home/oracle/sqlplus/admin]$ work directory
   $ svrmgrl
   SVRMGR> connect internal;
   SVRMGR> startup;
   SVRMGR> connect system/manager
   SVRMGR> @pupbld.sql
   SVRMGR>

2. [oracle: /home/oracle/sqlplus/demo]$ work directory
   $ sqlplus scott/tiger
   SQL> @demobld
   $

------------------------------------------------------------------------

[ 오라클 DB 서버 기동하기 ]

1. oracle account login
   $ svrmgrl
   SVRMGR> connect internal;
   SVRMGR> startup;
   SVRMGR> shutdown;
   SVRMGR> exit;
   $

2. DB User Create
   $ svrmgrl
   SVRMGR> connect internal;
   SVRMGR> startup;
   SVRMGR> create user scott identified by tiger
   default tablespace users
   temporary tablespace temp
   quota unlimited on users;
   SVRMGR> grant connect to scott;
   SVRMGR> exit;

3. DB connect
   $ sqlplus scott/tiger
   SQL> select table_name from tabs;
   SQL> desc dept;
   SQL> select * from dept;

4. remote DB connect - server listener.ora, client tnsnames.ora
   Edit host, oracle_home, sid_name, global_dbname

serever[oracle:/home/oracle/network/admin]$ vi listener.ora
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host=129.200.9.39)(Port= 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= www.toconet.co.kr.)
(ORACLE_HOME= /home/oracle)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /home/oracle)
(PROGRAM = extproc)
)
)
serever[oracle:/home/oracle/network/admin]$ lsnrctl start LISTENER
serever[oracle:/home/oracle/network/admin]$ netassit
client_server[oracle:/home/oracle/network/admin]$ vi tnsnames.ora
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
(CONNECT_DATA = (SID = extproc))
)
ORA8i =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 129.200.9.39)(Port= 1521))
(CONNECT_DATA = (SID = ORCL))
)
ORA8linux22 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 129.200.9.22)(Port= 1521))
(CONNECT_DATA = (SID = ORA8))
)
ORA8nt =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 129.200.9.100)(Port= 1521))
(CONNECT_DATA = (SID = ORCL))
)
ORA8i_BEQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /home/oracle)
   (argv0 = oracleORA8i)
   (args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
   (envs = 'ORACLE_HOME=/home/oracle,ORACLE_SID=ORCL')
)
)
$ tnsping ORA8i
$ lsnrctl start
$ lsnrctl status
client_server[oracle:]$ sqlplus scott/tiger@ORA8i
client_server[oracle:]$ sqlplus unro/unro@ORA8linux22
client_server[oracle:]$ sqlplus moct/moct@ORA8nt
client_server[oracle:]$ sqlplus system/manager@ORA8i ;

--------------------------------------------------------------------------

[ 문제 해결 및 활용팁 ]

1. 데이타 인서트가 안될 때 Rollback Segment Error(insert not problem)
   [oracle: /home/oracle/dbs]$ vi init<sid>.ora
   #rollback_segments # delete
   rollback_segments

2. 리눅스 부팅시 오라클 자동 기동되게 하기
   [root: /etc/rc.d]$ vi rc.local
   if [ ! -f /home/oracle/bin/dbstart -o ! -d /home/oracle ]; then
echo "Oracle startup: cannot start"
exit
   fi
   case "$1" in
   'start')
   echo "Start ORACLE Daemon..."
   su - oracle -c "/home/oracle/bin/dbstart"
   su - oracle -c "/home/oracle/bin/lsnrctl start"
   ;;
   'stop')
   echo "Stop ORACLE Daemon..."
   su - oracle -c "/home/oracle/bin/dbshut"
   su - oracle -c "/home/oracle/bin/lsnrctl stop"
   ;;
   esac

[ Proc*C 설치 ]

0. $ ./runInstaller -> next -> next -> Oracle Programmer 8.1.5.0.0
   # If Oracle8i install successfull, during setup not confiuration

1. precomp admin 설정

/home/oracle/precomp/admin]$ vi pcscfg.cfg
sys_include=($ORACLE_HOME/precomp/public,/usr/include,/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/include)
include=($ORACLE_HOME/precomp/public)
include=($ORACLE_HOME/rdbms/demo)
include=($ORACLE_HOME/network/public)
include=($ORACLE_HOME/plsql/public)
ltype=short

2. precomp lib 설정

/home/oracle/precomp/lib]$ vi env_precomp.mk
153line   $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) -lc -laio $(MATHLIB) $(USRLIBS)
-laio delete
   $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) -lc $(MATHLIB) $(USRLIBS)

[ import & export ]

1. Tape로 Export/Import하기

* TAPE DEVICE로 EXPORT받기.
% exp userid=system/manager full= y file=/dev/rmt/0m volsize=245

FILE은 TAPE이 있는 DEVICE 이름이고 VOLSIZE는 TAPE에 들어갈 DATA의
SIZE이다. 만약 첫번째 TAPE이 245M에 이르게 되면 다음 TAPE를 넣으라는
message가 나온다.

* TAPE DEVICE에서 IMPORT받기.
% imp userid=system/manager full=y file=/dev/rmt/0m volsize=245M
첫번째 TAPE이 245M에 이르면 다음 TAPE를 위한 message가 나온다.

*참고* volsize=0 의 의미는 tape 으로 화일을 보낼때 제한을 두지 않음
(no limit) 을 의미 합니다

2. Export file size prev view

   $ mknod /tmp/exp_pipe p
   $ exp file=/tmp/exp_pipe <other option> &
   $ dd if=/tmp/exe_pipe of=/dev/null bs=1024
64+0 records out