Before we introduce oracle9i, we'll introduce some information about Oracle, and let your friends know more about Oracle.
In 1977, Larry Airison and Bob Miner and Ed Oates created a software development lab (Software Development Laboratories). The
1Installation Environment
Install the database software on the Primary Library, and build the monitoring and instance, install the database software on the Standby Library, and build the monitoring, but do not build the instance.
Install and configure OracleDatabaseControl using emca on the command line interface
As a loyal user of the command line, the O & M of the server software tends to be completed using commands or scripts, so it is annoying to use a large amount of
Install Oracle10g in Linux and create a database. After installation, create it manually. Step 1: create a directory: oracleora_dataxldb2: Create
Install Oracle 10 Gb in Linux and create a database. After installation, create it manually. Step 1:
When OGG is used, data is synchronized one way between two Oracle databases.
Configuration: source database 100.100.100.21 Instance name dbsid2
Target database 100.100.100.41 Instance name db1
Tutorial objective: to synchronize the scott user emp
ORA-07274: spdcr: access error, access to oracledenied.
Symptom:
The ORA-12545 error is reported when SQL plus/as sysdba logs into the database, as follows:
[Oracle @ source ~] $ Sqlplus/as sysdbaORA-12545: Connect failed because targethost or
1. purpose of this article ● Install ORACLE8 Database server in redhat ● install apache and support wml ● Install PHP2. preparations before installation: redhat6.2install optical disk oracle8.161.tar.gz: run ApacheORACLE8 in Java
1. purpose of
After reading the installation experience of many online users in php, jsp, sybase, oracle, apache, and other aspects, I found that many of them are repeated and incomplete, based on my long-term summary of the above various types of things, I have
The parameter files used in oracle startup are generally in the following situations:1. Single Instance 1.1 is started by default:
In non-rac environments, the parameter files of oracle databases are stored in the $ ORACLE_HOME/dbs directory by
I have been in the blog Park for more than two years. Every time I want to write something, I will give myself a variety of excuses ~ Let's start with the longest-used Oracle Database Import today!
1. exp/imp of earlier versions can be connected to
There are a number of bizarre error cases encountered in the use of Oracle data pumps, which summarize some of the problems and solutions that you have encountered while using the data pump. Are the problems encountered in the use of the process,
Data | database
First, the principle of database selection
1, stable and reliable (high-availability)
Database preservation is the enterprise's most important data, is the core of enterprise application, stable and reliable database can ensure the
First, install the Oracle client, no instructions here. It should be noted that the client decompression location should be located at the root directory of the disk.If there is a problem in the path of the file name that is placed in the text or
Database version: 11.2.0.4Server version: RedHat6.4Main Library Primary: Installing database software and examplesStandby standby: Install only database softwareFirst, the pre-erection of the main standby storage environment:Main Library
There are typically several reasons why Oracle databases take up too much hard disk space (for example, Oracle 10.2.0):1. Oracle's installation directory ... \oracle\product\10.2.0\admin\orcl\udump directory, tracking log files occupy a lot of hard
1. Build Oracle RAC 11g cluster on Oracle Enterprise Linux and ISCSI2. All shared disk storage for Oracle RAC will be based on ISCSI,ISCSI using Openfiler version 2.3, which runs on the third node, which is referred to as the networked storage
As a loyal user of the command line, server-side software operations tend to use commands or scripts to complete, very annoying resources occupy a large GUI. The Oracle database is an important server-side software, and its installation operations
First, create a recovery directory
1, the establishment of the table space
Create tablespace rc_data datafile '/u01/app/oracle/oradata/ocp/rc_data.dbf ' size 50m;
2, build users
Create user RC_OCP identified by RC_OCP default tablespace rc_data
Configuration: Source database 100.100.100.21 instance name Dbsid2 Target Database 100.100.100.41 instance name db1Experimental target: The Scott user emp table in the source database is synchronized to the test table in the target database
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.