dbaliw

Exadata, How to change ilom root password

For security raison, we need to change dbnode/cell ilom root password regularly. Let’s login to Ilom and change password. > ssh exa01-ilom Password: Oracle(R) Integrated Lights Out Manager Version 4.0.4.52.a r139829 Copyright (c) 2021, Oracle and/or its affiliates. All rights reserved. Warning: HTTPS certificate is set to factory default. Hostname: exa01-ilom -> set /SP/users/root passwordContinue reading “Exadata, How to change ilom root password”

Oracle 19, recover standby become easier

Since oracle 19 , recover standby become quite easier. Here my dataguard configuration and it shows ORA-16810 error. DGMGRL> show configuration Configuration – ora19_cfg Protection Mode: MaxPerformance Members: ora19_pri – Primary database ora19_stb – Physical standby database Error: ORA-16810: multiple errors or warnings detected for the member Fast-Start Failover: Disabled Configuration Status: ERROR (status updatedContinue reading “Oracle 19, recover standby become easier”

Exadata, how to change ilom nameserver by ipconf in cell

You have to stop cell service properly before you change ilom network config in cell. You can find the procedure at How to restart cell services properly I propose you use ipconf to update your network config in exadata system. Don’t use ilom command line , because it doesn’t change /opt/oracle.cellos/cell.conf file, and you will haveContinue reading “Exadata, how to change ilom nameserver by ipconf in cell”

Exadata, how to backup domU

Backup user domaine machine (domU) is quite easy in Exadata system. 1. Pause the DomU [root@db01-m ~]# xm list Name ID Mem VCPUs State Time(s) Domain-0 0 8571 4 r—– 15546936.0 vm01db01.mydomaine.local 48 180227 22 -b—- 56705.8 … root@db01-m ~]# xm pause vm01db01.mydomaine.local [root@db01-m ~]# xm list Name ID Mem VCPUs State Time(s) Domain-0 0Continue reading “Exadata, how to backup domU”

Exadata, how to restart cell services properly

We don’t restart cell services too much often if cell works fine :-). But if we want to restart cell services and you don’t expect ASM instance to be affected, or you don’t want vm node eviction (in the worst case) , we must do it properly. [root@cell01 ~]# cellcli -e LIST GRIDDISK ATTRIBUTES name,asmmodestatus,asmdeactivationoutcomeContinue reading “Exadata, how to restart cell services properly”

ZDLRA, ORA-17629: Cannot connect to the remote database server

In my customer Data Guard environment , rman backup use ZDLRA bi-directional architecture, both the primary and the standby databases are registered with the catalog. Standby db DB_STBY1 connect to RA_stb catalogPrimary db DB_PRI1 connect to RA_pri catalog. The databases are distinguished using the DB_UNIQUE_NAME in rman configuration. CONFIGURE DB_UNIQUE_NAME ‘DB_PRI1’ CONNECT IDENTIFIER ‘DB_PRI1’; CONFIGURE DB_UNIQUE_NAMEContinue reading “ZDLRA, ORA-17629: Cannot connect to the remote database server”

Exadata, ILOM DNS server xxx in system configuration must match xxx in /opt/oracle.cellos/cell.conf

I got a error during exadata patchmgr precheck on cell storage. # ./patchmgr -cells cells -log_dir auto -patch_check_prereq -rolling … cel01: [ERROR] Can not continue. Runtime configuration is not consistent with values configured in /opt/oracle.cellos/cell.conf. cel01: [ERROR] Run ipconf to correct the inconsistencies. Failed check: /root/<em>cellupd_dpullec</em>/<em>p</em>/ipconf -check-consistency -at-runtime -semantic -verbose cel01: [ERROR] Details: cel01: ILOMContinue reading “Exadata, ILOM DNS server xxx in system configuration must match xxx in /opt/oracle.cellos/cell.conf”