Article presents quick installation of Oracle Enterprise RAC 12.1.0.1 on Windows 2008 using Oracle Virtual Box.
Architecture
Software used:
- Oracle Virtual Box – 64 bit
- Windows 2012 – 64 bit
- Oracle Database 12C Release 1(12.1.0.1) – 64 bit for Windows
Binaries 12.1.0.1
winx64_12c_database_1of2.zip - database software winx64_12c_database_2of2.zip - database software winx64_12c_grid_1of2.zip - grid software winx64_12c_grid_2of2.zip - grid software
Two virtual machines are created:
- rac1
- rac2
| public | private | vip | |
| rac1 | 192.168.0.50 | 192.168.1.60 | 192.168.0.70 |
| rac2 | 192.168.0.51 | 192.168.1.61 | 192.168.0.71 |
with single client access name (SCAN) address
| public | |
| rac-scan | 192.168.0.20 192.168.0.21 192.168.0.22 |
Each virtual machines consist of:
- 64G local disk (dynamic space allocation)
- 4G ram memory
- 3 network cards (2 dedicated just for RAC + 1 for Internet connection)
NOTE to save space rac2 is linked clone of rac1
Shared storage visible on each node:
- 20G shared virtual disk (fixed size)
Virtual Machine configuration
1. Start virtual box manager and click “New” button.
2. Click “Hide Description” to see more options. Enter virtual machine name “w2008_121_rac1”, select type “Microsoft Windows”, version “Windows 2008(64bit)”, set memory to 4096M. Click “Create” button to allocate storage for this machine.
3. Enter storage attributes: name, size 64G, type VDI, dynamically allocated then click “Create” button.
4. Virtual machine is ready click “Settings” to change some details.
5. Select “System” option, tab “Processor” in case you want to assign more processor to your virtual machine. I have 4 core machines so I assigned to rac1 2 CPU.
6. Select “Option” option, “Video” tab and assign 256MB of memory and enable 3D acceleration to improve graphics in your virtual machine.
7. Select “Network” option and select “Internal Network” for Adapter 1 and 2 and “NAT” for Adapter 3. Adapter 1 will be used as public RAC interface, Adapter 2 as private and Adapter 3 to connect to internet(it’s optional but I use it to have access to internet from my virtual machine).
8. On “Storage” tab assign iso file to “CD/DVD Drive” to install Windows 2008 64 bit. Once it’s done click “OK” button.
9. Virtual box is ready to install Windows 2008 so click “Start” button.
Install and configuration of Windows 2008
Install Windows 2008 Standard Full edition.
When installation is completed apply latest updates for Windows 2008. To speed up this process I suggest to download service pack 2 for Windows 2008.
OS changes
1. Modify hosts file
Do modifications in file “C:\windows\system32\drivers\etc\hosts”.
127.0.0.1 localhost ::1 localhost #public 192.168.0.50 rac1 192.168.0.51 rac2 #private 192.168.1.60 rac1-priv 192.168.1.61 rac2-priv #virtual 192.168.0.70 rac1-vip 192.168.0.71 rac2-vip #scan 192.168.0.20 rac-scan 192.168.0.21 rac-scan 192.168.0.22 rac-scan
3. Change network settings
Click “Start” -> “Control Panel” -> “Network and Sharing Center” -> “Manage network connections”.
Rename network interfaces to following names
Unidentified network (public)
- “Local Area Connection” to “public”
- “Local Area Connection 2” to “private”
Network (public)
- “Local Area Connection 3” to “internet”
Just right click on each network card you should see menu and option “rename”. Once it’s done you should see following
In the same window click “Advanced” -> “Advanced Settings …” to change order binding. In “Connections:” area change connections order to following – use green arrows on right side
- public
- private
- internet
Configure IP address on each network card
NOTE – IPv6 is not supported for Oracle Grid Infrastructure or Oracle RAC on Windows in the first release of Oracle RAC 12C so disable it on each network card.
We start in the same window “Network Connections”
public
- IP Address: 192.168.0.50
- Subnet: 255.255.255.0
Right click on “public” network to display menu and select “Properties”. Uncheck checkbox “Internet Protocol Version 6(TCP/IPv6)” then select “Internet Protocol Version 4(TCP/IPv4)” and click “Properties” button.
apply ip address for “public” interface and click “Advanced” button
on DNS tab uncheck checkbox “Register this connection’s addresses in DNS” then click “OK” buttons in each window to apply all the changes.
private:
- IP Address: 192.168.1.60
- Subnet: 255.255.255.0
Repeat the same steps for “private”. The only difference is ip address.
Verify network connections with ipconfig and ping
ipconfig command should show NIC in proper order:
- public
- private
- internet
C:\Users\Administrator>ipconfig Windows IP Configuration Ethernet adapter public: Connection-specific DNS Suffix . : IPv4 Address. . . . . . . . . . . : 192.168.0.50 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : Ethernet adapter private: Connection-specific DNS Suffix . : IPv4 Address. . . . . . . . . . . : 192.168.1.60 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : Ethernet adapter internet: Connection-specific DNS Suffix . : Link-local IPv6 Address . . . . . : fe80::94b:3a59:fdd8:2089%12 IPv4 Address. . . . . . . . . . . : 10.0.4.15 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 10.0.4.2 Tunnel adapter Local Area Connection* 8: Media State . . . . . . . . . . . : Media disconnected Connection-specific DNS Suffix . : Tunnel adapter Local Area Connection* 12: Media State . . . . . . . . . . . : Media disconnected Connection-specific DNS Suffix . : Tunnel adapter Local Area Connection* 13: Media State . . . . . . . . . . . : Media disconnected Connection-specific DNS Suffix . :
check with ping command response from NIC
C:\Users\Administrator>ping rac1 -n 1 Pinging rac1 [192.168.0.50] with 32 bytes of data: Reply from 192.168.0.50: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.0.50: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms C:\Users\Administrator>ping rac1-priv -n 1 Pinging rac1-priv [192.168.1.60] with 32 bytes of data: Reply from 192.168.1.60: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.1.60: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms
4. Disable Windows Media Sensing for TCP/IP:
- Backup the Windows registry.
- Use Registry Editor to view the following key in the registry:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters
- Add a new key type DWORD:
Value Name: DisableDHCPMediaSense Value: 1
- Exit the Registry Editor. It requires reboot of machine but don’t do it right now.
5. Change host name
Open the “System Properties” dialog (Start-> Control Panel -> System -> Change Settings)
click “Change” button
Enter computer name: rac1 and click “OK” button. It will ask to reboot machine.
After reboot verify new – hostname
C:\Users\Administrator>hostname rac1
and media sense is disabled – netsh interface ipv4 show global
C:\Users\Administrator>netsh interface ipv4 show global Querying active state... General Global Parameters --------------------------------------------- Default Hop Limit : 128 hops Neighbor Cache Limit : 256 entries per interface Route Cache Limit : 128 entries per compartment Reassembly Limit : 33543424 bytes ICMP Redirects : enabled Source Routing Behavior : dontforward Task Offload : enabled Dhcp Media Sense : disabled Media Sense Logging : enabled MLD Level : all MLD Version : version3 Multicast Forwarding : disabled Group Forwarded Fragments : disabled Randomize Identifiers : enabled Address Mask Reply : disabled Current Global Statistics --------------------------------------------- Number of Compartments : 1 Number of NL clients : 7 Number of FL providers : 4
Shared storage
1. To add shared storage virtual machine rac1 must be down. Once it’s down go to “Settings” select “Storage” then click on icon with plus on disk.
2. Click on “Create new disk” button.
3. Default option “VDI” is fine click “Next” button.
4. Select “Fixed size” then click “Next” button.
5. Enter storage name “Shared” and set size to 20G then click “Create” button.
6. Once created you should see new disk attached to our virtual machine. Click “OK” button.
7. From main menu you need to select File->Virtual Media Manager to change “Shared” disk attribute. Select “Shared.vdi” and click “Modify” button.
8. Select “Sharable” and click “OK” button. It will prepare this storage to be shareable between RAC instances. Please start virtual machine to create partitions on shared storage.
Host configuration
It’s time to add shared device to rac1 node using diskpart.exe tool.
1. List available disks on computer. There are two disks. “Disk 1” is dedicated for ASM partitions.
C:\Users\Administrator>diskpart Microsoft DiskPart version 6.0.6002 Copyright (C) 1999-2007 Microsoft Corporation. On computer: RAC1 DISKPART> list disk Disk ### Status Size Free Dyn Gpt -------- ---------- ------- ------- --- --- Disk 0 Online 64 GB 32 GB Disk 1 Online 20 GB 20 GB
2. Enable automount option. It is required for ASM installation.
DISKPART> automount enable Automatic mounting of new volumes enabled.
3. Select “Disk 1” and create extended and logical 2 partitions each 10G size
DISKPART> select disk 1 Disk 1 is now the selected disk. DISKPART> create partition extended DiskPart succeeded in creating the specified partition. DISKPART> create partition logical size=10240 DiskPart succeeded in creating the specified partition. DISKPART> create partition logical DiskPart succeeded in creating the specified partition.
4. Verify partitions
DISKPART> list partition Partition ### Type Size Offset ------------- ---------------- ------- ------- Partition 0 Extended 20 GB 1024 KB Partition 1 Logical 10 GB 2048 KB * Partition 2 Logical 10 GB 10 GB
5. Set “Elevate without prompting” for security
Run
C:\Users\Administrator>secpol.msc
to start “Local Security Policy”. Then select “Security Settings”->”Local Policies”->”Security Options” and change policy “User Account Control: Behavior of the evaluation prompt for administrators in Admin Approval Mode” to value “Elevate without prompting”.
6. Set Manage auditing and security log
Run
C:\Users\Administrator>secpol.msc
to start “Local Security Policy”. Then select “Security Settings”->”Local Policies”->”User Rights Assignment” and verify policy “Manage auditing and security log” to ensure “Administrators” group is assigned..
7. Turn off firewall
During installation of grid and database software firewall must be disabled. Just run following commands on each node.
C:\Users\Administrator>netsh firewall set opmode disable Ok. C:\Users\Administrator>netsh advfirewall set allprofiles state off Ok.
8. Disable SNP features
C:\Users\Administrator>netsh int tcp set global chimney=disabled Ok. C:\Users\Administrator>netsh tcp set global rss=disabled The following command was not found: tcp set global rss=disabled. C:\Users\Administrator>netsh interface tcp show global Querying active state... TCP Global Parameters ---------------------------------------------- Receive-Side Scaling State : enabled Chimney Offload State : disabled Receive Window Auto-Tuning Level : normal Add-On Congestion Control Provider : ctcp ECN Capability : disabled RFC 1323 Timestamps : disabled
9. Change environment variables
create directory c:\temp
C:\Users\Administrator>mkdir c:\temp
Click “Start”->”Control Panel”->”System”. Then click “Advanced system settings” to see System properties.
click “Environment variables” and modify “User variables for Administrator” TEMP and TMP
once it’s done verify it
C:\Users\Administrator>set temp TEMP=c:\temp C:\Users\Administrator>set tmp TMP=c:\temp
10. Unpack grid software
unzip winx64_12c_grid_1of2.zip unzip winx64_12c_grid_2of2.zip
11. Verify host is ready to install oracle grid software
runcluvfy.bat stage -pre crsinst -n rac1 -verbose
Problems I have noticed were memory and domain. Both can be ignored. From 4GB 256MB was consumed by graphic and my Window Server is not registered in domain.
Check: Total memory Node Name Available Required Status ---------- ---------------------- ------------------ ---------- rac1 3.9987GB (4192928.0KB) 4GB (4194304.0KB) failed Result: Total memory check failed Checking if current user is a domain user... Check: If user "Administrator" is a domain user ERROR: PRVF-10000 : Unable to check if user "RAC1\Administrator" is a domain user: "PRCZ-1091 : Failed to verify that user name "RAC1\Administrator" is a valid Windows user"
Shutdown rac1 machine to clone it.
Cloning machine
New machine rac2 is cloned from machine rac1 using “linked clone” method. It allows to speed up process of cloning. It’s especially useful for development environments.
- Full clone: In this mode all depending disk images are copied to the new VM folder. The clone can fully operate without the source VM.
- Linked clone: In this mode new differencing disk images are created where the parent disk images are the source disk images. If you selected the current state of the source VM as clone point, a new snapshot will be created implicitly.
1. Before we create “linked clone” we need to remove shared storage. On Storage tab select Shared.vdi then click “Remove Attachment”.
2. Now you should see w2008_121_rac1 without Shared storage.
3. In menu of VirtualBox select “Machine”-“Clone” option. Enter name for new machine w2008_121_rac2. Check checkbox “Reinitialize the MAC address of all network cards” and click “Next” button.
4. Select “Linked clone” option and click “Clone” button.
5. You should see new machine w2008_121_rac2
6. It’s time to attach Shared.vdi disk to both machine. Select first machine w2008_rac121_rac1 then click “Storage”. Select “Controller:SATA” and click last button “Add Hard Disk”.
7. Click “Choose existing disk”. You should see standard window to select a file. Select “Shared.vdi” to attach it to machine.
8. Once it’s done shared disk should be visible by machine w2008_121_rac1. Click “OK” button to save your configuration.
9. You need to repeat the same steps 6,7 to attach shared disk to machine w2008_121_rac2. Don’t be surprised that both machines are using the same disk “w2008_121_rac1.vdi”. New machine w2008_121_rac2 is linked clone.
Network settings for second machine
Start second linked machine w2008_121_rac2 and set new static ip address for eth0 and eth1.
- 192.168.0.51/255.255.255.0 for eth0 (public)
- 192.168.1.61/255.255.255.0 for eth1 (private)
and change host name to
- rac2
1. Click “Start”->”Network and Sharing Center”. Then click “Manage network connections”.
Right click on “public” and “private” network to display menu and select “Properties”. Then select “Internet Protocol Version 4(TCP/IPv4)” and click “Properties” button and change ip address for each network card.
2. Change hostname to rac2. Click “Start”->”Control Panel”->”System”->”Change settings”.
Click “Change” button
Enter computer name rac2 and click “OK” button. Once it’s done you will be asked to restart computer.
Reboot machine rac2 and start rac1 machine.
Verify network between nodes
It’s good time to run verify network on each node: rac1 and rac2
hostname ping rac1 -n 1 ping rac2 -n 1 ping rac1-priv -n 1 ping rac2-priv -n 1
test on rac1
C:\Users\Administrator>hostname rac1 C:\Users\Administrator>ping rac1 -n 1 Pinging rac1 [192.168.0.50] with 32 bytes of data: Reply from 192.168.0.50: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.0.50: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms C:\Users\Administrator>ping rac2 -n 1 Pinging rac2 [192.168.0.51] with 32 bytes of data: Reply from 192.168.0.51: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.0.51: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms C:\Users\Administrator>ping rac1-priv -n 1 Pinging rac1-priv [192.168.1.60] with 32 bytes of data: Reply from 192.168.1.60: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.1.60: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms C:\Users\Administrator>ping rac2-priv -n 1 Pinging rac2-priv [192.168.1.61] with 32 bytes of data: Reply from 192.168.1.61: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.1.61: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms
test on rac2
C:\Users\Administrator>hostname rac2 C:\Users\Administrator>ping rac1 -n 1 Pinging rac1 [192.168.0.50] with 32 bytes of data: Reply from 192.168.0.50: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.0.50: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms C:\Users\Administrator>ping rac2 -n 1 Pinging rac2 [192.168.0.51] with 32 bytes of data: Reply from 192.168.0.51: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.0.51: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms C:\Users\Administrator>ping rac1-priv -n 1 Pinging rac1-priv [192.168.1.60] with 32 bytes of data: Reply from 192.168.1.60: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.1.60: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms C:\Users\Administrator>ping rac2-priv -n 1 Pinging rac2-priv [192.168.1.61] with 32 bytes of data: Reply from 192.168.1.61: bytes=32 time<1ms TTL=128 Ping statistics for 192.168.1.61: Packets: Sent = 1, Received = 1, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms
Verify hosts rac1,rac2 before upgrade. Problems with memory and domain can be ignored.
runcluvfy.bat stage -pre crsinst -n rac1,rac2 -verbose c:\install\grid>runcluvfy.bat stage -pre crsinst -n rac1,rac2 -verbose Check: Total memory Node Name Available Required Status ---------- ---------------------- ------------------ ---------- rac2 3.9987GB (4192928.0KB) 4GB (4194304.0KB) failed rac1 3.9987GB (4192928.0KB) 4GB (4194304.0KB) failed Result: Total memory check failed Checking if current user is a domain user... Check: If user "Administrator" is a domain user ERROR: PRVF-10000 : Unable to check if user "RAC1\Administrator" is a domain user: "PRCZ-1091 : Failed to verify that user name "RAC1\Administrator" is a valid Windows user" Pre-check for cluster services setup was unsuccessful on all the nodes.
Grid software installation
Unzip grid software then run setup.exe to start grid software installation.
unzip winx64_12c_grid_1of2.zip unzip winx64_12c_grid_2of2.zip
1. Select “Skip software updates” and click “Next” button.
2. Select “Install and Configure Oracle Grid Infrastructure for a Cluster” and click “Next” button.
3. Accept default “Typical installation” and click “Next” button
4. Enter SCAN Name “rac-scan” then click “Add” button to add second node rac2
5. Enter public and virtual host name for second node and click “OK” button
6.Click on “Identify network interfaces” button
7. Ensure 192.168.0.0 subnet is public and 192.168.1.0 subnet is private and click “OK” button. You should be back on main screen so click “Next” button.
8. Validations are started for memory, network interfaces etc.
9. On the screen you can enter or accept default ORACLE_BASE and software location for grid software. You need to enter password for SYSASM. Once it’s done click “Next” button.
10. Click “Stamp disk” to add devices for ASM grid software.
11. Graphical interface for asmtool is started to stamp disks for ASM grid software. Click “Next” button.
12. You should see two devices which are candidate for ASM disks. Both devices where created using diskpart.exe as logical partitions. Accept default prefix “DATA” and click “Next” button.
13. Just click “Next” button then “Finish” button to return to main screen.
14. Now stamped devices should be visible. Change redundancy to “External” and select first devices “\\ORCLDISKDATA0” which will be assigned to diskgroup DATA. Then click “Next” button.
15. Additional check are conducted
16. You should see 2 problems. Check checkbox “Ignore All” and click “Next” button.
- Physical Memory – grid requires 4GB so i allocated 4GB. However part of it (256MB) is consumed by VirtualBox graphical card. You can ignore this problem.
- Administrator is not domain user – my installation is without domain that’s why we have this error. You can safely ignore it.
17. Click “Yes” button to continue with installation.
18. Summary window appears. Here you can see all your selections. It’s last moment to make changes. if you are happy with your choices click “Install” button.
19. Installation starts …
20. Once it’s done click “Close” button. Grid software is successfully installed.
21. Verify grid software installation
C:\Users\Administrator>srvctl status listener Listener LISTENER is enabled Listener LISTENER is running on node(s): rac1,rac2 C:\Users\Administrator>srvctl status asm ASM is running on rac1,rac2
ASM configuration assistant
So far we have created only one ASM group DATA. I want to show you how quickly you can add extra group to ASM instance.
Please start ASMCA.
ASMCA – ASM configuration assistant is part of grid software so run it from directory where grid software is installed
c:\app\12.1.0\grid\BIN>asmca
1. ASMCA started click “Disk Groups” tab.
2. Click “Create” button to add new ASM diskgroup.
3. Enter group name BACKUP, check checkbox for “\\ORCLDISKDATA1″ device, select redundancy “External(None)” and click “OK” button.
4. You should see following screen. Click “OK”.
5. Now you should see we have two ASM groups “BACKUP” and “DATA”. Click “Exit” button.
Now you can verify in sqlplus you have 2 ASM groups.
c:\app\12.1.0\grid\BIN>sqlplus SQL*Plus: Release 12.1.0.1.0 Production on Sun Jul 28 07:28:31 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Enter user-name: / as sysasm Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL> select name from v$asm_diskgroup; NAME ------------------------------ BACKUP DATA
Database software installation
Unzip database software then run setup.exe to start database software installation.
unzip winx64_12c_database_1of2.zip unzip winx64_12c_database_2of2.zip
1. Uncheck checkbox “I wish to receive security updates via My Oracle Support” and click “Next” button.
2. Ignore this message and click “Yes”.
3. Select “Skip software updates” and click “Next” button.
4. Select “Create and configure a database” and click “Next” button.
5. Select “Server Class” and click “Next” button.
6. Select “Oracle Real Application Clusters database installation” then click “Next” button.
7. Accept default policy “Admin managed” then click “Next” button.
8. Make sure both nodes are selected, then click the “Next” button.
9. Accept default “Typical install” and click “Next” button.
10. Decide about credential used for database software. I selected “Use Windows Built-in Account” then click “Next” button.
11. Ignore warning message. Just click “Yes” button.
12. There are many options for installation here:
- Oracle base – directory for ORACLE_BASE accept default
- Software location – directory for ORACLE_HOME accept default
- Storage type – select “Oracle Automatic Storage Management”
- Database file location – select diskgroup DATA
- Database edition – accept default “Enterprise Edition” or select other eg. “Standard Edition”
- Global database name – your database global name, in my case it’s ORA12C
- Administrator password – password for user SYS
- Create as Container database – check checkbox to create database ORA12C as container database and enter pluggable database name in my case PORA12C1
Then click “Next button to continue
13. Many checks are started to verify if your hosts are ready to install database software like: remote access to directories, OS parameters, settings etc.
14. On summary screen you can see all selected options. It’s the last time to make changes. If you are happy with selections click “Install” button.
15. It will take some time to install software so be patient.
16. In the end of installation DBCA(database configuration assistant) is started to create your rac database.
17. Summary window for our new rac database ORA12C. Just click “OK” button. it’s worth to change passwords for our important users like SYS, SYSTEM etc “Password Management”.
18. Installation of database software and new database ORA12C is completed. Click “Close” button. Run extra script <Oracle Home>\bin\selecthome.bat on each remote node(rac2) to active extra products.
Verify RAC installation
C:\Users\Administrator>srvctl config database -d ORA12C Database unique name: ORA12C Database name: ORA12C Oracle home: C:\app\Administrator\product\12.1.0\dbhome_1 Oracle user: nt authority\system Spfile: +DATA/ORA12C/spfileORA12C.ora Password file: +DATA/ORA12C/orapwora12c Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: ORA12C Database instances: ORA12C1,ORA12C2 Disk Groups: DATA Mount point paths: Services: Type: RAC Start concurrency: Stop concurrency: Database is administrator managed C:\Users\Administrator>srvctl status listener Listener LISTENER is enabled Listener LISTENER is running on node(s): rac1,rac2 C:\Users\Administrator>srvctl status asm ASM is running on rac1,rac2 C:\Users\Administrator>srvctl status database -d ORA12C Instance ORA12C1 is running on node rac1 Instance ORA12C2 is running on node rac2 c:\install\grid>srvctl status nodeapps VIP rac1-vip is enabled VIP rac1-vip is running on node: rac1 VIP rac2-vip is enabled VIP rac2-vip is running on node: rac2 Network is enabled Network is running on node: rac1 Network is running on node: rac2 ONS is enabled ONS daemon is running on node: rac1 ONS daemon is running on node: rac2
Status of your database can be visible in OEM https://rac1:5500/em
Have a fun 🙂
Tomasz
Keep getting an error when installing saying file not found for crsconfig_params
but when I look in the specified path there it is
I have no idea never got this error. If anyone encounter please share it.
Tomasz
got the same crsconfig_params error. Erase everything, redownload the package and make sure you check the cksum values match vs what is posted on Oracle website and then copy and unzip the install package on the node where you want to stall install from. I was able to get past this error.
Pingback: Install Oracle 12c on Windows env. - TechBoom
Thanks a tone for the wonderful blog
in my case the ping between 2 node is not working, how will that work