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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.