CentOS¿¡ TIBERO 5 ¼³Ä¡Çϱâ
-¼³Ä¡ Àü Áغñ»çÇ×-
TIBERO¸¦ ¼³Ä¡ÇϱâÀü¿¡ ¼³Ä¡ÆÄÀÏ ¹× LICENSE ÆÄÀÏÀ» ¹Ì¸® ÁغñÇØ µÎµµ·Ï ÇÑ´Ù.
-¼³Ä¡ ÆÄÀÏ ´Ù¿î·Îµå-
´Ù¿î·Îµå °æ·Î : https://technet.tmaxsoft.com/ko/front/main/main.do
¼³Ä¡ÆÄÀÏÀ» ´Ù¿î·Îµå ¹Þ±â À§Çؼ´Â TechNet¿¡ ȸ¿ø°¡ÀÔÀ» ÇؾßÇÑ´Ù.
ȸ¿ø°¡ÀÔ ÈÄ ´Ù¿î·Îµå ÅÇ¿¡¼ µ¥ÀÌÅͺ£À̽º¸¦ ¼±ÅÃÇÑ´Ù
¿øÇÏ´Â ¹öÀüÀ» ¼±ÅÃÇÏ¿© ´Ù¿î·Îµå ÇÒ ¼ö ÀÖÀ¸¸ç, ÇÏ´Ü¿¡¼ ¿øÇÏ´Â OS¸¦ ¼±Åà ÇÒ ¼ö ÀÖ´Ù.
À̹ø ¼³Ä¡´Â CentOS¿¡ TIBERO 5¹öÀü ¼³Ä¡À̹ǷΠTibero 5 ´Ù¿î·Îµå¿¡ Linux ¼³Ä¡ÆÄÀÏÀ» ¹Þµµ·Ï ÇÑ´Ù.
-¶óÀ̼¾½º ¹ß±Þ-
Àӽà ¶óÀ̼¾½º´Â ·Î±×ÀÎâ ÇÏ´Ü¿¡ [µ¥¸ð¶óÀ̼¾½º ½Åû] ¹öÆ°À» Ŭ¸¯ÇÏ¿© ¹ÞÀ» ¼ö ÀÖ´Ù.
Host NameÀº ÀÚ½ÅÀÌ ¼³Ä¡ÇÒ ¼¹öÀÇ hostnameÀ» ÀûÀ¸¸é µÇ´Âµ¥ CentOS ¼¹ö¿¡¼ ¾Æ·¡¿Í °°Àº ¸í·É¾î·Î È®ÀÎ ÇÒ ¼ö ÀÖ´Ù.
[root@server1 ~]# hostname server1 |
-¼³Ä¡ ½ÃÀÛ-
1. OS À¯Àú »ý¼º
TIBERO¸¦ »ç¿ë ÇÒ OS À¯Àú¸¦ »ý¼ºÇÏ°í Æнº¿öµå ¼³Á¤À» ¼öÇàÇÑ´Ù.
[root@server1 ~]# groupadd dba [root@server1 ~]# useradd -d /tibero -g dba tibero Changing password for user tibero. New password: BAD PASSWORD: it is based on a dictionary word BAD PASSWORD: is too simple Retype new password: passwd: all authentication tokens updated successfully. [root@server1 ~]# |
2. PROFILE ¼öÁ¤
»ý¼ºÇÑ TIBERO °èÁ¤À¸·Î Á¢¼ÓÇÏ¿© profile ÇÏ´Ü¿¡ ¾Æ·¡³»¿ëÀ» Ãß°¡ÇØÁØ´Ù.
[root@server1 ~]# su - tibero [tibero@server1 ~]$ vi .bash_profile |
[.bash_profile Ãß°¡³»¿ë]
export TB_HOME=/tibero/tibero5 export TB_SID=tibero export TB_PROF_DIR=$TB_HOME/bin/prof export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin |
3. TIBERO ¼³Ä¡ÆÄÀÏ ¾ÐÃà ÇØÁ¦
´Ù¿î·Îµå ¹ÞÀº ¼³Ä¡ÆÄÀÏÀ» TIBERO °èÁ¤À¸·Î ¾ÐÃàÇØÁ¦¸¦ ¼öÇàÇÑ µÚ tibero5 Æú´õ°¡ Á¤»óÀûÀ¸·Î »ý¼ºµÇ¾ú´ÂÁö È®ÀÎÇÑ´Ù.
[tibero@server1 ~]$ tar -xvf tibero5-bin-5_rel_S1419-linux64-86442-tested-opt.tar [tibero@server1 ~]$ ls tibero5 tibero5-bin-5_rel_S1419-linux64-86442-tested-opt.tar |
4. ¶óÀ̼¾½º ÆÄÀÏ ¾÷·Îµå
¹ß±Þ¹ÞÀº license.xml ÆÄÀÏÀ» ¾Æ·¡ °æ·Î¿¡ ¾÷·Îµå ÇÑ´Ù.
°æ·Î : $TB_HOME/license
[tibero@server1 ~]$ cd $TB_HOME/license [tibero@server1 license]$ ls license.xml |
5. gen_tip.sh ÆÄÀÏ ½ÇÇà
$TB_SID.tip ÆÄÀÏÀÌ »ý¼ºµÇ´Â gen_tip.sh ÆÄÀÏÀ» ½ÇÇà½ÃÄÑÁØ´Ù.
¿©±â¼ ÆÄÀϸíÀº 2¹ø¿¡¼ TB_SID·Î ¼³Á¤ÇÑ °ªÀ¸·Î »ý¼ºÀÌ µÈ´Ù.
¸¸¾à ¸®½º³Ê Æ÷Æ®¸¦ º¯°æÇÏ°í ½Í´Ù¸é $TB_HOME/client/config/tbdsn.tbr ÆÄÀÏÀÇ Æ÷Æ®¿Í tibero.tip ÆÄÀÏÀÇ LISTENER_PORT¸¦ ÇÔ²² º¯°æÇØ ÁÖ¾î¾ß ÇÑ´Ù.
¼³Á¤ÀÌ ¿Ï·áµÇ¾úÀ¸¸é TIBERO¸¦ nomount·Î ½ÇÇà½ÃŲ´Ù.
°æ·Î : $TB_HOME/config
[tibero@server1 ~]$ cd $TB_HOME/config [tibero@server1 config]$ ls gen_tip.sh gen_tip.sh [tibero@server1 config]$ sh gen_tip.sh Using TB_SID "tibero" /tibero/tibero5/config/tibero.tip generated /tibero/tibero5/config/psm_commands generated /tibero/tibero5/client/config/tbdsn.tbr generated. Running client/config/gen_esql_cfg.sh Done. [tibero@server1 config]$ ls tibero.tip tibero.tip [tibero@server1 config]$ tbboot nomount Listener port = 8629 Tibero 5 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NOMOUNT mode). |
6. µ¥ÀÌÅͺ£À̽º »ý¼º
Ƽº£·ÎÀÇ µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇÏ´Â sql¹®À» ÀÛ¼ºÇÏ¿© ½ÇÇà½ÃÄÑÁØ´Ù.
[tibero@server1 ~]$ cd $TB_HOME/config [tibero@server1 config]$ vi create_db.sql |
[create_db.sql ³»¿ë]
CREATE DATABASE USER SYS IDENTIFIED BY TIBERO MAXDATAFILES 4096 CHARACTER SET UTF8 LOGFILE GROUP 0 ('redo01.redo') SIZE 50M, GROUP 1 ('redo11.redo') SIZE 50M, GROUP 2 ('redo21.redo') SIZE 50M MAXLOGFILES 100 MAXLOGMEMBERS 8 NOARCHIVELOG DATAFILE 'system001.dtf' SIZE 256M AUTOEXTEND ON NEXT 16M MAXSIZE 3072M DEFAULT TABLESPACE USR DATAFILE 'usr001.dtf' SIZE 128M AUTOEXTEND ON NEXT 16M MAXSIZE 3072M DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'temp001.dtf' SIZE 128M AUTOEXTEND ON NEXT 16M MAXSIZE 10240M EXTENT MANAGEMENT LOCAL AUTOALLOCATE UNDO TABLESPACE UNDO DATAFILE 'undo001.dtf' SIZE 128M AUTOEXTEND ON NEXT 16M MAXSIZE 10240M EXTENT MANAGEMENT LOCAL AUTOALLOCATE; |
[tibero@server1 config]$ tbsql sys/tibero tbSQL 5 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Connected to Tibero. SQL> @create_db.sql Database created. File finished. |
7. µñ¼Å³Ê¸® Å×ÀÌºí »ý¼º
µ¥ÀÌÅͺ£À̽º¸¦ ±¸¼ºÇÏ´Â µñ¼Å³Ê¸® Å×À̺íÀ» »ý¼ºÇÑ´Ù.
»ý¼º½ºÅ©¸³Æ®´Â $TB_HOME/scripts °æ·Î¿¡ ÀÖ´Â system.sh ÆÄÀÏÀ» ½ÇÇàÇÏ¿©ÁÖ¸é µÈ´Ù.
½ÇÇà¿¡ ¾Õ¼ ÇöÀç nomount·Î µÇ¾îÀÖ´Â ¼ºñ½º¸¦ mount ´Ü°è·Î ±¸µ¿½ÃÄÑÁØ´Ù.
SYSCAT Æнº¿öµå¸¦ ¹¯´Â°÷¿¡ syscatÀ» ÀÔ·ÂÇÏ°í, system.sh ¿¡¼ »ý¼ºÈ®ÀÎÀº ÀüºÎ Y·Î üũÇÏ°í ³Ñ¾î°£´Ù.
[tibero@server1 config]$ tbboot Listener port = 8629 Tibero 5 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode). tibero@server1 config]$ tbsql sys/tibero tbSQL 5 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Connected to Tibero. SQL> create user syscat identified by syscat; |
[tibero@server1 ~]$ cd $TB_HOME/scripts [tibero@server1 scripts]$ sh system.sh Enter SYS password: tibero Enter SYSCAT password: syscat Creating the role DBA... Create default system users & roles?(Y/N): y Creating system users & roles... Creating virtual tables(1)... Creating virtual tables(2)... Granting public access to _VT_DUAL... Creating the system generated sequences... Creating internal dynamic performance views... Creating outline table... Creating system packages: Running /tibero/tibero5/scripts/pkg/pkg_standard.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_output.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_lob.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_utility_internal.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_utility.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_obfuscation.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_transaction.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_space_admin.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_space.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_random.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_lock.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_system.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_job.sql... Running /tibero/tibero5/scripts/pkg/pkg_utl_raw.sql... Running /tibero/tibero5/scripts/pkg/pkg_utl_i18n.sql... Running /tibero/tibero5/scripts/pkg/pkg_utl_file.sql... Running /tibero/tibero5/scripts/pkg/pkg_utl_str.sql... Running /tibero/tibero5/scripts/pkg/pkg_tb_utility.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_rowid.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_repair.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_application_info.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_java.sql... Running /tibero/tibero5/scripts/pkg/pkg_utl_encode.sql... Running /tibero/tibero5/scripts/pkg/pkg_utl_url.sql... Running /tibero/tibero5/scripts/pkg/pkg_utl_http_internal.sql... Running /tibero/tibero5/scripts/pkg/pkg_utl_http.sql... Running /tibero/tibero5/scripts/pkg/pkg_utl_tcp.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_session.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_crypto.sql... Running /tibero/tibero5/scripts/pkg/pkg_tool_utility.sql... Running /tibero/tibero5/scripts/pkg/pkg_psm_sql_result_cache.sql... Running /tibero/tibero5/scripts/pkg/pkg_htp.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_result_cache.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_flashback.sql... Running /tibero/tibero5/scripts/pkg/pkg_seaf.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_debug_jdwp.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_expression.sql... Creating packages for sql: Running /tibero/tibero5/scripts/pkg/pkg_dbms_types.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_sql.sql... Creating public synonyms for system packages... Creating auxiliary tables used in static views... Creating system tables related to job... Create system tables related to profile?(Y/N): y Creating system tables related to profile... Creating static views... Creating static view descriptions... Creating packages for statistics: Running /tibero/tibero5/scripts/pkg/pkg_sys_util.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_stats_internal.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_stats.sql... Register dbms_stats job to Job Scheduler?(Y/N): y Registering dbms_stats job to Job Scheduler... Creating packages for log errors: Running /tibero/tibero5/scripts/pkg/pkg_dbms_errlog.sql... Creating packages for mview: Running /tibero/tibero5/scripts/rewrite_table.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_mview_util.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_mview.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_mview_refresh_util.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_redefinition_stats.sql... Running /tibero/tibero5/scripts/pkg/pkg_dbms_redefinition.sql... Creating packages for text: Running /tibero/tibero5/scripts/pkg/pkg_text.sql... Creating remaining public synonyms for system packages... Running /tibero/tibero5/scripts/iparam_desc_gen.sql... Running /tibero/tibero5/scripts/trace_event_desc_gen.sql... Creating dynamic performance views... Creating dynamic performance view descriptions... Check APM status.. Stop APM Create APM tables?(Y/N): y Dropping tables used in APM... Creating auxiliary tables used in APM... Replenish APM Tables if Updates Exist Running /tibero/tibero5/scripts/apm_replenish.sql... Creating packages for APM... Running /tibero/tibero5/scripts/pkg/pkg_dbms_apm.sql... Start APM Creating spatial meta tables and views ... Creating internal system tables... Done. For details, check /tibero/tibero5/instance/tibero/log/system_init.log. |
7. TIBERO Á¤»ó ÀÛµ¿ È®ÀÎ
Ƽº£·ÎÀÇ Process, Listener Port, µñ¼Å³Ê¸® Å×ÀÌºí µîÀÌ Á¤»óÀûÀ¸·Î Ãâ·ÂµÇ´ÂÁö È®ÀÎÇÑ´Ù.
[ÇÁ·Î¼¼½º È®ÀÎ]
[tibero@server1 ~]$ ps -ef | grep tibero tibero 3585 1 0 00:38 pts/0 00:00:00 /tibero/tibero5/bin/tblistener -t NORMAL -SVR_SID tibero tibero 3586 3585 0 00:38 pts/0 00:00:00 tbsvr -n 4 -t NORMAL -SVR_SID tibero tibero 3587 3586 0 00:38 pts/0 00:00:00 tbsvr_WT001 -n 4 -t NORMAL -SVR_SID tibero tibero 3588 3586 3 00:38 pts/0 00:00:03 tbsvr_WT002 -n 4 -t NORMAL -SVR_SID tibero tibero 3589 3586 0 00:38 pts/0 00:00:00 tbsvr_WT003 -n 4 -t NORMAL -SVR_SID tibero tibero 3590 3586 0 00:38 pts/0 00:00:00 tbsvr_SEQW -n 4 -t NORMAL -SVR_SID tibero tibero 3591 3586 0 00:38 pts/0 00:00:00 tbsvr_LOGW -n 4 -t NORMAL -SVR_SID tibero tibero 3592 3586 0 00:38 pts/0 00:00:00 tbsvr_LOGA -n 4 -t NORMAL -SVR_SID tibero tibero 3593 3586 0 00:38 pts/0 00:00:00 tbsvr_CKPT -n 4 -t NORMAL -SVR_SID tibero tibero 3594 3586 1 00:38 pts/0 00:00:01 tbsvr_BLKW000 -n 4 -t NORMAL -SVR_SID tibero |
[Æ÷Æ®¿ÀÇ ȮÀÎ]
[tibero@server1 ~]$ netstat -an | grep 8629 tcp 0 0 0.0.0.0:8629 0.0.0.0:* LISTEN |
[½Ã½ºÅÛÅ×À̺í È®ÀÎ]
[tibero@server1 scripts]$ tbsql sys/tibero tbSQL 5 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Connected to Tibero. SQL> ls NAME SUBNAME OBJECT_TYPE ---------------------------------- ----------------------- -------------------- APM_REPORT_DIR DIRECTORY APM_TIP_DIR DIRECTORY NULL_VERIFY_FUNCTION FUNCTION VERIFY_FUNCTION FUNCTION _GET_PART_BOUND_STR FUNCTION DRC$IDX_KEY INDEX DRC$IPV_KEY INDEX DRC$IP_KEY INDEX DRC$PPA_KEY INDEX DRC$PPA_NAME INDEX DRC$PP_KEY INDEX DRC$PP_NAME INDEX DRC$SL_KEY INDEX DRC$SL_UNIQ INDEX DRC$UPA_KEY INDEX DRC$UPA_NAME INDEX DRC$UPV_KEY INDEX HS$_BASE_CAPS_PK INDEX HS$_BASE_DD_PK INDEX HS$_BASE_DD_UK1 INDEX HS$_CLASS_CAPS_PK INDEX HS$_CLASS_CAPS_UK1 INDEX HS$_CLASS_DD_PK INDEX HS$_CLASS_DD_UK1 INDEX HS$_CLASS_INIT_PK INDEX ...... |
[Äõ¸® Á¤»óÀÛµ¿ È®ÀÎ]
SQL> select sysdate from dual; SYSDATE -------------------------------- 2016/11/18 |
Ãâó: https://anyinstaller.tistory.com/2 [Àâ´ÙÇÑ Installer]