# Database alert log functions
# Remember to set DB_UNIQUE_NAME and ORACLE_SID variables and "load" this function file

# Display database alert log
# Usage: alert
alert() {
  adrci exec="set home diag\/rdbms\/$DB_UNIQUE_NAME/$ORACLE_SID\; show alert"
}

# Continuously tail database alert log
# Usage: talert
talert() {
  adrci exec="set home diag\/rdbms\/$DB_UNIQUE_NAME/$ORACLE_SID\; show alert \-tail \-F"
}

# Grep database alert log
# Usage: galert <string>
galert() {
  adrci exec="set home diag\/rdbms\/$DB_UNIQUE_NAME/$ORACLE_SID\; show alert -p \\\"message_text like '%$1%'\\\""
}

# Alert log entries for the last month
# Usage: malert
malert() {
  adrci exec="set home diag\/rdbms\/$DB_UNIQUE_NAME/$ORACLE_SID\; show alert -p \\\"originating_timestamp > systimestamp-30\\\""
}

# Alert log entries for the last day
# Usage: malert
dalert() {
  adrci exec="set home diag\/rdbms\/$DB_UNIQUE_NAME/$ORACLE_SID\; show alert -p \\\"originating_timestamp > systimestamp-1\\\""
}

# Display errors from alert log (errors are strings with ORA- in them)
# Usage: ealert
ealert() {
  adrci exec="set home diag\/rdbms\/$DB_UNIQUE_NAME/$ORACLE_SID\; \
    show alert -p \\\"message_text like '%ORA-%'\\\""
}

# Display errors from alert log for the last month (errors are strings with ORA- in them)
# Usage: lealert
lealert() {
  adrci exec="set home diag\/rdbms\/$DB_UNIQUE_NAME/$ORACLE_SID\; show alert -p \\\"message_text like '%ORA-%' and originating_timestamp > systimestamp-30\\\""
}

# Display instance startups and shutdowns
# Usage: db_start_stops
db_start_stops() {
  adrci exec="set home diag\/rdbms\/$DB_UNIQUE_NAME/$ORACLE_SID\; show alert -p \\\"message_text like '%Shutting down instance%' or message_text like '%Starting up ORACLE RDBMS%'\\\""
}

# Listener log functions
# Remember to set TNSLSNR_HOST and TNSLSNR_NAME variables and "load" this function file

# Display listener log
# Usage: listener
listener() {
  adrci exec="set home diag/tnslsnr\/$TNSLSNR_HOST/$TNSLSNR_NAME\; show alert" 
}

# Tail listener log
# Usage: tlistener
tlistener() {
  adrci exec="set home diag/tnslsnr\/$TNSLSNR_HOST/$TNSLSNR_NAME\; show alert \-tail \-F"
}

# Grep listener log
# Usage: glistener <STRING>
glistener() {
  adrci exec="set home diag\/tnslsnr\/$TNSLSNR_HOST/$TNSLSNR_NAME\; show alert -p \\\"message_text like '%$1%'\\\""
}

# Display errors from listener log (errors are strings that have TNS- in them)
# Usage: elistener
elistener() {
  adrci exec="set home diag\/tnslsnr\/$TNSLSNR_HOST/$TNSLSNR_NAME\; show alert -p \\\"message_text like '%TNS-%'\\\""
}


# Display start/stop information for the listener
# Usage: listener_start_stops
listener_start_stops() {
  adrci exec="set home diag\/tnslsnr\/$TNSLSNR_HOST/$TNSLSNR_NAME\; show alert -p \\\"message_text like '%Listening on%' or message_text like '%No longer listening on%'\\\""
}