Document Type | Troubleshooting
Category | Interface/Integration
Document Number | TIITS011
Issue
When configuring a DB Link, during the process of connecting from Tibero to Oracle (hereafter T to O), ORA-12641 error message may occur.
Error Occurrence
$ tbsql sys/tibero SQL> select * from dual@ora_link2; TBR-12044: Unable to connect to remote database. TBR-130009:(Error while trying to retrieve text for error ORA-12641
Connecting to Oracle with tbsql works normally
$ tbsql system/facc4036@gw_orcl tbSQL 5 SP1 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Connected to ORACLE GATEWAY using gw_orcl. SQL>
Cause
If the SQLNET.AUTHENTICATION_SERVICES parameter in the Oracle DB network configuration file sqlnet.ora is set to ALL, the ORA-12641 error may occur.
Solutions
Change the SQLNET.AUTHENTICATION_SERVICES parameter in the sqlnet.ora file located at $ORACLE_HOME/network/admin to resolve the issue and allow the DB Link to work properly.
Before Modification
[huyangrimdb:oracle] /oracle/product/10.2.0/network/admin> cat sqlnet.ora.bak SQLNET.AUTHENTICATION_SERVICES=ALL [huyangrimdb:oracle] /oracle/product/10.2.0/network/admin
After Modification
[huyangrimdb:oracle] /oracle/product/10.2.0/network/admin> cat sqlnet.ora SQLNET.AUTHENTICATION_SERVICES=none [huyangrimdb:oracle] /oracle/product/10.2.0/network/admin>