2025-03-12 14:02:17 [2] [REMOTE_INSTANCE_23] [set_ora_env] ORA-99999 ORACLE_HOME for SID 'REMOTE_INSTANCE_23' not found or not existing!
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [remote] ORACLE_SID      : REMOTE_INSTANCE_23
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [remote] ORACLE_HOME     :
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [remote] TNS_ADMIN       :
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [remote] LD_LIBRARY_PATH : /lib
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [remote] ORACLE_VERSION  : 19 (19)
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [mk_ora_db_connect] Single Instance
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [mk_ora_db_connect] ORA DB user    : XXXXXXXXXXXX
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [mk_ora_db_connect] DB sys connect :
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [mk_ora_db_connect] DB host        : a0.XXX.XXX.com
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [mk_ora_db_connect] DB port        : 1521
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [mk_ora_db_connect] TNS alias      :
2025-03-12 14:02:17 [0] [REMOTE_INSTANCE_23] [mk_ora_db_connect] TNS PING       : no
2025-03-12 14:02:18 [0] [REMOTE_INSTANCE_23] [mk_ora_db_connect] DB connection: USER/************@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=a0b.XXX.XXX.com)(PORT=1521))(CONNECT_DATA=(SID=CODAP)(SERVER=DEDICATED)(UR=A)))
2025-03-12 14:02:18 [0] [REMOTE_INSTANCE_23] [do_checks] Excluded:
2025-03-12 14:02:18 [0] [REMOTE_INSTANCE_23] [do_checks] Sections: instance performance processes sessions longactivesessions logswitches undostat recovery_area recovery_status dataguard_stats systemparameter iostats
2025-03-12 14:02:18 [0] [REMOTE_INSTANCE_23] [do_checks] Async sections: tablespaces rman jobs resumable iostats
2025-03-12 14:02:18 [0] [REMOTE_INSTANCE_23] [do_sync_checks] Query: prompt <<<oracle_instance:sep(124)>>>
select upper(i.instance_name)
                     || '|' || i.VERSION
                     || '|' || i.STATUS
                     || '|' || i.LOGINS
                     || '|' || i.ARCHIVER
                     || '|' || round((sysdate - i.startup_time) * 24*60*60)
                     || '|' || DBID
                     || '|' || LOG_MODE
                     || '|' || DATABASE_ROLE
                     || '|' || FORCE_LOGGING
                     || '|' || d.name
                     || '|' || to_char(d.created, 'ddmmyyyyhh24mi')
                from v$instance i, v$database d;
prompt <<<oracle_processes:sep(124)>>>
select upper(i.instance_name)
                  || '|' || CURRENT_UTILIZATION
                  || '|' || ltrim(rtrim(LIMIT_VALUE))
           from v$resource_limit, v$instance i
           where RESOURCE_NAME = 'processes';
prompt <<<oracle_sessions:sep(124)>>>
select upper(i.instance_name)
                     || '|' || CURRENT_UTILIZATION
                     || '|' || ltrim(LIMIT_VALUE)
                     || '|' || MAX_UTILIZATION
              from v$resource_limit, v$instance i
              where RESOURCE_NAME = 'sessions';
prompt <<<oracle_logswitches:sep(124)>>>
select upper(i.instance_name)
                  || '|' || logswitches
           from v$instance i ,
                (select count(1) logswitches
                 from v$loghist h , v$instance i
                 where h.first_time > sysdate - 1/24
                 and h.thread# = i.instance_number
                );
PROMPT <<<oracle_undostat:sep(124)>>>
PROMPT <<<oracle_recovery_status:sep(124)>>>
PROMPT <<<oracle_systemparameter:sep(124)>>>
select upper(i.instance_name)
         || '|' || NAME
         || '|' || DISPLAY_VALUE
         || '|' || ISDEFAULT
         from v$system_parameter, v$instance i
         where name not like '!_%' ESCAPE '!';
PROMPT <<<oracle_tablespaces:sep(124)>>>
PROMPT <<<oracle_resumable:sep(124)>>>
SET SERVEROUTPUT ON feedback off
              DECLARE
                  type x is table of varchar2(20000) index by pls_integer;
                  xx x;
              begin
                  begin
                      execute immediate 'select upper(i.INSTANCE_NAME)
                         ||''|''|| u.username
                         ||''|''|| a.SESSION_ID
                         ||''|''|| a.status
                         ||''|''|| a.TIMEOUT
                         ||''|''|| round((sysdate-to_date(a.SUSPEND_TIME,''mm/dd/yy hh24:mi:ss''))*24*60*60)
                         ||''|''|| a.ERROR_NUMBER
                         ||''|''|| to_char(to_date(a.SUSPEND_TIME, ''mm/dd/yy hh24:mi:ss''),''mm/dd/yy_hh24:mi:ss'')
                         ||''|''|| a.RESUME_TIME
                         ||''|''|| a.ERROR_MSG
                  from dba_resumable a, v$instance i, dba_users u
                  where a.INSTANCE_ID = i.INSTANCE_NUMBER
                  and u.user_id = a.user_id
                  and a.SUSPEND_TIME is not null
                  union all
                  select upper(i.INSTANCE_NAME)
                         || ''|||||||||''
                  from v$instance i'
                      bulk collect into xx;
                      if xx.count >= 1 then
                          for i in 1 .. xx.count loop
                              dbms_output.put_line(xx(i));
                          end loop;
                      end if;
                  exception
                      when others then
                          for cur1 in (select upper(i.instance_name) instance_name from  v$instance i) loop
                              dbms_output.put_line(cur1.instance_name || '| Debug: '||sqlerrm);
                          end loop;
                  end;
              END;
              /
              set serverout off
2025-03-12 14:02:18 [0] [REMOTE_INSTANCE_23] [do_sync_checks] [mk_ora_sqlplus] Piggyback host: A0B
2025-03-12 14:02:19 [0] [REMOTE_INSTANCE_23] [do_sync_checks] [mk_ora_sqlplus] Elapsed time: 1.43630