Friday, April 4, 2014

What s new in SAP HANA SPS 07?

As everyone knows SAP HANA SPS07 has many new features. Instead I explain each and every feature I am providing the documentation at one place. I highly recommend SAP Documentation first, once you go through below docs, if you read any books you will see the difference.

If you are SAP Basis/Database Admin and planning to take SAP Hana Training, I would strong recommend seeing below Videos before you start your training.
SAP HANA SPS 07 New Features and Videos

If you really want to be an expert I would advise to go thought the SAP documentation and practice.

Please click on below links for documentation

1. What’s new in the SAP HANA platform (Release Notes)
2. Architecture & Landscape
3. Administration & Monitoring
4. SAP HANA UI Integration Services.
5. SAP BI Integration
6. SAP HANA Interactive Education (SHINE)
7. Fulltext Search
8. Fuzzy Search
9. SQLScript
10. Geospatial Processing
11. AFL / Predictive
12. SAP HANA Studio Development Perspective
13. SAP River
14. SAP HANA Smart Data Access
15. Modeling Enhancements
16. Backup & Recovery
17. SAP HANA tailored data center integration
18. SAP HANA Platform Lifecycle Management
19. SAP HANA Extended Application Services (XS) & Content Lifecycle Management
20. Real-Time Data Replication with SAP Landscape Transformation Replication Server
21. Scale-Out, High Availability and Disaster Recovery
22. Driving Innovation with In-Memory Technology

I found few interesting topics on other blogs and sharing the info.

1. What's new in SAP HANA SPS 7 - Monitoring
2. What's new in SAP HANA SPS 7 - Authentication
3. What's new in SAP HANA SPS 7 - SHINE

Here are few tutorial videos posted on YouTube.

* SAP HANA server installation, part 1 - discusses important concepts, what documentation you need to consider, where to download, etc.
* SAP HANA server installation, part 2 - shows the actual installation using the new Lifecycle Manager GUI in interactive mode
* SAP Hana Installation – Server Database Autostart - shows how to configure SAP HANA database to start at system boot
* Installing SAP HANA Studio on Linux & Windows- How to install SAP HANA studio on Linux and Windows

Satishbabu Gunukula, Oracle ACE

ORA-00600: internal error code, arguments: [510], [0xnnnnnnnn], [threshold alerts latch], [], []

We have found below error in alert.log for Oracle Database version

ORA-00600: internal error code, arguments: [510], [0x060030070], [threshold alerts latch], [], [], [], [], [] 

We never saw this error before and the only change that we applied on the server is OEM agent installation.

During the troubleshooting I found that these errors might occur after adding alerts for threshold values on tablespaces and faulty threshold/alert causing the MMON process to fail at the moment the thresholds were checked.

Find thresholds defined on the database
SQL>select dbms_server_alert.view_thresholds from dual;

I found many thresholds in the database and I have cleared all unnecessary thresholds. After removing the thresholds I didn’t see the error in the alert.log, it looks like the issue has been fixed.

I found that this is a known bug 5727166 and fixed in and and affected Oracle versions are to and the issue.

Hope this helps.

Satishbabu Gunukula, Oracle ACE