Sriram Sanka

Databases | Cloud | Infrastructure | Security |

Oracle Database 12c Interactive Quick Reference Guide

Downloadable Interactive Quick Reference for Oracle Database 12c available @ http://www.oracle.com/go/?&Src=7875565&Act=4&pcode=WWOU13045613MPP009
ORA-07445: exception encountered: core dump [kttuser0()+272] [SIGFPE] [Integer divide by zero] [0x8949718] [] []

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 :…
ORA-27102: out of memory” While Creating a Database

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…
Microsoft__SQL_Server__2012_Pocket_Consultant By William R. Stanek

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…
SCN – What, why, and how?

Here is a good article about SCN see the link below SCN – What, why, and how?
Article From Infoworld about Oracle Code flaw

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…
SQL and Relational Theory, 2nd Edition by C.J. Date

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…
New My Oracle Support interface….Soon

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
ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of bounds in PH2POP.], [0], [1240], [], [], [], [], []

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 bounds in PH2POP.], [0], [1240], [], [], [], [], [] Encountered. No clues available On “alert-log” file. Verified with Oracle Support about it and found that its a…
“racgmain” Processes

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…