1. INGRIAN 계정 생성
# Oracle 관리자 접속 sqlplus sys/비밀번호 as sysdba REM 테이블 스페이스 생성 CREATE TABLESPACE ts_ingrian DATAFILE '/oradata/orcl/ingrian.dbf' SIZE 2M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE; REM 계정 생성 CREATE USER ingrian IDENTIFIED BY "비밀번호"; REM 테이블 스페이스 할당 ALTER USER ingrian DEFAULT TABLESPACE ts_ingrian; REM temp 테이블 스페이스 할당 ALTER USER ingrian TEMPORARY TABLESPACE TEMP; REM 비밀번호 수정 ALTER USER ingrian IDENTIFIED BY "비밀번호"; REM 모든 권한 주기 GRANT CONNECT, DBA, RESOURCE TO ingrian; |
2. ProtectDB 설치 (oracle 계정으로 설치)
$ ./install.sh install 07:02:36 - Info: SafeNet logging directory /tmp/inginstall already exists 07:02:36 - ........................................................ 07:02:36 - Beginning SafeNet Oracle's ProtectDB Installation 07:02:36 - 2016. 08. 17. (수) 07:02:36 KST 07:02:36 - ........................................................ 07:02:36 - Info: Mode = install Enter the password for the Oracle user SYS: ******** Confirm the password for the Oracle user SYS: ********
Enter the password for the Oracle user INGRIAN: ******** Confirm the password for the Oracle user INGRIAN: ******** 07:02:48 - Info: Creating ProtectDB Instance ID Please enter the ProtectDB Instance ID for this installation [5242-8514-17693-17347]: 07:02:49 - Using default ProtectDB Instance ID 07:02:49 - Info: Verifying ORACLE_HOME environment variable is set 07:02:49 - Success - using ORACLE_HOME: /opt/oracle/11g 07:02:49 - Info: Locating sqlplus executable 07:02:49 - Success - using sqlplus: /opt/oracle/11g/bin/sqlplus 07:02:49 - Info: Operating System - Linux Version - 2.6.9-103.0.0.0.1.ELsmp 07:02:49 - Info: Generic OS type set to Linux 07:02:49 - Info: Using Oracle version 11 07:02:49 - Info: Verifying login for user SYS 07:02:49 - Success 07:02:49 - Info: Verifying login for user INGRIAN 07:02:49 - Success 07:02:49 - Info: Checking if DBMS_LOB package installed. 07:02:50 - Success 07:02:50 - Info: Checking if connector is present. 07:02:50 - Success 07:02:50 - Info: Determining Oracle Architecture 07:02:50 - Using 64 Bit Oracle 07:02:50 - Info: Installing 64 bit shared libriaries 07:02:50 - Info: Granting required permissions to INGRIAN user 07:02:51 - Success 07:02:51 - Info: Checking object dependencies 07:02:51 - Success 07:02:51 - Info: Creating ProtectDB Database Schema 07:02:55 - Success 07:02:55 - Info: Creating ProtectDB lib directory /opt/oracle/11g/lib/safenet 07:02:55 - Success 07:02:55 - Info: Copying default ProtectDB.properties 07:02:55 - Info: Loading System Properties Default ProtectDB.properties is located in: /opt/oracle/11g/lib/safenet/ProtectDB.properties Enter full path to the properties file: /opt/oracle/11g/lib/safenet/ProtectDB.properties Enter the IP Address of the ProtectDB NAE Server: 10.10.10.86 Enter the Port of the ProtectDB NAE Server [9000]: Enter the full path for your ProtectDB Log File: /opt/oracle/11g/lib/safenet/protectdb.log No errors. + Property_File_Path = /opt/oracle/11g/lib/safenet/ProtectDB.properties 07:04:46 - Success 07:04:46 - Info: Registering Shared Libraries 07:04:46 - Success 07:04:46 - Info: Creating ProtectDB Stored Procedures 07:04:46 - Success 07:04:46 - Info: Installing ProtectDB Indexing Cartridge 07:04:52 - Success 07:04:52 - Info: Creating ProtectDB User Defined Functions 07:04:55 - Success 07:04:55 - Info: Inserting ProtectDB Instance ID 07:04:55 - Success 07:04:55 - Info: ProtectDB lib directory /opt/oracle/11g/lib/safenet already exists 07:04:55 - Info: Copying File 07:04:55 - Source - ./libingdb.so 07:04:55 - Destination - /opt/oracle/11g/lib/safenet/libingdb.so 07:04:55 - Success 07:04:55 - Info: Copying File 07:04:55 - Source - ./libstdc++.so.6 07:04:55 - Destination - /opt/oracle/11g/lib/safenet/libstdc++.so.6 07:04:55 - Success 07:04:55 - Info: Copying File 07:04:55 - Source - ./libgcc_s.so.1 07:04:55 - Destination - /opt/oracle/11g/lib/safenet/libgcc_s.so.1 07:04:55 - Success 07:04:55 - Info: Creating Symbolic Link 07:04:55 - Physical File - /opt/oracle/11g/lib/safenet/libstdc++.so.6 07:04:55 - Linked File - /opt/oracle/11g/lib/libstdc++.so.6 07:04:55 - Success 07:04:55 - Info: Creating Symbolic Link 07:04:55 - Physical File - /opt/oracle/11g/lib/safenet/libgcc_s.so.1 07:04:55 - Linked File - /opt/oracle/11g/lib/libgcc_s.so.1 07:04:55 - Success 07:04:55 - ..................................................................... 07:04:55 - Successfully Completed ProtectDB Oracle ProtectDB Installation 07:04:55 - 2016. 08. 17. (수) 07:04:55 KST 07:04:55 - ..................................................................... |