check external databse via DB13

[Former Member]

Hi,

I want to execute the tasks check database on db13 for a external java database to be monitored via dbacockit.

I´ve execute 134592 - Importing the SAPDBA role (sapdba_role.sql) script role, but I don´t see anything and sqplus it´s closed.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000098, user ID ADM)

Parámetros:-u / -jid CHECK20120221125555 -sid PIP -c -f check

BR0801I BRCONNECT 7.00 (52)

BR0477I Oracle pfile D:oracleCO2102databaseinitPIP.ora created from spfile D:oracleCO2102databasespfilePIP.ora

BR0805I Start of BRCONNECT processing: cezablhc.chk 2012-02-21 12.55.56

BR0484I BRCONNECT log file: E:oraclePIPsapcheckcehyblha.chk

BR0280I BRCONNECT time stamp: 2012-02-21 12.55.57

BR0813I Schema owners found in database PIP:

DBSNMP, DIP, OPS$DOMAINPIPADM, OPS$DOMAINSAPSERVICECO2, OPS$DOMAINSAPSERVICESR3, ORACLE_OCM, OUTLN, SAPSR3DB%, SYS, SYSTEM

TSMSYS

BR0252E Function _stat() failed for 'C:ORACLEPIPMIRRLOGA' at location BrDiskStatGet-1

BR0253E errno 2: No such file or directory

BR0277E Determination of disk volume status for C:ORACLEPIPMIRRLOGA failed

BR0806I End of BRCONNECT processing: cezablhc.chk2012-02-21 12.55.57

BR0280I BRCONNECT time stamp: 2012-02-21 12.55.57

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

failed for 'C:ORACLEPIPMIRRLOGA' at location BrDiskStatGet-1

BR0253E errno 2: No such file or directory

BR0277E Determination of disk volume status for C:ORACLEPIPMIRRLOGA failed

BR0806I End of BRCONNECT processing: cezablhc.chk2012-02-21 12.55.57

BR0280I BRCONNECT time stamp: 2012-02-21 12.55.57

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

[Former Member]

Hi,

Is this C:\ORACLE\PIP\MIRRLOGA a valid path?

What happens if you run the follow command at the command prompt?

brconnect -c -u / -f stats -t all -f -s PIP collect -p 4

Br,

Venky

[Former Member]

Thanks for your answer Pydi,

The path is correct.

If I execute this command I get this:

BR0156E Illegal value 'PIP' found for option '-s'

[Former Member]

Please use this and paste the log.

brconnect -c -u / -f stats -t all -f -sid PIP collect -p 4

[Former Member]

C:\Users\PIPadm>brconnect -c -u / -f stats -t all -f -sid PIP collect -p 4

BR0801I BRCONNECT 7.00 (52)

BR0153E Unknown option '-sid' found at position 9

BR0154E Unexpected option value 'PIP' found at position 10

BR0154E Unexpected option value 'collect' found at position 11

BR0806I End of BRCONNECT processing: cehybwlv.log 2012-02-21 15.01.55

BR0280I BRCONNECT time stamp: 2012-02-21 15.01.55

BR0804I BRCONNECT terminated with errors

[Former Member]

Pls remove sid and execute this as pipadm

brconnect -c -u / -f stats -t all -f collect -p 4

[Former Member]

BR0280I BRCONNECT thread 1: time stamp: 2012-02-21 15.19.17

BR0850I 808 of 808 objects processed - 0.934 of 0.934 units done

BR0204I Percentage done: 100.00%, estimated end time: 15:19

BR0001I **************************************************

BR0280I BRCONNECT time stamp: 2012-02-21 15.19.17

BR0848I Thread 1 finished with return code 0

BR0280I BRCONNECT time stamp: 2012-02-21 15.19.17

BR0879I Statistics checked for 0 tables

BR0878I Number of tables selected to collect statistics after check: 0

BR0880I Statistics collected for 808/0 tables/indexes

BR0806I End of BRCONNECT processing: cehybxzh.sta 2012-02-21 15.19.18

BR0280I BRCONNECT time stamp: 2012-02-21 15.19.18

BR0802I BRCONNECT completed successfully

Now It finished successfully if it´s executed from command line but If it´s executed from DB13 tcode the result its error.

Edited by: Ruben Torres on Feb 21, 2012 3:28 PM

[Former Member]

Hi,

Why not configure and use dbacockpit?

Note 1025707 - DBA Cockpit: Planning calendar and remote Oracle databases

Note 1028624 - Overview of DBA Cockpit for Oracle

Br,

Venky

[Former Member]

Hi Pydi,

I´ve configured the DBA Cockpit and planning calendar for remote Oracle databases. I´ve scheduled different tasks, full online backup, redo log backup, delete old logs and each one is successfully but the check the database fails.

[Former Member]

Hi,

Could you please check if the environment variable ORACLE_HOME and SAPDATA_HOME set properly.

Br,

Venky

[Former Member]

In the Environment variables of the user cenadm, user admin of the abap instance that manages the external java database PIP.

The next are the Environment.Variables:

ORACLE_HOME -> F:\oracle\cen\102

SAPDATA_HOME -> G:\oracle\CEN

PIP_ORACLE_HOME -> F:\oracle\cen\102 (Two system shares the same oracle home)

PIP_SAPDATA_HOME -> G:\oracle\PIP

Edited by: Ruben Torres on Mar 2, 2012 9:09 AM