Oracle RAC部署：基于ASM的双节点集群配置

Oracle RAC（Real Application Clusters）是Oracle数据库的一种高可用性解决方案，它允许多个数据库实例共享一个数据库。在Oracle RAC中，数据库实例可以分布在多个服务器上，从而提高系统的可用性和性能。本文将介绍如何在基于ASM（Automatic Storage Management）的双节点集群上部署Oracle RAC。

1. 准备工作

在开始部署之前，需要确保以下条件已经满足：

• 两个节点已经安装了Oracle软件，并且可以互相通信。
• 两个节点都配置了相同的网络设置，包括主机名、IP地址和子网掩码。
• 两个节点都安装了ASM，并且已经创建了ASM磁盘组。
• 两个节点都安装了Grid Infrastructure，并且已经创建了集群。
• 两个节点都安装了Oracle数据库，并且已经创建了数据库实例。

2. 创建数据库实例

在两个节点上创建数据库实例，确保它们具有相同的名称和版本。在创建数据库实例时，需要指定以下参数：

• 数据库名
• 数据库版本
• 数据库字符集
• 数据库国家区
• 数据库管理选项

例如，可以使用以下命令创建数据库实例：

CREATE DATABASE racdb  USER SYS IDENTIFIED BY syspassword  USER SYSTEM IDENTIFIED BY systempassword  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log') SIZE 100M,         GROUP 3 ('/u01/app/oracle/oradata/racdb/redo03.log') SIZE 100M  MAXLOGFILES 5  MAXLOGMEMBERS 5  MAXLOGHISTORY 1  MAXDATAFILES 100  CHARACTER SET AL32UTF8  NATIONAL CHARACTER SET AL16UTF16  EXTENT MANAGEMENT LOCAL  DATAFILE '/u01/app/oracle/oradata/racdb/system01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  SYSAUX DATAFILE '/u01/app/oracle/oradata/racdb/sysaux01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/racdb/redo01.log') SIZE 100M,         GROUP 2 ('/u01/app/oracle/oradata/racdb/redo02.log')