DisplayAdd1

TechnoTechDB is a platform, which will help to grow your carrier in Information sector. Having 15 years of Experience in Oracle/MongoDB/Postgres/Mysql databases, along with having good expertise level of knowledge in Scripting to automate database task. Our goal to start with zero to hero level expertise in Database. You can access/refer my some blogs on https://mrorcldba.blogspot.com link and post your comments and your suggestion to motive us.

Tuesday, 19 December 2023

Could not connect 'Ethernet0' to virtual network 'VMnet0'. More information can be found in the vmware.log file.


Error 

Could not connect 'Ethernet0' to virtual network 'VMnet0'. More information can be found in the vmware.log file.

 

Failed to connect virtual device 'Ethernet0'.


 

Solution: 

1. Stop all VMS from VMware workstation.

2. Once stop, click on  Edit -> "Virtual Network Editior"




3. It will open below wizard and click on change settings .  














4. Click on restore default and wait to complete. once reset completed start your machine. 



Hostname changed and ORACLE ASM restart is not able start and connect


If hostname changed (click here) and ORACLE ASM restart is not able start and connect, 


[root@oemserver oracle]# crsctl start has
CLSU-00100: operating system function: opendir failed with error data: 2
CLSU-00101: operating system error message: No such file or directory
CLSU-00103: error location: scrsearch1
CLSU-00104: additional error information: cant open scr home dir scls_scr_getval
CRS-4000: Command Start failed, or completed with errors.


Note: Below steps may loose your ASM disk data, so pls do not try below steps on prod directly .

Solution : Please refer below steps from Root user.


/u01/app/oracle/product/12.2.0.1/grid/perl/bin/perl  /u01/app/oracle/product/12.2.0.1/grid/crs/install/roothas.pl -deconfig -force
/u01/app/oracle/product/12.2.0.1/grid/perl/bin/perl  /u01/app/oracle/product/12.2.0.1/grid/crs/install/roothas.pl 
or
/u01/app/oracle/product/12.2.0.1/grid/perl/bin/perl  /u01/app/oracle/product/12.2.0.1/grid/crs/install/root.sh 


====  Other Issue during start ORACLE ASM Restart ======================

[oracle@oemserver ~]$ crsctl stat res -t

--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
               OFFLINE OFFLINE      oemserver                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE                                      STABLE
ora.diskmon
      1        OFFLINE OFFLINE                                       STABLE
ora.evmd
      1        ONLINE  ONLINE       oemserver                STABLE
--------------------------------------------------------------------------------


 
Error :
[oracle@oemserver ~]$ crsctl start resource ora.cssd
CRS-4995:  The command 'Stop  resource' is invalid in crsctl. Use srvctl for this command.

Solution :
./crsctl start resource ora.cssd -unsupported


[oracle@oemserver ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
               OFFLINE OFFLINE      oemserver                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       oemserver                STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       oemserver                STABLE
--------------------------------------------------------------------------------


=====================================================================

If asm is not starting, set display and use asmca. it will start ASM and you can mount disk which you wants.

[oracle@oemserver ~]$ asmca
[oracle@oemserver ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
               OFFLINE OFFLINE      oemserver                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       oemserver                STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       oemserver                STABLE
--------------------------------------------------------------------------------

[oracle@oemserver ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 19 14:09:20 2023

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

=====================================================================

Steps to add Listner/Disk/ASM in SRVCTL

[oracle@oemserver ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.asm
               OFFLINE OFFLINE      oemserver                STABLE
ora.ons
               OFFLINE OFFLINE      oemserver                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       oemserver                STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       oemserver                STABLE
--------------------------------------------------------------------------------

[oracle@oemserver ~]$ srvctl add listener -listener LISTENER -endpoints 1521
[oracle@oemserver ~]$ srvctl add asm -l LISTENER -d DATA -p +data/spfile.ora
[oracle@oemserver ~]$ srvctl config asm
ASM home: <CRS home>
Password file:
Backup of Password file:
ASM listener: LISTENER
Spfile: +data/spfile.ora
ASM diskgroup discovery string: DATA
[oracle@oemserver ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               OFFLINE OFFLINE      oemserver                STABLE
ora.asm
               OFFLINE OFFLINE      oemserver                STABLE
ora.ons
               OFFLINE OFFLINE      oemserver                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       oemserver                STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       oemserver                STABLE
--------------------------------------------------------------------------------
[oracle@oemserver ~]$

Monday, 18 December 2023

Unable to open kernel device '\\.\VMCIDev\VMX': The operation completed successfully.

Hello Friends, 


When I was working on new machine and install VMware 17 Pro, I copied backed up VM machine to new machine and started VM, It was showing below error.    


Error :



====================================================================================================

 Unable to open kernel device '\\.\VMCIDev\VMX': The operation completed successfully. Did you reboot after installing VMware Workstation?


Module 'DevicePowerOn' power on failed.


Failed to start the virtual machine.


====================================================================================================


Solution : 

I have copied/restored VM to "D:\VMware\VM2\EL_7.9" . 

1. Go to your VM directories. 

2. take backup of VMware virtual machine configuration (.vmx), as highlighted.  



3. Open OEL7.9 in notepad and search for vmci0.present. If it has set with TRUE value. Make it FALSE. shown as below.



4. Restart your VM machine, it will run without any error.

Feel free to share if issue not fixed. 

Wednesday, 13 December 2023

How to fix CheckName: TBLSPACE_FLASHBACK_OFF issue during Oracle Auto Upgrade

 Hello Friends, 


As from oracle 19c, Oracle started to provide database upgrade using autoupgrade features, It also provide report of preupgrade we have in traditional method but here you can get that report in HTML and easy to focus on error.  

Important point is DBA must be keep practicing to check flashback status on tablespace too if you are using tablespace during time of any activity. 

You may check it with the hep of "select name, flashback_on from v$tablespace " 

You face issue related to TBLSPACE_FLASHBACK_OFF is failing during prechecks stage. Error could be same as showing error in red box and description.  Please refer solution which fixes the issue.


  • CheckName: TBLSPACE_FLASHBACK_OFF
  •  
  • FixUp Available: NO
  •  
  • Severity: ERROR
  •  
  • Stage: PRECHECKS

As the AutoUpgrade utility creates restore points by default, enable flashback for the tablespace(s) that have flashback off prior to upgrading. For more details, refer to the section on "Using Flashback Database and Restore Points" in Oracle documentation "Backup and Recovery User's Guide".
Note: To find tablespaces with flashback off, run: select name from v$tablespace where flashback_on = 'NO';

Flashback is not possible if at least one tablespace in the database has flashback disabled.

At least one tablespace in this database has flashback off. To find such tablespaces, run: select name, flashback_on from v$tablespace where flashback_on = 'NO';


  • Solution: 


SQL> select name, flashback_on from v$tablespace ;
NAME                           FLA
------------------------------ ---
SYSTEM                         YES
SYSAUX                         YES
UNDOTBS1                       YES
TEMP                           YES
USERS                          YES
DATA_SCOTT                      NO
INDX_SCOTT                      NO

 

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

 

SQL> startup mount;
ORACLE instance started.
Total System Global Area 3.2212E+10 bytes
Fixed Size                 12178656 bytes
Variable Size            1.6643E+10 bytes
Database Buffers         1.5502E+10 bytes
Redo Buffers               54927360 bytes
Database mounted.

 

SQL>  alter tablespace DATA_SCOTT flashback on;
Tablespace altered.

SQL>  alter tablespace INDEX_SCOTT flashback on;
Tablespace altered.

SQL> select name, flashback_on from v$tablespace ;
NAME                           FLA
------------------------------ ---
SYSTEM                         YES
SYSAUX                         YES
UNDOTBS1                       YES
TEMP                           YES
USERS                          YES
DATA_SCOTT                      YES
INDX_SCOTT                      YES

SQL> alter database open; 

Once it started to show All tablespace flashback_on is YES, you may resume upgrade job.

 

 Please share your feedback if this didn't works.  

 

Steps to Rename Host in Oracle RESTART (ASM) in Linux

  oracle@localhost ] asmcmd ASMCMD> lsdg State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_...