Solaris10(x86)构建Oracle10gRAC之--建立数据库
Solaris 10(x86)构建Oracle 10g RAC之--建立数据库 系统环境： 操作系统：Solaris 10（x86-64） Cluster： Oracle CRS 10.2.0.1.0 Oracle： Oracle 10.2.0.1.0 如图所示：RAC 系统架构 650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/
Solaris 10(x86)构建Oracle 10g RAC之--建立数据库
系统环境：
操作系统：Solaris 10（x86-64）
Cluster： Oracle CRS 10.2.0.1.0
Oracle： Oracle 10.2.0.1.0
如图所示：RAC 系统架构
四、通过netca建立监听器
对于listener可以通过netca在建库之前建立，也可以在用dbca建库时来建立。
Listener建立成功，验证：
[root@node1:/]# crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....E1.lsnr application ONLINE ONLINE node1 ora.node1.gsd application ONLINE ONLINE node1 ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip application ONLINE ONLINE node1 ora....E2.lsnr application ONLINE ONLINE node2 ora.node2.gsd application ONLINE ONLINE node2 ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip application ONLINE ONLINE node2 [root@node1:/]# su - oracle Oracle Corporation SunOS 5.10 Generic Patch January 2005 [oracle@node1:/export/home/oracle]$ lsnrctl status LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 21-JAN-2015 15:51:45 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER_NODE1 Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production Start Date 21-JAN-2015 15:50:43 Uptime 0 days 0 hr. 1 min. 2 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /export/home/ora10/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /export/home/ora10/product/10.2.0/db_1/network/log/listener_node1.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.13)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.11)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
五、通过DBCA建立数据库
650) this.width=650;" style="max-width:90%" title="d1.png" alt="wKioL1TAmEewikJBAAMMuS4G2SA257.jpg" />
建立集群库
650) this.width=650;" style="max-width:90%" title="d2.png" alt="wKioL1TAmEnSnie_AAHnRU_RlQM456.jpg" />
650) this.width=650;" style="max-width:90%" title="d3.png" alt="wKiom1TAl3OjMxTyAAKyoesYAcM960.jpg" />
650) this.width=650;" style="max-width:90%" title="d4.png" alt="wKioL1TAmEuhQWgSAAM-ZXZvCcU142.jpg" />
数据库存储ASM设备
650) this.width=650;" style="max-width:90%" title="d5.png" alt="wKiom1TAl3bDPaEdAANlFEJKxDc609.jpg" />
建立ASM Instance的pfile
650) this.width=650;" style="max-width:90%" title="d6.png" alt="wKioL1TAmE3waBgIAAJWPTAdi1Q655.jpg" />
建立ASM DISKGROUP
650) this.width=650;" style="max-width:90%" title="d7.png" alt="wKioL1TAmE2wAqafAALmC3k8qqM358.jpg" />
通过RAW建立ASM diskgroup
650) this.width=650;" style="max-width:90%" title="d8.png" alt="wKiom1TAl3jAhkF8AAKwqddg3lc157.jpg" />
650) this.width=650;" style="max-width:90%" title="d9.png" alt="wKiom1TAl3jTRkltAAKWNeaILM4231.jpg" />
650) this.width=650;" style="max-width:90%" title="d10.png" alt="wKioL1TAmFCi7sKTAALd6GH0Et0509.jpg" />
650) this.width=650;" style="max-width:90%" title="d11.png" alt="wKiom1TAl3vxsJe0AAKYrJDxKG4772.jpg" />
650) this.width=650;" style="max-width:90%" title="d12.png" alt="wKioL1TAmFPiFDT8AAKmLOppX9I679.jpg" />
650) this.width=650;" style="max-width:90%" title="d13.png" alt="wKiom1TAl32RthFPAAL4Zts5ZF4375.jpg" />
650) this.width=650;" style="max-width:90%" title="d14.png" alt="wKioL1TAmFWCcxxZAAMw_tE4vz0963.jpg" />
验证：
[root@node1:/]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
ora.prod.db application ONLINE ONLINE node2
ora....d1.inst application ONLINE ONLINE node1
ora....d2.inst application ONLINE ONLINE node2
查询ASM diskgroup：
SQL> col name for a20
SQL> select GROUP_NUMBER,name,STATE,TOTAL_MB,FREE_MB,TYPE from v$asm_diskgroup
GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB TYPE
------------ -------------------- ----------- ---------- ---------- ------
1 DG1 MOUNTED 10244 5962 NORMAL
2 RCY1 MOUNTED 8204 7268 NORMAL
查询RDBMS Instance：
[oracle@node1:/export/home/oracle]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 21 17:13:50 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select instance_name,status from gv$instance;
INSTANCE_NAME STATUS
---------------- ------------
prod1 OPEN
prod2 OPEN
SQL> alter user scott identified by tiger account unlock;
User altered.
SQL> conn scott/tiger
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
EMP TABLE
BONUS TABLE
SALGRADE TABLE@至此，整个Oracle 10g的RAC已经架构完成 ！
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1390
52
Building a Custom WordPress User Flow, Part Three: Password Reset
Sep 03, 2023 pm 11:05 PM
In the first two tutorials in this series, we built custom pages for logging in and registering new users. Now, there's only one part of the login flow left to explore and replace: What happens if a user forgets their password and wants to reset their WordPress password? In this tutorial, we'll tackle the last step and complete the personalized login plugin we've built throughout the series. The password reset feature in WordPress more or less follows the standard method on websites today: the user initiates a reset by entering their username or email address and requesting WordPress to reset their password. Create a temporary password reset token and store it in user data. A link containing this token will be sent to the user's email address. User clicks on the link. In the heavy
Configuration guide for building Linux kernel using CMake
Jul 06, 2023 pm 02:46 PM
Overview of the configuration guide for building the Linux kernel using CMake In Linux development, building and configuring the kernel is an important step. For most people, using Kconfig and Makefile is the most common configuration method. However, using CMake to build and configure the Linux kernel is also a flexible and powerful option. This article will introduce how to use CMake to build and configure the Linux kernel, with some code examples. Install CMake First, we need to install CMak
ChatGPT Java: How to build an intelligent music recommendation system
Oct 27, 2023 pm 01:55 PM
ChatGPTJava: How to build an intelligent music recommendation system, specific code examples are needed. Introduction: With the rapid development of the Internet, music has become an indispensable part of people's daily lives. As music platforms continue to emerge, users often face a common problem: how to find music that suits their tastes? In order to solve this problem, the intelligent music recommendation system came into being. This article will introduce how to use ChatGPTJava to build an intelligent music recommendation system and provide specific code examples. No.
Smooth build: How to correctly configure the Maven image address
Feb 20, 2024 pm 08:48 PM
Smooth build: How to correctly configure the Maven image address When using Maven to build a project, it is very important to configure the correct image address. Properly configuring the mirror address can speed up project construction and avoid problems such as network delays. This article will introduce how to correctly configure the Maven mirror address and give specific code examples. Why do you need to configure the Maven image address? Maven is a project management tool that can automatically build projects, manage dependencies, generate reports, etc. When building a project in Maven, usually
Optimize the Maven project packaging process and improve development efficiency
Feb 24, 2024 pm 02:15 PM
Maven project packaging step guide: Optimize the build process and improve development efficiency. As software development projects become more and more complex, the efficiency and speed of project construction have become important links in the development process that cannot be ignored. As a popular project management tool, Maven plays a key role in project construction. This guide will explore how to improve development efficiency by optimizing the packaging steps of Maven projects and provide specific code examples. 1. Confirm the project structure. Before starting to optimize the Maven project packaging step, you first need to confirm
How to build an intelligent voice assistant using Python
Sep 09, 2023 pm 04:04 PM
How to use Python to build an intelligent voice assistant Introduction: In the era of rapid development of modern technology, people's demand for intelligent assistants is getting higher and higher. As one of the forms, smart voice assistants have been widely used in various devices such as mobile phones, computers, and smart speakers. This article will introduce how to use the Python programming language to build a simple intelligent voice assistant to help you implement your own personalized intelligent assistant from scratch. Preparation Before starting to build a voice assistant, we first need to prepare some necessary tools
Build an online calculator using JavaScript
Aug 09, 2023 pm 03:46 PM
Building online calculators with JavaScript As the Internet develops, more and more tools and applications begin to appear online. Among them, calculator is one of the most widely used tools. This article explains how to build a simple online calculator using JavaScript and provides code examples. Before we get started, we need to know some basic HTML and CSS knowledge. The calculator interface can be built using HTML table elements and then styled using CSS. Here is a basic
Build browser-based applications with Golang
Apr 08, 2024 am 09:24 AM
Build browser-based applications with Golang Golang combines with JavaScript to build dynamic front-end experiences. Install Golang: Visit https://golang.org/doc/install. Set up a Golang project: Create a file called main.go. Using GorillaWebToolkit: Add GorillaWebToolkit code to handle HTTP requests. Create HTML template: Create index.html in the templates subdirectory, which is the main template.
