tag:blogger.com,1999:blog-17353788109917121492012-02-16T12:39:53.576+03:00My Oracle Database Administration EndeavorZ. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.comBlogger521100tag:blogger.com,1999:blog-1735378810991712149.post-73072223434233769862012-02-14T12:11:00.000+03:002012-02-14T12:11:36.641+03:00

Oracle has been supporting Oracle Databases on z/OS since version 8. "Experiences with Oracle Database 10g on z/OS", is a good IBM Publication that describes experiences with the installation process of Oracle 10g on z/OS. http://www.redbooks.ibm.com/abstracts/sg247055.html "Oracle® Database Installation Guide 10g Release 1 (10.1) for IBM z/OS (OS/390)" from Oracle is a detailed documentation

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-17469398610132961142011-10-04T13:19:00.000+03:002011-10-04T13:19:01.079+03:00

The September 2011 Edition of Toad World PIPELINE Newsletter has published my third Oracle Technical Paper titled "How to resolve Root Certificate Expiry Issue for Enterprise Manager - Database Control". In it I have tried to explain how to resolve the Oracle Enterprise Manager – Database Control configuration errors for Oracle Database versions 10.2.0.4 or 10.2.0.5, as a result of the expired

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-80900199264592057782011-05-04T21:30:00.007+03:002011-05-17T21:35:24.603+03:00

Got my CISA Certification today and now I am CISA Certified. I had applied for Certification for CISA in March '11. And now I am a Certified Information Systems Auditor, as opposed to being Qualified based on passing the exam. The minimum benefit of this is that my name can have CISA appended to it. What more can I derive, is yet to come in my way as I progress in career. :) To certify, I

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-7146933109176193082011-04-05T22:05:00.000+03:002011-04-24T22:05:29.277+03:00

Finally, cleared my OCP 9i Database on 5th April. I had kept it pending for quite sometime. I should be getting my Oracle 9i database administration OCP certificate and the Managing Oracle 9i Database on Linux certificate in a month or so.

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-78667260282653161462011-03-20T16:04:00.000+03:002011-03-20T16:04:04.294+03:00

Amazing post on how to convert a Single-Instance Database to a Real Application Cluster using RCONFIG. Please do have a look at this post. It includes a comprehensive presentation on the subject. Converting your single-instance database to RAC with RCONFIG

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-15213706581755728692011-01-31T21:57:00.002+03:002011-02-02T13:54:02.690+03:00

I had appeared for CISA (Certified Information Systems Auditor) on 11th December, 2010 in Kuwait. Because of the amount of efforts put in for this examination, I have been anxiously waiting for the results. When I saw the email from ISACA in my inbox.... all I can say is my heartbeats were quite higher than normal... Adrenaline was doing its job. When I saw "PASSED" in the message body... there

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com3tag:blogger.com,1999:blog-1735378810991712149.post-79355166610972198392010-12-01T09:29:00.000+03:002010-12-01T09:29:16.598+03:00

tnsManager is an interesting tool by Andrew Barry to centralize your TNSNames management. Version 1.8.3 is the latest stable build. Simple steps and easy to deploy and manage. It is available for both Windows and Linux Environments. You can also configure tnsManager for High Availability.Test it out, it should be fun. You can download the installation and check out the Installation Guide and

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-2765165686511792082010-12-01T08:48:00.003+03:002010-12-01T08:53:05.208+03:00

ORA-19804: cannot reclaim string bytes disk space from string limit I received ORA-19804 on one of my RMAN clone jobs this morning. RMAN-00571: =========================================== RMAN-00569: ========= ERROR MESSAGE STACK FOLLOWS ========= RMAN-00571: =========================================== RMAN-03002: failure of Duplicate Db command at 11/30/2010 17:59:32 RMAN-03015: error

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-20911069934483993112010-11-19T19:52:00.003+03:002010-11-19T20:00:18.105+03:00

Installation of Oracle 10gR2 database on RedHat Enterprise Linux/Oracle Enterprise Linux 5 (x86_64) WEDNESDAY, NOVEMBER 17, 2010 | AGIS STAMATOPOULOS As root 1) Check Hardware Requirements # grep MemTotal /proc/meminfo >= 1Gb # grep SwapTotal /proc/meminfo  Between 1024 MB and 2048 MB 1.5 times the size of RAM  Between 2049 MB and 8192 MB Equal to the size of RAM  More than 8192 MB 0.75 times

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-6144256843611193162010-09-14T09:38:00.002+03:002010-09-14T09:48:38.199+03:00

The Seven Deadly Habits of a DBA . . and How to Cure Themby Paul ValléeCalling widespread bad habits in database administration "deadly" may seem extreme. However, when you consider the critical nature of most data, and just how damaging data loss or corruption can be to a corporation, "deadly" seems pretty dead-on.Although these habits are distressingly common among DBAs, they are curable with

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-7997635838379119282010-05-12T10:21:00.003+03:002010-05-12T10:29:37.266+03:00

The May 2010 Edition of Toad World PIPELINE Newsletter has published my second Oracle Technical Paper "Database Disaster Recovery using only RMAN Backups".Infact, they asked me to re-write the paper using Oracle 10g or 11g so that we could relate it with the supported versions. I have chosen Oracle 10g R2 (10.2.0.4) Standard Edition on Windows O/S to demonstrate the same.Here is the link to Toad

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-67677719173497203692010-04-06T14:19:00.008+03:002010-05-12T10:31:50.917+03:00

Today, I have successfully published my Oracle Technical Paper titled "Database Disaster Recovery using only RMAN Backups" under My Oracle Support Community (formerly known as Oracle Customer Knowledge Exchange)Link: https://communities.oracle.com/The technical paper demonstrates how an Oracle Database can be recovered or reconstructed by using only the RMAN Backup files in case of a complete

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com1tag:blogger.com,1999:blog-1735378810991712149.post-76966969032160294862010-04-01T13:15:00.002+03:002010-04-01T13:38:23.468+03:00

After our successful production database migration to 10gR2 (10.2.0.4), we came across a few user complaining about sorting issue in specific screens. On further investigation, we found out that some screens having fields with list of data values were not ordered, as they were in 9iR2.Upon a little googling we found an interesting case at Jaffar's blog "Change behavior of GROUP BY clause in

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-13821075974517363482010-03-14T14:38:00.006+03:002010-05-20T12:32:29.750+03:00

Last week, I was searching of some ASM contents on google and came across this great ASM post on "Shafiulla Oracle DBA Blog".Although, Conceptual Details on ASM were hardly touched, but the post was pretty straight-forward and a direct technical approach. Any DBA can use content to get their hands on 10g ASM. And, so I thought of working on the contents in my test 10g environment. And within a

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-16688398463568265252010-03-06T17:00:00.000+03:002010-03-06T17:08:07.647+03:00

On the 20th Feb 2010, we successfully migrated our entire system onto the new server, and the migrated the 9iR2 Production Database to 10gR2 Database (10.2.0.4), and the system were made available for the end users.Just a little bit about the server configuration:IBM x3650 Server, Xeon Quad Core E5430 2.66 GHz, with 16 GB RAM, having around 500 GB storage after RAID configurations.The Testing

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-58828083472505912952010-03-06T16:00:00.002+03:002010-03-06T16:24:00.370+03:00

RMAN Backups in Oracle Database 10g Standard Edition enables us to take compressed backups. "AS COMPRESSED BACKUPSET" is the addition in the default backup command:BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;Well, that should be good, so I put the backup command at test for my newly migrated 10g Database. Here we go...My Normal RMAN Backup takes an average of 30 minutes to complete,

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com4tag:blogger.com,1999:blog-1735378810991712149.post-38245510849490515672010-02-23T11:45:00.017+03:002010-04-11T09:59:06.881+03:00

Every DBA has to ensure that his hours spent in planning and testing the backup-recovery strategy works, especially it should be relied upon in any unexpected scenarios occur. We DBAs are always tend to be at ease when our scheduled backup jobs are performing well and are error-free, followed by couple of recovery testings scenarios.Nevertheless, there are always scenarios which may be left

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com6tag:blogger.com,1999:blog-1735378810991712149.post-43752695455980491142010-02-02T14:43:00.004+03:002010-02-02T15:28:25.138+03:00

Check the values of audit parameters of your 10g Database, as it is a default disabled feature.SQL> show parameter auditNAME TYPE VALUE------------------------------------ ----------- ------------------------------audit_file_dest string E:\ORACLE\ADMIN\ORCL\ADUMPaudit_sys_operations boolean FALSEaudit_trail string NONEThe AUDIT_TRAIL parameter can be used to enable auditing by setting one of the

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com1tag:blogger.com,1999:blog-1735378810991712149.post-81346408866277509482010-01-04T10:44:00.006+03:002010-01-04T11:15:46.560+03:00

Quick update on the server migration status. It's been long since I haven't written on this.Well, to start with, the Server is Huge and Powerful. That's what I would say as a summarized version. We carried out a simulated migration on the new server, and it was well-planned, quite simple and successful.Oracle 10g R2 base release installation was done first,Oracle 10.2.0.4 patchset was applied to

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-6804439896282693882009-12-31T09:42:00.002+03:002009-12-31T09:46:35.298+03:00

I came across this article "What Type of DBA Are You?" by Donald Burelson. Found it interesting and a little hilarious, especially the last part about having more than 1 DBAs working together.He categorizes DBAs into 3 types. Try to find what DBA Catagory you belong to.

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-53114630546691864712009-12-12T09:37:00.000+03:002009-12-13T09:52:04.592+03:00

Just thought of sharing an Exerpt from a PM Article "Project Memoirs: Real Projects, Real Lessons" written by Micheal Wood on http://www.gantthead.com/, which might be of interest to Developers and DBAs too. Eventually, we would all be climbing up the ladder and may face similar decision making situations. Here it goes...Lesson 4: Focusing on FTE efficiency can derail real progress.One of the

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-58770621145586778722009-11-09T11:02:00.004+03:002009-11-09T11:49:26.063+03:00

Oracle Enterprise Manager - Database Control (dbconsole) is something that usually installed and configured automatically whenever you install a new Oracle 10g database, using Database Configuration Assistant.I was wondering, if i was to delete the service or remove Enterprise Manager - Database Control, how is it possible to bring back EM! This is what I did to figure manually install and

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com2tag:blogger.com,1999:blog-1735378810991712149.post-17717803344606005372009-09-24T22:20:00.002+03:002009-09-24T22:24:40.889+03:00

Yesterday, I came to know that we have received the new server. The installations & configurations will be done on Saturday, and will be made available to me to carry out the Migration. I will share more on it soon, including the Server Configurations.

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-43649084805799972572009-07-09T09:18:00.005+03:002010-05-12T10:31:50.918+03:00

Today, I was immensely delighted to know that the Toad World PIPELINE Newsletter (July '09 Issue) is about to be released. You might question me why the emotions at display? I had sent my Oracle Technical Paper (the one which was published in Oracle Customer Knowledge Exchange in Apr '09) to the Technical Content Editor of Quest Software, after which it was immediately considered for being

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-48998194370579717002009-06-17T10:02:00.013+03:002009-06-17T11:53:01.426+03:00

The test setup for selected users was functioning smoothly. This bought us sometime to look for the bad Disks in local Market. The IT Administrators somehow managed to get the Disks. By the en of the 3rd Day, they replaced and rebuilt the Disks in the RAID5 Configuration. The O/S Partition was formatted and server O/S was upgraded to MS Windows 2003 Server [Standard Edition].We managed to recover

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-40553935902838028632009-05-31T08:46:00.013+03:002009-06-17T11:51:31.037+03:00

Finally, I am able to write on the Production Server Crash that happened at 07:25 am on 14th May '09.Our server has a 4 disk configuration for RAID5. We had encountered a disk failure couple of weeks back, which was recovered the same day. That was when our ERP Database Files had got corrupted. You can read about it here.This time, 2 Disks of the RAID5 Configuration crashed and to survive a crash

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-58427257381959863382009-05-24T07:47:00.004+03:002009-05-24T10:30:53.820+03:00

This is in relation with the earlier post "Investigating Hiccups in RMAN Implementation for Production Database", where I was trying to find out the severe performance issues when I carried out RMAN Backup on a network storage (SAN, available to me as NAS). Here are the findings from the earlier tests:The backup tablespace size is 1.36 GB with one datafile.The backup piece size in all 3 test

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-39912536268868194512009-05-19T14:40:00.005+03:002009-05-24T14:11:34.683+03:00

Last week, to be more precise 14th May '09, we had a major Server Crash. More than 2 of the Disks in the RAID5 Configuration went Poof!!! And yes, We brought the Server back from the dead, even though it really needed to lay in its grave this time (server's been running for more than 7-8 years) !!!! Can't wait to share with you my last week's experience, but before I post about it I need to carry

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-91101069020337983402009-05-05T12:33:00.004+03:002009-05-24T11:48:48.455+03:00

Today, I created a crash scenario by deleting all the files (including the archives and backups) in the FLASH RECOVERY AREA (C:\oracle\flash_recovery_area) in in my test 10G database. After which, I was only able to mount the database. A "startup" or an "alter database open" gave the following error: "ORA-38760: This database instance failed to turn on flashback database".Here, I will show how I

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-55702837107098330832009-05-03T21:02:00.003+03:002009-05-24T11:50:21.017+03:00

I was looking for notes on Oracle Data Guard Installation and Troubleshooting on Metalink (My Oracle Support), and accidentally found this great Metalink Note on Real Application Clusters. Thought of sharing this information on the blog. It will surely help us some day.Subject: Documentation Index for Real Application ClustersDoc ID: 188135.1                                     Type:REFERENCE 

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-25021085814352991662009-04-30T11:41:00.005+03:002009-05-24T08:09:40.148+03:00

Yesterday at 01:12 pm, the production instance crashed. We were reported of "Shared Memory Realm Does not Exist" error by the users.I noticed in the Alertlog, that the Control File (control05.ctl) was having some problem.Wed Apr 29 13:04:37 2009Errors in file d:\oracle\admin\orcl0\bdump\orcl_arc2_4852.trc:ORA-00202: controlfile: 'C:\ORACLE\ORADATA\ORCL\CONTROL05.CTL'ORA-27091: skgfqio: unable to

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com2tag:blogger.com,1999:blog-1735378810991712149.post-47333274540790330692009-04-14T13:16:00.005+03:002009-05-24T11:49:20.379+03:00

There was a simple question on OTN Forum today, yet the answer to it required a re-think on how to put the words right."Hi,anybody can expain what is the difference between starting the Oracle Services(using SERVICES.MSC) and starting the oracle instance (using Startup commant) ?. whats happening in oracle while doing these things?"Although most of us know the concepts behind the question, at

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-21863612444889402862009-04-11T13:38:00.007+03:002009-04-12T09:44:57.077+03:00

Data Pump Components:There are 3 major components of Data Pump Technology:DBMS_DATAPUMP packageIn this package are the procedures used to carryout the Data Pump export and import activities.DBMS_METADATA packageThis package is used to extract the metadata of the data dictionary objects.expdp, impdp client utilitiesUsing "expdp", you can extract data objects from the source database. And, using "

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com1tag:blogger.com,1999:blog-1735378810991712149.post-37361285252278032452009-04-09T11:56:00.007+03:002009-04-09T12:41:19.176+03:00

I am reading through "OCP Oracle Database 10G: New Features for Administrators Exam Guide" by Sam R. Alapati. A must read for 9i DBAs looking to upgrade skills to Oracle 10G.In 10G, there is a new background process called MMON [Manageability Monitor Process]. MMON keeps track of the High Water Mark Statistics and the Database Usage statistics, recording it in AWR [Automatic Workload Repository].

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-60501877613400427202009-04-09T09:57:00.004+03:002009-04-09T10:00:38.497+03:00

I really liked the template "Minima Dark", but had to change the template to "Minima Stretch", for better readability of texts, scripts and codes.

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-30301262348944759502009-04-07T13:57:00.021+03:002009-04-08T10:09:27.054+03:00

I mentioned in one of my RMAN posts earlier, that there was one feature that I really liked about RMAN. Well, today is your lucky day!!! I am going to talk about Database Cloning using RMAN.I am sure most of you would be very well aware of RMAN''s Duplicate Command. We will see the command in action.Before you start cloning you should fulfill the following pre-requisites:Target Database must be

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-34214063636949983052009-04-02T10:57:00.006+03:002009-04-09T12:41:02.198+03:00

While I was taking up the RMAN Backup performance issue along with support, I also posted the query on OTN Forums (http://forums.oracle.com/forums/message.jspa?messageID=3320320#3320320).I carried out the tablespace RMAN backup on the Database Server and then copied it to Blade5 SAN location. When I did a normal copy it took only 2 minutes as opposed to 21 minutes.This was what one contributor

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com1tag:blogger.com,1999:blog-1735378810991712149.post-6571902388133204612009-04-02T09:46:00.003+03:002010-05-12T10:31:50.918+03:00

Dear Friends & Colleagues,Today, with the grace of Almighty, I have achieved one of the major milestones of my career.I have successfully published my Oracle Technical Whitepaper titled "My Journey from 9.0.1 to 9.2.0.8" on Oracle Customer Knowledge Exchange (https://communities.oracle.com/). The paper is based on my work/accomplishments as an Oracle Database Administrator here in Integral

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com3tag:blogger.com,1999:blog-1735378810991712149.post-75851473828888006322009-03-25T11:35:00.012+03:002009-04-09T12:40:09.382+03:00

The Action Plan for Oracle R1 (9.0.1) to Oracle R2 (9.2.0.8) migration was in place, and the scheduled full export dumps of the production instance were generating around 9 GB dump file. I coordinated with the IT Admins and arranged for a Test Machine, where I could carry out series of migration tests with both Manual Upgrade Process and Database Upgrade Assistant.I had to set up an environment

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com3tag:blogger.com,1999:blog-1735378810991712149.post-18162019328818822552009-03-19T13:20:00.000+03:002009-04-09T12:40:09.382+03:00

Within the first few weeks when I had joined the Company, it was brought to my attention that the System Crashes were quite frequent, and that I had to resolve it at the earliest to prevent downtimes having business impact. I had inquired and gathered enough non-technical information regarding the System Crash Issue from the perspective of the Developers, the IT Admins, and few of the users. I

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-19591615863015890212009-03-18T08:41:00.002+03:002009-03-18T08:51:31.836+03:00

I received an email from Oracle University. So thought of sharing the discount information on variaous Oracle Exams with Oracle colleagues and aspirant in India.Hope it helps.SAVE 25% of all Oracle9i and 10g Exams -HURRY BOOK YOUR SEATS NOW!( Limited seats per week per centre)Exam Dates: 21st, 28th March 2009Hurry, Register Now!Please contact the below Oracle Representatives for exam

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-81407178115283606362009-03-17T08:36:00.003+03:002009-03-17T14:56:12.716+03:00

I heard about Oracle APEX from a lot of people, and that it was really a gem in designing Oracle Web Applications. I was wondering like Oracle IAS, we would need to know a lot of Java to do the same. But, to my surprise, Oracle Application Express was a true "Oracle SQL, PL/SQL" Web based developement tool. Everything you design, develop and deploy comes from the database.You need to have an

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-23575388720116319702009-03-03T15:46:00.004+03:002009-04-09T12:41:02.198+03:00

My RMAN Implementation is stuck at the point of near to "Implemented".I have configured the Production Database in Archivelog Mode.I have created a Recovery Catalog.I have registered the Production Database.I have set all the configuration required for the Disk Backup to a shared SAN location.But, RMAN backup to the shared SAN location is "killing" slow. It takes around 8-13 hours to have a full

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-37040627576191679612009-02-24T14:57:00.025+03:002009-04-09T12:40:09.382+03:00

We've seen in the first part that some serious attention was needed towards few of the issues which were escalating day-by-day, namely:Blocking Locks, affecting user activitiesSerious Performance Degradation (Slow Performance, Session Hangs, etc.)System Crashes in Business Hours, causing downtimeAfter I joined the company, it took me a while to get the picture by studying the logs and regularly

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-86150830129674559262009-02-23T14:02:00.002+03:002009-02-23T14:22:10.505+03:00

Blat is a small, efficent SMTP command line mailer for Windows.Blat simplifies the command line by storing any or all of the following in the regestry [HKEY_LOCAL_MACHINE \ SOFTWARE \ Public Domain \ Blat].SMTP Server AddressSender's AddressNumber of times to retry sendingPort number to use (ie, if not the SMTP default of 25)The -q switch which "supresses *all* output" You need to use -install so

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-73120613177042183492009-02-22T10:15:00.005+03:002009-05-24T11:48:18.019+03:00

One fine day, while carrying out our daily health checks we came across an over-grown Temporary Tablespace. The Temporary Tablespace had over-grown to 12GB. Normally, our temporary tablespace has not exceeded beyond 1 GB. But due to some one-time un-tuned script that ran the other evening, the tablespace having autoextend set to unlimited had grown to 12GB. We needed to reduce the size of the

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-60852981590810583792009-02-22T09:39:00.022+03:002009-05-24T11:48:18.019+03:00

Couple of months back we were hitting a lot of deadlock issues. I found out that deadlocks occur due to unindexes foreign keys and found the following script to find and create unindexed foriegn keys.Using SQL*Plus, connect to the schema for which you need to find the unindexed foriegn keys. Then execute the following scripts:Script to find Unindexed Foriegn Keyscolumn columns format a30

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com3tag:blogger.com,1999:blog-1735378810991712149.post-88684830252071527552009-02-22T08:15:00.002+03:002009-05-24T11:48:18.019+03:00

I use the following SQL Scripts for finding top SQLs that may cause performance degradation.Top SQL by Disk Readsselect substr(sql_text,1,500) "SQL",(cpu_time/1000000) "CPU_Seconds",disk_reads "Disk_Reads",buffer_gets "Buffer_Gets",executions "Executions",case when rows_processed = 0 then nullelse (buffer_gets/nvl(replace(rows_processed,0,1),1))end "Buffer_gets/rows_proc",(buffer_gets/nvl(replace

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-67950944091523315252009-02-18T13:57:00.010+03:002009-04-09T12:55:22.526+03:00

Though, creating RMAN Full backup script is pretty simple, I would like to share my script and how to create it over here.Firstly, Invoke RMAN. Then, connect to your Recovery Catalog and Target Database.You can create a RMAN Full Backup Script by running the following:create script prod_full_bkp{CROSSCHECK BACKUP;CROSSCHECKARCHIVELOG ALL;Sql 'alter system archive log current’;BACKUP DATABASE;

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com2tag:blogger.com,1999:blog-1735378810991712149.post-48384790020266942542009-02-17T15:57:00.020+03:002009-04-09T12:40:09.383+03:00

I would like to share my experience on how we migrated the production instance from Oracle 9iR1 (9.0.1) to Oracle 9iR2 (9.2.0.8) in August 2008.To begin with, let me provide a background on what was the situation before I joined this company.Our company's ERP is based on Oracle Forms/Reports 6i and Oracle Database 9i . Ever since the ERP was implemented, i.e. more than 5-6 years back, the

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0tag:blogger.com,1999:blog-1735378810991712149.post-19492295664507148332009-02-17T13:57:00.010+03:002009-04-09T12:41:02.198+03:00

We implemented RMAN backup strategy our production instance earlier this week. We had daily logical full database backups scheduled and weekly cold backups for our 9.2.0.8 Production Instance. The Server did not have sufficient resources to be put in archivelog mode, as the server is pretty old. We arranged extra RAM and some space on the server to achieve the same. Why we couldn't upgrade the

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com6tag:blogger.com,1999:blog-1735378810991712149.post-23244629534780195722009-02-17T13:05:00.005+03:002009-05-24T14:07:50.465+03:00

I am an Oracle DBA working in Kuwait. Trying to learn more from the day-to-day activities and experiences, I will be sharing my knowledge, findings and experiences here for people to see and provide their valuable feedback.

Z. K.http://www.blogger.com/profile/06087328486121381840noreply@blogger.com0