[tibero] tibero7 설치 & 실행 가이드.(DB/계정/테이블스페이스 생성, tbsql 접속 ...)

[tibero] tibero7 설치 & 실행 가이드.(DB/계정/테이블스페이스 생성, tbsql 접속 ...)

2023. 9. 21. 19:11ㆍDatabase/tibero

728x90

*설치 서버에서 수행되어야 하는 전수 작업(Ex. JDK 설치, OS별 패키지 설치, OS별 파라미터 …)은 링크를 참고하여 수행한다.

*티베로7을 설치하는 필자의 리눅스 서버 정보.

$ hostnamectl
   Static hostname: 
         Icon name: computer-desktop
           Chassis: desktop
        Machine ID: d9908b8943044e9f9fdd32c65bc2baa1
           Boot ID: c163bec4655f4b42a3433b512aabaa43
  Operating System: CentOS Linux 8
       CPE OS Name: cpe:/o:centos:centos:8
            Kernel: Linux 4.18.0-348.7.1.el8_5.x86_64
      Architecture: x86-64

*테크넷에서 수행해야하는 작업.

1.테크넷 접속.
2.설치 파일을 다운로드.

3.데모 라이센스를 다운로드.

4.다운로드한 tibero7-bin-FS02-linux64_3.10-254994.tar.gz, license.xml 파일을 서버로 이관.

*리눅스 서버에서 티베로7 설치 & 실행하기 위해서 수행하는 작업.

1.설치 파일의 압축을 해제.

$ tar -zxvf tibero7-bin-FS02-linux64_3.10-254994.tar.gz 
tibero7/bin/tbsvr
tibero7/bin/psmjavac
tibero7/bin/sm_sysmon_network_state.sh
tibero7/bin/tb_create_db.sh
tibero7/bin/sysalloc_summary.sh
tibero7/bin/tbcm
tibero7/bin/svr_rename.sh
tibero7/bin/tbiv
tibero7/bin/tbinfo
tibero7/bin/sm_sysmon_disk_io.sh
tibero7/bin/dbctl_for_cm.sh
tibero7/bin/tblistener
tibero7/bin/sm_sysmon_ps.sh
tibero7/bin/asdown
tibero7/bin/internal_svr_env.sh
tibero7/bin/sm_sysmon_network_io.sh
tibero7/bin/cm_res_exec.sh
tibero7/bin/sm_sysmon_disk_state.sh
tibero7/bin/tbcmobs
tibero7/bin/asboot
tibero7/bin/update/system_sh_pkgonly.sh
tibero7/bin/update/psm_recompile_all.sh
tibero7/bin/tbboot
tibero7/bin/tb_cert_manager
tibero7/bin/tbnetbench
tibero7/bin/base_env.sh
tibero7/bin/tbctl
tibero7/bin/cmrctl
tibero7/bin/tbprof
tibero7/bin/crfconf
tibero7/bin/tbcmbin
tibero7/bin/tbwallet_gen
tibero7/bin/alterdd.sh
tibero7/bin/svr_env.sh
tibero7/client/epa/java/lib/commons-collections.jar
tibero7/client/epa/java/lib/tbjavaepa.jar
tibero7/client/epa/java/lib/activation.jar
tibero7/client/epa/java/lib/commons-pool.jar
tibero7/client/epa/java/lib/mail.jar
tibero7/client/epa/java/lib/kuromoji-0.7.7.jar
tibero7/client/epa/java/config/epalog.properties
tibero7/client/epa/java/config/epalog4msl18.properties
tibero7/client/epa/java/config/epa.cfg
tibero7/client/lib/libtbpc.so
tibero7/client/lib/libtbxa.so
tibero7/client/lib/libtblr.so
tibero7/client/lib/libtboci.so
tibero7/client/lib/libdb2_ddlparser.so
tibero7/client/lib/libtbstr.so
tibero7/client/lib/libifmxparser.so
tibero7/client/lib/libtbextb.so
tibero7/client/lib/libdb2cblcv.so
tibero7/client/lib/libtbecbpp.so
tibero7/client/lib/libdb2_psmparser.so
tibero7/client/lib/libsqlite3_internal.so
tibero7/client/lib/libfancli.so
tibero7/client/lib/libsqltranscommon.so
tibero7/client/lib/libdb2ccv.so
tibero7/client/lib/libmariaparser.so
tibero7/client/lib/libtascomm.so
tibero7/client/lib/liboracle_sqlparser.so
tibero7/client/lib/libtupasm.so
tibero7/client/lib/libtsql_psmparser.so
tibero7/client/lib/libtbloader.so
tibero7/client/lib/libdb2parser.so
tibero7/client/lib/libtbclnt.so
tibero7/client/lib/libtbcliin.so
tibero7/client/lib/libtbertl_odbc.so
tibero7/client/lib/libclientcommon.so
tibero7/client/lib/libtbstat_v1.so
tibero7/client/lib/libtbicvt.so
tibero7/client/lib/libtbertl.so
tibero7/client/lib/libmod_tbpsm.so
tibero7/client/lib/libiparam.so
tibero7/client/lib/libtbstat.so
tibero7/client/lib/libcscli.so
tibero7/client/lib/liboracle_psmparser.so
tibero7/client/lib/libtbasc.so
tibero7/client/lib/libcscomm.so
tibero7/client/lib/libtbpcb.so
tibero7/client/lib/libtbecpp.so
tibero7/client/lib/libtbutil.so
tibero7/client/lib/libdatatype.so
tibero7/client/lib/libtbparser.so
tibero7/client/lib/libtbodbc.so
tibero7/client/lib/libtbmsg.so
tibero7/client/lib/libcommon.so
tibero7/client/lib/libtbcli.so
tibero7/client/lib/libtbprof.so
tibero7/client/lib/libsscli.so
tibero7/client/lib/libenv_client.so
tibero7/client/lib/libtbocci.so
tibero7/client/lib/libtascli.so
tibero7/client/lib/libtbeplutil.so
tibero7/client/lib/libtscli.so
tibero7/client/lib/libtbom_lite.so
tibero7/client/lib/libtbepl.so
tibero7/client/lib/jar/kryo-5.0.0-RC5.jar
tibero7/client/lib/jar/migrator_cli.jar
tibero7/client/lib/jar/hadoop-common-2.6.0.jar
tibero7/client/lib/jar/htools-0.27.jar
tibero7/client/lib/jar/swt_linux32.jar
tibero7/client/lib/jar/expimpv2.jar
tibero7/client/lib/jar/internal-jdbc-14.jar
tibero7/client/lib/jar/tibero7-jdbc-14.jar
tibero7/client/lib/jar/lz4-1.3.0.jar
tibero7/client/lib/jar/msllogger-14.jar
tibero7/client/lib/jar/internal-jdbc-16.jar
tibero7/client/lib/jar/tbopenjpa.jar
tibero7/client/lib/jar/msllogger-18.jar
tibero7/client/lib/jar/swt_win32.jar
tibero7/client/lib/jar/tibero7-jdbc-18.jar
tibero7/client/lib/jar/reflectasm-1.11.6.jar
tibero7/client/lib/jar/toolcom.jar
tibero7/client/lib/jar/wizard_cmd.jar
tibero7/client/lib/jar/swt_linux64.jar
tibero7/client/lib/jar/tibero7-jdbc-18-dbg.jar
tibero7/client/lib/jar/internal-jdbc-16-dbg.jar
tibero7/client/lib/jar/tibero7-jdbc.jar
tibero7/client/lib/jar/tibero7-jdbc-14-dbg.jar
tibero7/client/lib/jar/minlog-1.3.0.jar
tibero7/client/lib/jar/expimp.jar
tibero7/client/lib/jar/wizard_gui.jar
tibero7/client/lib/jar/swt_win64.jar
tibero7/client/lib/jar/commons-compress-1.20.jar
tibero7/client/lib/jar/forms_rt.jar
tibero7/client/lib/jar/internal-jdbc-14-dbg.jar
tibero7/client/lib/jar/tibero7-jdbc-dbg.jar
tibero7/client/lib/jar/objenesis-2.6.jar
tibero7/client/lib/jar/antlr4-runtime-4.3.jar
tibero7/client/lib/libclialloc.so
tibero7/client/lib/php/README
tibero7/client/lib/liblogloaderadapter.so
tibero7/client/lib/libmod_tbowa.so
tibero7/client/lib/libmio.so
tibero7/client/lib/libtbecommon.so
tibero7/client/lib/libdb2sqlcv.so
tibero7/client/lib/libtscli4.so
tibero7/client/lib/libtsqlparser.so
tibero7/client/config/tbimport_hl.config.default
tibero7/client/config/tbpcb.cfg
tibero7/client/config/tbc_file_id
tibero7/client/config/tbdfdump.cfg
tibero7/client/config/tbertl.cfg
tibero7/client/config/tbco_file_id
tibero7/client/config/tbpc.cfg
tibero7/client/config/gen_esql_cfg.sh
tibero7/client/include/stat_type.h
tibero7/client/include/sqlcli_types.h
tibero7/client/include/esql_lob.h
tibero7/client/include/stat_type_v1.h
tibero7/client/include/sqlcli_epl.h
tibero7/client/include/tsam4.h
tibero7/client/include/sqlcpr.h
tibero7/client/include/thr_type.list
tibero7/client/include/sqlca.h
tibero7/client/include/SQLCA
tibero7/client/include/sqlcli_ucode.h
tibero7/client/include/sqlcli_ext.h
tibero7/client/include/svrstat_type.h
tibero7/client/include/tbparser_interface.h
tibero7/client/include/stat_struct.h
tibero7/client/include/sqlcli_odbc.h
tibero7/client/include/extproc.h
tibero7/client/include/sqlda.h
tibero7/client/include/esql_api.h
tibero7/client/include/svr_stat_v1.h
tibero7/client/include/svrstat_type_v1.h
tibero7/client/include/tb_exdt.h
tibero7/client/include/svr_stat.h
tibero7/client/include/tsam.h
tibero7/client/include/tbutil.h
tibero7/client/include/tli.h
tibero7/client/include/sqlcli.h
tibero7/client/include/stat_struct_v1.h
tibero7/client/include/tbutil_cdecl.h
tibero7/client/include/xa.h
tibero7/client/bin/exportv2
tibero7/client/bin/tblogdump
tibero7/client/bin/tbbctviewer
tibero7/client/bin/tberr
tibero7/client/bin/sqlsy
tibero7/client/bin/importv2
tibero7/client/bin/tbepa
tibero7/client/bin/db2sqlconv
tibero7/client/bin/gw4db2_v10
tibero7/client/bin/tbhdreditor
tibero7/client/bin/tbicvt_db2
tibero7/client/bin/tbascmd
tibero7/client/bin/tbpcc
tibero7/client/bin/tblobdump
tibero7/client/bin/tbimportv2
tibero7/client/bin/tbwrap
tibero7/client/bin/tbsfcdump
tibero7/client/bin/oracle_sqlparse
tibero7/client/bin/tbinitdb
tibero7/client/bin/T-Up.zip
tibero7/client/bin/tbldprx
tibero7/client/bin/db2pli
tibero7/client/bin/gisLoader
tibero7/client/bin/libtbOCI_info
tibero7/client/bin/tbdb2ccv
tibero7/client/bin/shp2tibero
tibero7/client/bin/tbiobench
tibero7/client/bin/fan_cli
tibero7/client/bin/oracle_psm_sqlconv
tibero7/client/bin/table_migrator.zip
tibero7/client/bin/cepa_control
tibero7/client/bin/tbloader
tibero7/client/bin/db2_psm_sqlconv
tibero7/client/bin/import
tibero7/client/bin/gw_install.sh
tibero7/client/bin/tbpcb
tibero7/client/bin/tbcfdump
tibero7/client/bin/tbJavaGW.zip
tibero7/client/bin/tbdb2cblcv
tibero7/client/bin/tbjavaepa
tibero7/client/bin/gw4db2_v9
tibero7/client/bin/db2_ddl_sqlconv
tibero7/client/bin/assql
tibero7/client/bin/tbicvt
tibero7/client/bin/tbasdd
tibero7/client/bin/tbdb2sqlcv
tibero7/client/bin/tbdv
tibero7/client/bin/tbdfdump
tibero7/client/bin/tbpcbc
tibero7/client/bin/tbdc
tibero7/client/bin/runWizard.sh
tibero7/client/bin/tibero2shp
tibero7/client/bin/hldown
tibero7/client/bin/export
tibero7/client/bin/gw4orcl
tibero7/client/bin/tbpc
tibero7/client/bin/tbrmgr
tibero7/client/bin/tbdfmod
tibero7/client/bin/tbimport
tibero7/client/bin/tbsql
tibero7/client/bin/tbsql2
tibero7/client/bin/tbexportv2
tibero7/client/bin/tbexport
tibero7/client/bin/ifmxsqlconv
tibero7/client/ssl/openssl.cnf
tibero7/client/ssl/misc/CA.pl
tibero7/client/ssl/misc/tsget
tibero7/client/ssl/misc/tsget.pl
tibero7/client/ssl/openssl.cnf.dist
tibero7/client/ssl/ct_log_list.cnf.dist
tibero7/client/ssl/ct_log_list.cnf
tibero7/config/tip_jenkins.template
tibero7/config/ilog.map.example
tibero7/config/ssvr.template
tibero7/config/gen_tip_for_zeta.sh
tibero7/config/variant
tibero7/config/gen_tip_for_tac.sh
tibero7/config/cm.template
tibero7/config/gen_tip_for_ssvr.sh
tibero7/config/gen_psm_cmd.sh
tibero7/config/tip.template
tibero7/config/tas.template
tibero7/config/gen_tip.sh
tibero7/config/tibero.template
tibero7/config/tac.template
tibero7/lib/libspatial_c.so.0.4.5
tibero7/lib/libxqilla.so.3
tibero7/lib/libgeos_c.so.1
tibero7/lib/libspatial.so.0
tibero7/lib/libspatial_c.so.0
tibero7/lib/libspatial.so
tibero7/lib/libgeos_c.so
tibero7/lib/libxqilla.so
tibero7/lib/proj.db
tibero7/lib/libgeos_c.so.1.11.3
tibero7/lib/libspatial.so.0.4.5
tibero7/lib/libxerces-c-3.1.so
tibero7/lib/libgeos.so
tibero7/lib/libxqilla.so.3.3.0
tibero7/lib/libspatial_c.so
tibero7/lib/pkgconfig/xerces-c.pc
tibero7/lib/libgeos-3.7.3.so
tibero7/lib/libxerces-c.so
tibero7/scripts/tpr_stop.sql
tibero7/scripts/wizard_create_pkg_linux.properties
tibero7/scripts/tas_filecheck.sh
tibero7/scripts/cm_rc_gen.sh
tibero7/scripts/cm_auto_boot
tibero7/scripts/dpv.sql
tibero7/scripts/japanese_lexer_epa.sql
tibero7/scripts/system_check.sh
tibero7/scripts/outln.sql
tibero7/scripts/tbl_columns_recovery_FS01_or_less.sql
tibero7/scripts/odci.sql
tibero7/scripts/pkgbody_install.sh
tibero7/scripts/system_users_sod.sql
tibero7/scripts/sys_job.sql
tibero7/scripts/sv_dict.sql
tibero7/scripts/rewrite_table.sql
tibero7/scripts/systbl_workspacemanager.sql
tibero7/scripts/systbl_crypto_system.sql
tibero7/scripts/pkgspec_install.sh
tibero7/scripts/create_dba_sod_gen.sql
tibero7/scripts/tb_cert_viewer.sh
tibero7/scripts/vt_create_gen.sql
tibero7/scripts/cm_boot_cmd_repl.sh
tibero7/scripts/tpr_drop.sql
tibero7/scripts/system.sh
tibero7/scripts/hang_logging.sh
tibero7/scripts/install_chinese_lexer.sh
tibero7/scripts/systbl_create_agent.sql
tibero7/scripts/cm_down_cmd.sh
tibero7/scripts/mview_remote_install.sql
tibero7/scripts/catalogview.sql
tibero7/scripts/tudi.sql
tibero7/scripts/dd_sql_gen.sql
tibero7/scripts/report_stat_desc.sql
tibero7/scripts/client_policy.sql
tibero7/scripts/systbl_tpm.sql
tibero7/scripts/pkgspec_install_obj.sh
tibero7/scripts/ssvr_rc_gen.sh
tibero7/scripts/tbl_columns_recovery_FS02.sql
tibero7/scripts/systbl_tsn_timestamp.sql
tibero7/scripts/bininfo.py
tibero7/scripts/revalidate_viewnsyn.sql
tibero7/scripts/pkgbody_install_obj.sh
tibero7/scripts/iparam_desc_gen.sql
tibero7/scripts/wizard_create_pkg_windows.properties
tibero7/scripts/gis_register_units_of_measure.sql
tibero7/scripts/sys_profile.sql
tibero7/scripts/systbl_dbms_xmlschema.sql
tibero7/scripts/internal_svr_env.sh
tibero7/scripts/catalogview_sod.sql
tibero7/scripts/zeta_patch_manager.py
tibero7/scripts/wizard_create_pkg.properties
tibero7/scripts/cm_hacmp_check_cmd_aix.sh
tibero7/scripts/tpr_check_status.sql
tibero7/scripts/svr_thread_monitor.sh
tibero7/scripts/create_dba_gen.sql
tibero7/scripts/sa_label_function.sql
tibero7/scripts/create_additional_system_index.sql
tibero7/scripts/create_gis.sql
tibero7/scripts/systbl_parallel_execute.sql
tibero7/scripts/tpr.sql
tibero7/scripts/drop_stat_hist.sql
tibero7/scripts/sph_create_obj.sh
tibero7/scripts/systbl_server_alert.sql
tibero7/scripts/systbl_gen.sql
tibero7/scripts/plan_table.sql
tibero7/scripts/create_seq.sql
tibero7/scripts/stat_hist.sql
tibero7/scripts/cm_auto_boot.service
tibero7/scripts/systbl_rsrc.sql
tibero7/scripts/rmgr_cm_check.sh
tibero7/scripts/tbl_columns_redef_FS02.sql
tibero7/scripts/systbl_dbms_redact.sql
tibero7/scripts/sys_tbl.sql
tibero7/scripts/tpr_replenish.sql
tibero7/scripts/svr_set.sh
tibero7/scripts/ckpt_on_create.sql
tibero7/scripts/plustrace.sql
tibero7/scripts/tbl_columns_redef_FS01_or_less.sql
tibero7/scripts/cm_probe_cmd.sh
tibero7/scripts/systbl_label_security.sql
tibero7/scripts/systbl_lock.sql
tibero7/scripts/gis_register_default_srs.sql
tibero7/scripts/create_translation_profiles.sql
tibero7/scripts/sys_tbl_sod.sql
tibero7/scripts/cm_standby_cmd.sh
tibero7/scripts/vt_dual.sql
tibero7/scripts/cm_if_check_cmd_aix.sh
tibero7/scripts/systbl_job.sql
tibero7/scripts/sph_create_obj.sql
tibero7/scripts/cm_stat.sh
tibero7/scripts/cm_auto_down
tibero7/scripts/dpvx.sql
tibero7/scripts/tls_domination_function.sql
tibero7/scripts/zeta_patch_manager.yaml
tibero7/scripts/lock_waiter.sql
tibero7/scripts/tpr_create_obj.sql
tibero7/scripts/cm_import_res_from_file.sh
tibero7/scripts/systbl_scheduler.sql
tibero7/scripts/sod_setting.sql
tibero7/scripts/drop_additional_system_index.sql
tibero7/scripts/dpv_dict.sql
tibero7/scripts/tpr_create_obj.sh
tibero7/scripts/example_users.sql
tibero7/scripts/systbl_drop_agent.sql
tibero7/scripts/label_security_synonym.sql
tibero7/scripts/pkg/pkg_text_japanese_lexer.sql
tibero7/scripts/pkg/_pkg_dbms_xmlschema_obj.tbw
tibero7/scripts/pkg/_pkg_dbms_db2_translator.tbw
tibero7/scripts/pkg/pkg_ctx_output.sql
tibero7/scripts/pkg/_pkg_dbms_sqltune.tbw
tibero7/scripts/pkg/pkg_dbms_errlog.sql
tibero7/scripts/pkg/pkg_diutil.sql
tibero7/scripts/pkg/_pkg_dbms_mview_refresh_util.tbw
tibero7/scripts/pkg/pkg_utl_encode.sql
tibero7/scripts/pkg/pkg_dbms_geom.sql
tibero7/scripts/pkg/_pkg_dbms_utility.tbw
tibero7/scripts/pkg/_pkg_dbms_audit_event.tbw
tibero7/scripts/pkg/pkg_dbms_session.sql
tibero7/scripts/pkg/pkg_owa_util.sql
tibero7/scripts/pkg/pkg_dbms_scheduler.sql
tibero7/scripts/pkg/pkg_dbms_xmlgen_obj.sql
tibero7/scripts/pkg/_pkg_utl_recomp.tbw
tibero7/scripts/pkg/pkg_htf.sql
tibero7/scripts/pkg/_pkg_text_japanese_lexer.tbw
tibero7/scripts/pkg/pkg_dbms_pipe.sql
tibero7/scripts/pkg/pkg_tb_utility.sql
tibero7/scripts/pkg/_pkg_dbms_xmldom_obj.tbw
tibero7/scripts/pkg/_pkg_dbms_session.tbw
tibero7/scripts/pkg/_pkg_dbms_apm.tbw
tibero7/scripts/pkg/pkg_dbms_space_admin.sql
tibero7/scripts/pkg/pkg_dbms_obfuscation.sql
tibero7/scripts/pkg/pkg_utl_tcp.sql
tibero7/scripts/pkg/pkg_dbms_debug_jdwp.sql
tibero7/scripts/pkg/_pkg_dbms_mview.tbw
tibero7/scripts/pkg/pkg_dbms_stats_util.sql
tibero7/scripts/pkg/patch_task_229609.tbw
tibero7/scripts/pkg/pkg_dbms_xmldom.sql
tibero7/scripts/pkg/_pkg_dbms_metadata.tbw
tibero7/scripts/pkg/pkg_xmlinterface_obj.sql
tibero7/scripts/pkg/pkg_dbms_aq.sql
tibero7/scripts/pkg/_pkg_sys_util.tbw
tibero7/scripts/pkg/pkg_dbms_workspacemanager.sql
tibero7/scripts/pkg/uninstall_xmltype.sql
tibero7/scripts/pkg/_pkg_text_chinese_lexer.tbw
tibero7/scripts/pkg/_pkg_lbac_sa_labels.tbw
tibero7/scripts/pkg/pkg_dbms_redefinition.sql
tibero7/scripts/pkg/_pkg_dbms_sql_analyze.tbw
tibero7/scripts/pkg/pkg_dbms_backup_restore.sql
tibero7/scripts/pkg/pkg_dbms_rls.sql
tibero7/scripts/pkg/pkg_dbms_alert.sql
tibero7/scripts/pkg/pkg_dbms_sqltune_obj.sql
tibero7/scripts/pkg/_pkg_dbms_server_alert.tbw
tibero7/scripts/pkg/pkg_utl_smtp.sql
tibero7/scripts/pkg/pkg_dbms_sqltune.sql
tibero7/scripts/pkg/_pkg_dbms_spm.tbw
tibero7/scripts/pkg/_pkg_sa_components.tbw
tibero7/scripts/pkg/pkg_dbms_result_cache.sql
tibero7/scripts/pkg/pkg_dbms_rowid.sql
tibero7/scripts/pkg/pkg_sa_components.sql
tibero7/scripts/pkg/pkg_dbms_standard.sql
tibero7/scripts/pkg/pkg_utl_str.sql
tibero7/scripts/pkg/_pkg_dbms_parallel_execute.tbw
tibero7/scripts/pkg/_pkg_fan_ha.tbw
tibero7/scripts/pkg/pkg_htp.sql
tibero7/scripts/pkg/rollback_task_229609.tbw
tibero7/scripts/pkg/_pkg_db2_standard.tbw
tibero7/scripts/pkg/pkg_dbms_sanity.sql
tibero7/scripts/pkg/pkg_dbms_sql.sql
tibero7/scripts/pkg/pkg_dbms_odci.sql
tibero7/scripts/pkg/_pkg_dbms_xmlparser.tbw
tibero7/scripts/pkg/pkg_db2_standard.sql
tibero7/scripts/pkg/pkg_dbms_flashback.sql
tibero7/scripts/pkg/_pkg_dg_cipher.tbw
tibero7/scripts/pkg/pkg_utl_url.sql
tibero7/scripts/pkg/_pkg_dbms_errlog.tbw
tibero7/scripts/pkg/pkg_dbms_xmlsave.sql
tibero7/scripts/pkg/_pkg_fan_ha_uninstall.tbw
tibero7/scripts/pkg/_pkg_dbms_stats.tbw
tibero7/scripts/pkg/_pkg_dbms_xmldom.tbw
tibero7/scripts/pkg/_pkg_dbms_redact.tbw
tibero7/scripts/pkg/_pkg_client_appctx.tbw
tibero7/scripts/pkg/pkg_dbms_tpm.sql
tibero7/scripts/pkg/pkg_dbms_transaction.sql
tibero7/scripts/pkg/pkg_dbms_xmldom_obj.sql
tibero7/scripts/pkg/_pkg_dbms_workspacemanager.tbw
tibero7/scripts/pkg/pkg_dbms_output.sql
tibero7/scripts/pkg/pkg_dbms_space_sgmt_drop.sql
tibero7/scripts/pkg/install_xmltype.sql
tibero7/scripts/pkg/pkg_utl_file.sql
tibero7/scripts/pkg/_pkg_dbms_tpm.tbw
tibero7/scripts/pkg/_pkg_sa_label_admin.tbw
tibero7/scripts/pkg/pkg_dbms_ddl.sql
tibero7/scripts/pkg/pkg_dbms_mview_refresh_util.sql
tibero7/scripts/pkg/_pkg_sa_session.tbw
tibero7/scripts/pkg/_pkg_sa_user_admin.tbw
tibero7/scripts/pkg/_pkg_dbms_assert.tbw
tibero7/scripts/pkg/pkg_udt_meta.sql
tibero7/scripts/pkg/rollback_task_249213.tbw
tibero7/scripts/pkg/pkg_dbms_lob.sql
tibero7/scripts/pkg/pkg_dbms_metadata.sql
tibero7/scripts/pkg/_pkg_dbms_verify.tbw
tibero7/scripts/pkg/pkg_inst_cnt.sql
tibero7/scripts/pkg/_pkg_dbms_fga.tbw
tibero7/scripts/pkg/pkg_dbms_application_info.sql
tibero7/scripts/pkg/pkg_dbms_mssql_translator.sql
tibero7/scripts/pkg/pkg_dbms_xmlschema.sql
tibero7/scripts/pkg/xmltype.sql
tibero7/scripts/pkg/pkg_text.sql
tibero7/scripts/pkg/_pkg_dbms_sqltune_obj.tbw
tibero7/scripts/pkg/_pkg_rsc_measure.tbw
tibero7/scripts/pkg/pkg_dbms_stats.sql
tibero7/scripts/pkg/_pkg_dbms_backup_restore.tbw
tibero7/scripts/pkg/pkg_xmlinterface.sql
tibero7/scripts/pkg/create_pkg_text_tbl.sql
tibero7/scripts/pkg/pkg_utl_i18n.sql
tibero7/scripts/pkg/pkg_dbms_aq_utl.sql
tibero7/scripts/pkg/_pkg_dbms_xplan.tbw
tibero7/scripts/pkg/pkg_synonym.sql
tibero7/scripts/pkg/pkg_lbac_sa_labels.sql
tibero7/scripts/pkg/_pkg_utl_http.tbw
tibero7/scripts/pkg/pkg_sa_utl.sql
tibero7/scripts/pkg/pkg_dbms_server_alert.sql
tibero7/scripts/pkg/pkg_psm_sql_result_cache.sql
tibero7/scripts/pkg/pkg_dbms_expression.sql
tibero7/scripts/pkg/pkg_dbms_debug.sql
tibero7/scripts/pkg/pkg_dbms_tpr.sql
tibero7/scripts/pkg/pkg_dbms_fga.sql
tibero7/scripts/pkg/_pkg_sa_sysdba.tbw
tibero7/scripts/pkg/xmltype_test.sql
tibero7/scripts/pkg/_pkg_dbms_sql_translator.tbw
tibero7/scripts/pkg/pkg_sa_sysdba.sql
tibero7/scripts/pkg/_pkg_owa.tbw
tibero7/scripts/pkg/pkg_dbms_spm.sql
tibero7/scripts/pkg/_pkg_dbms_stats_util.tbw
tibero7/scripts/pkg/pkg_dbms_assert.sql
tibero7/scripts/pkg/pkg_dbms_types.sql
tibero7/scripts/pkg/_pkg_sa_policy_admin.tbw
tibero7/scripts/pkg/pkg_dbms_space.sql
tibero7/scripts/pkg/_pkg_dbms_rsrc.tbw
tibero7/scripts/pkg/pkg_dbms_lock.sql
tibero7/scripts/pkg/pkg_sys_util.sql
tibero7/scripts/pkg/pkg_sa_session.sql
tibero7/scripts/pkg/pkg_dbms_monitor.sql
tibero7/scripts/pkg/_pkg_htp.tbw
tibero7/scripts/pkg/pkg_dbms_crypto.sql
tibero7/scripts/pkg/pkg_dbms_mview_util.sql
tibero7/scripts/pkg/_pkg_dbms_geom.tbw
tibero7/scripts/pkg/pkg_dbms_mview.sql
tibero7/scripts/pkg/_pkg_dbms_mssql_translator.tbw
tibero7/scripts/pkg/pkg_dbms_sph.sql
tibero7/scripts/pkg/pkg_dg_cipher.sql
tibero7/scripts/pkg/pkg_dbms_parallel_execute.sql
tibero7/scripts/pkg/pkg_dbms_redact.sql
tibero7/scripts/pkg/pkg_dbms_utl_tb.sql
tibero7/scripts/pkg/pkg_dbms_job.sql
tibero7/scripts/pkg/pkg_dbms_sql_translator.sql
tibero7/scripts/pkg/_pkg_utl_url.tbw
tibero7/scripts/pkg/pkg_utl_compress.sql
tibero7/scripts/pkg/_pkg_dbms_xmlschema.tbw
tibero7/scripts/pkg/pkg_lbac_rls.sql
tibero7/scripts/pkg/_pkg_dbms_inmemory.tbw
tibero7/scripts/pkg/_pkg_utl_i18n.tbw
tibero7/scripts/pkg/_pkg_dbms_aqadm.tbw
tibero7/scripts/pkg/_pkg_dbms_redefinition_stats.tbw
tibero7/scripts/pkg/pkg_utl_http.sql
tibero7/scripts/pkg/pkg_dbms_repair.sql
tibero7/scripts/pkg/pkg_dbms_sql_analyze.sql
tibero7/scripts/pkg/pkg_dbms_rsrc.sql
tibero7/scripts/pkg/pkg_client_internal.sql
tibero7/scripts/pkg/pkg_dbms_xmlgen.sql
tibero7/scripts/pkg/_pkg_dbms_stats_submit.tbw
tibero7/scripts/pkg/_pkg_dbms_aq.tbw
tibero7/scripts/pkg/pkg_utl_recomp.sql
tibero7/scripts/pkg/pkg_utl_raw.sql
tibero7/scripts/pkg/pkg_sa_label_admin.sql
tibero7/scripts/pkg/pkg_dbms_inmemory.sql
tibero7/scripts/pkg/patch_task_249213.tbw
tibero7/scripts/pkg/pkg_standard.sql
tibero7/scripts/pkg/xmltype_install_checker.sql
tibero7/scripts/pkg/pkg_dbms_random.sql
tibero7/scripts/pkg/pkg_dbms_java.sql
tibero7/scripts/pkg/_pkg_dbms_verify_metadata_body.tbw
tibero7/scripts/pkg/pkg_dbms_db2_translator.sql
tibero7/scripts/pkg/uda_wm_concat.sql
tibero7/scripts/pkg/_pkg_dbms_xmlgen.tbw
tibero7/scripts/pkg/_pkg_dbms_xmlgen_obj.tbw
tibero7/scripts/pkg/pkg_dbms_aqadm.sql
tibero7/scripts/pkg/pkg_client_appctx.sql
tibero7/scripts/pkg/pkg_owa.sql
tibero7/scripts/pkg/pkg_inst_measure.sql
tibero7/scripts/pkg/pkg_dbms_utility.sql
tibero7/scripts/pkg/_pkg_dbms_utl_tb.tbw
tibero7/scripts/pkg/_uda_wm_concat.tbw
tibero7/scripts/pkg/pkg_dbms_parallel_execute_internal.sql
tibero7/scripts/pkg/pkg_dbms_redefinition_stats.sql
tibero7/scripts/pkg/pkg_tudiconst.sql
tibero7/scripts/pkg/pkg_standard_extension.sql
tibero7/scripts/pkg/pkg_synonym2.sql
tibero7/scripts/pkg/_pkg_dbms_verify_metadata_spec.tbw
tibero7/scripts/pkg/_pkg_dbms_mview_util.tbw
tibero7/scripts/pkg/anydata.sql
tibero7/scripts/pkg/_pkg_dbms_tpr.tbw
tibero7/scripts/pkg/pkg_utl_match.sql
tibero7/scripts/pkg/_pkg_text.tbw
tibero7/scripts/pkg/pkg_utl_ref.sql
tibero7/scripts/pkg/func_xmlidx.sql
tibero7/scripts/pkg/pkg_dbms_xmlparser.sql
tibero7/scripts/pkg/pkg_dbms_xmlschema_obj.sql
tibero7/scripts/pkg/pkg_dbms_xslprocessor.sql
tibero7/scripts/pkg/_pkg_dbms_parallel_execute_internal.tbw
tibero7/scripts/pkg/pkg_sa_user_admin.sql
tibero7/scripts/pkg/pkg_dbms_db_version.sql
tibero7/scripts/pkg/_pkg_dbms_sph.tbw
tibero7/scripts/pkg/pkg_seaf.sql
tibero7/scripts/pkg/pkg_dbms_xplan.sql
tibero7/scripts/pkg/pkg_dbms_xmlquery.sql
tibero7/scripts/pkg/_pkg_htf.tbw
tibero7/scripts/pkg/pkg_rsc_measure.sql
tibero7/scripts/pkg/_pkg_lbac_rls.tbw
tibero7/scripts/pkg/pkg_dbms_verify.sql
tibero7/scripts/pkg/pkg_dbms_system.sql
tibero7/scripts/pkg/_pkg_dbms_scheduler.tbw
tibero7/scripts/pkg/_pkg_utl_smtp.tbw
tibero7/scripts/pkg/_pkg_sa_utl.tbw
tibero7/scripts/pkg/pkg_dbms_ctx_ddl.sql
tibero7/scripts/pkg/pkg_sa_policy_admin.sql
tibero7/scripts/pkg/_pkg_dbms_xslprocessor.tbw
tibero7/scripts/pkg/_pkg_dbms_aq_utl.tbw
tibero7/scripts/pkg/pkg_text_chinese_lexer.sql
tibero7/scripts/catalogview_using_dpv.sql
tibero7/scripts/system_users.sql
tibero7/scripts/cm_boot_cmd.sh
tibero7/scripts/cm_runlevel_check_cmd.sh
tibero7/scripts/tpr_start.sql
tibero7/scripts/vt_drop_gen.sql
tibero7/license/oss_licenses/openssl.txt
tibero7/license/oss_licenses/openldap.txt
tibero7/license/oss_licenses/ICU_license.html
tibero7/license/oss_licenses/Apache_v2.txt
tibero7/license/oss_licenses/BSD_license.txt
tibero7/license/oss_licenses/LGPL_v2.txt
tibero7/license/oss_licenses/oss_licenses.txt
tibero7/license/oss_licenses/cmu.txt
tibero7/nls/zoneinfo/timezone_be.dat
tibero7/nls/zoneinfo/timezone_le.dat

2.환경변수 설정 후 적용.

$ vi .bash_profile
##tibero7 export path
export TB_HOME=/home/gunwoo/tibero7
export TB_SID=tibero
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin

$ . ./.bash_profile

3.라이선스 파일을 $TB_HOME/license 경로로 이관.

$ mv license.xml $TB_HOME/license/

4.$TB_HOME/config 경로에서 tibero7 설정 파일(tibero.tip, tbdsn.tbr, psm_commands)을 생성.

[$TB_HOME/config] $ ./gen_tip.sh 
Using TB_SID "tibero"
/home/gunwoo/tibero7/config/tibero.tip generated
/home/gunwoo/tibero7/config/psm_commands generated
/home/gunwoo/tibero7/client/config/tbdsn.tbr generated.
Running client/config/gen_esql_cfg.sh
Done.

5.NOMUNT MODE로 tibero7 서버 기동.

$ tbboot nomount
Listener port = 8629
Tibero 7  
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NOMOUNT mode).

6.tbsql을 사용해서 tibero7 서버로 접속.(sys는 계정명이며, tibero는 비밀번호이다.)

$ tbsql sys/tibero
tbSQL 7  
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL>

7.tibero7 서버에 DB 생성.(DB 이름은 4번에서 설정한 SID 이름과 동일해야 함.)

SQL> create database "tibero"
            user sys identified by tibero
            maxinstances 8
                maxdatafiles 100
                character set MSWIN949
            logfile group 1 'log001.log'
                             size 10M,
                    group 2 'log002.log'
                             size 10M,
                    group 3 'log003.log'
                              size 10M
            maxloggroups 255
            maxlogmembers 8
                noarchivelog
                       datafile 'system001.dtf'
                             size 10M
                             autoextend on next 5M
                             maxsize unlimited
            default temporary tablespace TEMP
                       tempfile 'temp001.dtf'
                             size 10M
                             autoextend on next 5M
                             maxsize unlimited
                             extent management local autoallocate
            undo tablespace UNDO
                       datafile 'undo001.dtf'
                             size 10M
                             autoextend on next 5M
                             maxsize unlimited
                             extent management local autoallocate;
Database created.

8.tbsql 종료.

SQL> exit
Disconnected.

9.NORMAL MODE로 tibero7 서버를 기동.

$ tbboot
Listener port = 8629
Tibero 7  
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

10.$TB_HOME/scripts 경로에서 system.sh(role, system user, view, package 생성을 위한 SQL 파일)을 실행.

[$TB_HOME/scripts] $ ./system.sh
Enter SYS password: 

Enter SYSCAT password: 

Creating additional system index...
Dropping agent table...
Creating client policy table ...
Creating text packages table ...
Creating the role DBA...
Create default system users & roles?(Y/N): 
Y

Creating system users & roles...
Creating example users...
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 tables related to dbms_job...
Creating system tables related to dbms_lock...
Creating system tables related to dbms_parallel_execute...
Creating system tables related to scheduler...
Creating system tables related to server_alert...
Creating system tables related to tpm...
Creating system tables related to tsn and timestamp...
Creating system tables related to rsrc...
Creating system tables related to workspacemanager...
Creating system tables related to statistics...
Creating system tables related to mview...
Create system tables related to dbms_xmlschema...
Create system tables related to dbms_redact...
Create system tables related to dbms_label_security...
Creating system package specifications:
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_standard.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_output.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_standard.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_standard_extension.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_xmlinterface.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_udt_meta.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_seaf.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/anydata.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_standard.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_db2_standard.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_application_info.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_aq.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_aq_utl.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_aqadm.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_assert.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_crypto.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_db2_translator.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_db_version.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_ddl.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_debug.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_debug_jdwp.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_errlog.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_expression.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_fga.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_flashback.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_geom.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_java.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_job.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_lob.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_lock.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_metadata.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_mssql_translator.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_mview.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_mview_refresh_util.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_mview_util.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_obfuscation.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_output.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_pipe.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_random.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_redefinition.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_redefinition_stats.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_repair.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_result_cache.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_rls.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_rowid.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_rsrc.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_scheduler.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_session.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_space.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_space_admin.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_sph.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_sql.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_sql_analyze.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_sql_translator.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_sqltune.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_stats.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_stats_util.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_spm.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_system.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_transaction.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_types.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_utility.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_utl_tb.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_verify.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_xmldom.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_xmlgen.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_xmlquery.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_xplan.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dg_cipher.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_htf.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_owa.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_htp.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_psm_sql_result_cache.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_sys_util.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_tb_utility.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_text.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_tudiconst.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_encode.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_file.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_tcp.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_http.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_url.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_i18n.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_match.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_raw.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_smtp.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_str.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_compress.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_text_japanese_lexer.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_tpm.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_recomp.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_monitor.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_server_alert.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_ctx_ddl.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_odci.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_utl_ref.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_alert.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_client_internal.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_xslprocessor.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/uda_wm_concat.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_diutil.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_xmlschema.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_sanity.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_xmlsave.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_xmlparser.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_space_sgmt_drop.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_client_appctx.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_redact.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_ctx_output.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_backup_restore.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_lbac_rls.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_lbac_sa_labels.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_sa_components.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_sa_label_admin.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_sa_policy_admin.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_sa_session.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_sa_sysdba.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_sa_user_admin.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_sa_utl.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_inmemory.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_parallel_execute_internal.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_parallel_execute.sql...
Creating auxiliary tables used in static views...
Create system tables related to profile?(Y/N): 
Y

Creating system tables related to profile...
Creating internal system tables...
Check TPR status..
Stop TPR
Create TPR tables?(Y/N): 
Y

Dropping tables used in TPR...
Creating auxiliary tables used in TPR...
Creating static views...
Creating static view descriptions...
Creating objects for sph:
    Running /home/gunwoo/tibero7/scripts/iparam_desc_gen.sql...
Creating dynamic performance views...
Creating dynamic performance view descriptions...
Creating additional static views using dpv...
Creating package bodies:
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_db2_standard.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_aq.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_aq_utl.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_aqadm.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_assert.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_db2_translator.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_errlog.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_fga.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_geom.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_metadata.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_mssql_translator.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_mview.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_mview_refresh_util.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_mview_util.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_redefinition_stats.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_rsrc.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_scheduler.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_session.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_sph.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_sql_analyze.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_sql_translator.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_sqltune.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_stats.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_stats_util.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_spm.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_utility.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_utl_tb.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_verify.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_workspacemanager.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_xmldom.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_xmlgen.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_xplan.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dg_cipher.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_htf.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_owa.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_htp.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_sys_util.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_text.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_utl_http.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_utl_url.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_utl_i18n.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_utl_smtp.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_text_japanese_lexer.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_tpm.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_utl_recomp.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_server_alert.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_xslprocessor.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_uda_wm_concat.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_xmlschema.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_xmlparser.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_client_appctx.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_redact.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_backup_restore.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_lbac_rls.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_lbac_sa_labels.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_sa_components.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_sa_label_admin.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_sa_policy_admin.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_sa_session.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_sa_sysdba.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_sa_user_admin.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_sa_utl.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_inmemory.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_parallel_execute_internal.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_parallel_execute.tbw...
Creating public synonyms for system packages...
Creating remaining public synonyms for system packages...
Register dbms_stats job to Job Scheduler?(Y/N):
Y

Registering dbms_stats job to Job Scheduler...
Creating audit event pacakge...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_audit_event.tbw...
Creating packages for TPR...
    Running /home/gunwoo/tibero7/scripts/pkg/pkg_dbms_tpr.sql...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_tpr.tbw...
    Running /home/gunwoo/tibero7/scripts/pkg/_pkg_dbms_apm.tbw...
Start TPR
Create tudi interface
    Running /home/gunwoo/tibero7/scripts/odci.sql...
Creating spatial meta tables and views ...
Registering default spatial reference systems ...
Registering unit of measure entries...
Creating internal system jobs...
Creating Japanese Lexer epa source ...
Creating internal system notice queue ...
Creating sql translator profiles ...
Creating agent table...
Done.
For details, check /home/gunwoo/tibero7/instance/tibero/log/system_init.log.

*사용자 계정 생성과 접속.

tbsql을 사용하여 sys 계정으로 접속.(tibero는 비밀번호를 의미하며, 초기 패스워드는 tibero로 설정된다.)

$ tbsql sys/tibero
tbSQL 7  
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.

테이블 스페이스 생성.

SQL> CREATE TABLESPACE anyt410_tibero7_daishin DATAFILE '/home/gunwoo/tibero7/database/tibero/anyt410_tibero7_daishin.dbf' SIZE 5M AUTOEXTEND ON NEXT 2M;
Tablespace 'ANYT410_TIBERO7_DAISHIN' created.

계정 생성.

SQL> CREATE USER anyt410_tibero7_daishin IDENTIFIED BY anyt410_tibero7_daishin DEFAULT TABLESPACE anyt410_tibero7_daishin;
User 'ANYT410_TIBERO7_DAISHIN' created.

생성한 계정에 CONNECT(외부 접속), RESOURCE(테이블 생성) 권한을 부여.

SQL> GRANT CONNECT, RESOURCE TO anyt410_tibero7_daishin;
Granted.

tbsql을 사용하여 생성한 계정으로 접속되는지 확인.

$ tbsql anyt410_tibero7_daishin/anyt410_tibero7_daishin
tbSQL 7  
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL>

티베로 클라이언트에서 티베로 서버로 접속하는 방법.

https://gomu92.tistory.com/31

728x90

저작자표시 비영리 변경금지

'Database > tibero' 카테고리의 다른 글

[tibero] TBR-7075 해결 방법. (0)	2023.09.21
[tibero] tibero6 설치 & 실행 가이드. (0)	2022.03.04
[tibero] 티베로 클라이언트에서 티베로 서버로 접속하는 방법.(tbdsn.tbr 설정 및 tbsql 사용 방법) (0)	2021.11.04

gomu92