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>

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

ORA-00600: internal error code, arguments

Facing below issue when database server down due to power outage.

SQL > startup

Error :-

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],

[], [], [], [], [], [], [], []

Cause:- 

This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:

1. Timeouts
2. File corruption
3. Failed data checks in memory
4. Hardware, memory, or I/O errors
5. Incorrectly restored files



Solution :- 

SQL> shutdown immediate
SQL> startup mount
SQL>alter database recover database;
SQL> alter database open