Category Archives: Oracle Database

Oracle Database 9i, 10g,11g, 12c

Cleared 1Z0-997 Oracle Cloud Infra. Certified Architect Professional…

Cleared following 3 Oracle Cloud Infrastructure exams in a row in three days. Thanks to great Oracle COVID offers. wish to attempt more exams but could not find more slots serially.. Oracle Cloud Infrastructure 2019 Certified Architect Professional https://www.youracclaim.com/badges/ba7f88e4-25a4-4b2e-92af-dd4c6dd081f1/public_url Oracle Autonomous Database Cloud 2019 Certified Specialist. https://www.youracclaim.com/badges/787ba425-6a23-495c-a2f3-ab6082f026fe/public_urlOracle Cloud Infrastructure 2019 Architect Associate https://www.youracclaim.com/badges/2b87f825-d1b8-4746-8745-40975ca49d7f/public_url Though i… Read More »

How to Clean up ODA Failed Deployment.

CLEANING UP FAILED ODA DEPLOYMENT. You can find cleanup.pl under /opt/oracle/oak/onecmd location. Repeat the steps on both ODA nodes.

ODA Bundle Patch: Upgrade to OAK 18.3.0.0.0

ODA Bundle Patch: Upgrade to OAK 18.3.0.0.0 Here i am upgrading ODA from 12.1.2.12.0 to 18.3.0.0.0.Backup ODA_BASE before proceeding with ODA Bundle patch.For ODA_BASE backup refer to post “Backup ODA_BASE: Database Appliance ODA X5“.Above post applies to ODA X5 or higher versions. Login to ODA_BASE as root user.Download & Unpack the ODA bundle patch on… Read More »

Backup ODA_BASE: Database Appliance ODA X5

There are situations we may need to backup ODA_BASE, especially before patching ODA_BASE.This article applies only to virtual deployment of ODA.In this Article I’ve used ODA-X5-2 appliance to backup.The procedure is applicable for ODA X5 or higher versions.ODA_BASE is backed up from the DOM machines, i.e. the parent machine from where ODA_BASE was created.Login to… Read More »

ODA X5 CPU configuration

Oracle Database Appliance X5-2 nodes each contain 2 CPUs and each CPU has 18 cores. When you deploy Oracle Database Appliance X5-2, all 72 cores (36 cores in each server) are active with hyper-threading enabled by default. Below show processor showing each node having two processors and each with 18 cores i.e. Node 0: 18… Read More »

CRS-0804, PROC-44, CRS-4535, PROC-44: Error in network address

Getting following error during CRS start. we had a server reboot post maintenance. CRS-0804, PROC-44, CRS-4535, PROC-44: Error in network address

CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4529: Cluster Synchronization Services is online
CRS-4534: Cannot communicate with Event Manager

[crsd(12451930)]CRS-0804:Cluster Ready Service aborted due to Oracle Cluster Registry error [PROC-44: Error in network address and interface operations Network address
and interface operations error [7]]. Details at (:CRSD00111:) in /grid/app/11.2.0.3/grid/log/sam-rac01/crsd/crsd.log.
2017-03-20 13:46:39.533:
[CLWAL][1]clsw_Initialize: OLR initlevel [70000]
2017-03-20 13:46:42.946: [ OCRAPI][1]clsu_get_private_ip_addresses: no ip addresses found.
[ OCRAPI][1]a_init_clsss: failed to call clsu_get_private_ip_addr (7)
2017-03-20 13:46:43.149: [ OCRAPI][1]a_init:13!: Clusterware init unsuccessful : [44]
2017-03-20 13:46:43.149: [ CRSOCR][1] OCR context init failure. Error: PROC-44: Error in network address and interface operations Network address and interface operat
ions error [7]
2017-03-20 13:46:43.150: [ CRSMAIN][1] Created alert : (:CRSD00111:) : Could not init OCR, error: PROC-44: Error in network address and interface operations Network ad
dress and interface operations error [7]
2017-03-20 13:46:43.150: [ CRSD][1][PANIC] CRSD exiting: Could not init OCR, code: 44
2017-03-20 13:46:43.150: [ CRSD][1] Done.</pre>

CRS-4638: Oracle High Availability Services is online

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4529: Cluster Synchronization Services is online

CRS-4534: Cannot communicate with Event Manager

[crsd(12451930)]CRS-0804:Cluster Ready Service aborted due to Oracle Cluster Registry error [PROC-44: Error in network address and interface operations Network address

and interface operations error [7]]. Details at (:CRSD00111:) in /grid/app/11.2.0.3/grid/log/sam-rac01/crsd/crsd.log.

2017-03-20 13:46:39.533:

[CLWAL][1]clsw_Initialize: OLR initlevel [70000]

2017-03-20 13:46:42.946: [ OCRAPI][1]clsu_get_private_ip_addresses: no ip addresses found.

[ OCRAPI][1]a_init_clsss: failed to call clsu_get_private_ip_addr (7)

2017-03-20 13:46:43.149: [ OCRAPI][1]a_init:13!: Clusterware init unsuccessful : [44]

2017-03-20 13:46:43.149: [ CRSOCR][1] OCR context init failure. Error: PROC-44: Error in network address and interface operations Network address and interface operat

ions error [7]

2017-03-20 13:46:43.150: [ CRSMAIN][1] Created alert : (:CRSD00111:) : Could not init OCR, error: PROC-44: Error in network address and interface operations Network ad

dress and interface operations error [7]

2017-03-20 13:46:43.150: [ CRSD][1][PANIC] CRSD exiting: Could not init OCR, code: 44

2017-03-20 13:46:43.150: [ CRSD][1] Done.</pre>

Looking at the logs above this seems to be issue with network. Verify the same by comparing output of following two commands.

$GRID_HOME/bin/oifcfg iflist -p -n
$GRID_HOME/bin/gpnptool get

1 2	$GRID_HOME/bin/oifcfg iflist -p -n $GRID_HOME/bin/gpnptool get

On output 1 the interface name for PRIVATE network is… Read More »

Oracle Database 18c, Database of Year 2018

Oracle database 18c is now available…it’s about a week since announcement made on 16 Feb. So we download a copy and try it … Well wait a sec..its released only on Oracle Cloud & Engineered Systems. So what does 18c stands for, the ‘c’ of course stands for cloud, but why 18c not 13c. Why… Read More »

Single Instance to RACOne Node Conversion.

Convert single instance to RAC using rconfig utility. Verify the database is added to cluster and is SINGLE Instance.

[oracle@SAMOELNODE01 ~]$ srvctl config database -d ORCL
Database unique name: ORCL
Database name:
Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_2
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ORCL
Database instance: ORCL
Disk Groups:
Mount point paths:
Services:
Type: SINGLE
Database is administrator managed

[oracle@SAMOELNODE01 ~]$ srvctl config database -d ORCL

Database unique name: ORCL

Database name:

Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_2

Oracle user: oracle

Spfile:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: ORCL

Database instance: ORCL

Disk Groups:

Mount point paths:

Services:

Type: SINGLE

Database is administrator managed

Above output shows Type: SINGLE.

[oracle@SAMOELNODE01 scripts]$ cd /u01/app/oracle/product/11.2.0.4/dbhome_2/assistants/rconfig/sampleXMLs/
[oracle@SAMOELNODE01 sampleXMLs]$ ls -ltr
total 12
-rw-r--r-- 1 oracle oinstall 2804 Mar 22 2010 ConvertToRAC_PolicyManaged.xml
-rw-r--r-- 1 oracle oinstall 2754 Apr 8 14:24 ConvertToRAC_AdminManaged.xml.orig
-rw-r--r-- 1 oracle oinstall 2781 Apr 8 15:00 ConvertToRAC_AdminManaged.xml
[oracle@SAMOELNODE01 sampleXMLs]$ cp ConvertToRAC_AdminManaged.xml ConvertToRACOneNode.xml
[oracle@SAMOELNODE01 sampleXMLs]$ diff ConvertToRAC_AdminManaged.xml ConvertToRACOneNode.xml
7c7
< <n:Convert verify="YES">
---
> <n:Convert verify="ONLY">
9c9
< <n:SourceDBHome>/oracle/product/11.2.0/db_1</n:SourceDBHome>
---
> <n:SourceDBHome>/u01/app/oracle/product/11.2.0.4/dbhome_2</n:SourceDBHome>
11c11
< <n:TargetDBHome>/oracle/product/11.2.0/db_1</n:TargetDBHome>
---
> <n:TargetDBHome>/u01/app/oracle/product/11.2.0.4/dbhome_2</n:TargetDBHome>
13c13
< <n:SourceDBInfo SID="sales">
---
> <n:SourceDBInfo SID="ORCL">
16c16
< <n:Password>oracle</n:Password>
---
> <n:Password>system123</n:Password>
22,23c22,23
< <n:Node name="node1"/>
< <n:Node name="node2"/>
---
> <n:Node name="SAMOELNODE01"/>
> <n:Node name="SAMOELNODE02"/>
26c26
< <!--n:RacOneNode servicename="saleORCLac1service"/-->
---
> <n:RacOneNode servicename="ORCL"/>
28c28
< <n:InstancePrefix>sales</n:InstancePrefix>
---
> <n:InstancePrefix>ORCL</n:InstancePrefix>
33c33
< <n:TargetDatabaseArea>+ASMDG</n:TargetDatabaseArea>
---
> <n:TargetDatabaseArea></n:TargetDatabaseArea>
35c35
< <n:TargetFlashRecoveryArea>+ASMDG</n:TargetFlashRecoveryArea>
---
> <n:TargetFlashRecoveryArea></n:TargetFlashRecoveryArea>

[oracle@SAMOELNODE01 scripts]$ cd /u01/app/oracle/product/11.2.0.4/dbhome_2/assistants/rconfig/sampleXMLs/

[oracle@SAMOELNODE01 sampleXMLs]$ ls -ltr

total 12

-rw-r--r-- 1 oracle oinstall 2804 Mar 22 2010 ConvertToRAC_PolicyManaged.xml

-rw-r--r-- 1 oracle oinstall 2754 Apr 8 14:24 ConvertToRAC_AdminManaged.xml.orig

-rw-r--r-- 1 oracle oinstall 2781 Apr 8 15:00 ConvertToRAC_AdminManaged.xml

[oracle@SAMOELNODE01 sampleXMLs]$ cp ConvertToRAC_AdminManaged.xml ConvertToRACOneNode.xml

[oracle@SAMOELNODE01 sampleXMLs]$ diff ConvertToRAC_AdminManaged.xml ConvertToRACOneNode.xml

7c7

< <n:Convert verify="YES">

---

> <n:Convert verify="ONLY">

9c9

< <n:SourceDBHome>/oracle/product/11.2.0/db_1</n:SourceDBHome>

---

> <n:SourceDBHome>/u01/app/oracle/product/11.2.0.4/dbhome_2</n:SourceDBHome>

11c11

< <n:TargetDBHome>/oracle/product/11.2.0/db_1</n:TargetDBHome>

---

> <n:TargetDBHome>/u01/app/oracle/product/11.2.0.4/dbhome_2</n:TargetDBHome>

13c13

< <n:SourceDBInfo SID="sales">

---

> <n:SourceDBInfo SID="ORCL">

16c16

< <n:Password>oracle</n:Password>

---

> <n:Password>system123</n:Password>

22,23c22,23

< <n:Node name="node1"/>

< <n:Node name="node2"/>

---

> <n:Node name="SAMOELNODE01"/>

> <n:Node name="SAMOELNODE02"/>

26c26

<

---

> <n:RacOneNode servicename="ORCL"/>

28c28

< <n:InstancePrefix>sales</n:InstancePrefix>

---

> <n:InstancePrefix>ORCL</n:InstancePrefix>

33c33

< <n:TargetDatabaseArea>+ASMDG</n:TargetDatabaseArea>

---

> <n:TargetDatabaseArea></n:TargetDatabaseArea>

35c35

< <n:TargetFlashRecoveryArea>+ASMDG</n:TargetFlashRecoveryArea>

---

> <n:TargetFlashRecoveryArea></n:TargetFlashRecoveryArea>

So here I’ve changed only following values i.e. SourceDBHome, TargetDBHome, SourceDBInfo, Password, Node name, RacOneNode servicename, InstancePrefix and following values are altered to blank (><) as we are not… Read More »