ORA-20106: SQLT parameter connect identifier must be set

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

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply