SearchOracle: Oracle tips, scripts, and expert advice

Can I check an Oracle instance without logging into the Oracle server?

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Mon, 23 Nov 2009 00:00:00 EDT

Can you check an Oracle instance to see if it's running without logging into the Oracle server? Learn how to do so in Windows or Linux from expert Brian Peasland.

Can I copy table data with unlike primary keys from Table1 to Table2?

Dan Clamage, Oracle Database Developer, Confluence (editor@searchoracle.com — Wed, 20 Jan 2010 00:00:00 EDT

Oracle PL/SQL expert Dan Clamage explains two methods for copying table data from table1 to table2 when the tables have different primary keys in this expert tip.

Can I make my Oracle Processor license central for multiple users?

Scott D. Rosenberg, CEO & Founder, Miro Consulting(editor@searchoracle.com — Tue, 15 Sep 2009 23:00:00 EDT

Learn whether you can make your Oracle Processor license a central system for multiple users and the benefits of the Oracle processor license metric in this expert tip.

Can I perform an Oracle server backup through a client machine?

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Mon, 23 Nov 2009 00:00:00 EDT

Learn how to perform an Oracle server backup through a client machine with Oracle's RMAN utility in this tip from Oracle expert Brian Peasland.

Do I need new Oracle and Linux licensing to perform Linux testing?

Scott D. Rosenberg, CEO & Founder, Miro Consulting(editor@searchoracle.com — Tue, 15 Sep 2009 23:00:00 EDT

Oracle licensing expert Scott Rosenberg explains the licensing requirements for Oracle and Linux licensing when performing Linux testing in Oracle.

How can I find similar values in two Oracle tables in PL/SQL?

Dan Clamage, Oracle Database Developer, Confluence (editor@searchoracle.com — Tue, 2 Feb 2010 00:00:00 EDT

Looking to find similar values in two Oracle tables in PL/SQL? Learn about how to do so with this tip from Oracle PL/SQL expert Dan Clamage.

How does the Oracle LGWR write to online redo log files?

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Mon, 23 Nov 2009 00:00:00 EDT

Learn how the Oracle LGWR writes both uncommitted and committed transactions from the log buffer to the online redo log files in this tip from Oracle expert Brian Peasland.

How to avoid duplicates of Oracle delimited codes in CLOB column

Dan Clamage, Oracle Database Developer, Confluence (editor@searchoracle.com — Mon, 1 Feb 2010 00:00:00 EDT

Learn how to avoid duplicates of Oracle delimited codes in a CLOB column by scanning the column in this tip from Oracle PL/SQL expert Dan Clamage.

How to calculate Universal Power Unit license requirements

Scott D. Rosenberg, CEO & Founder, Miro Consulting(editor@searchoracle.com — Tue, 15 Sep 2009 23:00:00 EDT

Oracle licensing expert Scott Rosenberg explains how to calculate Universal Power license requirements using server processor speed in this expert response.

How to enable remote Oracle OS authentication with OS_AUTHENT_PREFIX

Thu, 3 Dec 2009 00:00:00 EDT

Oracle expert Brian Fedorko explains how to enable remote Oracle OS authentication in Windows and Linux, including why you might receive the ORA-010145 error when trying to have an Oracle user identified externally.

How to join two tables with unique keys in Oracle

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Mon, 23 Nov 2009 00:00:00 EDT

Learn how to use an Oracle table join to connect two tables with unique keys in Oracle in this tip from Oracle expert Brian Peasland.

How to land your dream Oracle DBA job

Don Burleson, Contributor(editor@searchoracle.com — Thu, 14 Jan 2010 00:00:00 EDT

Despite the recession, companies are willing to pay top dollar for qualified Oracle professionals. Don Burleson offers guidance on nabbing the dream Oracle DBA job.

How to list rows with special characters in PL/SQL

Dan Clamage, Oracle Database Developer, Confluence (editor@searchoracle.com — Wed, 6 Jan 2010 00:00:00 EDT

Want to learn how to list rows with special characters in PL/SQL? Read this tip from our PL/SQL expert for advice on how to write a PL/SQL query using the translate, char or trunk functions.

How to perform a Big to Little Endian conversion in Oracle 8i

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Tue, 8 Dec 2009 00:00:00 EDT

Learn how to perform a Big to Little Endian conversion in Oracle 8i using either an Oracle upgrade or export/import in this tip from Oracle expert Brian Peasland.

How to perform database recovery with a corrupt control file in Oracle

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Tue, 8 Dec 2009 00:00:00 EDT

Learn how to perform database recovery with a corrupt control file in Oracle with these step by step instructions, including how to use the CREATE CONTROLFILE command, from Oracle expert Brian Peasland.

How to plan Oracle Grid Control Repository maintenance

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Mon, 14 Sep 2009 23:00:00 EDT

Oracle expert Brian Peasland explains whether you need to plan Grid Control Repository maintenance like you plan Oracle database maintenance.

How to restore a dump file with the Oracle SHOW=Y option

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Mon, 23 Nov 2009 00:00:00 EDT

Oracle expert Brian Peasland explains how to restore a dump file with the Oracle SHOW=Y option before precreating tablespaces.

How to use Log Miner to verify filtered Oracle NULL columns

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Tue, 2 Feb 2010 00:00:00 EDT

Learn how to use Log Miner to verify filtered Oracle NULL columns in an INSERT statement from a redo log write in this tip from Oracle database expert Brian Peasland.

How to use RMAN CONVERT to migrate from Solaris to Oracle 11g RHEL

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Tue, 15 Sep 2009 23:00:00 EDT

Learn how to migrate Oracle from Solaris to Oracle 11g RHEL with the RMAN CONVERT command in this tip from an Oracle expert.

How to use SQL Plus to export Oracle data from more than one table

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Tue, 8 Dec 2009 00:00:00 EDT

Learn how to use SQL Plus to export Oracle data from more than one table with the SPOOL command in this tip from Oracle expert Brian Peasland.

How to use a stored procedure to fetch from ref cursor in Oracle

Dan Clamage, Oracle Database Developer, Confluence (editor@searchoracle.com — Tue, 5 Jan 2010 00:00:00 EDT

Oracle expert Dan Clamage explains how to use a stored procedure to fetch from a ref cursor in Oracle in this tip.

How to use iterative scans to create hierarchical queries in SQL

Dan Clamage, Oracle Database Developer, Confluence (editor@searchoracle.com — Thu, 7 Jan 2010 00:00:00 EDT

PL/SQL expert Dan Clamage explains how to use iterative scans to create hierarchical queries in SQL that are database agnostic.

How to use the CREATE USER command to create a new username in Oracle

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Tue, 2 Feb 2010 00:00:00 EDT

Oracle expert Brian Peasland explains how to use the CREATE USER command to create a new username and password for your Oracle database.

Migrating Oracle to Sun Solaris with Oracle Transportable Tablespaces

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Mon, 14 Sep 2009 23:00:00 EDT

Learn how migrating Oracle from an HP-UX operations system to Sun Solaris is best done with Oracle Transportable Tablespaces in this tip from an Oracle expert.

Oracle Openworld 2009: Here's what to expect

SearchOracle.com(editor@searchoracle.com) — Thu, 17 Sep 2009 23:00:00 EDT

IOUG President Ian Abramson discusses what to expect at Oracle OpenWorld 2009, including information on hot topics like Oracle 11g R2, Oracle Middleware 11g, and the Sun acquisition.

Oracle?s OBIEE dashboard helps Kaleida Health combat the flu

Ed Scannell, Site Editor(editor@searchoracle.com — Wed, 30 Dec 2009 00:00:00 EDT

Kaleida Health created an Oracle Business Intelligence Suite Enterprise Edition (OBIEE) dashboard in hopes of a quick solution to tracking the toll the flu, particularly the H1-N1 strain, was taking.

Scaling an Oracle database: What is the best strategy for you?

Don Burleson, Contributor(editor@searchoracle.com — Tue, 15 Sep 2009 23:00:00 EDT

With the amount of data companies have to manage increasing, scaling an Oracle database is an inevitability. Here is a look at some proven database scalability strategies.

The top Oracle advice from the experts in 2009

Shayna Garlick, Assistant Editor(editor@searchoracle.com — Thu, 17 Dec 2009 00:00:00 EDT

Read this year?s Top 10 list of Oracle advice on Oracle security, licensing, databases and more from the SearchOracle.com experts.

Understanding different Oracle development license strategies

Scott D. Rosenberg, CEO & Founder, Miro Consulting(editor@searchoracle.com — Tue, 15 Sep 2009 23:00:00 EDT

Oracle licensing expert Scott Rosenberg explains how to plan your Oracle development license strategies, such as how to use the OTN development license, in this expert tip.

Why do I get an Oracle not available error with Oracle 8i on Windows?

Brian Peasland, Database Administrator, SGT, Inc. (oracle_dba@peasland.net — Mon, 23 Nov 2009 00:00:00 EDT

Are you getting an Oracle not available error when trying to use Oracle 8i on Windows 2003? Learn why in this tip from expert Brian Peasland.