Oracle 10g AND Oracle 11g manual database creation case -- Oracle 11g
System Environment:
Operating System: RedHat EL6
Oracle: Oracle 10g and Oracle 11g
Manual database creation is relatively easy to implement. In this case, we
Tags: oracle oracle 11g Redhat DatabaseFor beginners who want to learn Oracle, see the veteran. Operating System Information: VBox virtual machine software version: Install the required software: Required Software:Http://pan.baidu.com/s/1mgl8kzu Specific installation steps:A. Create a new virtual machine and install
Use VBox to simulate storage migration environments, os:rhel5.9,db:oracle 10.2.0.4 RAC ASM 2Nodes.
ASM uses extern redundancy, which does not use ASM's rebalance functionality, and OCR and Votedisk are stored in raw.
Migration includes Controlfile,datafile,tempfile,spfile,ocr,votedisk.
Path before migration
OCR/DEV/SDF1/DEV/RAW/RAW1,/DEV/SDF2/DEV/RAW/RAW2
VOTEDISK/DEV/SDG1/DEV/RAW/RAW3,/DEV/SDG2/DEV/RAW/RAW4,/dev/sdg3/dev/raw/raw5
ASM +data/dev/
Label:There are three types of options:1, first in the task Manager to switch off all VirtualBox process, and then into the C:\Users\Administrator\VirtualBox vms\ will be the corresponding guest folder to change the name of the guest, and then re-open it, you will find that can not open, Then turn off all the VirtualBox processes, change the guest name back, and then the guest will be able to use it smoothly.2. Open BIOS (depending on what computer you are) BIOS Setup Utility-"Config ==> CPU ==>
Label:Oracle 11G RAC Database installation (eight)
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 doc
Disclaimer: This article transfers from the network article, reproduced this article only for the personal collection, shares the knowledge, if has the infringement, please contact the blogger to delete.Original LeshamiOriginal address: http://blog.csdn.net/leshami/article/details/5529239--========================================== --oracle Instances and Oracle Databases (
Oracle Cluster Concepts and principles (ii)
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 rev
Oracle 10g AND Oracle 11g manual database creation case -- Oracle 10g
System Environment:
Operating System: RedHat EL6
Oracle: Oracle 10g and Oracle 11g
Manual database creation is relatively easy to implement. In this case, we w
--==========================================--oracle Instances and Oracle Databases (Oracle architecture)--==========================================/*For the first contact with Oracle database, two concepts that are easily confused are Oracle instances and
Tags: OracleSet power on (Linux) auto-start Oracle shutdown automatically shuts down Oracle1, switch to the root user, confirm that the startup file and the shutdown file is present[Email protected] bin]$ pwd/u01/oracle/product/10.2.0/db_1/bin[[email protected] bin]$ ls DbstartDbstart--sqlplus script to invoke when executing startup[[email protected] bin]$ ls DbshutDbshut--sqlplus the script to invoke when
Tags: Rhel 6 installation Oracle 11Objective:recently in the study of Oracle, here I put the installation and configuration process to record, follow my method of this step by point basically no problem, If you have any questions, you can talk about learning from each other. Installation environment and version:System version: Redhat 6.5Oracle version: 11.2.0.4.0Virtual machine version:
Tags: DBA RAM read-write management art SSE buffer temp tablespace UNIXReprinted from: http://blog.csdn.net/robinson_0612/article/details/5529239 An Oracle server consists of an Oracle instance and an Oracle database. That is: Oracle Server = Oracle Instance +
Oracle redo complexity-oracle Core Technology Reading Note 3, redo-oracle
I. Overview
We know that in oracle, Every modification to a piece of data generates a redo (that is, redo, which records the modified content ). The purpose is to back up the modified data for future redo. Now there is a problem. Redo logs are ge
Because of the installation of Oracle 10G when there was a problem, and then asked roommates to send a copy of the Oralce 10g client installation package came up.
It was possible to use Pl/sql, and then, in the case of a job need, to import an Oracle database backup from a colleague at a time, making
IMP statement to import a 6550 error, the internet to check the reason is because the server and the clien
Some time ago I started to learn some basic knowledge about oracle. To facilitate exercises and operations, I installed an Oracle 10 Gb. After the installation is complete, the current database is directly deprecated. The card is terrible. The card can only be used for surfing the Internet. At that time, I was too busy to do anything else, so I never care about it. Together with the last Internet cafe. Thes
Method 1:
As we all know, to connect to Oracle using PL/SQL, you need to install the Oracle client software. Have you ever wondered whether to directly connect to Oracle without installing the Oracle client?
In fact, I always wanted to do this, because this client is so annoying !!! Not only will JDK be installed,
Label:Data Guard is a remote replication technology for Oracle, it has physical and logical points, but in general, it needs a separate system in a remote location, two sets of hardware configurations can be different systems, but the software structure of the two systems are consistent, including the software version, directory storage structure, and data synchronization (in fact, is not real-time synchronization), the two sets of systems as long as
Tags: file path off SQ server has a lock creat evo combo1.Oracle Default UserAccess to Oracle database only with a legitimate user accountOracle has several default database usersAll data dictionary tables and views in the database are stored in the SYS pattern. SYS users are primarily used to maintain system information and manage instances.Systems is the default system administrator who owns the internal
1.1DescribedGenerate a lot of "oracle_w000_9708.trc" and "ORACLE_W000_9708.TRM" under the "$ORACLE _base/diag/rdbms/$ORACLE _sid/$ORACLE _sid/trace" folder File.These files are generated too quickly. The Oracle root folder is running out of free space.1.2Possible causesThe possible reason for the "$
About Oracle ASM instances
About Oracle ASM disk groups
About grouping and failure groups
About Oracle ASM Disks
About Oracle ASM files
About Oracle ASM instances
The Oracle ASM instance is built based on the same technology a
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.