Posts

Redhat Linux logical volume extension

I needed to extend a LV as it was small for what I needed to do. As you can see below, it was originally 20G in size. As root, I did the following steps: # df -h /u01 Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg00-lvU01 20G 9.1G 11G 46% /u01 1. First, I had to check for free size on the Volume Group. # vgdisplay --- Volume group --- VG Name vg00 System ID Format lvm2 Metadata Areas 1 Metadata Sequence No 8 VG Access read/write VG Status resizable MAX LV 0 Cur LV 7 Open LV 7 Max PV 0 Cur PV 1 Act PV 1 VG Size <222.02 GiB PE Size 4.00 MiB Total PE 56836 Alloc PE / Size 20480 / 80.00 GiB Free PE / Size 36356 / <142.02 GiB VG UUID poBYqN-t5P3-t6rE-UfeI-eaXj-OoMe-l1a39z 2. From above exam

"Failed to start LSB: Bring up/down networking" after OEL 7 VM build

I imported newly built OEL 7.7 VM from Oracle VirtualBox to an ODA (Oracle Database Appliance). Upon starting up the VM, the network was showing as being up for device "eth0" however the /etc/sysconfig/network-scripts/ifcfg-eth0 was existent at the moment. I restarted the network service but received the "Failed to start LSB: Bring up/down networking" error. I followed the below steps to resolve this error. 1.  Stop and disable the NetworkManager service.      # systemctl stop NetworkManager.service      # systemctl disable NetworkManager.service 2.  Enable the network service.      # systemctl enable network.service 3.  Create the ifcfg-eth0  and populate with the appropriate information.      # vi /etc/sysconfig/network-scripts/ifcfg-eth0 contents: TYPE=Ethernet BOOTPROTO=static NAME=eth0 DEVICE=eth0 ONBOOT=yes IPADDR=<IP_ADDRESS> NETMASK=<SUBNET_MASK> GATEWAY=<DEFAULT_GATEWAY> 4.  Restart the network.      # ser

ORA-17630: Mismatch in the remote file protocol version client 2 server 3

I was trying to create an Oracle Data Guard environment (physical standby) from an Oracle database running version 12.1.0.2. The database was running an older PSU version ("Database Patch Set Update : 12.1.0.2.161018 (24006101)") to be specific. Upon trying to build the standby by using RMAN DUPLICATE with ACTIVE DATABASE, I ran into the below error: executing Memory Script Starting backup at 16-JUL-18 RMAN-03009: failure of backup command on prm1 channel at 07/16/2018 13:51:46 ORA-17629: Cannot connect to the remote database server ORA-17630: Mismatch in the remote file protocol version client 2 server 3 continuing other job steps, job failed will not be re-run released channel: prm1 released channel: prm2 released channel: prm3 released channel: prm4 released channel: prm5 released channel: stb1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ====================

Migrate ODA VM to another ODA (with vdisks)

There wasn't any helpful blog entries out there for migrating a virtualized ODA VM that contains vdisks to another virtualized ODA.  Below is what I used in order to migrate the VMs over.  I'm using ACFS snapshots in order to successfully migrate my VMs. Always remember to test, test, and test before using this on a production ODA/VM. 1.  Execute the "oakcli show vm <vm_name>" in order to see the files that make-up the VM. [root@oda1dom0] # oakcli show vm TESTVM The Resource is : TESTVM         AutoStart       :       never         CPUPriority     :       100         Disks           :       |file:/OVS/Repositories/demorepo/.A                                 CFS/snaps/TESTVM/VirtualMachine                                 s/TESTVM/612aeba3b38f4527a4500e                                 c202a08e3f.img,xvda,w|         Domain          :       XEN_PVM         DriverDomain    :       False         ExpectedState   :       online         FailOver        :

ORA-00600: error in Queue Table SYS.SYS$SERVICE_METRICS_TAB

If this error is coming in Oracle database, then take downtime and do the following:  Drop the queue table - exec dbms_aqadm.drop_queue_table( queue_table=>'SYS.SYS$SERVICE_METRICS_TAB', force => TRUE) select object_name, object_type from dba_objects where object_name like '%SYS$SERVICE_%'; ----> no rows should be returned. Follow the below steps to recreate the queue table. SQL>STARTUP SQL>alter system enable restricted session; SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql SQL>alter system disable restricted session;

RMAN-06023: no backup or copy of datafile X found to restore

I was attempting to restore a backup via RMAN but received the following errors: RMAN-06023: no backup or copy of datafile 11 found to restore RMAN-06023: no backup or copy of datafile 10 found to restore RMAN-06023: no backup or copy of datafile 9 found to restore RMAN-06023: no backup or copy of datafile 8 found to restore RMAN-06023: no backup or copy of datafile 7 found to restore RMAN-06023: no backup or copy of datafile 6 found to restore RMAN-06023: no backup or copy of datafile 5 found to restore RMAN-06023: no backup or copy of datafile 4 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore The issue was with the FRA (Fast Recovery Area). RMAN will catalog any objects in the Flash Recovery Area that will not be registered in the controlfile and if any of this files belongs to an incarnation different from CURR

RMAN restore of ODA X6-2-HA RAC database

A client that I was supporting asked me to complete a dry run of a database restore on their newly built ODA.  Below are the steps that I performed to complete the database restore. Prerequisites: I built the RAC database using OAKCLI. I backed up the database with RMAN incremental level 0 + cumulative level 1. I dropped the database using SQLPLUS commands vs. OAKCLI as to not remove the ACFS directories for the database. 1. Startup the database instance in NOMOUNT. RMAN> startup nomount force; startup failed: ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '/u02/app/oracle/oradata/datastore/.ACFS/snaps/labtest/labtest/spfilelabtest.ora' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 starting Oracle instance without parameter file for retrieval of spfile Oracle instance started Total System Global Area    1073741824 bytes Fixed Size                     293263