ReliDB

Oracle provides several Configuration Assistant tools to facility administrative duties required by an Oracle DBA or Developer. The Oracle’s DBCA (Database Configuration Assistant) is the GUI tool used to create starter databases within the Oracle RDBMS. The DBCA utility was introduced in Oracle 8i and provides the user a GUI to eliminate the [...]

Posted on June 13th, 2010 under 11g, ASM, Oracle, Oracle 10g, hp-ux, itanium, linux, oracle 9i, unix. Tags: create, create database, database, dbca, make, Oracle, starting. Comments: None

In Oracle production database environments, it is desirable to use one Oracle installation for each database which resides on a server. The use of a separate Oracle installation for each database reduces the possibility of corruption of one ORACLE_HOME affecting all of the databases on a single server and allows for maintenance to be [...]

Posted on April 21st, 2010 under 11g, Oracle, Oracle 10g, hp-ux, itanium, linux, network, oracle 9i, unix. Tags: database, environment, multiple, multiple database, multiple oracle installs, Oracle, profile, single server, variables. Comments: None

Most Oracle database connects are made through the use of an Oracle process called the LISTENER which monitors a certain machine and port for connection requests to one or more database instances. There are times when a DBA or SA will want to monitor connects being made through the listener for various reasons. [...]

Posted on October 21st, 2009 under Oracle, Oracle 10g, linux, unix. Tags: connection, database, level, listener, Oracle, trace, user. Comments: None

I have found during some administrative tasks it is easier to have your system in single NODE configuration. An example of this, would be physical changes the database structure that due not include binary upgrades such as a CPU patch. It is easier to startup, shutdown, and restrict access thorough single stand alone [...]

Posted on September 3rd, 2009 under Oracle 10g, RAC, SQL. Tags: database, instance, NODE, RAC, shutdown, single node system, SRVCTL, startup. Comments: 2

Oracle provides database links to create direct connections from one database instance to another. This feature can come in handy in the movement of small to moderate amounts of data between systems. In this article we will review the creation of the DDL to regenerate public database links defined within an Oracle database.
1. [...]

Posted on August 22nd, 2009 under Oracle, Oracle 10g, SQL, oracle 9i. Tags: create, database, dba_db_links, db_link, ddl, link, Oracle, recreate. Comments: None

Oracle’s Recovery Manger (RMAN), originally released in Oracle 8, is a proprietary utility used for the backup and recovery of Oracle databases. Given a good Oracle RMAN backup, A DBA can recover from any disaster which may occur to their database, to include: loss of controlfiles, loss of datafiles, corruption of datafiles, loss of [...]

Posted on August 20th, 2009 under Oracle, Oracle 10g, RMAN, oracle 9i. Tags: database, disaster, entire, Oracle, recovery, restore, RMAN, whole. Comments: None

Oracle - Use of UTL_FILE to read external OS file into Oracle RDBMS.
Oracle provides the procedure UTL_FILE to allow for the reading of external OS layer files from within the Oracle RDBMS. This article will give an example of how to read the contents of an external OS file and display it in [...]

Posted on January 29th, 2009 under 11g, Oracle, Oracle 10g, SQL, hp-ux, itanium, linux, oracle 9i, script, security, sqlplus, unix. Tags: database, external, file, into, Oracle, os, read, utl_file. Comments: None