Database Admin

Collaborate 2013 Oracle user groups show guide

Collaborate 2013 is one of the biggest Oracle user group conferences of the year, and SearchOracle.com editors are on hand to cover it from start to finish.Collaborate 2013

What's out there for Oracle third-party tools

Oracle products come with an array of integrated tools, but an ecosystem of third-party tools exists that can make an Oracle developer's life even easier.Feature

Justify Oracle third-party tools with performance and cost benefits

Ignore Oracle third-party tools at your own risk and expense, according to contributor Frank Ohlhorst.Feature

Independent Oracle Users Group celebrates 20th anniversary

Independent Oracle Users Group President John Matelski argues for the value of an Oracle users group in today's day and age.Feature

Where to look for Oracle DBA learning materials

Readers ask SearchOracle.com expert Brian Peasland where they can find learning materials for becoming a better Oracle database administrator.Answer

Quest Software, its Toad tool leaping over to Dell

Dell plans to acquire Quest Software, maker of the Oracle Database development tool Toad. End users said Dell could improve Toad and adapt it for larger tech trends like “big data.”News | 02 Jul 2012

Oracle Advanced Analytics bundles R with Oracle Database

Oracle Advanced Analytics is the company’s newest announcement around data analytics, a market that Oracle seeks to blanket with products.News | 08 Feb 2012

Oracle querying for developers

What pain points do you experience in Oracle querying? Read this excerpt from Michael McLaughlin’s Oracle Database 11g & MySQL 5.6 Developer Handbook to learn the answers to your questions.Feature

Can Oracle be a NoSQL player?

The Oracle NoSQL database is mainly an attempt to satisfy existing Oracle Database customers interested in big data on the side, experts say.News | 25 Oct 2011

Quest boosts Toad for Oracle with version 11

New features of Toad for Oracle include more automated code analysis, allowing read-only access to production databases and reporting across all managed databases.News | 26 Sep 2011

How to tune Oracle instance recovery

Find out how to tune Oracle instance recovery in this tip from Matthew Morris, a renowned Oracle Database author.Oracle Database Tip

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.Answer

external hard drive

An external hard drive is a portable storage device that can be attached to a computer through a USB or Firewire connection, or wirelessly.Definition

How to copy Oracle Database 9i to a new server

Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another.Answer

Book excerpt: Effective MySQL Backup and Recovery

As a DBA, you need to create an effective strategy. How? Read this excerpt from Ronald Bradford's 'Effective MySQL: Backup and Recovery' to find out.Excerpt

How to copy an Oracle database

Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database.Tip

Improve the Media Recovery Process (MRP) in Oracle Data Guard

One reader asks expert William Cullen why the Media Recovery Process (MRP) in Oracle Data Guard shouldn't be used in multi-node Real Application Clusters (RAC) environments.Answer

Oracle license requirements in disaster recovery scenarios

One reader asks whether they need an Oracle license to back up their database to tape.Answer

Facebook MySQL DBA gives tips on server management

Facebook MySQL database administrator (DBA) Rob Wultsch tells Oracle OpenWorld attendees to “keep it simple, stupid” and gives tips for preventing DBA burnout.News | 03 Oct 2011

Data replication software helps hospital network prepare for the worst

The UPMC health network faced several data replication software challenges when ramping up its disaster recovery site.News | 21 Jul 2011

Matthew Morris

Matthew Morris is a database engineer at Computer Sciences Corporation and a popular author of Oracle certification study guides.Contributor

Collaborate 2013 Oracle user groups show guide

Collaborate 2013 is one of the biggest Oracle user group conferences of the year, and SearchOracle.com editors are on hand to cover it from start to finish.Collaborate 2013

Introducing Pluggable Database, the star of Oracle Database 12c

Meet Pluggable Database, the star of Oracle Database 12c—it may redefine database virtualization.News | 15 Feb 2013

Pluggable Database virtualizes Oracle Database 12c

Several users beta testing Oracle Database 12c say that Pluggable Database is one of its most powerful new features.Feature

Oracle Database 12c, Exadata x3 highlight OpenWorld keynote

Oracle CEO Larry Ellison highlighted some features of the new Oracle Database 12c and Exadata X3 products announced at Oracle OpenWorld 2012.News | 30 Sep 2012

OpenWorld and JavaOne 2012 conference coverage

guide

Oracle OpenWorld 2012 special report

The 30th annual Oracle OpenWorld conference has 50,000 registered attendees and is packed full of sessions and keynotes on Oracle databases, applications, middleware and hardware, among other topics. OpenWorld occurs the same time as JavaOne 2012, and together the two take over a large chunk of San Francisco for the entire week.

Editors from SearchOracle.com and SearchCloudApplications.com will be at OpenWorld the whole week, capturing all the news and focusing on user sessions on Oracle Database 12c, engineered systems and other hardware, Oracle application upgrades, cloud computing and other topics.guide

Oracle Database 12c to be announced at OpenWorld

The first major upgrade to Oracle's flagship database product in three years will include features around the cloud, tuning and automation.News | 21 Sep 2012

The 2012 Dynamic Database Project Award

The award will recognize the most innovative, cost-saving, best database project of 2012. Enter for a chance to win an Apple iPad. Deadline is Nov. 9.guide

Why won't TNS listener connect with Oracle Database 11g 32-bit?

One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g.Answer

Addressing quality-of-service improves Oracle database consolidation

In this fourth installment of a series on Oracle database consolidation, Jeff McCormick writes about achieving multi-tenancy within Oracle Database by addressing more quality-of-service concerns.Tip

How to copy an Oracle database

Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database.Tip

Exadata, hybrid columnar compression, and inserts

One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata.Answer

One shop describes its move off Oracle on Itanium

Given Oracle’s recent announcement that it would stop software development on Itanium, one environmental services company’s decision to move to x86 Linux is timely.News | 25 Mar 2011

Oracle database upgrade guide

If you’re considering a move to a new Oracle database version -- especially Oracle Database 11g or Oracle Database 11gR2 -- read our Oracle database upgrade guide for tips and customer success stories.Tutorial

Oracle upgrades: Tips and trends

If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades.Tutorial

Server load problems after moving from Oracle 10g XE to 11g SE One

Experiencing server load problems when moving from Oracle 10g XE to 11g SE One? Learn ways to solve these server load issues in this tip from Oracle database expert Brian Peasland.Answer

Minimize database downtime when moving an Oracle DB to a new server

Learn how to minimize database downtime when moving your Oracle 10gR2 database from a Windows 2003 32-bit server to a Windows 2008 64-bit server, using the Database Configuration Assistant, in this tip from an Oracle database expert.Answer

Oracle backup and recovery strategies: Export dump vs. RMAN

Should you use an export dump or RMAN in your Oracle backup and recovery strategies? Learn about the importance of employing both in this tip from Oracle expert Brian Peasland.Answer

Can I run Oracle 9i on a Windows 64-bit O/S?

If you want to migrate Oracle 9i to a Windows 64-bit O/S environment, learn in this expert tip why you may want to install Oracle 10g or 11g first.Answer

Online patching support highlights upcoming Oracle EBS 12.2 release

Oracle EBS 12.2 is expected out this year, and support for online patching will be one of its key features.Tip

Doing an Oracle patch update the right way is no easy task

Knowing which Oracle patch update is the right one, and how often to apply them, is key to keeping IT and end users happy.Feature

Global transaction IDs, full-text searches highlight MySQL 5.6 release

Performance boost is an important part of the MySQL 5.6 release, although integration may be an issue early on.Feature

Oracle database administrators assemble their 2013 Oracle wish list

Oracle database administrators want to see better query optimization, memory leakage detection and heterogeneous support of Data Guard in 2013.Feature

Pluggable Database virtualizes Oracle Database 12c

Several users beta testing Oracle Database 12c say that Pluggable Database is one of its most powerful new features.Feature

Harvard cuts IT footprint with FlexPod, Oracle Database Appliance

Harvard Business Publishing needed to upgrade its aging Dell server infrastructure, and decided on two separate integrated approaches to get it done.Case study

Oracle Database 12c, Exadata x3 highlight OpenWorld keynote

Oracle CEO Larry Ellison highlighted some features of the new Oracle Database 12c and Exadata X3 products announced at Oracle OpenWorld 2012.News | 30 Sep 2012

Oracle OpenWorld 2012 preview: Three questions

We asked four well-known Oracle experts three important questions about Oracle OpenWorld 2012, which is coming up next week.News | 26 Sep 2012

Oracle Database 12c to be announced at OpenWorld

The first major upgrade to Oracle's flagship database product in three years will include features around the cloud, tuning and automation.News | 21 Sep 2012

Midmarket companies find JD Edwards upgrades a good fit

At some point, your JD Edwards shop will have to decide whether to switch to a different product, upgrade or stay where you are. Learn what two other organizations did when working through JD Edwards upgrades.News | 08 May 2012

How to copy Oracle Database 9i to a new server

Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another.Answer

Why won't TNS listener connect with Oracle Database 11g 32-bit?

One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g.Answer

Avoiding and fixing mutating table errors

PL/SQL expert Daniel Clamage tells one reader why her merge statement is creating a mutating table error.Answer

How to perform incomplete recovery to overcome Oracle database error

Learn how to perform incomplete recovery in Oracle to overcome an error after restoring with RESETLOGs in this tip from Oracle expert Brian Peasland.Answer

Why am I receiving Oracle memory allocation errors?

Are you receiving Oracle memory allocation errors? Learn why you may be having memory allocation problems in Oracle in this tip from Oracle expert Brian Peasland.Ask the Expert

Oracle error 6550 may mean incorrect Oracle export version

Oracle expert Brian Peasland explains why you might get an Oracle error 6550 when using the wrong Oracle export version in this tip.Ask the Expert

Are we getting the ORA-00382 error because we're at maximum block size?

Are you receiving the ORA-00382 error when determining Solaris block size? Learn what the maximum block size on Solaris is in this expert tip.Ask the Expert

Why does the archive log in Oracle give me the ORA-16032 error?

Oracle expert Brian Peasland explains why you might be getting the ORA-16032 error, including why starting multiple instances with the archive log in Oracle will throw the error.Ask the Expert

How do I solve the ORA-00257 error in Oracle?

Read about some possible solutions to the ORA-00257 error in Oracle with this expert tip.Ask the Expert

Error during RMAN backup

An Oracle user asks why they are receiving an error when conducting an RMAN backup.Ask the Expert

How to tune Oracle instance recovery

Find out how to tune Oracle instance recovery in this tip from Matthew Morris, a renowned Oracle Database author.Oracle Database Tip

Matthew Morris

Matthew Morris is a database engineer at Computer Sciences Corporation and a popular author of Oracle certification study guides.Contributor

Collaborate 2013 Oracle user groups show guide

Collaborate 2013 is one of the biggest Oracle user group conferences of the year, and SearchOracle.com editors are on hand to cover it from start to finish.Collaborate 2013

What's out there for Oracle third-party tools

Oracle products come with an array of integrated tools, but an ecosystem of third-party tools exists that can make an Oracle developer's life even easier.Feature

Justify Oracle third-party tools with performance and cost benefits

Ignore Oracle third-party tools at your own risk and expense, according to contributor Frank Ohlhorst.Feature

Giving your Oracle hardware performance a shot in the arm

The performance of your databases and applications- both customer-facing and internal- are essential to your business’s success. And in the quest to improve performance, sometimes trying to dissect and fix code and tune important queries can be time consuming and expensive. You can’t just throw a bunch of hardware at the problem, since not all server hardware is created equal. This expert resource details how to pick the best server hardware for your Oracle environment. Also included is a report on how to determine where the database bottlenecks are and then find the right tools to help open them up. And finally, examine the increasing role that random-access memory (RAM) is playing in database and application environments.E-Handbook

Oracle database administrators assemble their 2013 Oracle wish list

Oracle database administrators want to see better query optimization, memory leakage detection and heterogeneous support of Data Guard in 2013.Feature

How CTO Joel Gilbert built his own Exadata

Gilbert, CTO of workforce management software company Pipkins, said he built Exadata before Oracle did. Well, kind of. See how he did it.Feature

Why won't TNS listener connect with Oracle Database 11g 32-bit?

One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g.Answer

Calling stored procedures inside user-defined functions in Oracle Database

In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database.Answer

Doing an Oracle patch update the right way is no easy task

Knowing which Oracle patch update is the right one, and how often to apply them, is key to keeping IT and end users happy.Feature

MySQL security analysis: Mitigating MySQL zero-day flaws

In the wake of several recent MySQL zero-day vulnerabilities, expert Michael Cobb assesses the state of MySQL security. Is a MySQL alternative needed?Tip

Black Hat 2012: David Litchfield slams Oracle database indexing

At Black Hat 2012, longtime Oracle thorn David Litchfield presents working exploits targeting Oracle database indexing vulnerabilities.News | 26 Jul 2012

Security pro: Find and secure sensitive Oracle database data

Jonathan Intner, solutions architect for data security company Vormetric, talks about what makes sensitive data sensitive, encryption key management and finding sensitive data in surprising places in this Q&A.News | 07 Dec 2011

Oracle Fusion Middleware evolves its mobile development platform

Oracle Application Development Framework (ADF) Mobile has improved, but the company should focus more on mobile security, a big consumer concern.Tip

Three trends in Oracle identity and access management

Moving toward a service-centric focus is one of three important IAM trends, according to one consultant.Tip

Object privileges in Oracle database security

A reader asks a question about the GRANT OPTION as it relates to object privileges in Oracle database security.Answer

Oracle issues patch update with 66 fixes

Oracle released a patch update with 66 fixes on Tuesday, aimed at vulnerabilities on multiple Oracle products including Oracle Database, E-Business Suite, PeopleSoft and Fusion Middleware.News | 17 Jan 2011

E-book: What you need to know about database security inside and outside your company

This e-book will take a look at how database managers can evolve their security strategies to match the increasingly sophisticated technologies used by hackers to attack their mission critical data. Find out the latest information about database security to make the right decisions for your organization.E-Book

Are Oracle DBA jobs at educational institutions the right fit for you?

Read about the pros and cons of working as an Oracle DBA or developer at a college or university, and how salaries, benefits, culture and responsibilities compare to Oracle DBA jobs in other industries.News | 28 Dec 2010

Collaborate 2012 Oracle user groups show guide

Conference Coverage

In-memory databases: Oracle TimesTen vs. Sybase ASE

In this first part, expert Mich Talebzadeh looks at the Oracle TimesTen in-memory database, detailing how it works and explaining when it’s beneficial over a traditional relational database management system.Tip

Data replication software helps hospital network prepare for the worst

The UPMC health network faced several data replication software challenges when ramping up its disaster recovery site.News | 21 Jul 2011

Mirroring in Oracle RAC and Data Guard

A reader asks a question about mirroring on Oracle RAC using Data Guard.Answer

MySQL high availability trends podcast

Sarah Novotny, a MySQL expert and chair of the MySQL advisory council of the IOUG, talks in this podcast about MySQL high availability.Podcast

Oracle RAC and distance limitations

One reader asks what the Oracle RAC distance limitations are for two environments being run in sync.Answer

Oracle Database 11g R2 High Availability sample book chapter

Here is a sample chapter from Oracle Database 11g R2 High Availability, a new book from Oracle Press.Book chapter | 27 May 2011

Ensuring high availability in Oracle Database 11g R2

Scott Jesse, senior manager for Oracle RAC customer support, discusses Oracle Database 11g Release 2 High Availability, a book he co-wrote this year.News | 27 May 2011

Oracle database professionals challenged by availability, upgrade issues

On top of the list for Oracle database professionals' challenges includes issues around availability and upgrades.Slideshow

Review: Oracle's 11g R2 database has some good and bad

Oracle made no major architectural enhancements to the 11g R2 database, but it made some useful changes and added some clunkers, too.Article | 22 Sep 2009

Collaborate 2013 Oracle user groups show guide

Collaborate 2013 is one of the biggest Oracle user group conferences of the year, and SearchOracle.com editors are on hand to cover it from start to finish.Collaborate 2013

Oracle Database Appliance x3-2 due out Tuesday

A major upgrade to the Oracle Database Appliance x3-2 gives it some of the Exadata platform's high-end features, although it isn't quite there yet.News | 04 Mar 2013

Oracle database administrators assemble their 2013 Oracle wish list

Oracle database administrators want to see better query optimization, memory leakage detection and heterogeneous support of Data Guard in 2013.Feature

PayPal completes a 60-day migration to Oracle Exadata

Online payment processor PayPal knows what it takes to migrate to a new data management platform in a hurry.Feature

Oracle licensing on Oracle Database Standard Edition

One reader asks two questions about licensing Oracle Database Standard Edition.Answer

Oracle Database Appliance has been slow to adoption

Alex Gorbachev, CTO of Pythian, explains why Oracle Database Appliance hasn't seen the rate of adoption that he was expecting.Video

Collaborate 2012 Oracle user groups show guide

Conference Coverage

Improve the Media Recovery Process (MRP) in Oracle Data Guard

One reader asks expert William Cullen why the Media Recovery Process (MRP) in Oracle Data Guard shouldn't be used in multi-node Real Application Clusters (RAC) environments.Answer

ATT.com eyes hybrid Oracle cloud computing

ATT.com is considering a hybrid public-private Oracle cloud computing model so it can handle highly variable traffic without having to build to peak capacity.News | 03 Nov 2011

Oracle Database Appliance: How much it really costs

This column from consultant Eric Guyer breaks down the hardware and software costs of the Oracle Database Appliance, unveiled last week and targeted for smaller businesses.Tip

Collaborate 2013 Oracle user groups show guide

Collaborate 2013 is one of the biggest Oracle user group conferences of the year, and SearchOracle.com editors are on hand to cover it from start to finish.Collaborate 2013

Oracle Solaris 11.1 update focuses on database integration, cloud

The Oracle Solaris 11.1 operating system update is keyed in on integration with Oracle Database and cloud computing features.News | 05 Nov 2012

Oracle Database 12c to be announced at OpenWorld

The first major upgrade to Oracle's flagship database product in three years will include features around the cloud, tuning and automation.News | 21 Sep 2012

ATT.com eyes hybrid Oracle cloud computing

ATT.com is considering a hybrid public-private Oracle cloud computing model so it can handle highly variable traffic without having to build to peak capacity.News | 03 Nov 2011

Oracle, Salesforce spar over cloud, multi-tenancy

Oracle’s latest public cloud offering came with jabs at Salesforce.com and multi-tenancy, a concept crucial to cloud computing.News | 20 Oct 2011

IOUG President talks Exadata, middleware

IOUG President Andrew Flowers spoke about the topics that are top-of-mind for members of the Independent Oracle Users Group, including Exadata, virtualization and middleware.News | 10 Oct 2011

Oracle Public Cloud: The good and bad

Oracle has decided cloud-based services do have some merit after all. But its latest offerings are missing key elements of true cloud computing services.Column | 07 Oct 2011

Oracle Public Cloud to offer two Fusion apps

Oracle announced the Oracle Public Cloud on Wednesday, which will initially offer Fusion CRM and HCM. Other options, for Java, a database service and a “social network,” will come later.News | 06 Oct 2011

Oracle Sun enterprise server hardware guide

Knowing what hardware works best for your Oracle databases, middleware and applications is key to optimizing performance. This Oracle Sun enterprise server hardware guide should help you on your way.Guide | 08 Apr 2011

Exadata, Exalogic, and Oracle’s move into the converged cloud

Can Oracle effectively deliver a cloud platform with their Exadata and Exalogic server appliance products?Feature | 06 Apr 2011

MySQL security analysis: Mitigating MySQL zero-day flaws

In the wake of several recent MySQL zero-day vulnerabilities, expert Michael Cobb assesses the state of MySQL security. Is a MySQL alternative needed?Tip

Global transaction IDs, full-text searches highlight MySQL 5.6 release

Performance boost is an important part of the MySQL 5.6 release, although integration may be an issue early on.Feature

Oracle database administrators assemble their 2013 Oracle wish list

Oracle database administrators want to see better query optimization, memory leakage detection and heterogeneous support of Data Guard in 2013.Feature

Book excerpt: Effective MySQL Backup and Recovery

As a DBA, you need to create an effective strategy. How? Read this excerpt from Ronald Bradford's 'Effective MySQL: Backup and Recovery' to find out.Excerpt

SearchOracle.com Advisory Board

Advisory Board

Oracle querying for developers

What pain points do you experience in Oracle querying? Read this excerpt from Michael McLaughlin’s Oracle Database 11g & MySQL 5.6 Developer Handbook to learn the answers to your questions.Feature

Book explores Oracle, MySQL query methods

Michael McLaughlin, author of Oracle 11g & MySQL 5.6 Developer Handbook discusses the benefits of keyword querying and more in this interview.Q&A | 29 Nov 2011

Facebook MySQL DBA gives tips on server management

Facebook MySQL database administrator (DBA) Rob Wultsch tells Oracle OpenWorld attendees to “keep it simple, stupid” and gives tips for preventing DBA burnout.News | 03 Oct 2011

MySQL high availability trends podcast

Sarah Novotny, a MySQL expert and chair of the MySQL advisory council of the IOUG, talks in this podcast about MySQL high availability.Podcast

IOUG President Andrew Flower on Oracle MySQL

Andrew Flower, President of IOUG, sat down with SearchOracle.com at the Collaborate 2011 conference in Orlando to discuss Oracle's stewardship of MySQL.Video