Discover asm commands in oracle 11g, include the articles, news, trends, analysis and practical advice about asm commands in oracle 11g on alibabacloud.com
Tags:productseventice Software installation rsa controloraclesoft completely uninstall 1. If the database is configured with automatic storage management (ASM), you should first delete the clustered Synchronization service CSS (Cluster Synchronization Services). The way to delete a CSS service is to execute the following command on the DOS command line: localconfig Delete 2, stop all Oracle Services in the
In general, Oracle 11g R2 RAC provides the following features:
High Availability: shared-everything mode ensures that services are not stopped when a single node fails, and other nodes in the cluster will take over quickly
Scalability: multiple nodes share the load and can provide processing capabilities far beyond that of a single database. Addition and deletion of nodes can be completed online without
--------------------------------------------------------------------------------------------------------------- ---------------------------Rman> Show snapshot controlfile name;Rman> Configure snapshot Controlfile name to '/STORAGE/SNAP_CONTROL/SNAPCF_%D_%I_%S_%P_%T.F ';Rman> Configure snapshot Controlfile name to ' +DATA/ORCL/SNAPCF_ORCL.F '; --can also be specified to the corresponding ASM disk group (disk group does not support wildcard naming)After
The full uninstall mode for Oracle 11g servers and clients has changed with the previous versions:1. Preparations before uninstallation: Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services.Ii. Batch unload: Run the deinstall. bat batch file of H: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ deinstall to uninstall the fi
The full uninstall mode for Oracle 11g servers and clients has changed with the previous versions:
1. Preparations before uninstallation: Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services.
Ii. Batch unload: Run the deinstall. bat batch file of H: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ deinstall to uninstall the
Starting to test Oracle 11g RAC, the current performance is limited, so a single node RAC is installed. The procedure is as follows:
Nic binding
Modify ifcfg-bond * ifcfg-eth * in/etc/modprobe. conf and/etc/sysconfig/network-scripts *
I will not talk more here
Configure xmanager connection
VI/usr/share/TPD/defaults. conf
Change enable = false under [XDMCP] to enable = true.
Change allowremoteroot = fa
CRS-0184/PRCR-1070 when Oracle 11g RAC executes root. sh
Oracle 11g RAC installation, the first node to execute root. sh encountered a CRS-0184/PRCR-1070, Google a lot of posts have not found a solution. Hey, let's calm down and look at the log !! The conclusion is a casual problem, as described below.
1. Fault
# Insta
Oracle 11g rac ocr and db_unique_name configuration relationship description 1. Problem 1: the following error is found in the alert log of RAC standby:
SUCCESS: diskgroup DATA was mountedERROR: failed toestablish dependency between database dave_st and diskgroup resourceora.DATA.dgSUCCESS: diskgroup FRA was mountedERROR: failed toestablish dependency between database dave_st and diskgroup resource ora.FRA.
disk. Split-brain has obvious harm to clusters. Cluster software vendors must provide solutions to solve this problem. Oracle cluster software (grid infrastructure in 11g) uses a quorum device ), it is called voting disk to determine the members in the cluster. All nodes in the cluster share a voting disk. When a node cannot send heartbeat to the internal network or voting disk, It is evicted from the clus
necessary to modify the Yum source, you can useHttp://mirrors.163.com/http://mirrors.sohu.com of these 2 domestic sources.Execute the following command. Cd/etc/yum.repos.dMV Centos-base.repo Centos-base.repo.bakwget Http://mirrors.163.com/.help/CentOS-Base-163.repo or wget Http://mirrors.sohu.com/help/CentOS-Base-sohu.repoRun the Yum Makecache build cache4 Console page Some of the text on the button is garbled solution (such as login screen: Login button)Workaround:EM garbled is caused by Java,
Tags: Oracle 11gTesting the importance of OLR in Oracle 11g clusterCalled an Oracle local Registry (OLR): All node in a cluster have a Local Registry for node-specific ResourcesTest one: Simulate the OLR abnormal loss situation:Here first will OLR Renam[Email protected] cdata]# MV VMRAC2.OLR Vmrac2.olr.bakThen try to s
background processes.B.orae grid Infrastructure (grid base layer, grid foundation software, cluster Software): is a software, responsible for managing nodes in the cluster, various resources and storage management, is the basis of RAC. Install the GI first and then install the RAC. GI can then be divided into:A. Oracle clusterwareB. Automated Storage Management ASM (Or
Some ASP. NET + Oracle 11G systems write-and-learn essays, including Oracle's "batch Update" and Oracle's internal encoding set to the Unicode Character Set. (4) Oracle "batch Update", "batch Add", and "batch Delete" Syntax Oracle can still isolate Multiple SQL statements using semicolons (;), such as SQL Server and
Oracle Clusterware 11g 2nd and later versions. For Oracle 11g 2nd and later versions, password-free SSH is required.
This command writes the DSA public key ~ /. Ssh/id_dsa.pub file to write the private key ~ /. Ssh/id_dsa file.
Do not distribute the private key to any user who has no permission to install the
Installing Oracle 11g R2 silently in CentOS
I,Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlOracle 11g online documentation:Http://www.oracle.com/pls/db112/homepage
Ii. System RequirementsMemory: 1 GB (minimum official requirement: 1 GB)Hard Disk: 40 GB (4.29G and 1.7G data files required for Enterprise Edition installation)
Ch
Tags: Modify OCA res scope control File View 11g routed iOS1. Understanding Backup and Recovery issuesThree indicators related to backup recovery are: MTBF average trouble-free timeMTTR mean failure recovery time.Data loss: How much to lose the book data.There are three advanced options for Oracle RAC Steam and DG that have an impact on performance (good bad)2. Type of failure1) Statement failure: DML state
Tags: sys source har Select where profile exe let. sh Recently do a DG archive log Delete,[Email protected] logs]crontab-l
* 8 * * * sh/home/oracle/dbscripts/del_arc.sh
The script calls generate delete checksum three scripts respectivelyCat del_arc.sh
#!/bin/bash
source/home/oracle/.bash_profile
sh/home/oracle/dbscripts/build_del_ archivelog.sh >>/home/
After the CentOS system is installed, you can start the installation of Oracle 11g. First, you must make some preparations.
Use commands to create an Oracle account and corresponding user groups
Create a folder and grant the Oracle user permissions, as shown in the command
protected] oradata]$ Lsnrctl Lsnrctl for linux:version 11.2.0.1.0-production on 17-oct-2016 20:36:34 Copyright (c) 1991, Oracle. All rights reserved. Welcome to Lsnrctl, type ' help ' for information. Lsnrctl> ( 2 ) View Commands Lsnrctl> Show The following operations is available after show An asterisk (*) denotes a modifier or extended command: Rawmode DisplayMode Rules Trc_file Trc_directory Trc_le
In Oracle 11g version, full-Table serial scan may use direct path read instead of db file scattered read used in earlier versions, obviously direct path read has more advantages:1. reduces the use of plug-ins and avoids possible use of plug-ins2. the size of physical IO no longer depends on the block in buffer_cache. Imagine that Block 1, 3, and 7 of an eight-block extent are in the cache, while Block 2, 4,
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.