Database Analysis
You can use the Scheduler in the MS ResourceKit (MICROSOFT) to schedule the creation of a check/analysis log, or enter the following command in the command line (example for using
brconnect -f check ):at \\<host name> <time> check.bat
at \\ps0001 00.00 check.bat
The database must be active at the specified time. If the database is usually shut down, you can also schedule database startups and shutdowns. To do this use
brconnect -f startup orThe
check.bat file should have the following contents:set PATH=%PATH%;<x:>\usr\sap\<SID>\SYS\exe\run
set ORACLE_HOME=<path>
set ORACLE_SID=<SID>
set SAPDATA_HOME=<path>
brconnect -u|-c -f check
Make sure the path for SAPDBA is set correctly.
For file
set PATH=%PATH%;D:\usr\sap\C11\SYS\exe\run
set ORACLE_HOME=D:\orant
set ORACLE_SID=C11
set SAPDATA_HOME=E:\oracle\C11
brconnect -u|-c -f check
To check any of the background statements that have been set, enter
at in the command line.