rac configuration oracle 11g

Read about rac configuration oracle 11g, The latest news, videos, and discussion topics about rac configuration oracle 11g from alibabacloud.com

11g R2 RAC Installation

During this time, I received a lot of consultation on the database of 11 GB. Maybe the database of 11G has gradually penetrated into the market. In the past few days, I started to try to install and test the RAC on the 11g. In general, the RAC of 11g R2 is not too troubles

Oracle 11g Client and plsql developer configuration

Oracle 11g ClientResourcesDownload resources, direct decompression for configuration Oracle Official resources: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html since Plsql developer is a 32-bit software, 32-bit Oracle clients need to be d

Oracle 11g dblink Configuration

The concept of dblink is not covered in this article, this article mainly introduces the creation of Dblink.1. Create an environment descriptionThis article will create and test Dblink in two operating systems for Red Hat version 5.5, Oracle 11g-equipped virtual machines.2. Host Configuration1) Configure the host Tnsname.ora file[Email protected] schema]$ cd/u01/app/ora

Oracle 11g Dataguard Physical standby configuration (v) Broker switchover test

This paper uses Oracle 11g Dataguard broker Switchover Test 1. Using Dataguard Broker Test switchover 1 Main Library situation Sql> select Open_mode,database_role,db_unique_name from V$database; Open_mode Database_role Db_unique_name -------------------- ---------------- ------------------------------ READ WRITE PRIMARY ORCL Sql> Sql> Conn ABC/ABC is connected. Sql> SELECT * FROM ABC; ID NAME --

Oracle 11g-Network Configuration

Oracle 11g-Network ConfigurationWhen we finish installing Oracle, we need a network connection, which of course requires two things: the server and the client. Through the configuration of the two we can achieve network connectivity. So, how do we usually access the database server? There are two main ways of doing thi

Oracle 11g configuration resolves Ora errors that occur when the connection database is started _oracle

\11.2.0\dbhome_1\bin>sqlplus/as SYSDBA Sql*plus:release 11.2.0.1.0 Productionon Wednesday December 21 10:56:26 2016 Copyright (c) 1982, Oracle. All rights reserved. Connect to: Oracle Database 11g Enterprise editionrelease 11.2.0.1.0-64bit Production With the partitioning, OLAP, Data miningand Real application testing options Sql> 3) Start Sql>startup Wh

Oracle 11g installation and network configuration

any valid digital port. 3) Select "Database Service" in the drop-down option in the right column of the window and click the Add Database button. Enter the global database name in the database column that appears, such as MyOracle. Note that the global database name differs from the database SID, and the global database name actually controls the uniqueness of the global naming of the database within the same network segment, such as the domain controller under Windows, where you can enter myo

Windows 64-bit installation of Oracle 11g,plsql Developer configuration issues, the perfect solution for the database display blank (graphics tutorial) _oracle

normal. Path:d:\app\administrator\product\11.2.0\client_1;d:\app\administrator\product\11.2.0\dbhome_1\bin; ... The fourth is Oracle_sid (ORCL instance name, which is the name of the database at installation time) Oracle_sid:orcl The fifth one is oracle_home. Oracle_home: You can not set, if the settings must be correct, otherwise can not be used. If you forget the instance name at Oracle installation, you can open the registration view, as sho

Installation and configuration of Oracle 11g client.

Tags: http os ar file data div art on CThe database and the client are on different machines.Before installing, navigate to the following folder on the server where the Oracle database is installed.Change localhost in Listener.ora and Tnsnames.ora to the IP address of the machine, my 192.168.1.102Then start installing OracleClientSelect Custom and be able to customize the installed components.Cancels the selection of the

Oracle 11g Client Installation and configuration.

Label:The database and the client are on different machines.Before installation, during the installation process, Oracle database server navigates to the following folder.Change localhost in Listener.ora and Tnsnames.ora to the IP address of the machine, my 192.168.1.102Then start installing OracleClientSelect Customize. The ability to customize installed components.Cancels the selection of the Oracle Sched

Statspack performance report Configuration method for ORACLE 11G ADG

Create a normal statspack report user on the main librarySqlplus/as SYSDBASql>@?/rdbms/admin/spcreate.sqlSql>--Notice to cancel $oracle_home/sqlplus/glogin.sql some settingsSql>--some normal words will appear asking for password and tablespace and temporary filesPerfstat 235619--Create SB UserSql>@?/rdbms/admin/sbcreate.sqlEnter the password tablespace temporary table space.Then ask if you want to configure network (y/n) input yConfigure the Tnsname of the standby library;Build Dblink use Perfst

Configuring the Linux 11G R2 RAC NTP service

When installing an Oracle 11g RAC, we need to configure the NTP service. There are many ways to configure clock synchronization in the case of virtual machines, either using the VMware-brought clock synchronization feature or directly using a local node as a time server. This article describes a clock server that directly configures NTP mode.[Python]View PlainCop

Why not hit the RAC database home when Oracle RAC Opatch Auto

Explain the environment: operating system: AIX 7.1Oracle version: Oracle RAC 11.2.0.3 before the 11.2.0.3.9 patch set, the RAC is not formally used, so you can simply hit the latest 11.2.0.3.11 patch set.The two sets of RAC that were newly installed today in the new PSU, also use Opatch Auto to hit the PSU, but one set

Configure the Linux 11G R2 rac ntp service

When installing Oracle 11g RAC, We need to configure the ntp service. There are many ways to configure the clock synchronization mode when using virtual machines. You can use the clock synchronization feature provided by vmware or directly use a local node as the time server. This article describes how to directly configure the ntp clock server. 1. view the hosts

How to configure the Linux 11G R2 RAC NTP service

When installing Oracle 11g RAC, we need to configure the NTP service. In the case of a virtual machine, there are many ways to configure the clock synchronization method, either using VMware's own clock synchronization feature or directly using a local node as a time server. This article describes the clock server that configures the NTP method directly. 1, view

11G R2 RAC add listen, 11gr2rac listen

11G R2 RAC add listen, 11gr2rac listen The procedure is as follows: Check the network number of the default network, in the red font of 1. It will be used to add a listener later: [grid@rac121 admin]$ srvctl config networkNetwork exists: 1/10.1.252.0/255.255.255.0/eth0, type static View the syntax for adding a listener to srvctl: [Grid @ rac121 admin] $ srvctl add listener-hAdds a listener

11g RAC R2 Architecture---Grid

hierarchy of tree graph)First floor OHASD logs are located at: $Grid _home/log/ The second layer: (OHASD agent) Cssdagent logs are located at: $Grid _home/log/ Cssdmonitor logs are located at: $Grid _home/log/ Orarootagent logs are located at: $Grid _home/log/ Oraagent logs are located at: $Grid _home/log/ Third tier (resources) CSSD logs are located at: $Grid _home/log/ CRSD logs are located at: $Grid _home/log/ CTSSD logs are located at

11g rac rebuilding the SPFILE of the ASM instance

11g rac rebuilding the SPFILE of the ASM instance 1. PrerequisitesYou need to know the following information:1) number of nodes2) the location of the disk included in the ASM disk group3) There are several disk groups for the instance.2. Steps and reconstruction scripts1) Successful scripts:*. Cluster_database_instances = 2+ ASM1.instance _ name = '+ ASM1'+ ASM1.instance _ name = '+ ASM2'+ ASM1.asm _ diskgr

Migrate OCR and VOTEDISK in 11g Rac

Migrate the OCR and VOTEDISK environments in 11g Rac: OEL + oracle rac 11.2.0.3 migration Description: migrate ocr and votedisk from + DATE to + OCR_VOTE. The operation is as follows: [root@ora2 ~]$ /u01/app/11.2.0/grid/bin/ocrcheckStatus of Oracle Cluster Registry is as fol

11g two node RAC add a third node

:21libcap.so.2-libcap.so.2.16[Email protected] lib64]# ln-s libcap.so.2.16libcap.so.1Re-execute canAdd Database software:On Node 1, execute the following command with the Oracle User:[Email protected] sshsetup]# su–oracle[Email protected] ~]$ CD $ORACLE _home/oui/bin./addnode.sh-silent "Cluster_new_nodes={rac3}"/u02/app/oracl

Total Pages: 15 1 .... 11 12 13 14 15 Go to: Go

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.