ReliDB

While I am not an OS expert, I can comment that Windows 7 has given us speed and reliability while eliminating the sluggish performance and over-bearing protection of Vista. In this series, I would like to discuss problems one may encounter while running Oracle products on a Windows 7 client and ways in which [...]

Posted on August 16th, 2010 under 11g, Oracle, installer, windows, windows 7. Tags: 7, Failed, installer, larry catt, Oracle, setup, windows, windows 7. Comments: None

Enable ADMIN Tracing on Oracle Listener:
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 [...]

Posted on July 3rd, 2010 under 11g, OPatch, Oracle, Oracle 10g, listener, network, oracle 9i. Tags: listener, Oracle, trace. Comments: None

During the normal administration and operation of an Oracle database system, programming units within the database can become invalid for various reasons. To resolve this issue, the Oracle RDBMS provides the package UTL_RECOMP to recompile objects which are currently in an invalid status. The UTL_RECOMP package provides the administrator with 3 subprogram units: [...]

Posted on June 30th, 2010 under 11g, Oracle, Oracle 10g, oracle 9i. Tags: dba_objects, invalid, object, Oracle, parallel, status, utl_recomp. Comments: None

Oracle RDBMS provides the ability to encode and decode data through the package UTL_ENCODE. This functionality can be extremely helpful in the transmission of data over open networks where plan text transmission would not be wanted. In this article we will review the use of encoding plain text and decoding the string produced. [...]

Posted on June 30th, 2010 under 11g, Oracle, Oracle 10g, SQL, oracle 9i. Tags: decode, encode, Oracle, plain, text. Comments: None

The Oracle RDBMS provides the ability to lock user accounts for various reasons when the administrator or organizational policy determines it necessary. When an account is locked the user will be notified upon connection attempt with the Oracle error ORA-28000. This article describes the process of unlocking a user account so the user [...]

Posted on June 18th, 2010 under 11g, Oracle, Oracle 10g, hp-ux, linux, network, oracle 9i. Tags: locked account, ORA-28000, Oracle. Comments: None

Oracle provides several Configuration Assistant tools to facility administrative duties required by an Oracle DBA or Developer. The Oracle’s NETCA (Network Configuration Assistant) is the GUI tool used to configure the network components of your Oracle RDBMS. In this article we will review the startup of the Network Configuration Assistant within [...]

Posted on June 15th, 2010 under 11g, Oracle, Oracle 10g, hp-ux, itanium, linux, network, oracle 9i. Tags: assistant, configuration, listener.ora, netca, network, Oracle, tnsnames.ora. Comments: None

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

Oracle provides the procedure UTL_MATCH to compare the difference between to two sets of strings. In this article we will examine the function EDIT_DISTANCE_SIMILARITY which returns the percentage of matching strings: 0 meaning no similarity and 100 meaning complete similarity.
1. Logon to your Oracle database server as the Oracle software owner. [...]

Posted on May 25th, 2010 under 11g, Oracle, Oracle 10g. Tags: comparison, Oracle, rdbms, string, utl_match. Comments: None

Oracle - Determining Local Host name and IP address with UTL_INADDR procedure
Oracle provides the procedure UTL_INADDR to retrieve your server’s host name and IP address from within the Oracle RDBMS. In this article we will demonstrate the retrieval of host name and IP address from within the RDBMS.
1. Logon to your [...]

Posted on May 22nd, 2010 under 11g, Oracle, Oracle 10g, sqlplus. Tags: find host, find IP, host, in database, ip, Oracle, rdbms, UTL_INADDR. Comments: 1