Database Administrator

Background The architecture of Oracle Apps is very complex and many technologies (or services) are used ). For example, Apache Web server, Apache Jserv, Forms Listener servlet (or forms server), and so on, each service has its own configuration file.

1. First download the source file of the Berkeley db database from the Oracle official website. Http://download.oracle.com/otn/berkeley-db/db-5.3.15.tar.gz 2. The downloaded file is a packaged file and needs to be decompressed using tar in the

For Oracle's learning and discussion, I will proceed directly below, and I will not discuss the history of Oracle, because the Oracle official team has a better explanation, here is a refinement of my knowledge about Oracle. For more information

Cocould not load program Oracledevmdm:Symbol resolution failed for/usr/lib/libc. a [aio_64.o] because:Symbol kaio_rdwr64 (number 1) is not exported from dependentModule/unix.Symbol listio64 (number 2) is not exported from dependentModule/unix.Symbol

Compile the following function in the user to prompt that no dba_objects object exists; Create or replace function my_get_name (v_objid number)Return varchar2 isV_objname varchar2 (100 );BeginSelect t. OBJECT_NAME into v_objname from dba_objects t

1./etc/oratab description Use cat to view the file: Gg1:/home/Oracle> cat/etc/oratab # # This file is used by ORACLEutilities. It is created by root. sh # And updated by the Database ConfigurationAssistant when creating # A database. # A

PL/SQL contains two types of cursors: 1. Display cursors 2. Implicit cursors Display cursor:Syntax:CUROSR cursor_name is select_statement;Open cursor: open cursor_name;Extract data: 1. FETCH curosr_name INTO varible1, variable2 ....;2. FETCH

In view of redis list, hash, set, string and other types of operations, many people are familiar with the use of, a brief introduction to dynamic parameter modification, master-slave switchover, persistent settings, system information

If the directory on the master and backup is different, add the files in the pfile file on both ends. If the directory is the same, add the following files:*. Log_file_name_convert = '/u01/oradata/orcl/', '/u02/oradata/orcl /' *.

1. Workspace Manager introduces Oracle Workspace Manager's architecture of creating different versions for different tables. Version Management (Workspace manager) is a new feature of Oracle 11g. It is embedded in the oracle database and allows

Replace variables (only used for SQL * Plus or development tools with the same principle as SQL * Plus ):Temporary storage valueIt can be used to create a general script.It can be used to interact with users, so it is also called interactive

1. query the user's connection statusSelect username, sid, serial # from v $ session where username = 'maximo '; Username sid serial #--------------------------------------------------MAXOMO 22 1MAXIMO 142 1   2. delete one by oneAlter system kill

In Oracle databases, consistent gets is very useful in determining the performance of a SQL segment. Generally, comparing the performance of two SQL segments is not a short execution time, it depends on whose consistent gets is small. However, this

Oracle 11g grid infrastructure installation failure, or need to uninstall, not as troublesome as 10g CRS component Uninstall. Take linux as an example. The procedure for manually deleting CRS at 10 Gb is as follows:Rm-f/etc/init. d/init.css

Latin1 is an alias for the ISO-8859-1, and Latin-1 is written in some environments. ISO-8859-1 encoding is single-byte encoding, downward compatible with ASCII, its encoding range is 0x00-0xFF, 0x00-0x7F completely consistent with ASCII, 0x80-0x9F

Backup OverviewLogical backup:There are two types of backup: , Physical backup and logical backup Physical backup: This method completely restores the database, but requires a large number of external storage devices, such as tape libraries,

In the database design principle, the purpose of the Self-increasing field is to determine the uniqueness of each record for the unique index, and to ensure the query speed when the database volume is large. However, there are separate fields in

MHA is divided into management nodes and database nodes. database nodes are composed of mysql master-slave or master-slave nodes. When the master database fails, the management node will automatically upgrade from the master node to the master node;

Ubuntu version: 12.04 LTS MySQL version: MySQL Community Server 5.5.25 Installation Directory:/usr/local/development/mysql-5.5.25 1. Open the websiteHttp://www.mysql.com/downloads/mysql/To download the MySQL version (this article selects the 64-bit

Cause: In the RAC + RAW + ARCHIVE environment, several RAW files are added, but the host is modified on one side. The following error occurs: ORA-01157: cannot identify/lock data file 129-see DBWR trace file ORA-01110: data file 129: