SQL Performance (MOSC)

MOSC Banner

ORA-20106: SQLT parameter connect_identifier must be set

edited Jan 16, 2015 4:20PM in SQL Performance (MOSC) 6 commentsAnswered

I'm new to SQLT tool, trying to excute a problematic SQL getting error as below. ANy help is highly appreciated.

cd\sqlt\run sqlplus dbname

SQL> DEF connect_identifier='DBNAME';

SQL> START sqltxtract.sql <SQLID> <SQLT password>

PL/SQL procedure successfully completed.

Parameter 1:
SQL_ID or HASH_VALUE of the SQL to be extracted (required)

Paremeter 2:
SQLTXPLAIN password (required)


PL/SQL procedure successfully completed.


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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center