Skip to Content
0

DB02 "Alert Log" option missing

Jun 22, 2017 at 03:59 PM

225

avatar image
Former Member

Hello,

Could you please suggest how we can enable "Alert Log" in DB02 under below path?

DB02 >> Performance >> Additional Functions >> "Alert Log"

I cannot see "Alert Log" Option at this path.

Analysis done till now:

Same data as DB02 can be seen in ST04 and DBACOCKPIT

1546456 - DBACockpit: Remote File Access for some Oracle files >> Helps for accessing data after you see "Alert Log" option.

Data available in DEV and Production only QAS system is affected hence there is no issues with Support pack difference.

Thanks,

Deepak

10 |10000 characters needed characters left characters exceeded

Hi Deepak,

I adjusted the tags on your question slightly, adding that this is for an ABAP application server and Oracle database. Getting the tags right on your question is important in order to get it in front of the right people who can help.

It would be helpful if you could provide some more information in your question. For instance, what NetWeaver release are you working in? What release of Oracle are you using? Did you run the scripts suggested in the Note that you linked (1546456)? You mention that there is no support pack level difference in the QAS system that is affected when compared against the DEV and PRD systems that are not affected; what about an Oracle patch difference, or a difference in how the system was installed?

I suggest you edit your question to add this information, or otherwise add it as a comment upon the "answer" you provided earlier.

For more guidance on how to post questions that get good responses, have a look at https://blogs.sap.com/2010/05/12/asking-good-questions-in-the-forums-to-get-good-answers/.

Cheers,
Matt

0
* Please Login or Register to Answer, Follow or Comment.

7 Answers

avatar image
Former Member Jun 23, 2017 at 12:54 PM
0

Hello James,

Thank you for your input but unfortunately it is not helping.

As mentioned in the issue description DBACOCKPIT also shows same data and no "alert log" option there as well.

Further I can see other options like "Bundle Patch" hence dbs_ora_Schema should not be an issue.

Thanks,

Deepak

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 22, 2017 at 04:19 PM
0

DB02 >> QAS

DB02 >> DEV


db02-qas.png (10.1 kB)
db02-dev.png (10.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
James Zhang
Jun 23, 2017 at 07:40 AM
0

Hi Deepak,

Please check whether via dbacockpit can locate "alert log".

Please also the environment variable dbs_ora_schema, whether it is the upper case like:

select username from dba_users

Best regards,
James

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello James,

Thank you for your input but unfortunately it is not helping.

As mentioned in the issue description DBACOCKPIT also shows same data and no "alert log" option there as well.

Further I can see other options like "Bundle Patch" hence dbs_ora_Schema should not be an issue.

Thanks,

Deepak

0

Hi Deepak,

I suppose dbs_ora_Schema is the same case with "select username from dba_users".

I advise you to raise a chat/ticket to SAP support.

Best regards,
James

0
Reagan Benjamin
Jun 23, 2017 at 02:20 PM
0

Are you using the same version of SAP kernel for QAS and DEV?

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Yes. Same Version.

749 REL - PL 214

0
Juan Reyes
Jun 27, 2017 at 10:36 AM
0

Hi Deepak,

Check your "system configuration" on DB02.... make sure both systems match, there is some deprecated options that you can enable or disable that might give or take away functionality that have been replaced.

Regards, JP

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Checked and found configuration on both systems are exact similar

0
avatar image
Former Member Jun 27, 2017 at 03:09 PM
0

Have you done any System refresh/ Patch update or upgrade for this system.

Regards/Abhishek

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

System refresh is generally yearly / half yearly activity. I am little unsure if that could be the cause considering data i visible in production.

0
Prithviraj Rajpurohit Jun 30, 2017 at 11:21 AM
0

Hi Deepak,

Please check the sap note 11911, hope that helps.

Regards,

Prithviraj

Share
10 |10000 characters needed characters left characters exceeded