Secrets for optimizing Oracle table inserts

When loading large-volumes of data, you have several choices:1 - Tune INSERTS - Parallelized programs doing concurrent INSERT statements2 - Tune SQL*Loader - Using sqlldr Direct Load, and adjusting parameters improves INSERT performance.3 - Tune imports - Use Oracle Data Pump (Formally...

Read More

Oracle Business Intelligence (BI) Software Benefits and Challenges

Oracle BI Suite EE Plus represents significant opportunities and challenges for Oracle E-Business Suite (EBS) customers. Using automated conversion tools and services, there is now a cost-effective method of migrating that minimizes downtime and maximizes the benefits your organization...

Read More

Utility Computing Made Simple: Automated Provisioning and Patching Solutions for Oracle Grid Computing

Utility computing is all about enabling system resources, including the grid, server farm, and clustering, to be acquired for different types of applications.Many enterprises are adopting grid and utility computing technologies because of their benefits. This document discusses the...

Read More

Master Data Management

If Master data management (MDM) is defined as the processes and tools which centrally and persistently define non-transactional entities of an organization, then its execution requires consideration of many moving parts. There is the data itself, data governance, business rules,...

Read More

Monitor Oracle Application Health and Performance with Middleware

Organizations are finding limitations in orchestrating processes across ERP, SCM and CRM applications. Business and IT leaders deploy middleware with a sharp eye on the health and performance of key business applications. Learn how you can narrow your short list significantly with...

Read More

Transactional Data Management for Eliminating Database Downtime When Upgrading or Migrating from Oracle 8i or 9i to Oracle 10g

Oracle 8i and 9i database customers are facing more urgency to upgrade to Oracle 10g or higher, particularly where more business-critical applications are supported. In many cases, cross-platform migrations may also need to occur along with the database upgrade. Despite this necessary...

Read More

How to Create Oracle Database Manually

CREATING THE DATABASE MANUALLYThis method involves typing the create database statement within SQL*DBA.Using this method allows for more flexibility such as specifyingthe MAXDATAFILES parameter or specifying multiple SYSTEM tablespacedatabase files. However by doing this manually...

Read More

How to Create Oracle Database Manually

CREATING THE DATABASE MANUALLY This method involves typing the create database statement within SQL*DBA. Using this method allows for more flexibility such as specifying the MAXDATAFILES parameter or specifying multiple SYSTEM tablespace database files. However by doing this manually...

Read More

Simple Storage for Oracle Database 10g and 11g

Oracle's launch of its Database 11g marks a major step forward in the relationship between Oracle databases and storage infrastructure. With 11g, Oracle has built Direct NFS (network file services) Client into Oracle, offering users the advantages of NAS for greater simplicity in...

Read More

How to change your oracle user password?

There are two SQL command syntaxes that can be used to change Oracle user password:first thing first log in to oracle database sqlplus "/ as sysdba" or sqlplus [user_name]@[service_name]1. Use SQL command "alter user" to change your oracle user password (for every of oracle version).SQL>ALTER...

Read More

EXP-00056: ORACLE error 12541 encountered

EXP-00056: ORACLE error 12541 encounteredORA-12541: TNS:no listenerEXP-00000: Export terminated unsuccessfullycheck your tnsname.ora or your server liste...

Read More

Best Practices in Data Management

Financial institutions are forced to collect more data and dig deeper into their databases in order to refine their analyses due to constant performance pressures and changing regulatory demands. A holistic, unified approach to data management, one that ensures a smooth flow of information...

Read More

Simple Storage for Oracle Database 10g and 11g

Oracle's launch of its Database 11g marks a major step forward in the relationship between Oracle databases and storage infrastructure. With 11g, Oracle has built Direct NFS (network file services) Client into Oracle, offering users the advantages of NAS for greater simplicity in...

Read More

How to configure Windows 32 bit to let Oracle use more than 2 GB of memory

The 32-bit operating systems such as Windows 2000 and Windows Server2003 provide access to 4-gigabyte (GB) of virtual address space. The lower 2 GB of virtual memory is private per process and available for application use. The upper 2 GB is reserved for operating system use.All...

Read More

Real-Time Performance Boost with New Oracle Database Option

Oracle In-Memory Database Cache now offers Oracle Database customers lightning-fast transaction response times by caching frequently used data in the application tier. Based on the Oracle TimesTen In-Memory Database, the new option delivers a real-time, dynamic, updatable cache for...

Read More

ORA-27101: shared memory realm does not exist

ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existCause: SGA is not allocated and instance is not started due to use the wrong oracle_sid and or oracle_home. Action: use the following command on your sqlplus set ORACLE_SID = grms sqlplus /nolog...

Read More

Oralce Error List

ORA-06512ORA-09936ORA-00600ORA-00904ORA-00942ORA-01034ORA-600ORA-06550ORA-12560ORA-01422ORA-27101ORA-20000ORA-01555ORA-01722ORA-12500ORA-01000ORA-12514ORA-01110ORA-01017ORA-00001ORA-01843ORA-01033ORA-00054ORA-07445ORA-12638ORA-06508ORA-01652ORA-00020ORA-01113ORA-12203ORA-00922OR...

Read More

ORA-01034: ORACLE not available

ORA-01034: ORACLE not availableCause: oracle database/ instance not startedAction: start oracle oracle database/instanceTo start oracle simply just logon using sqlplus on local serversqlplus "/ as sysdba"then start the database using the following commandsqplus> star...

Read More

ORA-00942 : table or view does not exist

ORA-00942: table or view does not existCause: The table or view entered does not exist or you don't have the privilege to that referencestable or view. Or those specified table or view belong to difference schema.Action: check if you specified the correct table name or check if you...

Read More

ORA-00904: invalid identifier

ORA-00904: "string": invalid identifier/invalid column nameCause: The column name entered is either missing or invalid.Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters...

Read More

ORA-09933 Deletion of old password file failed

ORA-09933: Deletion of old password file failed.Cause: The removal of the old password file failed or ORACLE was unable to create a password file.Action: Check the UNIX error number for the specific reas...

Read More

EXP-00056: ORACLE error 19206 encountered during an expor

EXP-00056: ORACLE error 19206 encountered during an exportCause: missing or invalid of metadata tables or XMLDB schema was dropped or modifiedAction: run the "$ORACLE_HOME/rdbms/admin/catmeta.sql" script when connected as sysdba you might following error during doing an export of...

Read More

Grid Computing on Windows

At Solutia, the IT goal is to get information to the people who need it, any time they need it. Solutia's high?volume manufacturing facilities are humming 24 hours a day, so critical database information must be accessible every minute. Downtime translates into lost production time,...

Read More

Oracle Database Backup with RMAN

Backup related technical termsMain category of doing database backupWhole database backups: a backup of every datafile in the database, plus the control file. Whole database backups are the most common type of backup. Partial database backups: backup of either tablespaces ,datafiles,...

Read More

ORA-01422: exact fetch returns more than requested number of rows

ORA-01422: exact fetch returns more than requested number of rowsCause: The number specified in exact fetch is less than the rows returned.Action: Rewrite the query or change number of rows requestedWith Oralce ORA-01422 error the cause would be you tried to execute a SELECT INTO...

Read More

ORA-00001: unique constraint (string.string) violated

ORA-00001: unique constraint (string.string) violatedCause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.Action: Either remove the unique...

Read More

ORA-00936: missing expression

ORA-00936: missing expressionCause: A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word...

Read More

EXP-00056: ORACLE error 6550 encountered

EXP-00056: ORACLE error 6550 encounteredORA-06550: line 1, column 41:PLS-00302: component 'SET_NO_OUTLINES' must be declaredORA-06550: line 1, column 15:PL/SQL: Statement ignoredEXP-00000: Export terminated unsuccessfully You would get this error when you are trying to export your...

Read More

Step by Step Installing Red Hat Linux on VmWare

Installing Red Hat over VmWare - part 1Installing Red Hat over VmWare - part 2Installing Red Hat over VmWare - part 3Installing Red Hat over VmWare - part...

Read More

SUN'S REFERENCE ARCHITECTURE FOR ORACLE 11g GRID

Sun's Reference Architecture for Oracle 11g Grid is a portfolio of Sun and third-party products designed to reduce the risks, uncertainty, and costs associated with implementing an Oracle database within a grid computing environment. Designed, tested, implemented, and tuned at the...

Read More