Database monitoring with Java Schema giving error

[former_member231914]

Hello All,

I need to configure Database monitoring (DBACOCKPIT) feature from Solution Manager diagnostic from my sol man EHP1 system with all the satellite systems which are on NW04's with SP17. Now when i'm trying to configuring with JAVA Schema SAP<SID>DB , it is giving me error "Error in CL_DB6_SYS with return code ADBC error".

I did try to search on this, but could not get any information, i can access DBACOCKPIT from ABAP schema, but with java schema, it is giving me problems.If anyone came across the solution for same, please help me out.

Also, i would like to know, features & functionality which will be provided through Java schema.

Waiting for answers.

PS: I'm using Oracle 10.2.0.4 on HP-UX 11iv3.

Thanks,

Anand.

[fidel_vales · Accepted solution]

Hi,

I really do not understand what you try to do, better said, WHAT are you doing.

You will need to provide a detailed explaination, step by step.

> Also, i would like to know, features & functionality which will be provided through Java schema.

DBACOCKPIT is an ABAP program, it does NOT run in a "Java schema".

If you have a Dual stack ABAP and JAVA you do not have to configure DBACOCKPIT for anything as you only have ONE database.

You could configure DBACOCKPIT to monitor a different database, for example a JAVA only as it is not available in JAVA.

For that you have to create a new connection, you have to configure also the names resolution at oracle level ...

Check SAP notes:

1256322 Establishing a remote database connection in DBACOCKPIT

1261329 DBA Cockpit: Oracle as remote database

[Former Member]

Hi Anand

Have you done the manual preparation for Java systems as mentioned in the Note below ? Following Notes might help you. Are you on EHp1 sp18 or SP19 ?

Note 1139623 - Using transaction RZ20 to monitor remote Oracle databases

Note 1261679 - DBA Cockpit: Java schema not recognized

Note 1252411 - DBA Cockpit: Patches for Integration with SolMan

Which method are you utilizing for the setup ? check this blog and notes too

/people/tony.dethomasis2/blog/2009/05/11/take-off-with-the-dbacockpit

[former_member231914]

Thanks to both for providing inputs.

My issue is related with ABAP+ JAVA stack system, as i did successfully registered only Java (EP) stack system successfully.

To brief up, i'm getting error when i'm using SAPSIDDB java schema & user for registering system in DBACOCKPIT, but while doing with SAPSID which is ABAP Schema, i can register my system successfully.

So now, do i really required SAPSIDDB for registering ABAP+JAVA stack system?

Will this provide me any extra features/functions??

Also what roles & authorisations should SAPSID user have while accessing this ?

Thanks,

Anand.

[fidel_vales]

Hi,

For ABAP+JAVA stack system there is only one database, therefore you do not need to register both.

Nevertheless, it seems that there is an issue for (only) JAVA systems.

Take a look at note 1263152.

> Also what roles & authorisations should SAPSID user have while accessing this ?

I do not understand what do you mean.

SAP<sid_target> already exist on the "target" database, it has the correct authorizations.

SAP<sid_local> does not connect to the target database. it does not need any role/authorization

[former_member231914]

Thanks Mr.Fidel for the quick reply.

I have configured only java system also, now there is only issue for user SAPSID ABAP Schema user not having sufficient rights. This user is of my PI System, which is ABAP + JAVA stack systems.

When i'm trying to access through SAPSID user, it is giving me error as "User SAPPIX does not have administrative privileges", i did checked it's user & has got SAPCONN role.

What role it should contain, this is working fine for other systems, only in this system it is giving me error. Please advice...

Thanks.

Anand.

[former_member231914]

Hello,

I can monitor DB from my solution manager system through DBA Cockpit..even i'm getting error related with Previlages are missing for SAP(SID) Schema user in Diagnostic setup for Database monitoring section.

May i know, what other features will be provided, apart from this or rather that error is really logical, since i can monitor my system remotely?

Waiting for some positive comments on this...

[former_member231914]

I can check DB from sol man system through DBACockpit tcode.

About Java Schema error, so far no fool proof answer from anyone...not even by SAP