Build an Oracle10G (6) dbca database for RAC under AIX, and oracle10gdbca

Build an Oracle10G (6) dbca database for RAC under AIX, and oracle10gdbca

Establish a series of RAC instances under AIX

Build an Oracle10G (6) dbca database with RAC under AIX

Environment

Node	Node 1	Node 2
Small Machine Model	IBM p-series 630	IBM p-series 630
Host Name	AIX203	AIX204
Vswitch	SAN optical fiber switch
Storage	SAN T3 Storage

 

The outline process is as follows:

Part 1: Host Configuration

I. Detection System Environment

Ii. Network Configuration

3. users and groups

Iv. Network Parameter Adjustment

V. Time Synchronization

Vi. Volume Group

Part 2: install and configure hacmp

VII. install and configure hacmp

Part 3: Install CRS

8. Install CRS

Part 4: Installing oracle software

9. Install oracle

Part 5: Configure monitoring and create an oracle database

10. Set up a listener

11. dbca database creation

12. Verification

**************************************** Next part ************************************** *******

Last article address

**************************************** **************************************** ****************
Start text:

11. Create a library 1. Create a symbolic link file for bare Devices

Create a symbolic link file for the bare device (create a directory on all nodes)

[Oracle @ aix211 ~]Su-oracle

[18:03:41 oracle @ aix203 ~] $Mkdir-p/u01/app/oracle/oradata/prod/

[18:01:34 oracle @ aix204 ~] $Mkdir-p/u01/app/oracle/oradata/prod/

// Create a link (both nodes are created)

Node 1 establish a link

[18:08:17 oracle @ aix203 ~] $Cat mkln. sh

Add:

Ln-s/dev/rsystem/u01/app/oracle/oradata/prod/system01.dbf

Ln-s/dev/rsysaux/u01/app/oracle/oradata/prod/sysaux01.dbf

Ln-s/dev/rusers/u01/app/oracle/oradata/prod/users01.dbf

Ln-s/dev/rundotbs1/u01/app/oracle/oradata/prod/undotbs01.dbf

Ln-s/dev/rundotbs2/u01/app/oracle/oradata/prod/undotbs02.dbf

Ln-s/dev/rtemp/u01/app/oracle/oradata/prod/temp01.dbf

Ln-s/dev/rcontrol1_1/u01/app/oracle/oradata/prod/control01.ctl

Ln-s/dev/rcontrol2_2/u01/app/oracle/oradata/prod/control02.ctl

Ln-s/dev/rcontrol3_3/u01/app/oracle/oradata/prod/control03.ctl

Ln-s/dev/rredo1_1/u01/app/oracle/oradata/prod/log11.log

Ln-s/dev/rredo1_2/u01/app/oracle/oradata/prod/log12.log

Ln-s/dev/rredo2_1/u01/app/oracle/oradata/prod/log21.log

Ln-s/dev/rredo2_2/u01/app/oracle/oradata/prod/log22.log

Ln-s/dev/rindex/u01/app/oracle/oradata/prod/index01.dbf

Ln-s/dev/rspfile/u01/app/oracle/oradata/prod/spfileprod. ora

Ln-s/dev/rexample/u01/app/oracle/oradata/prod/example01.dbf

[18:08:24 oracle @ aix203 ~] $Sh mkln. sh// Execute the script

[18:09:26 oracle @ aix203 ~] $Ls-l/u01/app/oracle/oradata/prod/

Create a link on node 2

[18:09:43 oracle @ aix203 ~] $Rcp mkln. sh aix204 :~ /

[18:11:00 oracle @ aix204 ~] $Cat mkln. sh

Ln-s/dev/rsystem/u01/app/oracle/oradata/prod/system01.dbf

Ln-s/dev/rsysaux/u01/app/oracle/oradata/prod/sysaux01.dbf

Ln-s/dev/rusers/u01/app/oracle/oradata/prod/users01.dbf

Ln-s/dev/rundotbs1/u01/app/oracle/oradata/prod/undotbs01.dbf

Ln-s/dev/rundotbs2/u01/app/oracle/oradata/prod/undotbs02.dbf

Ln-s/dev/rtemp/u01/app/oracle/oradata/prod/temp01.dbf

Ln-s/dev/rcontrol1_1/u01/app/oracle/oradata/prod/control01.ctl

Ln-s/dev/rcontrol2_2/u01/app/oracle/oradata/prod/control02.ctl

Ln-s/dev/rcontrol3_3/u01/app/oracle/oradata/prod/control03.ctl

Ln-s/dev/rredo1_1/u01/app/oracle/oradata/prod/log11.log

Ln-s/dev/rredo1_2/u01/app/oracle/oradata/prod/log12.log

Ln-s/dev/rredo2_1/u01/app/oracle/oradata/prod/log21.log

Ln-s/dev/rredo2_2/u01/app/oracle/oradata/prod/log22.log

Ln-s/dev/rindex/u01/app/oracle/oradata/prod/index01.dbf

Ln-s/dev/rspfile/u01/app/oracle/oradata/prod/spfileprod. ora

Ln-s/dev/rexample/u01/app/oracle/oradata/prod/example01.dbf

[18:11:23 oracle @ aix204 ~] $Sh mkln. sh// Execute the script

[18:11:37 oracle @ aix204 ~] $Ls-l/u01/app/oracle/oradata/prod/

[Supplement]: Force re-build the dbf File

$Ln-sf/dev/rexample/u01/app/oracle/oradata/prod/example01.dbf

// Add f to force Reconstruction

2. Create a ing file for the bare Device

Create a ing file on node 1 and then execute it when dbca creates a database.

[Oracle @ aix203 ~]Su-oracle

[18:14:08 oracle @ aix203 ~] $Cat raw_map.txt

System =/dev/rsystem

Sysaux =/dev/rsysaux

Users =/dev/rusers

Undotbs1 =/dev/rundotbs1

Undotbs2 =/dev/rundotbs2

Temp =/dev/rtemp

Control1 =/dev/rcontrol1_1

Control2 =/dev/rcontrol2_2

Control3 =/dev/rcontrol3_3

Redo1_1 =/dev/rredo1_1

Redo1_2 =/dev/rredo1_2

Redo2_1 =/dev/rredo2_1

Redo2_2 =/dev/rredo2_2

Index =/dev/rindex

Spfile =/dev/rspfile

Example =/dev/rexample

 

3. graphical dbca database creation

Run the dbca command in X-manager:

$Export DISPLAY = 192.168.8.73: 0// Control the Host IP Address

$Source/etc/profile

$Dbca

// When creating a database in dbca, select the raw device and use the raw map file, that is, select the ing file created on node 1.

The following locations are automatically read by the ing file (controlling the file location, data file location, and log file location) without modification:

Preview 【Database Information:

If an error is reported, You can manually Start Node 1.

12. Verification

[08:34:29 root @ aix203/] #Crs_stat-t// View the process status on node 1

[08:34:53 root @ aix204/] #Crs_stat-t// View the process status on node 2

[08:35:49 root @ aix203/] #Crsctl check crs// Node 1 checks the service status

[08:34:57 root @ aix204/] #Crsctl check crs// Node 2 Detection Service Status

[08:34:36 root @ aix203/] #Su-oracle

[T u @ h W] $Bash

[08:35:12 oracle @ aix203 ~] $Source/etc/profile

[08:35:20 oracle @ aix203 ~] $Sqlplus '/as sysdba'// Log on to sqlplus at Node 1

[08:36:20 root @ aix204/] #Su-oracle

[You have new mail]

[08:36:27 oracle @ aix204 ~] $Sqlplus '/as sysdba'// Log on to sqlplus at Node 2

SQL>Select * from scott. dept;// View table information in node 1

SQL>Select * from scott. dept;// View table information on node 2

SQL>Selectstatus, instance_name from gv $ instance;// View the cluster instance status on node 1

SQL>Select status, instance_name from gv $ instance;// View the cluster instance status on node 2

**************************************** *******Statement************************************************ 

Original works, from "Deep Blue blog" blog, welcome to reprint, reprint please be sure to indicate the source (http://blog.csdn.net/huangyanlong ).

Please leave a message if the statement is incorrect. Thank you very much.

Reminder: Click the directory to view the directory.

*****************************************************************************************************

An error occurred while creating the database in the last step of oracle 10g aix rac and dbca. You cannot recreate a database with the same name.

We recommend that you reinstall the database... COPY the previous logs first.

How to Create a database named oracle10g

There are two methods to create a database in Oracle. The first is to use Oracle database builder and DBCA, which is a graphical interface and easy to understand because of its friendly and beautiful interface and complete prompts. In Windows, this tool can be opened in the Oracle program group ("START"-"program"-"Oracle-OraDb10g_home1"-"Configuration and Migration Tools"-"Database Configuration Assistant "), you can also directly enter dbca in the command line ("START"-"run"-"cmd") tool. Another method is to create a database manually. This is what we will talk about below.
Manual database creation is more troublesome than DBCA database creation. However, if we have learned how to manually create a database, we can better understand the architecture of the Oracle database. Manual database creation requires several steps, each of which is critical. It includes:
1. create necessary Directories
2. Create an initialization parameter file
3. Set the environment variable Oracle_sid.
4. Create an instance
5. Create a password file
6. Start the database to the nomount (Instance) Status
7. Execute the database creation script
8. Execute catalog to create a data dictionary.
9. Run catproc to create a package.
10. Run pupbld.
11. Create a spfile file from the initialization parameter file
12. Execute the scott script to create the scott mode.
After completing the above steps, you can use "SQL> alter database open;" to open the normal use of the database. Next, I will use the above steps as an experiment.
Experimental System Platform: Windows Server 2000 Database System Version: Oracle Database 10 GB
Oracle installation path: name of the database created by drive D: book
1. Open the command line tool and create related directories.
C: \> mkdir D: \ oracle \ product \ 10.1.0 \ admin \ book
C: \> mkdir D: \ oracle \ product \ 10.1.0 \ admin \ book \ bdump
C: \> mkdir D: \ oracle \ product \ 10.1.0 \ admin \ book \ udump
C: \> mkdir D: \ oracle \ product \ 10.1.0 \ admin \ book \ cdump
C: \> mkdir D: \ oracle \ product \ 10.1.0 \ admin \ book \ pfile
C: \> mkdir D: \ oracle \ product \ 10.1.0 \ admin \ book \ create
C: \> mkdir D: \ oracle \ product \ 10.1.0 \ oradata \ book
You can also create a directory on the GUI of Windows. The subdirectories in the D: \ oracle \ product \ 10.1.0 \ admin \ book directory are mainly used to store tracking information during database operation. The two most important sub-directories are the bdump and udump directories. The bdump directory stores the database ...... the remaining full text>