Leveraging Logical Standby Databases in Oracle 11g Data Guard
Oracle Data Guard still offers support for the venerable logical standby database in Oracle Database 11g. This article, investigates how data warehouse and data mart environments can effectively leverage logical standby database features, but simultaneously provide a final destination when failover from a primary database is mandated during disaster recovery.
Building an Oracle (and other RDBMS) Server Environment
In previous articles discussing Oracle and VMware, the hardware and software components consisted of a Windows-based PC and the Oracle RDBMS. Steve Callan expands upon the "Oracle in a virtualized environment" concept by looking at other alternatives for the hardware and software.
Oracle 11g Security Guidelines for Auditing
Oracle focuses on the default settings for just about all of the security setup in "The Oracle 2-Day Security Guide". As we draw near the close of the book, we'll examine a few guidelines for auditing.
Setting up Oracle as a Data Source for SQL Server
The requirements for setting up Oracle as a data source for SQL Server include some obstacles and one major showstopper. Read on to learn a work-a-round that allows you to continue the setup.
Creating a standard audit trail in Oracle Database 11g
Turning on auditing is easy; knowing what to do with it is entirely different. Learn how to create a standard audit trail using Oracles Enterprise Manager.
Setting default auditing as recommended by Oracle
If you dont know where to start when setting Oracle auditing parameters, just start with what Oracle recommends. In this article, we set the default auditing as recommended by Oracle.
The Second 5 top new features in Oracle Database 11gR2
The second part of this two-part article completes a high-level evaluation of Oracle 11gR2's new features to assist Oracle DBAs to decide whether to upgrade their Oracle 9i, 10g, and 11gR1 databases to Oracle 11g Release 2 in the near term.
Oracle as a Data Source
This article takes a quick look at Oracle database's materialized view and extends the concept of that feature to a case where Oracle is the data source for another relational database management system.
Getting started with standard auditing in Oracle Database 11g
Database auditing is big business. Are you ready for the challenge to pass an audit? This article begins with an introduction to Oracles standard auditing that we can build on to answer that question.
To Partition or Not to Partition in E-Business Suite
As a database administrator, there are two kinds of databases you are likely to own: those you design and those you inherit. This article looks at what takes place during the design phase, and then applies the lessons learned to a real world implementation, courtesy of Oracle E-Business Suite.
Secure Sockets Layer and Oracle 11g Security
In an Oracle environment, much of the communication between client and server is unsecured and clear-text. Learn how Oracle Advanced Security and Secure Sockets Layer (SSL) can be used to tighten security for both network traffic and for communication between user and database.
Printing Barcodes in Oracle Reports
No, really, you may have to do this one day: enable the use of barcodes in Oracle Reports. Is this a database administration or administrator responsibility?
Fast-Start Failover in Oracle 11g Data Guard
Learn how to set up and control automatic failover using the Fast-Start Failover Observer, so that DBA intervention is no longer required during a disaster recovery scenario.
Securing Client Connections: OS Authentication
Connection to an Oracle database, using operating system authentication has come under fire for providing loopholes in security. You be the judge.
Securing Oracle Database Client Connections
Connection methods to Oracle databases have remained relatively static over the years. Unfortunately, governmental regulations and would-be attackers have not stood still. Join us as we begin a look at securing client connections.
»
More Features...
Receive articles via our XML/RSS feed
 
Oracle on Linux versus Oracle on Sun
As Oracle embraces Sun hardware, will commodity hardware go out the window.
A little hardware banter between Oracle and IBM
Oracles Ellison and IBM's director of product strategy, Bernie Spang sling some mud.
MySQL lives on
The whole world was watching as Oracle laid plans for Sun products, especially the future of MySQL.
Oracle Technology homepage goes mobile
Go to oracle.com/otn if youd like to start using OTN mobile.
Oracle Completes Acquisition of Sun
Its official! Now we can get on with business.
Forming alliances against Oracle and Sun; HP and Microsoft will give it a go
Are newly formed alliances coming too late to head off Oracles powerful lineup of systems and software?
To improve performance, availability, and scalability, Georgian College uses Oracle 11g Grid
Beefing up with Oracle 11g and RAC help Georgian College improve the performance, availability, and scalability of its Oracle PeopleSoft Enterprise applications.
Mueller still fighting the Oracle-Sun acquisition
Oracle / Sun deal moves to China and Russia as Mueller prays for rain.
Dont miss the Oracle & Sun Strategy Event January 27
Oracle will be hosting a live event for customers, partners, press and analysts on January 27, 9:00 AM 2:00 PM PT, at its headquarters in Redwood Shores, California.
Oracle gets unconditional approval from European Commission
Oracle has announced today that it has received regulatory approval from the European Commission for its acquisition of Sun Microsystems, Inc.
How well do you know the software giant Oracle?
Take a few minutes to browse through 40 quick facts about Oracle.
Intevydis reveals Oracle Internet Directory Heap Corruption
Oracle Internet Directory oidldapd heap corruption.
Sun may experience massive layoffs after acquisition
Many analysts have estimated that Oracle will lay off about half of Suns current employees when Sun is acquitted by Oracle in the coming weeks.
Analysts predict Oracle to cut thousands of Sun staff after acquisition
The only reason Oracle has held off making huge layoffs at Sun is because the acquisition is still in limbo with the European Commission.
Application Security, Inc. will support Oracles latest Critical Patch Update
Every CPU for the Oracle database will be implemented by Application Security, Inc. to help ensure high level of protection and performance for Oracle databases.
»
More News...
Receive news via our XML/RSS feed
Bulk File Edit
This script will go through each file with the *.dat extension in a directory and fill the 3rd pattern "<>" in the line that contains a specified directory, with a specified path.
FULL OUTER JOIN LOOP
This script displays matched records from two tables when constraints prevent a full outer join.
IF EXISTS/IF NOT EXISTS
This script creates a user, if the user does not exist in the db and drops the user, if the user exists in the db.
Killing Sessions
Use this script to kill a job and re-run it fter incorporating HINTS.
Debugging Column Length
This script debugs column length mismatch in Oracle tables and joins the matching rows through an equi join.
»
More Scripts...
|
