Integration of Java Instance within DB13/DBACOCKPIT (MCOD)

[Former Member]

We have 2 Oralce instances (ABAP and Java instance), e.g. MCOD installation.

We would like to plan/execute DB actions like DB check, online backup from DB13.

We successfully integrated the Java DB within transaction DBACOCKPIT according to SAP note 1139623.

Now we can see second/Java DB entry within DB13.

When we execute DB check for this DB we get the following error:

''CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

Parameters:-u / -jid CHECK20101028171549 -sid EP2 -c -f check

BR0252E Function fopen() failed for 'F:\oracle\FI2\sapcheck\ceeldqoy.chk' at location file_printout-4

BR0253E errno 2: No such file or directory

External program terminated with exit code 5

According to SAP note 134592 we run sap_dba_role and have granted the dba role to <sid>adm and SAPService<sid>

(from Java schema for ABAP users).

What we miss in order to plan and execute DB actions from DB13 for Java DB?

[tomas-krojzl]

Hello,

I would understand why to integrate external database in RZ20/DB13 but what you are describing is that you are using SAME database and you are trying to integrate it for the second time.

It makes no sense to me - in case you are doing online backup - completed database is stored (in case of MCOD - all SAP systems contained in this database are backed up).

Anyway this is probably the note you are looking for: 853610 - Configuring transaction DB13C for Oracle

Best regards.

[Former Member]

Hello!

I have 2 databases instances on the same windows server:

- ABAP database instance (sid=FI2, schema=SAPSR3, OS-users: FI2adm, SAPServiceFI2)

- Java/Portal database instance (sid=PO3, schema=SAPSR3DB, OS-users: PO3adm)

I installed oracle only one, so two databases uses the same Oracle version 10.2.0.4.

Per default I cann access via DB13/DBACOCKPIT/RZ20 within my SAP System "FI1" only my ABAP DB instance.

Now I integrated my Portal database "PO3" via DBACOCKPIT.

Unfortunately when I plan/execute db actions for the Java/Portal instance I get the following errors:

''CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

Parameters:-u / -jid CHECK20101028171549 -sid PO3 -c -f check

BR0252E Function fopen() failed for 'F:\oracle\FI2\sapcheck\ceeldqoy.chk' at location file_printout-4

BR0253E errno 2: No such file or directory

External program terminated with exit code 5

[former_member524429]

Hi,

Have you created OPS$PO3ADM user in your PO3 Java Stack ? If not then create it as followed.

SQL> connect / as sysdba

SQL> create user OPS$<SAPSID>ADM default tablespace system temporary tablespace psaptemp identified externally;

SQL> grant connect, sapdba, resource to OPS$<SAPSID>ADM;

SQL> grant all on SDBAH to OPS$<SAPSID>ADM;

SQL> grant all on SDBAD to OPS$<SAPSID>ADM;

Also ensure that the permissions of BRTools programs are maintained as per [SAP Note 113747 - Permissions for DBA tools BRTools|https://service.sap.com/sap/support/notes/113747], as your mentioned issues can point to the permissions of br*tools program (brconnect, brbackup, brarchive, etc...etc....).

After performing above steps, try to execute any DB13 action like "Check Database"..and again check the log.

Regards,

Bhavik G. Shroff

[tomas-krojzl]

Hello,

please check note: 853610 - Configuring transaction DB13C for Oracle

You must perform all steps as described in section "Configuring a remote non-ABAP database".

You must create user in target database, set environment, check file system priviledges, etc.

Best regards.

[Former Member]

Hello!

Of course I have created two OPS-users from ABAP stack for the Java instance:

>create user "O$OPSSAPSERVICEFI2" identified externally;

>create user "O$OPSFI2ADM" identified externally;

Then I granted the following permissions to the users:

>grant connect, sapdba to "O$OPSFI2ADM";

>grant connect, sapdba to "O$OPSSAPSERVICEFI2";

I also run the sapdba_role skript for Java instance as follows:

>sqlplus /nolog @sapdba_role SR3DB

I have 2 Oracle directories:

F:oracleFI2

F:oraclePO3

The problem still exists, because when I plan the actions for PO3 from DB13 I still get the following action:

BR0252E Function fopen() failed for 'F:oracleFI2saparchaeelgapk.svd' at location file_printout-4

BR0253E errno 2: No such file or directory

External program terminated with exit code 5

Job started

Step 001 started (program RSDBAJOB, variant &0000000000621, user ID Lemke)

Ausführung des logischen Kommandos BRCONNECT auf Rechner GOHENM12

Parameter:-u / -jid CHECK20101029112201 -sid PO3 -c -f check

BR0801I BRCONNECT 7.00 (48)

BR0280I BRCONNECT time stamp: 2010-10-29 11.22.01

BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0806I End of BRCONNECT processing: ceelhimz.chk2010-10-29 11.22.01

BR0280I BRCONNECT time stamp: 2010-10-29 11.22.01

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

BR0252E Function fopen() failed for 'F:oracleFI2sapcheckceelhimz.chk' at location file_printout-4

BR0253E errno 2: No such file or directory

External program terminated with exit code 5

[Former Member]

>>BR0252E Function fopen() failed for 'F:\oracle\FI2\saparch\aeelgapk.svd' at location file_printout-4

>>BR0253E errno 2: No such file or directory

can you please create below directory? and make sure you have below directories for PO3

F:\oracle\FI2\saparch

F:\oracle\FI2\sapbackup

F:\oracle\FI2\sapreorg

[Former Member]

Hello!

these directories exist, and have been created within Portal installation.

I think it should be the environment problem, because I try to execute check from DB13 with ABAP user SAPServiceFI2.

Therefore the path F:\oracle\FI2\saparch\ will be expected instead of F:\oracle\PO3\saparch\

Is it not?

[tomas-krojzl]

Hello,

do you have both instances on one machine or you have two servers - one per SAP system..

in case you have one machine - did you made this step from note above?

Caution 4:
If multiple databases exist on the same remote server that you want to control by using transaction DB13C on the central system, you must set the following <(><<)>SAPSID<(>><)>-specific variables in the "cenadm" environment, for example:
setenv JV1_ORACLE_HOME /oracle/JV1/<db_vers>
setenv JV1_SAPDATA_HOME /oracle/JV1
setenv JV2_ORACLE_HOME /oracle/JV2/<db_vers>
setenv JV2_SAPDATA_HOME /oracle/JV2
setenv JV3_ORACLE_HOME /oracle/JV3/<db_vers>
setenv JV3_SAPDATA_HOME /oracle/JV3
For Windows, maintain the corresponding environment variables for the user "cenadm".
If directory-specific environment variables are required (SAPARCH, SAPBACKUP, SAPCHECK, SAPREORG, or SAPTRACE), they must receive the prefix <(><<)>SAPSID<(>><)>, similar to SAPDATA_HOME. On the Windows platform, for example:
set JV1_SAPDATA_HOME=D:\oracle\JV1
set JV1_SAPARCH=E:\oracle\JV1\saparch
set JV1_SAPREORG=F:\oracle\JV1\sapreorg
set JV2_SAPDATA_HOME=D:\oracle\JV2
set JV2_SAPARCH=E:\oracle\JV2\saparch
set JV2_SAPREORG=F:\oracle\JV2\sapreorg
set JV3_SAPDATA_HOME=D:\oracle\JV3
set JV3_SAPARCH=E:\oracle\JV3\saparch
set JV3_SAPREORG=F:\oracle\JV3\sapreorg

Best regards.

[Former Member]

Hello!

Exactly, I have 2 databases (FI2 and PO3) on the same Windows Server.

I already integrated PO3 (Java instance) into DBACOCKPIT and can see the alerts for this Java database within SAP system.

As next I would like to set the following environment variables for FI2adm user.

set PO3_SAPDATA_HOME=F:\oracle\PO3

set PO3_SAPARCH=F:\oracle\PO3\saparch

set PO3_SAPREORG=F:\oracle\PO3\sapreorg

set PO3_SAPCHECK =F:\oracle\PO3\sapreorg

The questions still:

How can I map these settings e.g. PO3_SAPCHECK for the execution of db actions from DB13?

In other words, how does SAP know by execution of DB check for Java instance within tcode DB13 about the existence of environment variable PO3_SAPCHECK?

How to set the same environment variables for SAPServiceFI2?

What is the difference between DBACOCKPIT and DB13C?

Unfortunately I cann see any possibilities to add a new database entry for PO3 within tcode DB13C?

[Former Member]

>>What is the difference between DBACOCKPIT and DB13C?

DB13c is central DBA planning calaender. see Note 853610 - Configuring transaction DB13C for Oracle

DBACOCKPIT : http://help.sap.com/saphelp_nw70ehp1/helpdata/en/f8/a70f51542d482ea1a9ea888824d586/content.htm

[former_member204746]

ask help from Holger Thomasson, Jgen Pfeiffer or Thom Heinemann.