ORA-20106: SQLT parameter connect_identifier must be set
Error
During execution of SQLT on one the client, i am getting the following error:
DECLARE
*
ERROR at line 1:
ORA-20106: SQLT parameter connect_identifier must be set when running SQLT from
a remote client
Cause
I am using the tns for connecting the database with application user as shown below. It will end with error as show above.
SQLPLUS appuser@ORCL
Password:
SQL> start sqltxtract.sql 16p6u0h5t22nm
Solution
You need to login with only app user without connection identifier as shown below. If you need to set the oracle sid then set it above.
This command will completed successfully.
SET ORACLE_SID=ORCL
SQLPLUS appuser
Password:
SQL> start sqltxtract.sql 16p6u0h5t22nm