Document Type | Troubleshooting
Category | Administration
Applicable Product Versions | 6FS07, 6FS07PS
Error Code | 8103
Document Number | TADTS079
Issue
When querying dba_profiles, the error TBR-8103: Circular synonym detected occurs.
SQL> select * from dba_profiles; TBR-8103 : Circular synonym detected.
Cause
dba_profiles is a VIEW object owned by the SYSCAT account and is provided as a SYNONYM pointing to that VIEW in the PUBLIC account.
If the VIEW or SYNONYM is in an INVALID state, this error may occur.
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.
Solutions
Run the scripts $TB_HOME/scripts/sys_tbl.sql and $TB_HOME/scripts/sys_profile.sql to recreate 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. ... (truncated)... 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. ... (truncated)... 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.