Monday, December 14, 2015

Webinar: Oracle Golden Gate 12c New Features

The Oracle GoldenGate software package delivers low-impact, real-time data integration and transactional data replication across heterogeneous systems for continuous availability, zero-downtime migration, and business intelligence.

Date and time: Friday, January 8th, 2016 8:00 am-9:00am
Pacific Daylight Time (San Francisco, GMT-07:00)

Join the Webinar to learn Golden Gate 12c New Features

· Expanded heterogeneous Support
· Multitenant Container Database (CDB) Support
· Oracle Universal Installer (OUI) Support
· Support for Public and Private Clouds
· Integrated Replicat
· Security
· Coordinated Replicat
· New 32K VARCHAR2 Support
· High Availability (HA) enhancements
· Support for Other Oracle products
· Improvements to feature Functionality

To register for this Webinar, please send an email to SatishbabuGunukula@gmail.com and reserve your spot. Registration is limited to first 50 members only.

You will receive an email confirmation with meeting link. For presentation link Click here .

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

Friday, November 6, 2015

syntax error: unterminated quoted string literal


I have encountered below “sql syntax error” during data import into HANA Dynamic Tiering

* 257: sql syntax error: unterminated quoted string literal: line 1 col 13 (at pos 13) SQLSTATE: HY000
Here are the possible reasons for this error

1. You will see this error when data file name is wrong in the control file

2. The “quote” is not closed properly in the IMPORT command.

For ex:-
HANA=>IMPORT FROM '/hana/shared/DT/HDB00/work/employee.txt.ctl
As you see quote is not ended properly in above command

3. when data file is empty

Regards,
Satishbabu Gunukula, Oracle ACE

RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old

I have created a 12c Database recently and when trying to register database I have received below warning message

RMAN> Register Database
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.04 in RCVCAT database is too old
RMAN-00571: ======================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ======================================================
RMAN-03002: failure of register command at 11/04/2015 10:12:11RMAN-06429: RCVCAT database is not compatible with this version of RMAN


I tried to upgrade the database and I have received below error

RMAN> upgrade catalog;
RMAN-00571: ======================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ======================================================
RMAN-07539: insufficient privileges to create or upgrade the catalog schema


It looks like more privileges needed to upgrade the catalog schema. But In 12c do not grant any privileges manually to upgrade catalog. Instead you need to run below script provided by oracle

$ sqlplus sys/xxxx@RMANCAT as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/dbmsrmansys.sql


Once you run above scripts, now you can upgrade the catalog

$ rman TARGET / CATALOG rman/xxxxx@RMANCAT

RMAN> upgrade catalog;
recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN> upgrade catalog;

recovery catalog upgraded to version 12.01.00.02
DBMS_RCVMAN package upgraded to version 12.01.00.02
DBMS_RCVCAT package upgraded to version 12.01.00.02.

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

Hope this helps

Regards
Satishbabu Gunukula, Oracle ACE

Friday, August 7, 2015

[SAP][ODBC Driver]Non-space text found after ending quote


I have encountered below error during data import into HANA Dynamic Tiering

* 403: internal error: [SAP][ODBC Driver]Non-space text found after ending quote
-- (dblib/db_RecScanner.cxx 2657) SQLSTATE: HY000


I found that data has quotes (“) which is causing the issue. But didn’t find any forum/link related to this error in HANA DT or solution.

At this situation SLT can help, I have used SLT to load the data and was able to load successfully.

During research I found that few users encountered same issue during the data import into SYBASE
They propose below recommendations

- Remove quotes from all values in data file
- TURN OFF the QUOTES as QUOTES ON is default.

Refer below link for more info for SYBASE error
https://scn.sap.com/thread/3638327

Other possible errors you may encounter:

* 403: internal error: [SAP][ODBC Driver]Cannot convert PatKey to a integer(10) (column EMPLOYEE_ID) SQLSTATE: HY00

Possible solution: Please choose appropriate data type.

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

2: general error: Table does not exist SQLSTATE: HY000


I was importing data into HANA Dynamic Tiering and encountered below error.

* 2: general error: Table does not exist SQLSTATE: HY000

You will see this error if TABLE NAME is wrong. I have verified that table exists in the database but still see same issue and I have verified the syntax of the control file and everything looks good.

IMPORT DATA INTO TABLE "dtuser"."employee" FROM '/hana/shared/DT/HDB00/work/employee.txt'
RECORD DELIMITED BY '\n'
FIELD DELIMITED BY '|'
OPTIONALLY ENCLOSED BY '"'
ERROR LOG '/hana/shared/DT/HDB00/work/employee.log'

I see that user and table name is in lower case. I have modified the control file to use upper case for user/ table name and I was able to IMPORT successfully.

Other possible errors you may encounter:  
  • 2: general error: Cannot open the file, /hana/shared/DT/HDB00/work/employee.txt SQLSTATE: HY000
Possible solution: The file name is wrong or path may be in correct. You need to correct the same 
  • 2: general error: Cannot open Control file, /hana/shared/DT/HDB00/work/employee.ctl
Possible solution: The control file name is wrong or control file path may be incorrect

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

Thursday, July 23, 2015

Why Virtual Private Catalog?

Hi Everyone,

My articles published in Oracle Experts website media "Allthingsoracle.com" by RedGate

Please see the below link.

Article: Why Virtual Private Catalog?

This article will help you to understand

  • What is Virtual Private Catalog
  • How to secure the boundaries between DBA's
  • How to segregate the duties in an Enterprise Environment.

I hope you will like the article and it will be helpful to you.

Please leave your valuable comments.

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

ORA-01163: SIZE clause indicates (blocks), but should match header

I have generated a control file using “backup control file to trace” but while recreating I have encountered below error

*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 32768 (blocks), but should match header 262144
ORA-01517: log member: '/oracle/TEST/redo1/TEST_redo1.rdo'


I see that the failure is due to log member size. But the current redo log file size on the disk and in the script is correct. I ran below query to find the redo log BLOCKSIZE and found that the size is 4096.

select * from v$log;

I tried couple of options to recreate the control file by changing the redo log size in KB/MB/Bytes..etc but nothing worked. After investigation I found that drop and recreating the redo log is only the option.

Other possible scenarios/errors
1. If you receive the same ORA-01163 error for DATA FILE then your size calculation might be incorrect.

    Use below formula to get the size.
    Expected size = Expected no of blocks * db_block_size / 1024

2. ORA-01378: The logical block size (4096) of file /oracle/TEST/redo1/TEST_redo1.rdo'is not
    compatible with the disk sector size (media sector size is 512 and host sector size is 512)

If you receive above error you ned to set below parameter
SQL> alter system set "_disk_sector_size_override"=TRUE scope=both;

Reference for more info.
ORA-00344: WHEN RESIZING YOUR REDO LOGS (Doc ID 1018307.102)

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

Tuesday, July 21, 2015

Are you attending Oracle OpenWorld?

Oracle OpenWorld presents the world's largest, most in-depth selection of sessions by Oracle experts, customers, and partners over a course of five days.

Oracle OpenWorld 2015- October 25- 29, 2015

In Oracle Open World, you are sure to discover new ways to optimize your systems, new solutions that will help you take your business to the next level and new practices that will make you more successful in your job and in your industry.

At Oracle Open World you are going to get -
• 2500+ Technology sessions
• Labs & demos
• Exhibitors and partners
• Opportunities to meet with industry experts
• Fun at the Welcome Reception and Appreciation event at the end.

And lot more…!

Click here for Oracle Open World Agenda

Exhibit, Sell, Win – At Oracle Open World. This is the great opportunity to launch and demo your new products and solutions, meet people face to face with prospects. Follow the Three easy steps to Exhibit.

Click here to lean “How to Exhibit: Three Easy Steps

Learn at Oracle OpenWorld
Oracle Open World provides more educational and networking opportunities than any other Oracle conference. Last year Oracle OpenWorld attracted 60,000+ visitors and this year you can expect more.

Whether you are an experienced developer or DBA, a novice technologist, or business manager or executive, you'll find how-tos, overviews, best-practice sessions, and customer panels targeted to your job role and level of expertise at Oracle OpenWorld.

Oracle Open World Streams and Tracks
Applications
Database
Engineered Systems
Enterprise Manager
Industries
Middleware
MySQL
Operating Systems
Servers and Storage
Support and Services
Virtualization


Let Your Manager Know Why You Should Attend
Oracle OpenWorld offers thousands of sessions geared toward helping Oracle users get the most out of their IT infrastructure and investments—and helping them make the most cost-effective and strategic IT decisions for the future.

Oracle OpenWorld is also a great showcase for the latest developments in cloud, big data, security, governance, data center optimization, and other issues that we’re dealing with. Through presentations and hands-on sessions the conference offers hundreds of opportunities to learn money- and time-saving techniques.

Nowhere else you could get the detailed best practices learned by other companies facing challenges similar to yours. You can get advice directly from the people who know the technology best, and can participate in question-and-answer sessions and other roundtable meetings—getting access to high-value information from experts, peers, partners, and industry leaders.

If you still need some help convincing your manager to let you attend Oracle OpenWorld, Download a Customizable Justification Letter.

There are many packages in Oracle OpenWorld 2015 and see which one best suite your needs. Note that Early Bird and Group Registrations receive discounts.

Here is the available packages info.
https://www.oracle.com/openworld/register/index.html

Please see below link to compare benefits
https://www.oracle.com/openworld/register/compare.html#compare

Some of the sessions will be covering in Oracle Open world are:
• Technology- Oracle’s complete technology portfolio
• Applications - Enablement offerings, initiatives and service development options
• Engineered Systems - Ways to transform IT into more cost effective operation
• Industry - Discover ways to successfully position and deliver solutions to clients
• Cloud - Learn how to go to market and implement innovative cloud solutions

Click here to View all the sessions.

Become Part of the Experience, Meet up with your peers, find out when and where our leaders and most exciting events will occur, and participate in the discussion.

Click here to Register for Oracle OpenWorld 2015

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

Wednesday, June 24, 2015

ORA-01102 cannot mount database in EXCLUSIVE mode

Users might receive error “ORA-01102” when trying to startup

01102, 00000, "cannot mount database in EXCLUSIVE mode"
// *Cause: Some other instance has the database mounted exclusive or shared.
// *Action: Shutdown other instance or mount in a compatible mode.


You will receive this error when instance is already opening in parallel. You can resolve this issue by shutting down all the instances before mounting the database.

Verify that no background processes running owner as oracle
Ps –ef |grep <$ORACLE_SID>

If you found any processes then shutdown the instance, if you are not able to shutdown then you can kill by using “kill -9 <processed>.

Now you should be able to startup without any issues.

Regards
Satishbabu Gunukula, Oracle ACE

Monday, May 18, 2015

Oracle Optimized Data Center Reference Architecture


IT departments are under constant pressure to increase their ability to respond rapidly to rapidly changing business requirements and select best technology while reducing cost and risk

This results in complexity and integration challenges.These effects add up to drive agility, cost, and risk in the wrong directions. While it is clear that cloud computing offers many potential benefits

Oracle’s optimized data center is a pragmatic solution to these problems. By providing a fully integrated stack, “from Applications to Disk”, the data center is greatly simplified while integration is already built- in. This paves the way for reduced cost and risk.

The key drivers for the optimized data center can be summarized as follows
  • Cost management: Virtualization/consolidation, simplification
  • Business gro wth: Removing barriers to infrastructure performance and flexibility
  • Service continuity: Maximum availability architecture, disaster recovery planning
  • Security and conformity: Comprehensive, end-to-end security and compliance approach
This paper published by Oracle Corporation and it will show in architectural terms how reduced risk reduced cost , and increased agility can be achieved through consistent integration and reduced complexity.

You can download the White paper "Oracle Optimized Data Center Reference Architecture"

Regards
Satishbabu Gunukula
http://www.oracleracexpert.com


http://www.oracle.com/technetwork/topics/entarch/oracle-wp-optmizd-dc-ref-arch-1918519.pdf

Wednesday, May 13, 2015

error while loading shared libraries: libSQLDBCHDB.so

While installing SAP HANA Database system I have received following error.

Do you want to create a customer incident? You can now:
Choose OK to create the support SAPCAR archive SUPPORT.SAR
Choose Stop to stop the task and continue later

We don't know what causing the issue and need to find the error from log file.

I found below error in log file "R3load.exe.log" under "/install/tmp/sapinst_instdir/BS2013SR2/ERP607SR2/HDB/INSTALL/DISTRIBUTED/ABAP/DB"
usr/sap/BWE/SYS/exe/uc/linuxx86_64/R3load: error while loading shared libraries: libSQLDBCHDB.so: cannot open shared object file: No such file or directory

By looking the error it looks like shared libraries libSQLDBCHDB is missing. This library is related to hana client and installation will use the client to connect to the database.

I want to make sure that library exists or not and ran find command. I was able to find the library

find . -name libSQLDBCHDB.so -print
./HANA/hdbclient/libSQLDBCHDB.so


That means library exists but not able to use this connect to HANA database. It looks like the issue is with Environment variable

When you come across this issue with HANA Client, make sure to check following
1. LD_LIBRARY_PATH is set properly
2. SAPSYSTEMNAME & DBMS_TYPE is set

In my case LD_LIBRARY_PATH library path does not have "hdbclcient" path, after updating correct path I was able to install successfully.

LD_LIBRARY_PATH=/usr/sap/HANA/SYS/exe/run:/usr/sap/HANA/SYS/exe/uc/linuxx86_64:/usr/sap/HANA/hdbclient

Note: You might receive this error during the maintenance also

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

Thursday, May 7, 2015

Terminating the instance due to error 16038 and unable to startup

I have encountered storage crash on one of the Database system. After storage is back online, not able to bring up the database. The database comes to mount stage and terminating the instance.

We are receiving below error.

ORA-03113: end-of-file on communication channel
Process ID: 5038
Session ID: 202 Serial number: 3


When I look into the alert.log I found below error messages

ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Mar 10 10:24:10 2015
Incomplete read from log member '/oracle/ORAC/datafile/ORAC/onlinelog/ORAC_Redo1_.log'. Trying next member.
ARCH: All Archive destinations made inactive due to error 333
ARCH: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/ORAC/archiveORAC_ARCH_347548987.dbf' (error 333) (ORAC)
Committing creation of archivelog '/oracle/ORAC/archive/1_3541_854889367.dbf' (error 333)
Errors in file /oracle/diag/rdbms/orac/ORAC/trace/ORAC_ora_23498.trc:
ORA-16038: log 1 sequence# 3541 cannot be archived
ORA-00333: redo log read error block count
ORA-00312: online log 1 thread 1: '/oracle/ORAC/datafile/ORAC/onlinelog/ORAC_Redo1_.log'

USER (ospid: 23498): terminating the instance due to error 16038
Tue Mar 10 10:24:12 2015
System state dump requested by (instance=1, osid=23498), summary=[abnormal instance termination].
System State dumped to trace file /oracle/diag/rdbms/orac/ORAC/trace/ORAC_diag_23470.trc
Dumping diagnostic data in directory=[cdmp_20150310102412], requested by (instance=1, osid=23498), summary=[abnomal instance termination].
Instance terminated by USER, pid = 23498


By looking the error, I can see that one of the online redo is corrupted. Archive process cannot able to archive to disk. In order to bring up the database you need to clear the corrupted redo log.

From ALERT.LOG file, I am able to identify that group 1 redo log 1 corrupted. By using below command I have cleared the unarchived log file

SQL> alter database clear unarchived logfile ‘/oracle/ORAC/datafile/ORAC/onlinelog/ORAC_Redo1_.log'

If you find all multiplexed redo members are corrupted then you need to run below command to clear the GROUP.

SQL> alter database clear unarchived logfile group 1;

Now I am able to bring up the database. But note that you cannot able to bring the database back beyond corrupted point using old backups. Now you must take one FULL database backup.

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

ORA-16038: log 1 sequence# 3541 cannot be archived

I have encountered storage crash on one of the Database system. After storage is back online, not able to bring up the database. The database comes to mount stage, but going down.

We are receiving below error.

ORA-03113: end-of-file on communication channel
Process ID: 5038
Session ID: 202 Serial number: 3


When I look into the alert.log I found below error messages

ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Mar 10 10:24:10 2015
Incomplete read from log member '/oracle/ORAC/datafile/ORAC/onlinelog/ORAC_Redo1_.log'. Trying next member.
ARCH: All Archive destinations made inactive due to error 333
ARCH: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/ORAC/archiveORAC_ARCH_347548987.dbf' (error 333) (ORAC)
Committing creation of archivelog '/oracle/ORAC/archive/1_3541_854889367.dbf' (error 333)
Errors in file /oracle/diag/rdbms/orac/ORAC/trace/ORAC_ora_23498.trc:
ORA-16038: log 1 sequence# 3541 cannot be archived
ORA-00333: redo log read error block count
ORA-00312: online log 1 thread 1: '/oracle/ORAC/datafile/ORAC/onlinelog/ORAC_Redo1_.log'

USER (ospid: 23498): terminating the instance due to error 16038
Tue Mar 10 10:24:12 2015
System state dump requested by (instance=1, osid=23498), summary=[abnormal instance termination].
System State dumped to trace file /oracle/diag/rdbms/orac/ORAC/trace/ORAC_diag_23470.trc
Dumping diagnostic data in directory=[cdmp_20150310102412], requested by (instance=1, osid=23498), summary=[abnomal instance termination].
Instance terminated by USER, pid = 23498


By looking the error, I can see that one of the online redo is corrupted. Archive process cannot able to archive to disk. In order to bring up the database you need to clear the corrupted redo log.

From ALERT.LOG file, I am able to identify that group 1 redo log 1 corrupted. By using below command I have cleared the unarchived log file

SQL> alter database clear unarchived logfile ‘/oracle/ORAC/datafile/ORAC/onlinelog/ORAC_Redo1_.log'

If you find all multiplexed redo members are corrupted then you need to run below command to clear the GROUP.

SQL> alter database clear unarchived logfile group 1;

Now I am able to bring up the database. But note that you cannot able to bring the database back beyond corrupted point using old backups. Now you must take one FULL database backup.

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

Monday, February 9, 2015

Oracle RMAN New Features in Oracle 12c - Part 3

Hi Everyone,

My articles published in Oracle Experts website media "Allthingsoracle.com" by RedGate

Please view the article using below link.

Oracle Database 12c – RMAN New Features: Part3

In this article I will cover:
  • Cross-Platform Backup and Restore Improvements
  • Recovering Tables and Table Partitions using RMAN Backups
  • Unified auditing and RMAN
Please check Part1 & Part 2 for more features.

This article will help all Oracle Community to understand new enhancements and additions in Recovery Manager (RMAN) and take advantage of new features for efficient backup & recovery.

I hope you will like the article and it will be helpful to you.

Please leave your valuable comments.

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

Monday, January 12, 2015

Oracle GoldenGate 12c New Features - Part2

Hi Everyone,

My articles published in Oracle Experts website media "Allthingsoracle.com" by RedGate

Please see the article using below link.

Oracle Golden Gate 12c New Features – Part 2

In this article I will cover:

  • Security
  • Coordinated Replicat
  • New 32K VARCHAR2 Support
  • High Availability (HA) enhancements
  • Support for Other Oracle products
  • Improvements to feature Functionality
This article will help all Oracle Community to understand Oracle GoldenGate 12c new features and how it helps in continuous availability, disaster tolerance and real-time data integration solutions that enable the management and movement of transactional data across the enterprise.

I hope you will like the article and it will be helpful to you.

Please leave your valuable comments.

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