How do I manually add an instance to a RAC?

This post shows the steps to manually add a new instance to your RAC database.

1. Set instance-specific parameters to your SPFILE.
2. One of the parameters requires the LISTENERS_ORCL4 entry in the TNSNAMES.
3. I put my spfile and password file on shared storage.
4. Add online redo log groups.
5. Add standby redo log files.

How do I create a Dbca RAC database?

From the Oracle_home\bin directory, run dbca.exe to start the Database Configuration Assistant. On the Database Operation screen, select Create Database. On the Creation Mode screen, select Advanced Mode. On the Database Template screen, select Oracle Real Application Clusters (RAC) database for the Database Type.

How do I manually create a database?

Create a Database Manually

1. Step 1: Decide on Your Instance’s System Identifier (SID)
2. Step 2: Create the Initialization Parameter File.
3. Step 3: Connect to and Start the Instance.
4. Step 4: Issue the CREATE DATABASE Statement.
5. Step 5: Run Scripts to Build Data Dictionary Views.
6. Step 6: Run Scripts to Install Additional Options.

How many nodes are supported in a RAC database?

Oracle RAC 11g supports up to 100 nodes. For some applications, RAC may require careful application partitioning to enhance performance.

How to create data guard with 2 node RAC?

Oracle Binaries are installed. Step 1: Check standby database cluster services are running : Step 2: Prepare the Primary Database : Check force logging at primary database and enable it if not enabled. SQL> select force_logging from v$database; FOR — NO SQL> ALTER DATABASE FORCE LOGGING; Database altered.

How to create a database manually in RAC?

It is always recommended to create database in RAC using DBCA only (GUI) . But for some reason, if you want to create manually, then follow below steps: In this article , we will create a database in a 2 node rac. Database name will be DBATST with instance names DBATST1,DBATST2 1. Prepare a init file: (as below)

How to alter Oracle 12c-2 node RAC database?

$ sqlplus / as sysdba SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +DG01 Oldest online log sequence 299300 Next log sequence to archive 299305 Current log sequence 299305

How to stop one node in a two node Oracle RAC cluster?

When performing maintenance on our 2 node Oracle Rac Cluster we need to be able to stop 1 node and keep the other node up and running. Disable autostart of CRS in order to be able to perform server-maintenance and CRS is not restarted after a reboot of the server (as user root) CRS-4621: Oracle High Availability Services autostart is disabled.