ORA-20106

When i was run  sqltxtract.sql script with SQL_id facing below error.

# cd sqlt/run
# sqlplus apps
SQL> START sqltxtract.sql SQL_ID [HASH_VALUE] [sqltxplain_password]

SQL> START sqltxtract.sql 223a9p72spa100 *****


Error :-

DECLARE
*
ERROR at line 1:
ORA-20106: SQLT parameter connect_identifier must be set when running SQLT from a remote client
ORA-06512: at line 10

Solution :-

The only solution to avoid such error is to set connect_identifier using below command:

=================
EXEC sqltxadmin.sqlt$a.set_sess_param(‘connect_identifier’, ‘@SID’);
=================

In case if you are getting above error in RDS Orale then please use below command to set Connect Identifier.

=================
EXEC sqltxadmin.sqlt$a.set_param(‘connect_identifier’, ‘@<hostname>:<port>/<sid>’);

# sqlplus / as sysdba

SQL> EXEC sqltxadmin.sqlt$a.set_param('connect_identifier', '@sonu.oracle.com:1521/PROD');

PL/SQL procedure successfully completed.

SQL>

=================