Document Type | Troubleshooting
Category | Administration
Applicable Product Versions | 6FS06, 6FS07, 7FS02
Error Code | 17004
Document Number | TADTS041
Issue
This situation occurs in Tibero Active Cluster (hereafter TAC), where users other than SYS with connection permissions can connect on one node of the same DB but cannot connect on another node.
When connecting via tbsql, error 17004 occurs at the prompt.
$ tbsql tibero/tmax@temp tbSQL 6 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. TBR-17004: Permission denied. -- Confirmed that the tbr file on one TAC node is set to a special port
Note
17004 Error: Permission denied.
Cause
When connecting through a special port, the sys user can connect normally, but other users receive error 17004 regardless of granted privileges such as connect or DBA.
Note
If the tbsql file lacks permissions, a permission denied error occurs at the OS terminal, and error 17004 does not occur.
Solutions
- Verify that the listener port in the tip file matches the port in the tbr file.
- Connect through the listener port.
$ tbsql sys/tibero@temp tbSQL 6 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Connected to Tibero using temp. SQL select * from dba_role_privs where grantee='TIBERO'; GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE ------------- ----------------- -------------- ------------ TIBERO DBA NO YES TIBERO CONNECT YES YES TIBERO RESOURCE YES YES 3 rows selected.