Database Tuning (MOSC)

MOSC Banner

BRCONNECT run via Cron job

edited May 16, 2018 5:09AM in Database Tuning (MOSC) 10 commentsAnswered

Hi,

Oracle version : 12.1.0.2

I was trying to run below script, its not getting run via CRONJOB even not getting any error. Its just skipping. Please your help be much appreciate.

#!/bin/sh

#> brconnect.txt

#log_file='brconnect.txt'

ORACLE_SID=QC1

ORACLE_HOME=/oracle/QC1/121

LD_LIBRARY_PATH=$ORACLE_HOME/lib

PATH=$ORACLE_HOME/bin:$PATH

export PATH

export ORACLE_HOME

export ORACLE_SID

export LD_LIBRARY_PATH

#export log_file

#spool $log_file

brconnect -u / -c -f stats -o SAPSR3 -t USRVART -e null -m E -s P20 -f allsel,collect,method,sample,keep -p 8  > /oracle/QC1/12102/tbs_usage/brconnect.log

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