vi check_log.sh

#!/bin/bash

# Created : 2019.10.10

# Updated :

# Author :

# Description :alert log

loadsql="SELECT count(1)

FROM v\$diag_alert_ext

WHERE

originating_timestamp > ( sysdate - interval '1' HOUR )

and

( message_text LIKE '%error%'

OR message_text LIKE '%ORA-%'

OR message_text LIKE '%terminating the instance%'

OR message_text LIKE '%CRS-%');"

loadsql="$loadsql"

result=`sqlplus -s /nolog <<EOF

set echo off feedback off heading off underline off;

conn / as sysdba;

$loadsql

exit;

EOF`

echo $result

vi check_session.sh

#!/bin/bash

# Created : 2019.10.10

# Updated :

# Author :

# Description :session

loadsql="select count(*)

from v\$session

where status ='ACTIVE';"

loadsql="$loadsql"

result=`sqlplus -s /nolog <<EOF

set echo off feedback off heading off underline off;

conn / as sysdba;

$loadsql

exit;

EOF`

echo $result

vi check_deadlock.sh

#!/bin/bash

# Created : 2019.10.10

# Updated :

# Author :

# Description :dead lock

loadsql="select count(*)

from v\$session

where status ='ACTIVE';"

loadsql="$loadsql"

result=`sqlplus -s /nolog <<EOF

set echo off feedback off heading off underline off;

conn / as sysdba;

$loadsql

exit;

EOF`

echo $result

vi check_sync.sh

#!/bin/bash

# Created : 2019.10.10

# Updated :

# Author :

# Description :master_standby_sync

loadsql="select status

from v\$archive_dest

where dest_name='LOG_ARCHIVE_DEST_2';"

loadsql="$loadsql"

result=`sqlplus -s /nolog <<EOF

set echo off feedback off heading off underline off;

conn / as sysdba;

$loadsql

exit;

EOF`

echo $result

vi check_real_time.sh

#!/bin/bash

# Created : 2019.10.10

# Updated :

# Author :

# Description :real-time sync

loadsql="select recovery_mode

from v\$archive_dest_status

where dest_id=2;"

loadsql="$loadsql"

result=`sqlplus -s /nolog <<EOF

set echo off feedback off heading off underline off;

conn / as sysdba;

$loadsql

exit;

EOF`

echo $result