Downloadable Interactive Quick Reference for Oracle Database 12c available @
http://www.oracle.com/go/?&Src=7875565&Act=4&pcode=WWOU13045613MPP009
Oracle Database 12c Interactive Quick Reference Guide
Posted by Sriram Sanka on August 8, 2013
Posted in Uncategorized | 5 Comments »
ORA-07445: exception encountered: core dump [kttuser0()+272] [SIGFPE] [Integer divide by zero] [0x8949718] [] []
Posted by Sriram Sanka on February 18, 2013
Today, we were encountered with this internal error on One of our test environment.
On Our Database ,we have 2 temporary table-spaces with a Temporary table space group.
While we are performing Data pump Import (IMPDP) into another machine , The job was failed multiple times with following error on screen ….
Screen Error :Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name “DW01” prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.When I verified for the cause, on alert log, found an Internal error only after Temporary tablespace creation ..
Alert log Content :
CREATE TEMPORARY TABLESPACE “TEMP_TWO” TEMPFILE ‘/u01/app/oracle/oracle/product/10.2.0/oradata/*****/temp02.dbf’SIZE 844103680 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M TABLESPACE GROUP TBS_GROUP EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
ORA-1119 signalled during CREATE TEMPORARY TABLESPACE “TEMP_TWO” TEMPFILE ‘/u01/app/oracle/oracle/product/10.2.0/oradata/********/temp02.dbf’ SIZE 844103680 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M TABLESPACE GROUP TBS_GROUP EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 …
Sun Feb 17 13:18:26 PST 2013
Thread 1 advanced to log sequence 47 (LGWR switch)
Current log# 2 seq# 47 mem# 0: /u01/app/oracle/*****/*****/redo02.log
Sun Feb 17 13:18:32 PST 2013
Errors in file /u01/app/oracle/******/admin/******/bdump/*****_dw01_24538.trc:ORA-07445: exception encountered: core dump [kttuser0()+272] [SIGFPE] [Integer divide by zero] [0x8949718] [] []
Creating the temp tablespaces manually before IMPDP process will avoid such errors.
For More info please read metalink document ID 1259393.1
Posted in Uncategorized | 2 Comments »
ORA-27102: out of memory” While Creating a Database
Posted by Sriram Sanka on September 24, 2012
Today ,While Installing Oracle V 10g Using DBCA On a 32 bit Linux machine with 16 GB of RAM,(allocated 5GB as SGA ) We were encountered with this Error and unable to go further.
[oracle@db ~]$ oerr ORA 27102
27102, 00000, “out of memory”
// *Cause: Out of memory
// *Action: Consult the trace file for details
[oracle@db ~]$
This is Because of On 32 Bit version,It cannot allocate more than 4 GB of Memory to a process Directly.For this either we need to upgrade to 64 bit and start the Installation or decrease the Memory total value.
So we decreased the total memory size to 2.5 GB and It went successful without any issues.
Read Oracle Meta link Document ID 430492.1 to get More Information on this.
Happy reading 😉
Posted in Oracle Server Administration | Tagged: ORA-27102 :Out of Memory | 7 Comments »
Microsoft__SQL_Server__2012_Pocket_Consultant By William R. Stanek
Posted by Sriram Sanka on May 8, 2012
Well written and Well Organised resource for DB Admins By William R. Stanek
This Book really suits for
- Current SQL Server database administrators.
- Accomplished users who have some administrator responsibilities.
- Administrators migrating to SQL Server 2012 from previous versions.
- Administrators transitioning from other database architectures.
I like the way author Presented the topics in a step-by-step manner and well categorized topics.
- Managing Your SQL Servers
- Managing SQL Server Services and Clients
- Implementing Policy-Based Management
- Configuring and Tuning Your SQL Servers
- Tuning and Linking Your SQL Servers
- Database Administration Essentials
- Implementing SQL Server 2012 Security
- Manipulating Schemas, Tables,and Views
- Using Indexes, Constraints, and Partitions
- Automating and Maintaining SQL Server 2012
- SQL Server 2012 Backup and Recovery
- SQL Server 2012 Profiling and Monitoring
You can get the book from http://shop.oreilly.com/product/0790145337627.do
Posted in Books | Leave a Comment »
SCN – What, why, and how?
Posted by Sriram Sanka on January 20, 2012
Posted in Oracle Server Administration | Tagged: scn | Leave a Comment »
Article From Infoworld about Oracle Code flaw
Posted by Sriram Sanka on January 19, 2012
Yesterday, there was an interesting article was posted/published On InfoWorld By Paul Venezia.
http://www.infoworld.com/d/security/fundamental-oracle-flaw-revealed-184163
http://www.infoworld.com/t/data-management/calling-all-oracle-customers-184103?source=fssr
Oracle has published this On Its MOS Bug 12371955 Backup task can cause increased SCN growth rate leading to ORA-600 [2252] errors with Document ID [ID 12371955.8] and Old existing Document 253977.1 will also give some information on it.
for this to be fixed , One should apply the latest CPU patch released on 18-Jan-2012 by Oracle.
Oracle has published an article on MOS yesterday: note 1376995.1 with an associated script “scnhealthcheck.sql” you can find and download in note 1393363.1.which are very helpful.
Posted in Uncategorized | Tagged: infoworld, oracle, oracle customers | Leave a Comment »
SQL and Relational Theory, 2nd Edition by C.J. Date
Posted by Sriram Sanka on January 19, 2012
C.J. Date, is an independent author, lecturer, researcher, and consultant, specializing in relational database technology. He is best known for his book An Introduction to Database Systems.This book does n`t deal with SQL statements .. But is all about between SQL and the Relational concepts theory in a mathematical way.How SQL departs from relational theory, the basic principles of relational theory etc…
This Book contains 12 Chapters .. you can find Exercises at the end of each chapter.I like the Appendix section of this Book.
Appendix A: The Relational Model
Appendix B : SQL Departures from the Relational Model
Appendix C: A Relational Approach to Missing Information
Appendix D: A Tutorial D Grammar
Appendix E: Summary of Recommendations
Appendix F: Answers to Exercises
Appendix G: Suggestions for Further Reading.
I recommend this book for all who works with SQL.
you can find his books and videos @ http://www.oreillynet.com/pub/au/2136
Posted in Books | 1 Comment »
New My Oracle Support interface….Soon
Posted by Sriram Sanka on January 19, 2012
On 17-Jan-2012,Oracle Announced,That its going to upgrade (New) My Oracle Support User interface, which Oracle ADF.
For More details Please refer The New My Oracle Support User Interface [ID 1385682.1]
http://www.dba-village.com/village/dvp_news.NewsDetails?NewsIdA=3874
Posted in Uncategorized | Leave a Comment »
ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of bounds in PH2POP.], [0], [1240], [], [], [], [], []
Posted by Sriram Sanka on January 11, 2012
Recently we upgraded Our Development Database from Oracle V10.2.0.1 to V10.2.0.5.
Today While I was Compiling an Invalid procedure,
ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of Encountered.
bounds in PH2POP.], [0], [1240], [], [], [], [], []
No clues available On “alert-log” file.
Verified with Oracle Support about it and found that its a Bug{Bug 10400244} on 10.2.0.5.
Oracle Meta-link Document [ID 1358114.1] Will give some clues about it.
Fixing errors other than this Internal error will resolved this issue.
Posted in Oracle Server Administration | Tagged: development database, internal error, oracle support | 11 Comments »
“racgmain” Processes
Posted by Sriram Sanka on October 3, 2011
Some good Experience for Me today.Early in the Morning ……
One of Our RAC node filled up with 100% CPU usage.As part of Investigation We found that this was because of racgmain Process.
It was filled-up with more than 250 racgmain process which are consuming CPU a lot.Due this Our System got Very slow.
To avoid this, we should apply latest patch which is > 10.2.0.5 and CRS patch too.There was a temporary workaround for this ..you can see that in Metalink Doc ID 732086.1 and ID 6196746.8
Posted in Oracle Server Administration, Uncategorized | Leave a Comment »
Not Just Databases 