ReliDB

ReliDB

Oracle tips and tricks.

ReliDB RSS Feed
 
 
 
 

Archive for 11g

Oracle installation of 10.2.0.4 for Windows 7 Error

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 [...]

Enable ADMIN Tracing on Oracle Listener:

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 [...]

Oracle UTL_RECOMP package and the RECOMP_PARALLEL subprogram

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: [...]

Oracle - Encoding and Decoding Oracle data with UTL_ENCODE Package

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. [...]

Resolving Oracle error code: ORA-28000

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 [...]

Oracle NETCA - Network Configuration assistant.

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 [...]

Oracle DBCA - Database Configuration assistant.

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 [...]

Oracle - UTL_MATCH.EDIT_DISTANCE_SIMILARITY string comparison

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. [...]

Oracle - Determining Local Host name and IP address with UTL_INADDR procedure

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 [...]

Execution of Oracle SQL commands from within UNIX or LINUX shell scripts:

In the management of Oracle RDBMS, we frequently have the need to develop shell scripts to manage our databases. This article demonstrates the use of BASH shell script to connect to an Oracle database and execute PL/SQL and SQL statements from within the Oracle database. The following procedure will work on UNIX and [...]