Skip to main content

Search

Welcome to Tibero GTS!

How to Resolve ORA-12641 Error When Configuring T to O DB Link

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>

 

 

 

Related to