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 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
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
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 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
\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
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
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
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
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
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
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
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
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
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
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
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
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 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
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.