Apps DBA Workshop

We were working on 8 node Extended RAC setup and based on request from customer we need to scale up the existing ASM disk group and when we tried adding the disk to the disk group we encountered the following error SQL> alter diskgroup data add disk '/dev/mapper/CL1_SITEA_D007' force; alter diskgroup data add disk '/dev/mapper/CL1_SITEA_D007' force * ERROR at line 1: ORA-00600: internal error code, arguments: [kfgSiteNumPopulate02], [], [], [], [], [], [], [], [], [], [], [] Error From ASM Alert logfile: Dumping diagnostic data in directory=[cdmp_20230424121633], requested by (instance=1, osid=397487), summary=[incident=68188]. 2023-04-24T12:16:33.770798+03:00 NOTE: Attempting voting file refresh on diskgroup DATA NOTE: Refresh completed on diskgroup DATA. No voting file found. 2023-04-24T12:16:36.289397+03:00 ORA-00600: internal error code, arguments: [kfgSiteNumPopulate02], [], [], [], [], [], [], [], [], [], [], [] 2023-04-24T12:16:36.289445+03:00 ERROR: al...

 We encountered the following error while installing Oracle 19c RDBMS Installation in RAC environment.   OEL 8.6 was the deployed Operating system.   If this issue is encountered, please ensure Oracle Inventory has at least 755 privileges are there on the directory. Once the proper privileges are set we were able to proceed with the RDBMS Installations.   Thanks for reading. Regards, zaheer

I encountered this error while extending   2 node 12c cluster to 3 nodes. Error: [INS-30160] Installer has detected the nodes specified for add node operation have uncleaned Inventory. Cause: In /u01 directory there was an oraInventory directory exists. Though the directory is emptly oui still assuming that there is some content in this directory. Action: Delete oraInventory directory from nodes on which you are facing Issues. OUI will create this directory after successful addition of nodes. Hope this helps. Thanks for reading :) regards, Zaheer

We are trying to install and configure two node Oracle Grid infrastructure 12.1.0.2 for one of our customer, but there was an issue with on of the cluster node and installation cannot proceed further. All pre-reqs checks were successful, we tested ssh it was working fine. Even nodes communication was working without any issues from both the nodes. Error Screen Shot: Its a very generic error that points to invalid hostname, but honestly hostname was defined correctly. After lot of troubleshooting we found solution, there was problem with "hostname -i", when we see the hostname IP address it was pointing to IP Address + MAC address which is not correct. After fixing this issue installation completed with any issues. Hope it helps, thanks for reading.  regards, Zaheer

 We were not able to create the container database and it encountered following Error: [pool-1-thread-1] [ 2021-08-17 15:25:52.277 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName [pool-1-thread-1] [ 2021-08-17 15:25:52.277 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName:nodenumber: 1 [pool-1-thread-1] [ 2021-08-17 15:25:52.279 AST ] [has.ClusterUtilNative.Native] prsr_trace: Native: getLocalNodeName:nodename: erp-preprod-db01 INFO: Aug 17, 2021 3:25:52 PM oracle.assistants.dbca.util.NodeSelectionHelper reorderLocalNodeIndex INFO: Local node found at index:0 localnode:erp-preprod-db01 INFO: Aug 17, 2021 3:25:52 PM oracle.assistants.dbca.action.DBIdentificationAction updateRACConfiguration INFO: Added: [erp-preprod-db01, erp-preprod-db02] to the node list in the bean [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [has.UtilNative.Native] prsr_trace: Native: getCRSHome [pool-1-thread-1] [ 2021-08-17 15:25:52.280 AST ] [has.UtilNa...

This a step by step article for configuring oracle 12c RAC on Oracle Enterprise Linux 6.1. Following software's used for this deployment: 1) Oracle Virtual Box 2) Oracle Enterprise Linux 6.1 (64-Bit) 3) Oracle 12c Grid Infrastructure (64-Bit) 4) Oracle 12c Database Virtual machines configuration: I used windows DNS Server 2008 for resolving scan IP to simulate it with real world deployments. You can use a single entry of scan in /etc/hosts file for TEST deployments. The high level steps for deployment: (assuming virtual box - already Installed) 1) Create Virtual machines 2) Install Oracle Enterprise Linux 6.1 3) Configure additional Hardware required for RAC (SHARED STORAGE) 4) Clone virtual machine 5) Perform all OS pre-requisites 6) Install Oracle 12c Grid Infrastructure 7) Install Oracle 12c RDBMS  home 8) Create RAC database 1) Create Virtual Mahcine: Follow step by step screens for creation of virtual machines: ...