Document Type | Troubleshooting
Category | Administration
Applicable Product Version | Tibero 7.2.3
Document Number | TADTS082
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.