Database Administrator

Two types of Oracle Database initialization parameter files:File: initsid. ora spfilesid. oraPath: $ ORACLE_HOME/dbs Differences between plain text parameter files and binary parameter files:1. Modify parameters in different ways: When initsid. ora

This article describes how to install and configure Oracle SOA Suite in Linux. The version of SOA Suite is 11.1.1.3.0, which is the latest version. Just like setting up an environment in the past two days, simply record the building process and

Oracle introduced the flash recovery area concept in 10 Gb to simplify and improve backup. However, the flash recovery area also needs to be carefully planned and configured. Otherwise, problems may occur, from Oracle10gR2, Oracle also provides a

Solution: 1. Stop OEM firstEmctl stop dbconsole 2. Enter the following three paths:$ ORACLE_HOME/jdk/jre/lib$ ORACLE_HOME/jre/1.4.2/lib$ ORACLE_HOME/javavm/lib/ojvmfonts 3. overwrite the following command in each directoryCp font. properties.

Platform: CentOS 5.3, Oracle 10.2.0.1Plan: db_name = risotest. You can also use risotest for the global database name. The directory structure is roughly divided into the following structure: You can do whatever you like: You need to have a concept

After Oracle 10201 rac is upgraded to 10204, the following error is reported during export. EXP-00056: ORACLE error 3212 encounteredThe ORA-03212: Temporary Segment cannot be created in locally-managed tablespaceEXP-00000: Export terminated

A test was conducted. SQL> create table test1 (cola varchar2 (10); the table has been created. SQL> create table test2 (colb varchar2 (10); the table has been created. SQL> select * from test1; SQL> select * from test2; SQL> create or replace

I have been trying to install a testing environment for Oracle10g RAC. Today I have finally finished it. For more information, see: The specific steps are not listed. The above descriptions are very detailed. I just want to list some errors and

1. Build the installation environment 1. Create an informix user group and user Log in as root, and then: Groupadd-g 3000 informix Useradd-u 3000-g 3000-d/home/informix-m informix 2. Modify Environment Variables # Su-informix # Cd # Ls- # Vi.

LVS Server: 192.85.1.5Virtual IP: 192.85.1.10Real Server1: 192.85.1.4Real Server2: 192.85.1.9Install ipvsadm and keepalived on The LVS Server.$ Sudo apt-get install ipvsadm keepalivedYou can directly modify keepalived. conf without configuring

1. Statement to modify the Oracle user password Alter user edw1010 identified by edw1010; In fact, this is very simple, but because it is not commonly used, it may seem a little busy. 2. View deleted code scripts The reference statement is as

Although I have written a lot of SQL statements on Oracle before, I didn't take the time to study Oracle systematically. Practice is important, but there is no theoretical standard to learn and understand, in practice, you cannot write SQL

The following are examples of Oracle knowledge points. User Logon (switch the user name and password to log on ): Sqlplus/nolog Connect/as sysdba 1. Users 1. Create a user (example) Create user olay identified by 123; 2. delete a user (delete

A colleague asked me a few days ago whether exp/imp involved the version. I think that as long as it is software, it will involve the compatibility of high and low versions. Oracle is also software, so is it. Simple experiment: Exp tool Version: 10

Before leaving work today, I suddenly received a call from the Bureau asking for a detailed call record for June October. Then, the entire table is started and the extracted records are inserted into the detail table. Now, we can delete tens of

Explanation of Incomplete recovery In the previous article (loss of the UNDO tablespace caused by RMAN backup and recovery), we talked about how to deal with the loss of the UNDO tablespace. The UNDO tablespace cannot be taken offline. Similarly,

Oracle archiving Mode 1. Check whether the oracle database is in archive mode: 1. select name, log_mode from v $ database; NAME LOG_MODE------------------------------------------QUERY NOARCHIVELOG   2. Use the archive log list Command Database log

1 show all; displays the current configuration information 2 select * from v $ rman_configuration; query non-default values in RMAN 3 common configure options 3.1 persistence Policy Configure retention policy to recovery window of 7 days; backups

Flash back technology is usually used to quickly and easily recover logical errors such as misoperations in the database. The flash back method can be divided into database flash back, table flash back, and transaction flash back, based on the

To build a Oracle10g-RAC cluster environment, we need to solve the problem of shared storage first; Here the FreeNAS-8.0.4-RELEASE-p1-x64.iso is used to configure ISCSI shared storage; Install the FreeNAS8 system, and the operating system disk can