or ASM. Block devices and bare devices will no longer be supported in Oracle12. Oracle strongly recommends using at least 3 voting disks in a different location. When using ASM to manage voting disks, you need to be aware of the redundancy levels of disk groups and failure groups. Note that all copies of voting disk are in one disk group, and you cannot distribute voting disks across multiple disk groups. When using an externally redundant disk group
vote disk, which is restarted when a node with >=3 vote disk connection times out due to network or storage reasons. When one or two vote disk is damaged, it does not affect the operation of the cluster.How to view the configuration of an existing systemFor an existing system, the following methods can be used to confirm the heartbeat configuration of the DB instance, including the NIC name, IP address, and network protocol used.? The simplest method can be obtained in the database background a
Tags: OracleOracle Database 11g Some important initialization parameters (i)Initialize parameter file locationD:\app\Administrator\admin\orcl1\pfile\init.oraInit.ora1, Diagnostic_destIn 11g, there is a new structure for storing diagnostic information called the Automated Diagnostics repository (AUTOMATICD Diagnostic Repository ADR).Specify the directory location with some parameters, such as $ORACLE_BASE/DI
This article describes how to install Oracle 11gR2 (11.2.0.3) in Oracle Linux 6.3 ). Since Oracle 11g, the official Oracle website does not provide a download link for its Patch. You need to use the Meatlink account to download the Patch. Do not worry about the kids shoes. I
Write in front: In the work, the general installation of Oracle oneG client, configure Net Manager (installed client or server), remote connection to the Oracle database to meet the needs of connecting the database. If you want the machine to operate Oracle, you need to install Oracle one-to-oneG server.
Database 11G RAC cluster installation (vii)
ORACLE ENTERPRISE LINUX 5.7 Databases 11G RAC database installation (eight)
Basic test and use of database 11G RAC under ORACLE ENTERPRISE LINUX 5.7 (ix)
Cache Fusion principleThe background process for RAC has been d
dbms_workload_repository. Create_snapshot;We can also use the Dbms_workload_repository package to complete the baseline, modification of the default settings and so on.ADDM (Automatic Database Diagnostic Monitor AWR)is a consultant system within Oracle that can automate some of the optimization recommendations for the most databases, give recommendations for SQL optimization, index creation, and statistics collection.ADDM report Generation:Sqlplus>@?
, Oracle will rearrange the NON-ACCESS predicate order to reduce CPU costs, but in most cases it will not be aware of performance differences.) )
Overall-it ' s definitely a good thing. In practice, you may have a much stronger bias towards indexed access paths which the May impact performance.
Anyway--it's certainly a good thing. In fact, you can find a stronger preference for index access paths, which will affect performance.
Further reading:oracl
Oracle 10g and Oracle 11g hand-built case--oracle 10gSystem environment:Operating system: RedHat EL6Oracle:oracle 10g and Oracle 11gThe Manual construction of the library is relatively easy to implement, this case is from 10g and 11g
install11. Use the Startup ScriptYou need to make some changes before using the startup script, mainly to configure the ORACLE_HOME_LISTNER variable.Vi $ ORACLE_HOME/bin/dbstartPut 79 rowsORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracleModifyORACLE_HOME_LISTNER = $ ORACLE_HOMEOtherwise, an error is returned:[Oracle @ gtlions bin] $./dbstartFailed to auto-start Oracle Net Listene using/ade/vikrkuma_new/
Now there is a need to use Exp/imp to import 11g of database data into 9i, to solve this problem generally think of three ways of thinking, try (in fact, from the high version of the server to support the low version of the client principle, you can probably guess the use of 9i client to handle the problem)
Method 1: Export imports all use 11g clients
--11G Cli
Navicat for Oracle connection to Oracle 11G operation process, navicat11g
Procedure for connecting Navicat for Oracle to Oracle at 11 GB
1. Change the Oracle configuration file
After installing
Oracle 11g real-time SQL monitoring
Oracle,In-depth analysis of Oracle,Reading Notes April 9 th, 2010Author: dbtan | [indicate the source and author information in hyperlink form during reprinting]
Link: http://www.dbtan.com/2010/04/real-time-sql-monitoring-in-oracle11g.html
Orac
information between Oracle processesAbout connected session information, including all current active and inactive sessionsDatabase information is stored in the SGAORACLE.DATABASE.11G InstallationThis trial CentOS6.5 system, before installing Oracle to pay attention to hardware requirements, memory minimum of 4GB, virtual memory is twice times the physical memor
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.