[tibero] TBR-7075 해결 방법.

2023. 9. 21. 17:22ㆍDatabase/tibero

728x90
728x90

TIBERO 서버의 생성된 계정에 CONNECT(외부 접속), RESOURCE(테이블 생성) ... 등 권한을 부여할 때, 하단과 같은 에러가 발생. 

SQL> GRANT CONNECT, RESOURCE TO anyt410_tibero7_daishin;
TBR-7075: Specified role 'CONNECT' was not found.

TBR-7075 해결 방법.

  • 티베로 서버를 노말모드로 기동한다.
  • $TB_HOME/scripts 경로에서 system.sh(role, system user, view, package … 생성을 위한 SQL 파일)을 실행한다.
  • system.sh와 관련된 옵션은 링크를 참고한다.
[$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.

system.sh 실행 후, TBR-7075 발생했던 쿼리를 실행.

SQL> GRANT CONNECT, RESOURCE TO anyt410_tibero7_daishin;
Granted.

 

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

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

[tibero] tibero7 설치 & 실행 가이드.(DB/계정/테이블스페이스 생성, tbsql 접속 ...)  (0) 2023.09.21
[tibero] tibero6 설치 & 실행 가이드.  (0) 2022.03.04
[tibero] 티베로 클라이언트에서 티베로 서버로 접속하는 방법.(tbdsn.tbr 설정 및 tbsql 사용 방법)  (0) 2021.11.04

티스토리툴바