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

Oracle DBLink script -- Drop existing database linkDrop database link DBLink name; -- Create database linkCreate database link DBLink nameConnect to remote database username identified by passwordUsing '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =

1. Modify the dbstart script:$ Vi $ Oracle_HOME/bin/dbstart# ORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracleORACLE_HOME_LISTNER = $ ORACLE_HOME 2. Modify/etc/oratab in the following format:$ Vi/etc/oratabSID: $ ORACLE_HOME: Y3. Modify/etc/rc. local to

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

To install Oracle in a virtual machine Linux: Step 1: copy the oracle Installation Software to the Linux environment. The specific steps are as follows: in/etc/samba/sam. configure the shared directory in conf. First, you need to create a new folder

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

PL/SQL is a block structure language. The block consists of the definition part, execution part, and Exception Handling part. Syntax structure: Declare /* * Definition: used to define variables */ Variable name variable type V1 varchar2 (10 )

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

In Oracle databases, varchar2 (4000), a large amount of content, is often helpless. In this regard, we often use large objects for storage (clob), but because the jdbc driver does not support CLOB well, it is often very troublesome to use hibernate

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.

I. hardware configuration IBM3850 (based on the installation environment) 2. Software preparation Linux.x64_11gR2_database_1of2.zip Linux.x64_11gr2_databasesilicate f2.zip FileZilla.exe Iii. FileZilla software installation and configuration 1.

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

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

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