cancel
Showing results for 
Search instead for 
Did you mean: 

How to access to Oracle log for a Java system ?

Former Member
0 Kudos

The customer wants to be able to read Oracle log (alert_sid.log) for a Java system. He cannot have access at the operating system level.

For an ABAP system, it is possible with transaction ST04 or ST04N.

But, which SAP standard tool can offer this read access for a Java system ? NWA ?

Best regards

Daniel

Accepted Solutions (0)

Answers (2)

Answers (2)

stefan_koehler
Active Contributor
0 Kudos

Hello Daniel,

if your customer only wants to view the alert.log you got 3 possibilites:

1) Use the view X$DBGALERTEXT with Oracle 11g

2) Create an external table on the alert log file

3) Configure Enterprise Database Control to manage your database with web interface

Regards

Stefan

Former Member
0 Kudos

Hello Daniel,

the easiest way should be to add the Java database as a remote database to the ABAP instance DBACOCKPIT. Then your customer could access the alertlog from the Java instance via the ABAP instance DBACOCKPIT transaction. See SAP note 1256322 for more details.

Regards,

Mark

Former Member
0 Kudos

This is a good solution for a system with ABAP and Java instances.

We have also Portal applications and then there is no ABAP instance. We do not want one application could access to database of other applications. What could be the solution in that case ?

Best regards

Daniel

Former Member
0 Kudos

SAP's recommendation is to use the Solution Manager as a central monitoring/reporting system. So create remote connections from the Solution Manager DBACOCKPIT (even if SolMan is not using an Oracle database) to your AS Java or Portal instances running on Oracle. You cannot access application data via DBACOCKPIT, so the connection should be safe to use.