[ORACLE] 아카이빙 모드 확인 하는법

아래 명령어로 아카이빙 모드 확인 및 대상 파일 위치 확인 가능함.

C:\Users\Administrator>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 7 08:10:54 2023

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            D:\archive
Oldest online log sequence     31974
Next log sequence to archive   31976
Current log sequence           31976

HSODBC를 이용하여 ORACLE에서 MSSQL로 DB LINK 하기

 [ 출처 : https://oracle.tistory.com/189 ]

Oracle DB가 Windows에 설치 되어 있어야 가능합니다.

제어판상의 ODBC 데이터 원본 관리자 -> 시스템 DSN에 추가(시스템 환경 32/64에 맞추어 설정 되어야 함)

Listener에 추가(10g일 경우 hsodbc, 11g일 경우 dg4odbc로 등록함)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
      (SID_NAME = MSSQL )
      (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = dg4odbc)
    )
  )

Tnsname.ora에추가

MSSQL =
 (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP )(PORT = 1521))
    (CONNECT_DATA = (SID = MSSQL ))
    (HS=OK)
  ) 

환경 설정 파일 새로 생성

E:\app\Administrator\product\11.2.0\dbhome_1\hs\admin\initMSSQL.ora

# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#

HS_FDS_CONNECT_INFO = MSSQL
HS_FDS_TRACE_LEVEL = 1
HS_DB_DOMAIN = MSSQL
HS_DB_NAME = MSSQL

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

설정이 완료되었으면 리스트 재 시작함.

lsnrctl stop / start

 

db link 생성

CREATE DATABASE LINK HSODBC
CONNECT TO user IDENTIFIED BY password USING tnsname; 

테이블 조회

SELECT * FROM table@hsodbc;

 

[Oracle] 테이블 관련 조회

 [참조 : https://gent.tistory.com/  https://m.blog.naver.com/  ]

Primary Key  & Index 조회 SQL

 SELECT A.TABLE_NAME,
       A.CONSTRAINT_NAME,
       B.COLUMN_NAME,     
       B.POSITION
  FROM ALL_CONSTRAINTS  A,
       ALL_CONS_COLUMNS B
 WHERE A.TABLE_NAME      = {Table_Name}
   AND A.CONSTRAINT_TYPE = 'P'
   AND A.OWNER           = B.OWNER
   AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
 ORDER BY B.POSITION

- View별 조회 내용

ALL_CONSTRAINTS : 현재 사용자가 엑세스할 수 있는 테이블에 대한 제약 조건 정의
USER_CONSTRAINTS : 현재 사용자의 스키마에 있는 테이블에 대한 제약 조건 정의
DBA_CONSTRAINTS :  데이터베이스의 모든 제약 조건 정의

Index 조회(또다른 방법-조회결과 약간 다름)

SELECT * FROM USER_INDEXES WHERE TABLE_NAME = {Table_Name}

 

# 인덱스명 변경하기(PK도 가능)
    ALTER INDEX 변경전이름 RENAME TO 변경후이름;

# 인덱스 REBUILD
alter index [인덱스명] rebuild tablespace [테이블스페이스명]
storage(initial 이니셜값 next 넥스트값 pctincrease 0) ;

# PRIMARY KEY 재생성
1.먼저 PRIMARY KEY 를 drop하세요.
  -> ALTER TABLE [테이블명] DROP PRIMARY KEY;
  -> ALTER TABLE [테이블명] DROP CONSTRAINT [PK명];

2.다시 PRIMARY KEY 를 만드세요.
  -> ALTER TABLE 테이블명 ADD CONSTRAINT PK명 PRIMARY KEY(컬럼1,컬럼2)
       USING INDEX TABLESPACE 테이블스페이스명 STORAGE (INITIAL 5K NEXT 2K PCTINCREASE 0)

[ORACLE] Table space 관련

 테이블 스페이스 삭제

drop tablespace [TABLE SPANE NAME] ;

아래와 같은 오류 발생시 테이블 스페이스내 의존선으로 연결된 부분이 있는 것으로  아래 SQL로 확인 후 제거하고 삭제 처리한다.

ORA-00604: error occurred at recursive SQL level 1
ORA-02429: cannot drop index used for enforcement of unique/primary key

SELECT  INDEX_NAME,  TABLE_NAME,  TABLESPACE_NAME
 FROM DBA_INDEXES
WHERE TABLESPACE_NAME= '[TABLE SPANE NAME]' ;

실행 결과를 복사하여 한번 실행한 후 테이블 스페이스를 삭제 한다.

SELECT
 'DROP TABLE ' || TABLE_OWNER||'.'|| TABLE_NAME || ' CASCADE CONSTRAINTS;'
FROM DBA_INDEXES
WHERE TABLESPACE_NAME= '[TABLE SPANE NAME]';

 

처리가 끝나면 물리적인 파일도 삭제 처리 한다.

윈도우 서버에서 영문 요일을 구하여 오라클 백업 배치 파일 작성

@echo off
for /f %%i in ('powershell ^(get-date^).DayOfWeek') do set week=%%i
cd c:\backup
del %week%_*.* /q

exp ID/PW file=%week%_backup.dmp log=%week%_backup.log statistics=none

Task Manager에서 작업할 내용을 추가

 - 로그인 안돼어 있을 경우에도 실행되도록 설정

 - 실행할 시간 설정

 - 수행할 배치 파일 설정

CentOS7 PHP7설치 및 오라클 모듈(oci8.so) 생성

[출처 : http://ellordnet.tistory.com/ / http://syanoe.com/ ]

1. PHP7 설치
  - epel-release 인스톨 및 yum 저장소를 업데이트 해 줍니다.

# yum install -y epel-release
# rpm -ivh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
# yum –enablerepo=remi update remi-release
# yum update
# php70 -v  <--설치 버전 확인
PHP 7.0.26 (cli) (built: Nov 21 2017 14:27:35) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies

# yum install php70 php70-php php70-php-gd php70-php-mbstring php70-php-mysqlnd

2.oracle-instantclient를 다운 받는다.
 - 11.2.0.4.0 버전으로 아래 두개의 파일을 다운 받는다.
  oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
  oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

 - 다운 받은 파일을 설치

# rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
# rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

 - oci8모듈소스를 다운 받는다.

[root@centos-linux ellord]# pecl install oci8
WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update
downloading oci8-2.1.8.tgz ...
Starting to download oci8-2.1.8.tgz (194,154 bytes)
.........................................done: 194,154 bytes
11 source files, building
running: phpize
Configuring for:
PHP Api Version:         20151012
Zend Module Api No:      20151012
Zend Extension Api No:   320151012
Please provide the path to the ORACLE_HOME directory. Use 'instantclient,/path/to/instant/client/lib' if you're compiling with Oracle Instant Client [autodetect] : instantclient,/usr/lib/oracle/11.2/client64/lib <--입력(설치 경로 등록)

 - 아래와 같이 자동 컴파일 진행됨.

building in /var/tmp/pear-build-root87TwHg/oci8-2.1.8
running: /var/tmp/oci8/configure --with-php-config=/usr/bin/php-config --with-oci8=instantclient,/usr/lib/oracle/11.2/client64/lib
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for a sed that does not truncate output... /usr/bin/sed
checking for cc... cc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether cc accepts -g... yes
checking for cc option to accept ISO C89... none needed
checking how to run the C preprocessor... cc -E
checking for icc... no
checking for suncc... no
checking whether cc understands -c and -o together... yes
checking for system library directory... lib
checking if compiler supports -R... no
checking if compiler supports -Wl,-rpath,... yes
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking target system type... x86_64-unknown-linux-gnu
checking for PHP prefix... /usr
checking for PHP includes... -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib
checking for PHP extension directory... /usr/lib64/php/modules
checking for PHP installed headers prefix... /usr/include/php
checking if debug is enabled... no
checking if zts is enabled... no
checking for re2c... no
configure: WARNING: You will need re2c 0.13.4 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking for Oracle Database OCI8 support... yes, shared
checking PHP version... 7.0.24, ok
checking OCI8 DTrace support... no
checking size of long int... 8
checking checking if we're on a 64-bit platform... yes
checking Oracle Instant Client directory... /usr/lib/oracle/11.2/client64/lib
checking Oracle Instant Client SDK header directory... /usr/include/oracle/11.2/client64
checking Oracle Instant Client library version compatibility... 11.1
checking how to print strings... printf
checking for a sed that does not truncate output... (cached) /usr/bin/sed
checking for fgrep... /usr/bin/grep -F
checking for ld used by cc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B
checking the name lister (/usr/bin/nm -B) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 1572864
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking how to convert x86_64-unknown-linux-gnu file names to x86_64-unknown-linux-gnu format... func_convert_file_noop
checking how to convert x86_64-unknown-linux-gnu file names to toolchain format... func_convert_file_noop
checking for /usr/bin/ld option to reload object files... -r
checking for objdump... objdump
checking how to recognize dependent libraries... pass_all
checking for dlltool... no
checking how to associate runtime and link libraries... printf %s\n
checking for ar... ar
checking for archiver @FILE support... @
checking for strip... strip
checking for ranlib... ranlib
checking for gawk... (cached) gawk
checking command to parse /usr/bin/nm -B output from cc object... ok
checking for sysroot... no
checking for mt... no
checking if : is a manifest tool... no
checking for dlfcn.h... yes
checking for objdir... .libs
checking if cc supports -fno-rtti -fno-exceptions... no
checking for cc option to produce PIC... -fPIC -DPIC
checking if cc PIC flag -fPIC -DPIC works... yes
checking if cc static flag -static works... no
checking if cc supports -c -o file.o... yes
checking if cc supports -c -o file.o... (cached) yes
checking whether the cc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
configure: creating ./config.status
config.status: creating config.h
config.status: executing libtool commands
running: make
/bin/sh /var/tmp/pear-build-root87TwHg/oci8-2.1.8/libtool --mode=compile cc  -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64  -DHAVE_CONFIG_H  -g -O2   -c /var/tmp/oci8/oci8.c -o oci8.lo
libtool: compile:  cc -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64 -DHAVE_CONFIG_H -g -O2 -c /var/tmp/oci8/oci8.c  -fPIC -DPIC -o .libs/oci8.o
/bin/sh /var/tmp/pear-build-root87TwHg/oci8-2.1.8/libtool --mode=compile cc  -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64  -DHAVE_CONFIG_H  -g -O2   -c /var/tmp/oci8/oci8_lob.c -o oci8_lob.lo
libtool: compile:  cc -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64 -DHAVE_CONFIG_H -g -O2 -c /var/tmp/oci8/oci8_lob.c  -fPIC -DPIC -o .libs/oci8_lob.o
/bin/sh /var/tmp/pear-build-root87TwHg/oci8-2.1.8/libtool --mode=compile cc  -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64  -DHAVE_CONFIG_H  -g -O2   -c /var/tmp/oci8/oci8_statement.c -o oci8_statement.lo
libtool: compile:  cc -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64 -DHAVE_CONFIG_H -g -O2 -c /var/tmp/oci8/oci8_statement.c  -fPIC -DPIC -o .libs/oci8_statement.o
/bin/sh /var/tmp/pear-build-root87TwHg/oci8-2.1.8/libtool --mode=compile cc  -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64  -DHAVE_CONFIG_H  -g -O2   -c /var/tmp/oci8/oci8_collection.c -o oci8_collection.lo
libtool: compile:  cc -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64 -DHAVE_CONFIG_H -g -O2 -c /var/tmp/oci8/oci8_collection.c  -fPIC -DPIC -o .libs/oci8_collection.o
/bin/sh /var/tmp/pear-build-root87TwHg/oci8-2.1.8/libtool --mode=compile cc  -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64  -DHAVE_CONFIG_H  -g -O2   -c /var/tmp/oci8/oci8_interface.c -o oci8_interface.lo
libtool: compile:  cc -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64 -DHAVE_CONFIG_H -g -O2 -c /var/tmp/oci8/oci8_interface.c  -fPIC -DPIC -o .libs/oci8_interface.o
/bin/sh /var/tmp/pear-build-root87TwHg/oci8-2.1.8/libtool --mode=compile cc  -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64  -DHAVE_CONFIG_H  -g -O2   -c /var/tmp/oci8/oci8_failover.c -o oci8_failover.lo
libtool: compile:  cc -I. -I/var/tmp/oci8 -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64 -DHAVE_CONFIG_H -g -O2 -c /var/tmp/oci8/oci8_failover.c  -fPIC -DPIC -o .libs/oci8_failover.o
/bin/sh /var/tmp/pear-build-root87TwHg/oci8-2.1.8/libtool --mode=link cc -DPHP_ATOM_INC -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/include -I/var/tmp/pear-build-root87TwHg/oci8-2.1.8/main -I/var/tmp/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/include/oracle/11.2/client64  -DHAVE_CONFIG_H  -g -O2   -o oci8.la -export-dynamic -avoid-version -prefer-pic -module -rpath /var/tmp/pear-build-root87TwHg/oci8-2.1.8/modules  oci8.lo oci8_lob.lo oci8_statement.lo oci8_collection.lo oci8_interface.lo oci8_failover.lo -Wl,-rpath,/usr/lib/oracle/11.2/client64/lib -L/usr/lib/oracle/11.2/client64/lib -lclntsh
libtool: link: cc -shared  -fPIC -DPIC  .libs/oci8.o .libs/oci8_lob.o .libs/oci8_statement.o .libs/oci8_collection.o .libs/oci8_interface.o .libs/oci8_failover.o   -L/usr/lib/oracle/11.2/client64/lib -lclntsh  -O2 -Wl,-rpath -Wl,/usr/lib/oracle/11.2/client64/lib   -Wl,-soname -Wl,oci8.so -o .libs/oci8.so
libtool: link: ( cd ".libs" && rm -f "oci8.la" && ln -s "../oci8.la" "oci8.la" )
/bin/sh /var/tmp/pear-build-root87TwHg/oci8-2.1.8/libtool --mode=install cp ./oci8.la /var/tmp/pear-build-root87TwHg/oci8-2.1.8/modules
libtool: install: cp ./.libs/oci8.so /var/tmp/pear-build-root87TwHg/oci8-2.1.8/modules/oci8.so
libtool: install: cp ./.libs/oci8.lai /var/tmp/pear-build-root87TwHg/oci8-2.1.8/modules/oci8.la
libtool: finish: PATH="/usr/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/sbin" ldconfig -n /var/tmp/pear-build-root87TwHg/oci8-2.1.8/modules
----------------------------------------------------------------------
Libraries have been installed in:
   /var/tmp/pear-build-root87TwHg/oci8-2.1.8/modules

if you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
   - add LIBDIR to the `LD_LIBRARY_PATH' environment variable
     during execution
   - add LIBDIR to the `LD_RUN_PATH' environment variable
     during linking
   - use the `-Wl,-rpath -Wl,LIBDIR' linker flag
   - have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------

Build complete.
Don't forget to run 'make test'.

running: make INSTALL_ROOT="/var/tmp/pear-build-root87TwHg/install-oci8-2.1.8" install
Installing shared extensions:     /var/tmp/pear-build-root87TwHg/install-oci8-2.1.8/usr/lib64/php/modules/
running: find "/var/tmp/pear-build-root87TwHg/install-oci8-2.1.8" | xargs ls -dils
  1252758   0 drwxr-xr-x. 3 root root     17 11월  7 17:46 /var/tmp/pear-build-root87TwHg/install-oci8-2.1.8
101046009   0 drwxr-xr-x. 3 root root     19 11월  7 17:46 /var/tmp/pear-build-root87TwHg/install-oci8-2.1.8/usr
  1252759   0 drwxr-xr-x. 3 root root     17 11월  7 17:46 /var/tmp/pear-build-root87TwHg/install-oci8-2.1.8/usr/lib64
 34473647   0 drwxr-xr-x. 3 root root     21 11월  7 17:46 /var/tmp/pear-build-root87TwHg/install-oci8-2.1.8/usr/lib64/php
 67823917   0 drwxr-xr-x. 2 root root     21 11월  7 17:46 /var/tmp/pear-build-root87TwHg/install-oci8-2.1.8/usr/lib64/php/modules
 67823918 584 -rwxr-xr-x. 1 root root 595672 11월  7 17:46 /var/tmp/pear-build-root87TwHg/install-oci8-2.1.8/usr/lib64/php/modules/oci8.so

Build process completed successfully
Installing '/usr/lib64/php/modules/oci8.so'
install ok: channel://pecl.php.net/oci8-2.1.8
configuration option "php_ini" is not set to php.ini location
You should add "extension=oci8.so" to php.ini

 - 생성 파일 확인 및 php.ini에 모듈 추가

# cd /usr/lib64/php/modules/
# ls
bz2.so       exif.so      gmp.so       mcrypt.so          pdo.so          pdo_sqlite.so  simplexml.so  sysvshm.so    xmlrpc.so
calendar.so  fileinfo.so  iconv.so     mysqlnd.so         pdo_dblib.so    pgsql.so       sockets.so    tokenizer.so  xmlwriter.so
ctype.so     ftp.so       imagick.so   mysqlnd_mysqli.so  pdo_mysqlnd.so  phar.so        sqlite3.so    wddx.so       xsl.so
curl.so      gd.so        json.so      oci8.so            pdo_odbc.so     posix.so       sysvmsg.so    xml.so        zip.so
dom.so       gettext.so   mbstring.so  odbc.so            pdo_pgsql.so    shmop.so       sysvsem.so    xmlreader.so

# chmod 755 oci8.so

# vi /etc/php.ini

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
extension=oci8.so