When learning about the basic architecture of Oracle databases, I have learned about the storage structure of Oracle. Logically, Oracle data is stored in tablespaces and physically stored in datafiles. A tablespace can belong to only one database (a database can contain multiple tablespaces), including one or more data files. Tablespace can be further divided int
Oracle 10g Tutorials: Oracle Net Services
In this tutorial you will learn Oracle Net Services-an overview, using Oracle Net manager, creating listeners, choosing general parameters, enable the tracing and logging for the database transactions. we will also learn how to use tnsping to test
Common oracle maintenance and oracle maintenance at work
Http://blog.csdn.net/lili72
Background: due to historical reasons, some of the company's businesses are still using oracle. If something goes wrong, it is very troublesome. Since mysql, hive, Hbase, and so on are used for a long time, some oracle commands are sl
Similarities and differences between Oracle Enterprise Edition, Standard Edition, and other versions, oracle Enterprise Edition
For different development and deployment environments, Oracle divides the same series of Oracle databases into four versions: Standard Edition One, Standard Edition, and Enterprise Edition) an
Linux-install Oracle (CentOS-Oracle 12c) and centos7 install oracle12c
Step 1: network connection, which is described in my previous blog.
Purpose of network connection: to use the yum command, download the file directly online.
Step 2: Go to the oracle official website to download 12c
Two files on the database server: (installed in Linux)
Linuxamd64_12102_databa
Oracle 11gR2 is installed in Oracle Linux 6.0 (also suitable for other linux versions of RedHat ).There is no major difference in the installation under. After all, the three linux releases are more different in log.This document is a review after I installed oracle11gR2 in Oracle Linux 6.0. Some installation details are not mentioned.# Represents the root user.
Notes on installing Oracle 10.2.0.1.0 on Oracle Linux 4u4
Exercise the Oracle RAC formation process. Step 1: First practice installing Oracle 10.2.0.1.0 on Oracle Linux 4u4. It is difficult to directly install RAC. Start from simple. For the overall RAC steps, refer to the R
Tags: install path get nod suitable active Targe operation nload Existing Oracle Study-aix6.1 Building Oracle 10GR2 RAC (4) I. Installation of CRS patches before installing CRS, you need to install patch p6718715_10203_aix64-5l, or you will see "Node not found" error during installation. [[email protected]/] #cd/home/oracle/p6718715_10203_aix64-5l/ Once the pat
Label:Today, we share a note of my own study, hoping to bring help to those who meet the same problem. I do not know if everyone in the Win7 64-bit system with PB to connect to the Oracle database, have encountered "Oracle Library Oci.dll couldnot be loaded" issue. Today, in the Win7 64-bit system with PB to connect to the Oracle database, has been the above erro
Practicing Oracle's RAC build process, the first step is to practice installing Oracle 10.2.0.1.0 on 4U4 first. Installing RAC directly is somewhat difficult. From a simple start. For the total RAC Step, refer to the RAC form of the teacher.1. Start VC, login vsphere 5.1,2. Create a new virtual machine, Redhat 4 32bit compatible virtual machine, memory 1G, HDD 30G. Remove the floppy drive and select the optical drive as an ISO image file.3. Start the
Oracle experiences 1 -- oracle introduction @ basic SQL statement @ conditional query @ sort data theory and case studies1. Oracle IntroductionOracle is the first word for English translation of oracle (Oracle bone inscriptions) Unearthed from Yin.
Oracle materialized view code example, oracle Materialized View
Materialized View of Oracle
Recently, oracle materialized views have been updated based on the project business needs. You can search for information on this topic on the Internet to facilitate improvement. The content is as follows:
Materialized View is
Oracle Database hot backup and recovery and example, oracle Database
Manual Hot Standby (Database opening status)
Backup control file:
Alter database backup controlfile to '/u01/oradata/prod/con. bak1 ';
Back up data files (here pl/SQL is used for batch processing, and the query results can be pasted and run)
BeginFor I in (select tablespace_name from dba_tablespaces) loopDbms_output.put_line ('alter tables
Environment:Source Server:VM7.14 rhel5.5-32 Oracle 11.2.0.0g172.16.3.202Target ServerVM7.14 rhel5.5-32 oracle 11.2.0.0g172.16.3.204
Source Server
1. Add verification tables and data to the database:
[Oracle @ ebs01 ~] $ Sqlplus "/as sysdba"
SQL * Plus: Release 11.2.0.1.0 Production on Sun Jun 10 13:09:43 2012
Copyright (c) 1982,200 9,
Http://blog.csdn.net/lizhenhuatop/archive/2008/09/27/2986303.aspxFYI
For historical reasons, Oracle had no Chinese character sets (such as oracle6, oracle7, and oracle7.1), but some users used the database since then, and
You can use the us7ascii character set to store Chinese characters, or you may choose a default character set, such as we8iso8859p1 or
Us7ascii, and these two character sets do not have Chinese character encoding. Although this chara
, the 11.2.0.1 RAC that is installed on the virtual machine is chosen 11.2.0.1 because of problems with public IP and private network segments. During the installation instance, the computer crashes and restarts, and CRS fails to start.
[Root@rac1 bin]#./crsctlstart CRS
Crs-4124:oracle highavailability Services startup failed.
Crs-4000:command startfailed, or completed with errors.
[Root@rac1 bin]# Ps-ef|grep has
Root 8081 1 0 03:14? 00:00:00/u01/ap
From:https://support.oracle.comWhat is "Oracle javavm Component Database PSU"?Oracle JAVAVM Component Database PSU is released as part of the Critical Patch Update program from October onwards.IT consists of separate patches:
One for JDBC clients-applicable to client, Instant client, Database and Grid oracle_homes.This is a referred to as "JDBC Patch" in the rest of this document.
One for the
first, start and stop Oracle Stopping and starting Oracle needs to be switched to Oracle users so that no other user has permission to start and stop Oracle (including root and no permissions). 1. Run Sqlplus without logging on to Oracle:Sqlplus/nolog2. Connect to the Oracle
2014-07-26 BaoxinjianI. Basic concepts of Oracle Architecture
1. Oracle's overall architecture is divided into three parts
The first part: System Global Area (SGA)
Part Two: program Global zone and background process
Part III: Oracle's Files
2. From functional angle to those division
Storage structure
Includes: Control files, data files, and log files
Role: These files form the physical storage str
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.