Oracle concept (Oracle 10.2)
10. Application Architecture
This chapter defines the application architecture and describes how Oracle database servers and database applications work in a distributed processing environment. This architecture can be applied to almost any type of Oracle Database system environment.
This ch
Environment: I use the VBOX virtual machine, a host that has installed the Oracle database and GOLDENDGATE. The other one only installs the ORACLE database.Configure the database environment, goldengate users, and install GoldenGate. For more information, see configure OGG between two Oracle databases-synchronization D
Oracle Silent Installation and oracle Silent Installation
Download the oracle installation package:
:
Note: To download oracle, you must register oracle.
Http://download.oracle.com/otn/nt/oracle11g
Download two packages:
Linux.x64_11gR2_database_1of2.zip
Linux.x64_11gr2_dat
Steps for migrating a single Oracle DataBase instance to Oracle RAC:
-------------------------------------- Split line --------------------------------------
Detailed illustration of the entire process of VMware + Linux + Oracle 10G RAC
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing
1. Products used: ArcSDE 9.3 + Oracle 10.2.0.1
2. Problem description: arcmaploud is used for spatial data, and the operation is performed within several minutes. The arcmapis does not respond, the CPU usage of the data warehouse server is 100rmb, and the number of gsrvr.exe processes is 10 +.
3. Solution: Upgrade Oracle from 10.2.0.1 to 10.2.0.3 or. 2.0.4.
4. Cause: According to ESRI engineers, oracle10
Oracle remote connection (PLSQL, SQL developement + Oracle database + client + remote connection settings, plsqldevelopement
Server
Configuration: oracle11g R2 x64
1. Set the listener
A. Launch bar-> Start-> Program-> Oracle-OraDb11g_home1-> Configure and port tools-> Net Manager
B. oracle Net configuration-> Local->
use. The driver is even more admirable. The two-way text copy with the host machine is even more elegant. The only drawback is that the block size is 400 mb.
(3) The VM virtualbox 4.2 provided by Oracle is smaller than MB, and the enhanced components, namely, guest additions, must be installed separately after the text copy is completed. In addition, the driver compatibility is not very good, in use, shutdown may fail. Finally, I chose it.: Http://
In linux, oracle is configured with the system to start and shut down, and in linux, oracle is configured
Configure oracle to start and shut down with the system in linux
1. Modify the/etc/oratab FileChange the number of databases that need to be started with the operating system from N to Y.Lis:/u01/app/oracle/product
How to uninstall oracle and uninstall oracle
Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of oracle. It still occupies a major share in the database market. Lawren
How RAC Works and related components (iii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review review, the other is easy to use. This document is
Create an Oracle database
Create an Oracle database (taking Oracle10g as an example)
There are two ways to create a database: one is to create a database manually using a command line script; the other is to create a database using the Database Configuration Wizard provided by Oracle. This document describes how to create an
As one of the mainstream databases in the current market, Oracle databases are developed on many applications. Due to the reasons for upgrading Oracle databases and different application providers, several Oracle versions may exist in an application unit, such as Oracle 7, Oracle
Oracle Installation
Oracle8i is installed through a new Java-based Oracle universal Installer (Oui). The same interface [1 m cyran, 1999] is available on all platforms. The above sentence is correct, but some small differences should be noted. X-compatible display capability is required on UNIX, or an application like exceed is available on the client workstation. You can directly run the installer on Windo
Oracle uses goldengate to perform one-way replication for Oracle and mysql. Oracle uses one-way replication for Oracle and mysql respectively. Blog. csdn. netq947817003articledetails13294937 II. Add the corresponding content to the ORACLE master database and the
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.