tag:blogger.com,1999:blog-15611537533536738992012-02-16T01:55:34.821-06:00Learn about Oracle products you may not have known about. Oracle is not just a database company...Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.comBlogger261100tag:blogger.com,1999:blog-1561153753353673899.post-68590687719295029512010-09-13T04:08:00.004-05:002010-09-13T04:16:14.895-05:00

You dread the moment when it comes, but you find your self in a situation where you must failover your database. You have rehearsed the steps all along, but have never put a true failover into practice. So what do you do? Here are the steps demonstrating a failover scenario with Oracle Database 11g and Data Guard.Detecting a Failover Situation. Once I’ve established that it’s truly necessary to

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-85657222577079158332010-07-29T23:53:00.002-05:002010-07-29T23:57:28.914-05:00

How to Flashback Primary database with a Standby configuration. The Quick, Down and Dirty (if you want the why's, please read the documentation)To Flashback primary database execute following steps : 1. Shutdown primary database . SQL> SHUTDOWN IMMEDIATE 2. Start primary database in mount stage SQL> STARTUP MOUNT 3. Flashback primary database to specified scn SQL> FLASHBACK DATABASE TO SCN ;

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-63830823949876242742009-12-02T16:59:00.004-06:002009-12-02T17:04:57.911-06:00

By Linda SmithORACLE STREAMS BIDIRECTIONAL CONFIGURATION WITH CONFLICT RESOLUTION BEST PRACTICESThis section recommends best practice for configuring Streams for Oracle Database 10g Release 2. The discussions are divided into the following sections:• Guidelines for Preparing All Streams Configurations • Recommendations for Downstream Capture Configurations • Recommendations for Upstream (Local)

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-65896560636468541342009-10-26T17:04:00.005-05:002009-11-14T15:29:50.174-06:00

I normally do not gripe on my blog but this one has to be stated. When installing Oracle Enterprise Manager Grid Control 10gR2 you are required to finish the installation with several "recommended" packages. One in particular is the OMS Configuration package. Without this package, you mine as well kiss your hopes for Grid Control goodbye. To me, it is not "recommended" but essential.

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-18048950950460092132009-10-26T13:50:00.006-05:002009-10-26T14:01:20.394-05:00

ORACLE STREAMS CONFIGURATION BEST PRACTICES This section recommends best practice for configuring Streams for Oracle Database 10g Release 2. The discussions are divided into the following sections: · Guidelines for Preparing All Streams Configurations · Recommendations for Downstream Capture Configurations · Recommendations for Upstream (Local) Capture Configurations All

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-55634943953945510212009-06-19T13:11:00.010-05:002009-06-19T15:26:56.784-05:00

Using Oracle 10g RAC can be intimidating enough so if you do not have access to Grid Control, here is the quick, down and dirty way to setup Database Control for you cluster. By using Database Control on a RAC Cluster, it makes a DBA's life much easier then relying on command line alone.How to Set Up Database ControlBefore you begin running any commands, you will need a few things handy. You

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-37835836403793274812009-06-18T14:28:00.007-05:002009-06-18T14:43:40.691-05:00

Activating the Standby Database - Failover MethodIn the event of a disaster on the primary machine, you need to make the standby database active as soon as possible. In this example, it is assumed that the primary database server is not available and that the standby database needs to be activated as the primary database immediately. The standby database will need to be activated in its current

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com1tag:blogger.com,1999:blog-1561153753353673899.post-86845710720400358162008-08-11T23:50:00.023-05:002008-08-12T03:13:42.517-05:00

Recently, I had the pleasure of having to rebuild the control file on a three-node RAC cluster with two, single, stand-alone standby databases on different servers in different locations and all of them are using ASM. Sound like a handful? You bet! The most difficult portion was finding the information on how to do it.I've done hundreds of control file rebuilds dating back to Oracle7. I've

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com1tag:blogger.com,1999:blog-1561153753353673899.post-88601137275196831342008-05-23T00:37:00.019-05:002008-05-23T01:35:44.611-05:00

As a DBA, I dread the fact that Oracle is bound to release another critical patchset every 90 days and possibly another version patchset for the database very six months. Its always a struggle to know that once you have downloaded, tested and deployed one patchset to your 100 databases, its time to go and perform the same routine again. Most companies literally could hire a full-time DBA just to

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com2tag:blogger.com,1999:blog-1561153753353673899.post-32057335060656047212008-05-21T10:14:00.004-05:002008-05-21T10:30:36.313-05:00

As of Oracle 10g Database on UNIX and Linux varieties, many people have asked why does the installation guide advise the use of "oinstall" as the primary group and "dba" as the seconday group? Why is there a separate group just for the installation of the software? In past versions of Oracle Database, there was only one group: dba. Why are there now two?To further answer this question, I did

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com2tag:blogger.com,1999:blog-1561153753353673899.post-79863104381508813982008-03-19T14:47:00.004-05:002008-03-19T15:30:57.556-05:00

As I visit customers, I am asked time and time again "What is a DBA responsible for in the organization?" If you are a DBA you already know the job of the DBA seems to be everything that everyone else either does not want to do or does not have the ability to do. DBAs get the enviable task of figuring out all of the things no one else can figure out. The standard DBA needs to have an

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-4079461177085659722008-02-08T13:06:00.000-06:002008-02-08T13:23:17.670-06:00

QUESTION:Consider a table TEST having a single column called num which is of dataype NUMBER. Assuming that the table has 5 rows and all are integers in the num column. If one has to find the total of the num column for all the rows of thetable, it is quite simple. Use the aggregate function SUM().But, if one has to find the product of the num column, how would you do it ?NOTE: It has to be done

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com1tag:blogger.com,1999:blog-1561153753353673899.post-26808912893313938202008-01-02T14:45:00.000-06:002008-01-02T14:56:35.110-06:00

Oracle invites you to attend our Free Technology event: Innovate with Oracle 11g featuring speaker Tom Kyte from http://asktom.oracle.com/.To view the invitation and register, visit http://www.oracle.com/dm/08q3field/10545_ev_otd_multicities_jan08-feb08.htmlThe World's #1 Database Is Better Than Ever Oracle Database 11g: Innovate FasterManageability & Change Assurance MAA Audit & Database Vault

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-30549072213961654402008-01-01T21:06:00.000-06:002008-01-01T23:27:34.429-06:00

With Oracle 11g now well on its way in the market, I wanted to comment on one of the best new options available: Real Application Testing. Oracle 11g now allows DBAs the ability to capture their exisiting workload on a production system and play it back on a test system exactly as it behaved on production. Sound too good to be true? It isn't. In fact, its very easy to do.I have taken the time to

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com3tag:blogger.com,1999:blog-1561153753353673899.post-27019079520508733112007-11-11T01:11:00.000-06:002007-11-11T01:50:59.534-06:00

The next few blogs will discuss the new features that have been provided to streamline backup and recovery tasks. It utilizes the Flash Recovery Area, a feature that unifies related recovery files within a specific area and simplifies database administrator tasks. In previous releases of the Oracle database when you backed up the database using incremental backups, RMAN had to examine the entire

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com1tag:blogger.com,1999:blog-1561153753353673899.post-90756890127280081132007-11-11T00:58:00.000-06:002007-11-11T01:08:28.427-06:00

1. Turn on block checking.The aim is to detect, very early the presence of corrupt blocks in the database. This has a slight performance overhead, but Checksums allow Oracle to detect early corruption caused by underlying disk, storage system, or I/O system problems.SQL> alter system set db_block_checking = true scope=both;2. Turn on block tracking when using RMAN backups (if running 10g)This

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-47176474481244611872007-10-20T20:00:00.000-05:002007-10-22T12:57:19.334-05:00

It is easier than you think to upgrade your existing Oracle9i Database. In the past, there were several tedious, manual processes that had to be outlined and documented, tested and proven, prior to upgrading. With Oracle Database 10g, the upgrade process is available through the Oracle 10g Enterprise Manager. All tasks, processes, and post-upgrade tasks are available after your installation of

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-53635752328849930222007-09-28T16:50:00.000-05:002007-09-28T17:32:50.322-05:00

This describes how you can use the Enterprise Manager Database Control with its four main pages to proactively and reactively monitor and manage your database environment. In addition, this tutorial describes how you can find a starting point for various database administration tasks, view your host configuration, tablespace contents, historical performance data, alert log errors, and the

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-9516425373882560752007-09-28T15:47:00.000-05:002007-09-28T16:49:08.505-05:00

Configuring Linux for the Installation of Oracle Database 10gInstalled an Oracle Database 10 g certified version of Linux on a platform certified for that version of Linux. To see the latest certification information, use Metalink and select Certify & Availability . You can also use OTN .Checking the Hardware RequirementsThe system on which you install Linux must meet the following requirements:·

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com3tag:blogger.com,1999:blog-1561153753353673899.post-88605874847600468892007-09-28T15:39:00.000-05:002007-09-28T15:47:36.209-05:00

One of my latest adventures was to create a document on how to upgrade to Oracle Database 10g. Based on Garner, over 50% of Oracle Database customers are now beginning the process of evaluating, testing, an upgrading to Oracle 10g. I designed what I call a "cookbook" to help make the upgrade process faster and for DBAs to learn the steps quicker than reading the manual. In this next series of

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-27912913594806441732007-09-12T18:45:00.000-05:002007-09-14T12:40:22.274-05:00

Most customers I know that have upgraded to 10g or currently on 10g do not know about the how Oracle 10g handles statistics. Oracle 10g Database offers a new and improved tool for diagnosing Database Performance issues. It's called the Automated WorkLoad Repository (AWR). However, there are still a number of customers using statistics package (statspack) intially introduced in Oracle 8i. The goal

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-89795399200877852242007-08-23T14:42:00.000-05:002007-08-23T15:43:12.439-05:00

Rich Niemiec, CEO of TUSC, published his latest and greatest performance tuning book: Oracle Database 10g Performance Tuning Tips & Techniques. As with all of Mr. Niemiec's books, it is a well documented, easy to read and follow, providing DBAs and Developers insight to establish Best Practices and Tip & Tricks on tuning the Oracle 10g database. To my surprise, Mr. Niemiec has acknowledge me in

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-13082938079148620212007-08-04T01:56:00.000-05:002007-08-23T15:42:30.111-05:00

Oracle has announced their newest version for availability soon. A description of the 11g New Feature is available on OTN here. Since I have had a chance to use the latest verstion, I have listed my Top Ten New Features of Oracle Database 11g:1. Database ReplayIn my eyes this is the best New Feature of all! After many years of frustrated code testing, lack of code testing, implementing patches

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-30768598683646777912007-07-27T19:37:00.000-05:002007-07-27T20:17:51.143-05:00

With the weather changing constantly recently, my allergies have hit an all time high. I became a slug today so that I will have the energy I need by Monday. With nothing better to do, I decided to geek out by research various topics on the Internet. One of the things I have been considering is upgrading one of my servers with more powerful processors. While in the process of pricing a server,

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com1tag:blogger.com,1999:blog-1561153753353673899.post-66220982453824224062007-07-21T15:12:00.000-05:002007-07-27T20:17:13.419-05:00

Back in the early 1990's I was an employee at IBM. I received a letter in the mail from them last week informing me that they have "misplaced" thousands of backup tapes that included all the employment records from the 1990's. Nice! Of course, they offered to pay for a year's worth of Credit Security monitoring with the announcement of this loss. All I could think to say was "Why aren't you using

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0tag:blogger.com,1999:blog-1561153753353673899.post-88162334652434840072007-05-08T01:14:00.000-05:002007-05-14T01:26:19.434-05:00

When you hear the word "Oracle" most people think database. But Oracle is more than a database. Over the years, Oracle Corporation has expanded its software to encompass web technology, applications, security, and now storage. Oracle Secure Backup is a centralized tape backup management software providing secure data protection for heterogeneous file systems and the Oracle Database.According to a

Linda Smithhttp://www.blogger.com/profile/00298482365151722459noreply@blogger.com0