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
Tags: let stp knowledge iptables Owner system SPFile splay Post Oracle LINUX 6.3 + Oracle 11.2.0.3 RAC + vbox Installation documentation 2015-10-21 12:51 525 people read Comments (0) favorite reports Classification:Oracle RAC Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced. VBOX + Oracle Linux 6U3 +
Some of the basics of Oracle have been learned some time ago, and for ease of practice and operation, an Oracle 10g was installed. After the installation, the book was directly discarded. Card to the death, card to directly can only be used as the Internet. At that time because of busy also do not do other things, so has not been in charge of it. Make up for the last Internet café. The two days are free. So
A set of 11203 RAC ADG on Exadata machine environment in the previous time, ADG error was prompted during standby side query Node2, but the Dblink query was normal, DG's ora-1089 The process is on the Node1, and the confirmation is a simple bug record.
--on standby node2, but on standby Node1 is workedSelect COUNT (*) from DBMT.DBMT_TABLEINFO@LINK_WEEJAR_A2. anbob.com;
Ora-01089:immediate shutdown in progress-no operations are permittedProcess id:77
Memlock 60397977* Hard Memlock 60397977This value is greater than the SGA requirement and is harmless.If the Exadata machine, please refer to document 1284261.1 for parameter requirements.2). re-login to root and Oracle user, check Memlock limit$ ulimit-l603979773). If you use 11G and later versions, AMM (automatic memory management) is turned on by default, but AMM and hugepagesis incompatible (because Hu
1. Oracle Installation
Please refer to the following link for more information: http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html.
2. Use the command line sqlplus to connect to Oracle
(1) Check the listening status
C: \> LSNRCTL status
LSNRCTL for 32-bit windows: Version 9.2.0.1.0-production on 2005 11:01:01
Copyright (c) 1991,200 2, Oracle Corporation. A
It takes a day and a half to resolve the client connection to the Oracle database on the server side, unable to connect the problem. Ora-01034:oracle Not available (ORACLE does not exist), ora-27101:shared memory realm does not exist analysis:A few days ago you can also connect to the database, but yesterday, the local no reason to connect to the server database.
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
Oracle Server entry and oracle management routineI. Common oracle database management toolsOracle Universal Installer (OUI): used to install, upgrade, or delete Software ComponentsOracle Database Configuration Assistant (DBCA): a graphical user interface tool that interacts with OUI. It can also be used independently to create, delete, or modify databases.SQL * P
What is a relational database? Oracle database architecture, Oracle cluster introduction, and oracle Architecture
What is a relational database?
Databases based on Relational Models.
What is a relational model?
Use rows and columns in a two-dimensional table to maintain the data model.
Oracle database architectur
Tags: style blog http ar file Data SP Div 2014 1 installation Knowledge of Oracle (oracle10g and oracle11g version differences ) :A the installation directory should not have Chinese and white spaceB oracle10g support winxp does not support win7,8 and vista;oracle11g supports all versions2 oralce Server: comprised of Oracle instances and Oracle datab
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->
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
Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R2 11.2.0.4. The operating system version is Oracle
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
Oracle undo complexity-oracle Core Technology Reading Notes 4, undo-oracle
I. Overview
Undo stores old data. For example, if you modify A record to change abc of column A to def, abc is saved in undo. There are two purposes: 1. if your transaction has not been committed, but you have modified column A, when someone else reads this data, they should not be able to
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.