Skip to main content

Search

Welcome to Tibero GTS!

Users Other Than sys with Permissions Cannot Connect_17004 Error

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.
 
 
 

Related to