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

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

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


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

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 10.2.0.5 and 11.2.0.1 and affected Oracle versions are 10.2.0.2 to 11.2.0.7 and the issue.

Hope this helps.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Tuesday, March 11, 2014

SAP HANA SPS 07 New Features and Videos

SAP HANA SPS07 has many new features. Here I am providing “Product expert session recorded Videos" to make it easy for you to learn.

1. Architecture & Landscape

Driven by customer demand for innovation, a lot of new capabilities had been introduced into SAP HANA over the last three years. Keep pace with the changes and new capabilities introduced, by overseeing the product architecture, scenarios and deployment options which are available with SAP HANA SPS 07.

2. New development language and programming environment

Introducing SAP River, a new development language and programming model for rapidly developing a complete SAP HANA backend application.

3. Modeling Enhancements

This session will provide an overview of the new capabilities and enhancements in SAP HANA Modeling available with SAP HANA SPS 07. 

4. SAP HANA Extended Application Services (XS) & Content Lifecycle Management

This session will discuss new features for “backend” XS and content lifecycle management in SAP HANA SPS 07.


5. SAP HANA UI Integration Services - Overview and What´s New with SPS 07?

SAP HANA UI Integration Services provide the required services and UI patterns to easily create and design single applications or application sites based on HANA native (XS) applications through efficient development tools, standardized services and consistent UI experience. This session will discuss the overview of SAP HANA UI Integration Services and new features delivered in SAP HANA SPS 07.

6. Application Function Library/ Predictive Analysis library

SAP HANA contains native predictive analytics functionality, provided through the framework of the Application Function Library. In particular, the Predictive Analysis Library (PAL) and the Application Function Modeler (AFM) are used to build, train, execute, and leverage predictive models inside SAP HANA. This session will provide an update on the latest features for PAL and AFM in SAP HANA SPS 075. 

7. SQLScript

This session we will cover what’s new in SQLScript in SAP HANA SPS 07. You should able to learn new procedure artifact, the new function wizards, a procedure viewer as well as catalog debugging and a new debugging authorization concept.

8. Text Analysis

This Live Expert session offers the opportunity to learn about the highly anticipated new custom configuration and dictionary support in SAP HANA Studio for text analysis. In pursuit of continuous improvement, greater indexing throughput and deeper, refined language coverage will also be highlighted.

9. HANA Development Tools (Studio & Web IDE)

In this session we will explore the new features in the SAP HANA Development perspective of the SAP HANA Studio as well as the SAP HANA Web-based Development Workbench. See improvements to the overall tooling, workflow, individual editors as well as completely new tools such as the graphical CDS tool.

10. Backup & Recovery and High Availability & Disaster Recovery

Focus of this session is on the new features available for HANA backup and recovery, including extended support for storage snapshots.

11. Real-time data replication

A proven data provisioning concept is a key success factor for most SAP HANA-based applications and scenarios. In the last years SAP Landscape Transformation replication server evolved to a cornerstone in most SAP HANA customer landscapes with real-time replication needs. Connecting SAP and non-SAP software sources, filtering and the transformation of data can be used to achieve outstanding performance with SAP Landscape Transformation replication server and SAP HANA. In this session, you will learn about its newest functions and features for SAP HANA SPS 07 as well as about the development roadmap

Hope this helps, please leave your comments.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Wednesday, February 26, 2014

warning: overriding commands for target `nmosudo' during Oracle Patch

When applying Oracle PSU 11.2.0.4.1 (p17478514_112040_Linux-x86-64.zip), you will see below Warning message. Don’t be panic as this is expected warning and it is safe to ignore as per readme.txt

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
/home/oracle/product/11.2.0.4/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/home/oracle/product/11.2.0.4/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' 


OPatch output for your reference
oracle$opatch apply
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/product/11.2.0.4/dbhome_1
Central Inventory : /u01/home/oracle/oraInventory
from : /home/oracle/product/11.2.0.4/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.4.0
Log file location : /home/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/17478514_Feb_12_2014_15_28_16/apply2014-02-12_15-28-16PM_1.log

Applying interim patch '17478514' to OH '/home/oracle/product/11.2.0.4/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/home/oracle/product/11.2.0.4/dbhome_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sdo, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.sdo.locator, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
/home/oracle/product/11.2.0.4/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/home/oracle/product/11.2.0.4/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'

Verifying the update...
Patch 17478514 successfully applied
OPatch Session completed with warnings.
Log file location: /home/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/17478514_Feb_12_2014_15_28_16/apply2014-02-12_15-28-16PM_1.log

Other known issues in PSU 11.2.0.4.1
1. while running the catbundle.sql script or its rollback script you may see below errors and these are ignorable errors as per readme.txt

RA-29809: cannot drop an operator with dependent objects
ORA-29931: specified association does not exist
ORA-29830: operator does not exist
ORA-00942: table or view does not exist
ORA-00955: name is already used by an existing object
ORA-01430: column being added already exists in table
ORA-01432: public synonym to be dropped does not exist
ORA-01434: private synonym to be dropped does not exist
ORA-01435: user does not exist
ORA-01917: user or role 'XDB' does not exist
ORA-01920: user name '<user-name>' conflicts with another user or role name
ORA-01921: role name '<role name>' conflicts with another user or role name
ORA-01952: system privileges not granted to 'WKSYS'
ORA-02303: cannot drop or replace a type with type or table dependents
ORA-02443: Cannot drop constraint - nonexistent constraint
ORA-04043: object <object-name> does not exist
ORA-29832: cannot drop or replace an indextype with dependent indexes
ORA-29844: duplicate operator name specified
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
ORA-06512: at line <line number>. If this error follow any of above errors, then can be safely ignored.
ORA-01927: cannot REVOKE privileges you did not grant

2. On HP-UX Systems you might see below warnings while performing the relinking of oracle binary and these are ignorable warnings as per readme.txt

WARNING:OUI-67215:
OPatch found the word "failed" in the stderr of the make command.Please look at this stderr. You can re-run this make command.
cc: warning 487: Possibly incorrect message catalog.
total_lntt_bytes is 0, assuming size of .debug_lntt
Failed to mmap lntt temp file. 

After applying Oracle Patch set update 11.2.0.4.1 if you see below warning messages then you might have affected with another bug and refer below Metalink note for more info.

"Warning: odm_mkdir not found in ODM library"

 Bug 18180390 : AFTER APPLYING DBPSU 11.2.0.4.1 DB PROCESSES GET WARNING: ODM_MKDIR NOT FOUND

Regards,
Satishbabu Gunukula,Oracle ACE
http://www.oracleracexpert.com

Thursday, January 23, 2014

Optimal redo logfile size in Oracle

If you have a small redo log file then you will see frequent log switches, in case of large redo logfile you might be at risk of losing data during instance crash. The optimal redo logfile size should not have more than 5 switches per hour.

You can use below query to find the number of log switches per hour

col day format a15;
col hour format a4;
col total format 999;
select to_char(first_time,'yyyy-mm-dd') day, to_char(first_time,'hh24') hour, count(*) total
from v$log_history
group by to_char(first_time,'yyyy-mm-dd'),to_char(first_time,'hh24')
order by to_char(first_time,'yyyy-mm-dd'),to_char(first_time,'hh24') asc;


To resize the redo logfile size follow the steps in below link

In Oracle 10g, the Redo Logfile Size Advisor introduced and using this you can determine the optimal redo log size based upon FAST_START_MTTR_TARGET parameter. You must set a non-zero value to enable redo log file size advisor.

FAST_START_MTTR_TARGET – this parameter enables you to specific number of seconds the database takes to perform crash recovery. Based up on this value Oracle determines the checkpoint writes to meet the target.

If you DONT set FAST_START_MTTR_TARGET then OPTIMAL_LOGFILE_SIZE in V$INSTANCE_RECOVERY will not populated with recommend redo log file size.

SQL> show parameter FAST_START_MTTR_TARGET
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target integer 0

SQL> select optimal_logfile_size from v$instance_recovery;
OPTIMAL_LOGFILE_SIZE
--------------------------------

User must set FAST_START_MTTR_TARGET to a non-zero value then OPTIMAL_LOGFILE_SIZE in V$INSTANCE_RECOVERY will be populated with recommend redo log file size.

Here I am setting FAST_START_MTTR_TARGET=60 (sec), you will see that OPTIMAL_LOGFILE_SIZE will be populated with recommended value.

SQL> alter system set FAST_START_MTTR_TARGET=60 scope=both;
System altered.

SQL> select OPTIMAL_LOGFILE_SIZE from v$instance_recovery;
OPTIMAL_LOGFILE_SIZE
--------------------
151

Now the checkpoints are driven by FAST_START_MTTR_TARGET parameter.

In some cases user will see many log switches during batch job window and there is no log switches out of batch job window. In this case you need to optimal value for redo log size and may need to set archive_lag_target to force redo log switches to increase the frequency during non-batch job window.

For more information on archive_lag_target refer below Oracle document.
http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams009.htm

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com