Issue

tbdsn.tbr alias configured with two or more instances will cause the error TBR-12050: Connection error. Connect to a different server. when attempting to connect to that alias in Mount mode.

Cause

This is a normal throw intended to reduce user faults by clearly specifying the instance to connect to.

Solutions

• When connecting using an alias in Mount mode, the instance set in that alias must be unique.
• Modify the alias or connect using a different alias.

Test Scenario

$TB_HOME/client/config/tbdsn.tbr example

test1=(                           # Valid alias
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=test1)
    )
)

test2=(                          # Alias with two or more instance settings
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=test1)
    )
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=test1)
    )
)

tbsql connection example: Mount mode startup

$ tbboot mount
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).

$ tbsql sys/tibero@test1

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero using test1.

SQL> quit
Disconnected.

$ tbsql sys/tibero@test2

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

TBR-12050: Connection error. Connect to a different server.

SQL> quit

The TBR-12050 error occurs when connecting with the test2 alias.

tbsql connection example: Normal Mode startup

$ tbboot

Tibero instance terminated (NORMAL mode).

Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

$ tbsql sys/tibero@test1

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> quit
Disconnected.

$ tbsql sys/tibero@test2

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero using test2.

Unlike Mount mode, no error occurs.