Livereorg QSA 설치

privatekim·2025년 6월 26일

Livereorg

QSA는 Quest Server Agent로 라이브리오그가 DBMS에 접근할 수 있게 해주는 agent이다.
QSA 설치 방법은 크게 2가지로 나뉜다.

Space Manager를 통한 GUI 설치
Manual기반의 CLI 설치

위 두 가지 방식에 대해 정리해보고자 한다.

DB와 통신이 가능한 상태여야 함

목표

QSA 설치

환경

client

OS : window 11
DBMS : oracle 19c
SW : livereorg 9.0

DBMS

OS : OEL7.9
DBMS : oracle 19c single

사전 요구사항

sqlnet.ora 설정

$ORACLE_HOME/network/admin/sqlnet.ora의 파일 내용에 다음 과 같은 값을 추가해 줘야한다.
(해당 파일이 없으면 생성해도 무관)

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 10
bequeath_detach=yes

OS user 생성

오라클 유저와 동일한 권한 부여

[live@ora19c ~]$ useradd -g dba -G dba live
[live@ora19c ~]$ passwd live

DB tablespace, user 생성

##tablespace 생성
SQL> create tablespace live datafile '...' size 200m autoextend on;

##user 생성
SQL> create user live identified by live default tablespace live;

##권한 부여
SQL> grant dba to live;
SQL> grant execute on DBMS_PIPE     to live;
SQL> grant execute on DBMS_SQL      to live;
SQL> grant execute on DBMS_SYS_SQL  to live;
SQL> grant execute on DBMS_LOB      to live;

Manual 설치

1. client의 환경에 설치되어 있는 QSA 설치 파일을 수동으로 target DB 서버에 전송한다.

C:\Program Files\Quest Software\Space Manager 9.0\QuestServerAgent 해당 경로의 Linux64-3.10-x86-Ora19_0.tar.Z파일을 서버에 전송하고 다음 명령어를 수행하여 압축을 해제한다.

[live@ora19c ~]$ uncompress Linux64-3.10-x86-Ora19_0.tar.Z
[live@ora19c ~]$ tar -xvf Linux64-3.10-x86-Ora19_0.tar
[live@ora19c ~]$ ls
Install.sh  Linux64-3.10-x86-Ora19_0.tar  Platform.sh  QSA  QSA_cpu_arch.sh  QSA_osmatch.sh  qsaparms.sh  Uninstall.sh

2. Install.sh 실행

[live@ora19c ~]$ ./Install.sh

*** Important Note ***

 Before continuing to install the Quest Server Agent,
 verify that your 'sqlnet.ora' file contains the option:

 bequeath_detach=yes

 Your 'sqlnet.ora' file should be located in the directory:

 '$ORACLE_HOME/network/admin'

 The 'sqlnet.ora' file may also be located in the directory
 name contained in the environment variable 'TNS_ADMIN'

Proceed (y/n):y

***********************
Platform: Linux
CPU Arch: x86
***********************





This script will allow you to install or upgrade the Quest
Server Agent running on Linux version 3.10.


Please supply ORACLE_SID and ORACLE_HOME for the database
instance:

ORACLE_SID [ORA19C]:
ORACLE_HOME [/u01/app/oracle/product/19.0.0/dbhome_1]:

...


Select a tablespace to store new database objects.


SYSTEM                                  931840       2304
SYSAUX                                  665600      35008
UNDOTBS1                                353280     327424
SPLEX                                   102400     101248
USERS                                     5120       2368
LIVE                                    204800     199808

Tablespace [LIVE]:LIVE








Please choose the base installation directory for the Quest
Server Agent.

Installation directory [/u01/app/oracle/product/19.0.0/dbhome_1]:/home/live




Ready to install

  QSA distribution        Linux64-3.10-x86-Ora19_0
  Oracle SID              ORA19C
  Oracle User             LIVE
  Oracle Tablespace       LIVE
  Server name             ora19c
  Operating System        Linux
  Install Directory       /home/live/Quest/QSA/ORA19C

Proceed (y/n):y

...

QSA Configuration Program

This program will allow you to view and modify the configuration
settings for the Quest Server Agent.

Quest Server Agent Parameters:

  ID   Valid Name                      Current Value
  ---- ----- ------------------------- -------------------------------------
  1    Yes   MAX_LOG_AGE               30
  2    Yes   MAX_HISTORY_AGE           365
  3    Yes   ALLOW_SECURITY_POLICIES   NO
  4    Yes   MAX_FILE_SIZE             1024MB
  5    Yes   DISKSPACE_RESERVE         10MB
  6    Yes   EXPORT_BUFFER_SIZE        32MB
  7    Yes   IMPORT_METHOD             CONVENTIONAL
  8    Yes   IMPORT_BUFFER_SIZE        32MB
  9    Yes   MULTIBLOCK_READ_COUNT     100
  10   Yes   COMMIT_SIZE               256MB
  11   Yes   COUNT_STAR                1
  12   No    LW_TABLESPACE
  13   Yes   LW_SEQ_CACHE_TRANS        100
  14   Yes   LW_SEQ_CACHE_POSTING      100
  15   Yes   LW_NULL_COLUMNS           32
  16   No    WORKDIR
  17   Yes   OVERFLOW_DIR_01
  18   Yes   OVERFLOW_DIR_02
  19   Yes   OVERFLOW_DIR_03
  20   Yes   OVERFLOW_DIR_04
  21   Yes   OVERFLOW_DIR_05
  22   Yes   SENDMAIL_DOMAIN
  23   Yes   SENDMAIL_HOST
  24   Yes   SENDMAIL_PORT
  25   Yes   SENDMAIL_FROM
  26   Yes   SENDMAIL_TO
  27   Yes   SENDMAIL_TO1
  28   Yes   LAP_PROCESS_COLLECTION    60
  29   Yes   LAP_DELAYED_TRANS         2
  30   Yes   LAP_STATS_INTERVAL        10
  31   Yes   LAP_TABLESPACE
  32   Yes   LAP_LOG_DIR
  33   Yes   QSA_INCLUDE_TLOCK_TABS    YES
  34   Yes   SNMP_TO_HOST
  35   Yes   SNMP_PORT                 0
  36   Yes   SNMP_COMMUNITY            QUEST LIVEREORG
  37   Yes   LOCKS_REPORTING           NO
  38   Yes   LOCKS_MAXIMUM_REPORTS     3
  39   Yes   LOCKS_SYSTEM_FILE_LOG     NO
  40   Yes   LOCKS_SYSTEM_FILE_APPEND  YES
  41   Yes   LOCKS_SCRIPT_LOG          YES
  42   Yes   LOCKS_CANCELLED_JOBS      YES
  43   Yes   LOCKS_WAIT_FOR_NOLOCKS    NO
  44   Yes   REPORT_LW_POSTING         YES
  45   Yes   SEND_GROUP_STATUS         NONE
  46   Yes   SEND_SCRIPT_START         NONE
  47   Yes   SEND_SCRIPT_RESTART       NONE
  48   Yes   SEND_SCRIPT_UNSCHEDULED   NONE
  49   Yes   SEND_SCRIPT_COMPLETE      NONE
  50   Yes   SEND_SCRIPT_CANCELLED     NONE
  51   Yes   SEND_SCRIPT_ABORT         NONE
  52   Yes   SEND_SCRIPT_HALTED        NONE
  53   Yes   SEND_SCRIPT_SCHEDULED     NONE
  54   Yes   SEND_LR_WAIT_WINDOW       NONE
  55   Yes   SEND_LR_IN_WINDOW         NONE
  56   Yes   SEND_LR_WAIT_APPROVAL     NONE
  57   Yes   SEND_LR_APPROVED          NONE
  58   Yes   SEND_LR_START             NONE
  59   Yes   SEND_LR_RESTART           NONE
  60   Yes   SEND_LR_COPY_START        NONE
  61   Yes   SEND_LR_COPY_COMPLETE     NONE
  62   Yes   SEND_LR_SWITCH_START      NONE
  63   Yes   SEND_LR_SWITCH_COMPLETE   NONE
  64   Yes   SEND_LR_COMPLETE          NONE
  65   Yes   SEND_LR_COMPLETE_DATA     NONE
  66   Yes   SEND_LR_COMPLETE_SUM      NONE
  67   Yes   SEND_LR_COMPLETE_TOTAL    NONE

Warning, not all parameters contain valid values

Do you wish to modify any of these parameters (y/n): y
Please enter the ID number of the parameter: 12


You are about to update the value for LW_TABLESPACE


Please enter the new value for LW_TABLESPACE

...

*** Warning ***
ASCII characters should be used for TABLESPACE names.
  LW_TABLESPACE [] LIVE

...

Do you wish to modify any of these parameters (y/n): 16

Please answer Y or N

...

Do you wish to modify any of these parameters (y/n): y
Please enter the ID number of the parameter: 16


You are about to update the value for WORKDIR


Please enter the new value for WORKDIR


*** Warning ***
ASCII characters should be used for DIRECTORY names.
  WORKDIR [] /home/live/Quest/QSA/work
No such directory as "/home/live/Quest/QSA/work"
Do you wish to create this directory (y/n): y


Do you wish to modify any of these parameters (y/n): n
Parameters updated



To have the server agent autostarted upon server boot-up, you'll
need to log in as "root" and perform the following commands:

    cd /home/live/Quest/QSA/ORA19C/inst
    ./root.sh

This script will create an /etc/qsatab file and install an rc
script so that the Quest Server Agent is started at boot-up
time.

설치 확인

[live@ora19c ~]$ ps -ef | grep qex
live     13656     1  0 16:23 pts/1    00:00:00 ./qexecd ORA19C /home/live/Quest/QSA/ORA19C
live     14034  3271  0 16:24 pts/1    00:00:00 grep --color=auto qex