문서유형ㅣ장애해결
분야ㅣ 관리/환경설정
적용제품버전ㅣ6FS07, 6FS07PS
오류코드ㅣ8103
문서번호ㅣTADTS079
현상
dba_profiles를 조회할 경우 TBR-8103 : Circular synonym detected. 에러가 발생합니다.
SQL> select * from dba_profiles; TBR-8103 : Circular synonym detected.
원인
dba_profiles는 SYSCAT 계정이 소유한 VIEW 객체이며, PUBLIC 계정에서는 해당 VIEW를 가리키는 SYNONYM 형태로 제공됩니다.
해당 VIEW 혹은 SYNONYM 상태가 INVALID 일 경우 해당 에러가 발생할 수 있습니다.
SQL> select owner,object_type, object_name,status from dba_objects where object_name = 'DBA_PROFILES'; OWNER OBJECT_TYPE OBJECT_NAME STATUS ------------------------------ ----------------------- ------------------------------ ------- PUBLIC SYNONYM DBA_OBJECTS INVALID SYSCAT VIEW DBA_OBJECTS INVALID 2 rows selected.
해결
$TB_HOME/scripts/sys_tbl.sql과 $TB_HOME/scripts/sys_profile.sql을 수행하여 dba_profiles를 재생성해줍니다.
$ tbsql sys/tibero tbSQL 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Connected to Tibero. SQL> @$TB_HOME/scripts/sys_tbl.sql Table '_TS_QUOTA' created. Table '_PROXY_INFO' created. Table '_PROXY_DATA' created. Table '_PROXY_ROLE_INFO' created. Table '_PROXY_ROLE_DATA' created. Sequence '_PROFILE_SEQ' created. ... (후략)... SQL> @$TB_HOME/scripts/sys_profile.sql Function 'NULL_VERIFY_FUNCTION' created. Function 'TB_COMPLEXITY_CHECK' created. Function 'TB_STRING_DISTANCE' created. Function 'VERIFY_FUNCTION' created. Function 'VERIFY_FUNCTION2' created. ... (후략)... SQL> select owner,object_type, object_name,status from dba_objects where object_name = 'DBA_PROFILES'; OWNER OBJECT_TYPE OBJECT_NAME STATUS ------------------------------ ----------------------- ------------------------------ ------- PUBLIC SYNONYM DBA_OBJECTS VALID SYSCAT VIEW DBA_OBJECTS VALID 2 rows selected. SQL> select * from dba_profiles; PROFILE ------------------------------------------------------------------------------------------- RESOURCE_NAME ------------------------------------------------------------------------------------------- RESOURCE_TYPE ------------- LIMIT ------------------------------------------------------------------------------------------- DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL_VERIFY_FUNCTION DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 DEFAULT PASSWORD_GRACE_TIME PASSWORD 0 DEFAULT LOGIN_PERIOD PASSWORD UNLIMITED DEFAULT SESSIONS_PER_USER UNKNOWN UNLIMITED 9 rows selected.