How to schdule DBA JOB for oracle database of Java instance

[Former Member]

I make this post, because when I install a java stack, I wonder me how to schedule dba job on it. There is no DB13 or DBAcokpit transaction… so I found this solution.

1.  Prerequisite :

• A Solman ( or ABAP instance with DBACOKPIT transaction) named PS5 in our case
• A Java Instance known of solman named PJ1 in our case.

2.  Link DB JAVA instance to  ABAP STACK

a.  Solman CASE

The dbco is created when you do Manage system configuration

The DBCO to DB of java instance is created in step 4 :

Pay attention:

• if you use user who is not the owner of the SAP schema, you will miss some functionality in DBAcokpit (like SQL editor).
• Instance must be defined in tnsnames of sap user (by default /sapmnt/<SID>/profile/oracle/tnsnames.ora, or path is defined in env variable TNS_ADMIN)

b.  Other CASE

Transaction DBACOKPIT:

System Configuration,

Add:

Pay attention:

• if you use user who is not the owner of the SAP schema, you will miss some functionality in DBAcokpit (like SQL editor).
• Instance must be defined in tnsnames of sap user (by default /sapmnt/<SID>/profile/oracle/tnsnames.ora, or path is defined in env variable TNS_ADMIN)

3.  Maintain ssh connection with ssh key between ABAP server and Java server

In Solman server, at os level as <sid>adm generate key pair :

Sapps5:ps5adm 52> ssh-keygen  -t rsa

Generating public/private rsa key pair.

Enter file in which to save the key (/home/ps5adm/.ssh/id_rsa):

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in / home/ps5adm /.ssh/id_rsa.

Your public key has been saved in / home/ps5adm /.ssh/id_rsa.pub.

The key fingerprint is:

99:a6:d8:38:5b:c2:e4:05:27:a7:06:c6:33:d0:b9:1f psadm@sapps5

The key's randomart image is:

+--[ RSA 2048]----+

|.. .             |

| oo              |

|  *.o o          |

| ..+E*   o       |

|   .+.. S        |

|   =.= o         |

|    B +          |

|     =           |

|    . |

+-----------------+

Copy content of /home/ps5adm /.ssh/id_rsa.pub in file $HOME/.ssh/authorized_keys of pj1adm in server of java instance.

4.  Create RFC CONNECTION

Transaction SM59 :

Create or modify RF connection (name is SAPXPG_DBDEST_<hostname of DB server>):

The important point is start type of external program : is must be Secure shell.

Test it :

5.  Schedules jobs :

So now, you will be able to schedule DBA job on java instance from you solution manager with DBA cockpit :

Select you instance :

In DBA Planning calendar schedule your job

When your jobs are finished, you can have a look on log: