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

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.

Tuesday, 26 September 2023

How to install VNC in Linux

Hello Guys,

First step we need to enable X11 on server, to setup X11 please follow below link.

https://mrorcldba.blogspot.com/2023/06/how-to-enable-x11-in-linux.html

Once X11 setup done, please follow below command

[opc@testt1 ~]$ sudo yum -y install tigervnc-server xorg-x11-fonts-Type1

Loaded plugins: versionlock

Excluding 103 updates due to versionlock (use "yum versionlock status" to show them)

Resolving Dependencies

--> Running transaction check

---> Package tigervnc-server.x86_64 0:1.8.0-25.el7_9 will be installed

--> Processing Dependency: tigervnc-server-minimal for package: tigervnc-server-1.8.0-25.el7_9.x86_64

--> Processing Dependency: xorg-x11-xinit for package: tigervnc-server-1.8.0-25.el7_9.x86_64

--> Processing Dependency: libpixman-1.so.0()(64bit) for package: tigervnc-server-1.8.0-25.el7_9.x86_64

---> Package xorg-x11-fonts-Type1.noarch 0:7.5-9.el7 will be installed

--> Processing Dependency: mkfontdir for package: xorg-x11-fonts-Type1-7.5-9.el7.noarch

--> Processing Dependency: ttmkfdir for package: xorg-x11-fonts-Type1-7.5-9.el7.noarch

--> Running transaction check

---> Package pixman.x86_64 0:0.34.0-1.el7 will be installed

---> Package tigervnc-server-minimal.x86_64 0:1.8.0-25.el7_9 will be installed

--> Processing Dependency: mesa-dri-drivers for package: tigervnc-server-minimal-1.8.0-25.el7_9.x86_64

--> Processing Dependency: tigervnc-license for package: tigervnc-server-minimal-1.8.0-25.el7_9.x86_64

--> Processing Dependency: xkeyboard-config for package: tigervnc-server-minimal-1.8.0-25.el7_9.x86_64

--> Processing Dependency: xorg-x11-xkb-utils for package: tigervnc-server-minimal-1.8.0-25.el7_9.x86_64

--> Processing Dependency: libGL.so.1()(64bit) for package: tigervnc-server-minimal-1.8.0-25.el7_9.x86_64

--> Processing Dependency: libXfont2.so.2()(64bit) for package: tigervnc-server-minimal-1.8.0-25.el7_9.x86_64

--> Processing Dependency: libxshmfence.so.1()(64bit) for package: tigervnc-server-minimal-1.8.0-25.el7_9.x86_64

---> Package ttmkfdir.x86_64 0:3.0.9-42.el7 will be installed

---> Package xorg-x11-font-utils.x86_64 1:7.5-21.el7 will be installed

--> Processing Dependency: libfontenc.so.1()(64bit) for package: 1:xorg-x11-font-utils-7.5-21.el7.x86_64

---> Package xorg-x11-xinit.x86_64 0:1.3.4-2.el7 will be installed

--> Processing Dependency: xorg-x11-server-utils for package: xorg-x11-xinit-1.3.4-2.el7.x86_64

--> Running transaction check

---> Package libXfont2.x86_64 0:2.0.3-1.el7 will be installed

---> Package libfontenc.x86_64 0:1.1.3-3.el7 will be installed

---> Package libglvnd-glx.x86_64 1:1.0.1-0.8.git5baa1e5.el7 will be installed

--> Processing Dependency: libglvnd(x86-64) = 1:1.0.1-0.8.git5baa1e5.el7 for package: 1:libglvnd-glx-1.0.1-0.8.git5baa1e5.el7.x86_64

--> Processing Dependency: mesa-libGL(x86-64) >= 13.0.4-1 for package: 1:libglvnd-glx-1.0.1-0.8.git5baa1e5.el7.x86_64

--> Processing Dependency: libGLdispatch.so.0()(64bit) for package: 1:libglvnd-glx-1.0.1-0.8.git5baa1e5.el7.x86_64

---> Package libxshmfence.x86_64 0:1.2-1.el7 will be installed

---> Package mesa-dri-drivers.x86_64 0:18.3.4-12.el7_9 will be installed

--> Processing Dependency: libdrm >= 2.4.83 for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

--> Processing Dependency: libLLVM-7-rhel.so(LLVM_7)(64bit) for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

--> Processing Dependency: mesa-filesystem(x86-64) for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

--> Processing Dependency: libLLVM-7-rhel.so()(64bit) for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

--> Processing Dependency: libdrm.so.2()(64bit) for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

--> Processing Dependency: libdrm_amdgpu.so.1()(64bit) for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

--> Processing Dependency: libdrm_intel.so.1()(64bit) for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

--> Processing Dependency: libdrm_nouveau.so.2()(64bit) for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

--> Processing Dependency: libdrm_radeon.so.1()(64bit) for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

--> Processing Dependency: libglapi.so.0()(64bit) for package: mesa-dri-drivers-18.3.4-12.el7_9.x86_64

---> Package tigervnc-license.noarch 0:1.8.0-25.el7_9 will be installed

---> Package xkeyboard-config.noarch 0:2.24-1.el7 will be installed

---> Package xorg-x11-server-utils.x86_64 0:7.7-20.el7 will be installed

---> Package xorg-x11-xkb-utils.x86_64 0:7.7-14.el7 will be installed

--> Processing Dependency: libxkbfile.so.1()(64bit) for package: xorg-x11-xkb-utils-7.7-14.el7.x86_64

--> Running transaction check

---> Package libdrm.x86_64 0:2.4.97-2.el7 will be installed

--> Processing Dependency: libpciaccess.so.0()(64bit) for package: libdrm-2.4.97-2.el7.x86_64

---> Package libglvnd.x86_64 1:1.0.1-0.8.git5baa1e5.el7 will be installed

---> Package libxkbfile.x86_64 0:1.0.9-3.el7 will be installed

---> Package llvm-private.x86_64 0:7.0.1-1.el7 will be installed

---> Package mesa-filesystem.x86_64 0:18.3.4-12.el7_9 will be installed

---> Package mesa-libGL.x86_64 0:18.3.4-12.el7_9 will be installed

---> Package mesa-libglapi.x86_64 0:18.3.4-12.el7_9 will be installed

--> Running transaction check

---> Package libpciaccess.x86_64 0:0.14-1.el7 will be installed

--> Finished Dependency Resolution

--> Finding unneeded leftover dependencies

Found and removing 0 unneeded dependencies

Dependencies Resolved

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

Package Arch Version Repository Size

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

Installing:

tigervnc-server x86_64 1.8.0-25.el7_9 ol7_latest 211 k

xorg-x11-fonts-Type1 noarch 7.5-9.el7 ol7_latest 521 k

Installing for dependencies:

libXfont2 x86_64 2.0.3-1.el7 ol7_latest 143 k

libdrm x86_64 2.4.97-2.el7 ol7_latest 151 k

libfontenc x86_64 1.1.3-3.el7 ol7_latest 30 k

libglvnd x86_64 1:1.0.1-0.8.git5baa1e5.el7 ol7_latest 89 k

libglvnd-glx x86_64 1:1.0.1-0.8.git5baa1e5.el7 ol7_latest 124 k

libpciaccess x86_64 0.14-1.el7 ol7_latest 26 k

libxkbfile x86_64 1.0.9-3.el7 ol7_latest 82 k

libxshmfence x86_64 1.2-1.el7 ol7_latest 6.5 k

llvm-private x86_64 7.0.1-1.el7 ol7_latest 23 M

mesa-dri-drivers x86_64 18.3.4-12.el7_9 ol7_latest 7.2 M

mesa-filesystem x86_64 18.3.4-12.el7_9 ol7_latest 18 k

mesa-libGL x86_64 18.3.4-12.el7_9 ol7_latest 165 k

mesa-libglapi x86_64 18.3.4-12.el7_9 ol7_latest 45 k

pixman x86_64 0.34.0-1.el7 ol7_latest 247 k

tigervnc-license noarch 1.8.0-25.el7_9 ol7_latest 30 k

tigervnc-server-minimal x86_64 1.8.0-25.el7_9 ol7_latest 1.0 M

ttmkfdir x86_64 3.0.9-42.el7 ol7_latest 47 k

xkeyboard-config noarch 2.24-1.el7 ol7_latest 833 k

xorg-x11-font-utils x86_64 1:7.5-21.el7 ol7_latest 104 k

xorg-x11-server-utils x86_64 7.7-20.el7 ol7_latest 178 k

xorg-x11-xinit x86_64 1.3.4-2.el7 ol7_latest 58 k

xorg-x11-xkb-utils x86_64 7.7-14.el7 ol7_latest 102 k

Transaction Summary

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

Install 2 Packages (+22 Dependent packages)

Total download size: 34 M

Installed size: 115 M

Downloading packages:

(1/24): libdrm-2.4.97-2.el7.x86_64.rpm | 151 kB 00:00:00

(2/24): libfontenc-1.1.3-3.el7.x86_64.rpm | 30 kB 00:00:00

(3/24): libglvnd-1.0.1-0.8.git5baa1e5.el7.x86_64.rpm | 89 kB 00:00:00

(4/24): libglvnd-glx-1.0.1-0.8.git5baa1e5.el7.x86_64.rpm | 124 kB 00:00:00

(5/24): libpciaccess-0.14-1.el7.x86_64.rpm | 26 kB 00:00:00

(6/24): libxkbfile-1.0.9-3.el7.x86_64.rpm | 82 kB 00:00:00

(7/24): libxshmfence-1.2-1.el7.x86_64.rpm | 6.5 kB 00:00:00

(8/24): libXfont2-2.0.3-1.el7.x86_64.rpm | 143 kB 00:00:00

(9/24): llvm-private-7.0.1-1.el7.x86_64.rpm | 23 MB 00:00:00

(10/24): mesa-dri-drivers-18.3.4-12.el7_9.x86_64.rpm | 7.2 MB 00:00:00

(11/24): mesa-libGL-18.3.4-12.el7_9.x86_64.rpm | 165 kB 00:00:00

(12/24): mesa-libglapi-18.3.4-12.el7_9.x86_64.rpm | 45 kB 00:00:00

(13/24): pixman-0.34.0-1.el7.x86_64.rpm | 247 kB 00:00:00

(14/24): mesa-filesystem-18.3.4-12.el7_9.x86_64.rpm | 18 kB 00:00:00

(15/24): tigervnc-server-1.8.0-25.el7_9.x86_64.rpm | 211 kB 00:00:00

(16/24): tigervnc-license-1.8.0-25.el7_9.noarch.rpm | 30 kB 00:00:00

(17/24): ttmkfdir-3.0.9-42.el7.x86_64.rpm | 47 kB 00:00:00

(18/24): tigervnc-server-minimal-1.8.0-25.el7_9.x86_64.rpm | 1.0 MB 00:00:00

(19/24): xkeyboard-config-2.24-1.el7.noarch.rpm | 833 kB 00:00:00

(20/24): xorg-x11-font-utils-7.5-21.el7.x86_64.rpm | 104 kB 00:00:00

(21/24): xorg-x11-fonts-Type1-7.5-9.el7.noarch.rpm | 521 kB 00:00:00

(22/24): xorg-x11-xinit-1.3.4-2.el7.x86_64.rpm | 58 kB 00:00:00

(23/24): xorg-x11-server-utils-7.7-20.el7.x86_64.rpm | 178 kB 00:00:00

(24/24): xorg-x11-xkb-utils-7.7-14.el7.x86_64.rpm | 102 kB 00:00:00

-----------------------------------------------------------------------------------------------------------------------------------------

Total 14 MB/s | 34 MB 00:00:02

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : libfontenc-1.1.3-3.el7.x86_64 1/24

Installing : libxshmfence-1.2-1.el7.x86_64 2/24

Installing : mesa-libglapi-18.3.4-12.el7_9.x86_64 3/24

Installing : pixman-0.34.0-1.el7.x86_64 4/24

Installing : 1:xorg-x11-font-utils-7.5-21.el7.x86_64 5/24

Installing : libXfont2-2.0.3-1.el7.x86_64 6/24

Installing : xorg-x11-server-utils-7.7-20.el7.x86_64 7/24

Installing : xorg-x11-xinit-1.3.4-2.el7.x86_64 8/24

Installing : 1:libglvnd-1.0.1-0.8.git5baa1e5.el7.x86_64 9/24

Installing : xkeyboard-config-2.24-1.el7.noarch 10/24

Installing : llvm-private-7.0.1-1.el7.x86_64 11/24

Installing : libxkbfile-1.0.9-3.el7.x86_64 12/24

Installing : xorg-x11-xkb-utils-7.7-14.el7.x86_64 13/24

Installing : ttmkfdir-3.0.9-42.el7.x86_64 14/24

Installing : mesa-filesystem-18.3.4-12.el7_9.x86_64 15/24

Installing : tigervnc-license-1.8.0-25.el7_9.noarch 16/24

Installing : libpciaccess-0.14-1.el7.x86_64 17/24

Installing : libdrm-2.4.97-2.el7.x86_64 18/24

Installing : mesa-dri-drivers-18.3.4-12.el7_9.x86_64 19/24

Installing : 1:libglvnd-glx-1.0.1-0.8.git5baa1e5.el7.x86_64 20/24

Installing : mesa-libGL-18.3.4-12.el7_9.x86_64 21/24

Installing : tigervnc-server-minimal-1.8.0-25.el7_9.x86_64 22/24

Installing : tigervnc-server-1.8.0-25.el7_9.x86_64 23/24

Installing : xorg-x11-fonts-Type1-7.5-9.el7.noarch 24/24

Verifying : libpciaccess-0.14-1.el7.x86_64 1/24

Verifying : 1:xorg-x11-font-utils-7.5-21.el7.x86_64 2/24

Verifying : 1:libglvnd-glx-1.0.1-0.8.git5baa1e5.el7.x86_64 3/24

Verifying : tigervnc-license-1.8.0-25.el7_9.noarch 4/24

Verifying : xorg-x11-xkb-utils-7.7-14.el7.x86_64 5/24

Verifying : mesa-filesystem-18.3.4-12.el7_9.x86_64 6/24

Verifying : ttmkfdir-3.0.9-42.el7.x86_64 7/24

Verifying : xorg-x11-xinit-1.3.4-2.el7.x86_64 8/24

Verifying : libxkbfile-1.0.9-3.el7.x86_64 9/24

Verifying : llvm-private-7.0.1-1.el7.x86_64 10/24

Verifying : xkeyboard-config-2.24-1.el7.noarch 11/24

Verifying : tigervnc-server-minimal-1.8.0-25.el7_9.x86_64 12/24

Verifying : mesa-dri-drivers-18.3.4-12.el7_9.x86_64 13/24

Verifying : 1:libglvnd-1.0.1-0.8.git5baa1e5.el7.x86_64 14/24

Verifying : libdrm-2.4.97-2.el7.x86_64 15/24

Verifying : mesa-libGL-18.3.4-12.el7_9.x86_64 16/24

Verifying : tigervnc-server-1.8.0-25.el7_9.x86_64 17/24

Verifying : xorg-x11-fonts-Type1-7.5-9.el7.noarch 18/24

Verifying : libXfont2-2.0.3-1.el7.x86_64 19/24

Verifying : pixman-0.34.0-1.el7.x86_64 20/24

Verifying : mesa-libglapi-18.3.4-12.el7_9.x86_64 21/24

Verifying : libxshmfence-1.2-1.el7.x86_64 22/24

Verifying : xorg-x11-server-utils-7.7-20.el7.x86_64 23/24

Verifying : libfontenc-1.1.3-3.el7.x86_64 24/24

Installed:

tigervnc-server.x86_64 0:1.8.0-25.el7_9 xorg-x11-fonts-Type1.noarch 0:7.5-9.el7

Dependency Installed:

libXfont2.x86_64 0:2.0.3-1.el7 libdrm.x86_64 0:2.4.97-2.el7

libfontenc.x86_64 0:1.1.3-3.el7 libglvnd.x86_64 1:1.0.1-0.8.git5baa1e5.el7

libglvnd-glx.x86_64 1:1.0.1-0.8.git5baa1e5.el7 libpciaccess.x86_64 0:0.14-1.el7

libxkbfile.x86_64 0:1.0.9-3.el7 libxshmfence.x86_64 0:1.2-1.el7

llvm-private.x86_64 0:7.0.1-1.el7 mesa-dri-drivers.x86_64 0:18.3.4-12.el7_9

mesa-filesystem.x86_64 0:18.3.4-12.el7_9 mesa-libGL.x86_64 0:18.3.4-12.el7_9

mesa-libglapi.x86_64 0:18.3.4-12.el7_9 pixman.x86_64 0:0.34.0-1.el7

tigervnc-license.noarch 0:1.8.0-25.el7_9 tigervnc-server-minimal.x86_64 0:1.8.0-25.el7_9

ttmkfdir.x86_64 0:3.0.9-42.el7 xkeyboard-config.noarch 0:2.24-1.el7

xorg-x11-font-utils.x86_64 1:7.5-21.el7 xorg-x11-server-utils.x86_64 0:7.7-20.el7

xorg-x11-xinit.x86_64 0:1.3.4-2.el7 xorg-x11-xkb-utils.x86_64 0:7.7-14.el7

Complete!

[opc@testt1 ~]$ vncserver

You will require a password to access your desktops.

Password:

Verify:

Would you like to enter a view-only password (y/n)? y

Password:

Verify:

xauth: file /home/opc/.Xauthority does not exist

New 'testt1:1 (opc)' desktop is testt1:1

Creating default startup script /home/opc/.vnc/xstartup

Creating default config /home/opc/.vnc/config

Starting applications specified in /home/opc/.vnc/xstartup

Log file is /home/opc/.vnc/testt1:1.log

[opc@testt1 ~]$ ps -ef | grep -i vnc

opc 41667 1 0 16:26 pts/1 00:00:00 /usr/bin/Xvnc :1 -auth /home/opc/.Xauthority -desktop testt1:1 (opc) -fp catalogue:/etc/X11/fontpath.d -geometry 1024x768 -pn -rfbauth /home/opc/.vnc/passwd -rfbport 5901 -rfbwait 30000

opc 43054 39215 0 16:27 pts/1 00:00:00 grep --color=auto -i vnc

[opc@testt1 ~]$

Wednesday, 12 July 2023

Some Important MOS DOC ID for Oracle Real Application Testing (RAT)

Real Application Testing: Database Capture FAQ (Doc ID 1920275.1)

FAQ: Database Upgrade Using Real Application Testing (Doc ID 1600574.1)

Real Application Testing: Database Replay FAQ (Doc ID 2204090.1)

Database Testing: Best Practices (Doc ID 1535885.1)

Primary Note for Real Application Testing Option (Doc ID 1464274.1)

Database Testing: Best Practices (Doc ID 1535885.1)

Real Application Testing: Database Replay FAQ (Doc ID 2204090.1)

Mandatory Patches for Database Testing Functionality for Current and Earlier Releases (Doc ID 560977.1)

How To Find Database Replay Divergence Details (RAT) (Doc ID 1388309.1)

Scripts to Debug Slow Replay (Doc ID 760402.1)

Comprehensive Database Real Application Testing Diagnostic Information (Doc ID 1287620.1)

Database Capture and Replay: Common Errors and Reasons (Doc ID 463263.1)

Slow Database Replay with Waits on “WCR: replay clock” (Doc ID 1538269.1)

Real Application Testing: How to Run Workload Analyzer (Doc ID 1268920.1)

Dbms_Stats.Gather_Fixed_Object_Stats Is Hanging While Reading X$DBKFDG (Doc ID 2417784.1)

Tuesday, 4 July 2023

WGET Command to download any patchs or binary from Oracle Support site in Linux.

Hello Friends,

First you need to search patch or binary from oracle support or MOS. Once you get it, click on download, right click on the patch and copy URL and update the same URL in highlighted yellow portions.

Also you need update your oracle support login ID and password in highlighted sky blue portion.

Once Command is ready put the same in Linux prompt where you have internet access it will start to download the file.

wget --http-user=<userid>@oracle.com --http-password=<SomePassword> --no-check-certificate --output-document=p35042068_190000_Linux-x86-64.zip "https://updates.oracle.com/Orion/Services/download/p35042068_190000_Linux-x86-64.zip?aru=12345678&patch_file=p35042068_190000_Linux-x86-64.zip"

Silent Mode - Oracle Database Installation and DB creation.

Steps to install oracle 11g and Database silent mode .

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

--- Silent DB Binary Installation on File System.

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

cat /tmp/db_install.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=instance-20230630-1255

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/ora11g/oracle/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/ora11g/oracle/product/11g/dbhome_1

ORACLE_BASE=/ora11g/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.DBA_GROUP=dba

oracle.install.db.BACKUPDBA_GROUP=dba

oracle.install.db.DGDBA_GROUP=dba

oracle.install.db.KMDBA_GROUP=dba

oracle.install.db.OSRACDBA_GROUP=dba

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

oracle.installer.autoupdates.option=SKIP_UPDATES

./runInstaller -silent -responseFile /tmp/db_install.rsp

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

--- Silent DB creation on File System.

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

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11g/dbhome_1

export ORA_INVENTORY=/u01/app/oraInventory

export PATH=/usr/sbin:/usr/local/bin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export ORACLE_SID=ORCL11G

export DATA_DIR=/u01/app/oracle/oradata/ORCL11G

dbca -silent -createDatabase \

-templateName $ORACLE_BASE/product/11g/dbhome_1/assistants/dbca/templates/General_Purpose.dbc \

-gdbname ${ORACLE_SID} -sid ${ORACLE_SID} -responseFile NO_VALUE \

-characterSet AL32UTF8 \

-sysPassword SysPassword \

-systemPassword SysPassword \

-databaseType MULTIPURPOSE \

-totalMemory 4096 -automaticMemoryManagement true \

-storageType FS \

-datafileDestination "${DATA_DIR}" \

-redoLogFileSize 50 \

-emConfiguration NONE

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

--- Silent DB creation on File System with 11g EM.

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

dbca -silent -createDatabase -templateName /ora11g/oracle/product/11g/dbhome_3/assistants/dbca/templates/General_Purpose.dbc -gdbname oratdb -sid oratdb -responseFile NO_VALUE -characterSet AL32UTF8 -totalMemory 4096 -automaticMemoryManagement true -emConfiguration LOCAL -datafiledestination /u01/app/oracle/oradata/ora11g -sysPassword Oracle123 -systemPassword Oracle123 -dbsnmpPassword Oracle123 -sysmanPassword Oracle123

Friday, 30 June 2023

How to Enable X11 in Linux

┌───────────────────────────────────────────────────┐

│ • MobaXterm Personal Edition v22.0 • │

│ (SSH client, X server and network tools) │

│ │

│ ➤ SSH session to opc@XXXXXX │

│ • Direct SSH : ✔ │

│ • SSH compression : ✔ │

│ • SSH-browser : ✔ │

│ • X11-forwarding : ✘ (disabled or not supported by server) │

│ │

│ ➤ For more info, ctrl+click on help or visit our website. │

└───────────────────────────────────────────────────┘

Activate the web console with: systemctl enable --now cockpit.socket

[root@instance ~]# sudo yum install xorg-x11-xauth

Last metadata expiration check: 0:02:38 ago on Fri 30 Jun 2023 07:43:21 AM GMT.

Dependencies resolved.

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

Package Architecture Version Repository Size

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

Installing:

xorg-x11-xauth x86_64 1:1.0.9-12.el8 ol8_appstream 39 k

Installing dependencies:

libICE x86_64 1.0.9-15.el8 ol8_appstream 74 k

libSM x86_64 1.2.3-1.el8 ol8_appstream 47 k

libXmu x86_64 1.1.3-1.el8 ol8_appstream 75 k

libXt x86_64 1.1.5-12.el8 ol8_appstream 185 k

Transaction Summary

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

Install 5 Packages

Total download size: 421 k

Installed size: 1.0 M

Is this ok [y/N]: y

Downloading Packages:

(1/5): libSM-1.2.3-1.el8.x86_64.rpm 432 kB/s | 47 kB 00:00

(2/5): libICE-1.0.9-15.el8.x86_64.rpm 544 kB/s | 74 kB 00:00

(3/5): libXt-1.1.5-12.el8.x86_64.rpm 2.6 MB/s | 185 kB 00:00

(4/5): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm 656 kB/s | 39 kB 00:00

(5/5): libXmu-1.1.3-1.el8.x86_64.rpm 253 kB/s | 75 kB 00:00

----------------------------------------------------------------------------------------------------------------------------------

Total 1.4 MB/s | 421 kB 00:00

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing : libICE-1.0.9-15.el8.x86_64 1/5

Installing : libSM-1.2.3-1.el8.x86_64 2/5

Installing : libXt-1.1.5-12.el8.x86_64 3/5

Installing : libXmu-1.1.3-1.el8.x86_64 4/5

Installing : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 5/5

Running scriptlet: xorg-x11-xauth-1:1.0.9-12.el8.x86_64 5/5

Verifying : libICE-1.0.9-15.el8.x86_64 1/5

Verifying : libSM-1.2.3-1.el8.x86_64 2/5

Verifying : libXmu-1.1.3-1.el8.x86_64 3/5

Verifying : libXt-1.1.5-12.el8.x86_64 4/5

Verifying : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 5/5

Installed:

libICE-1.0.9-15.el8.x86_64 libSM-1.2.3-1.el8.x86_64 libXmu-1.1.3-1.el8.x86_64 libXt-1.1.5-12.el8.x86_64

xorg-x11-xauth-1:1.0.9-12.el8.x86_64

Complete!

[root@instance ~]# sudo yum install xterm

Last metadata expiration check: 0:02:48 ago on Fri 30 Jun 2023 07:43:21 AM GMT.

Dependencies resolved.

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

Package Architecture Version Repository Size

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

Installing:

xterm x86_64 331-1.el8_3.2 ol8_appstream 528 k

Installing dependencies:

libXaw x86_64 1.0.13-10.el8 ol8_appstream 194 k

libXft x86_64 2.3.3-1.el8 ol8_appstream 67 k

libXpm x86_64 3.5.12-9.el8_7 ol8_appstream 58 k

libfontenc x86_64 1.1.3-8.el8 ol8_appstream 37 k

xorg-x11-font-utils x86_64 1:7.5-41.el8 ol8_appstream 104 k

xterm-resize x86_64 331-1.el8_3.2 ol8_appstream 38 k

Installing weak dependencies:

xorg-x11-fonts-misc noarch 7.5-19.el8 ol8_appstream 5.8 M

Transaction Summary

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

Install 8 Packages

Total download size: 6.8 M

Installed size: 9.5 M

Is this ok [y/N]: y

Downloading Packages:

(1/8): libXpm-3.5.12-9.el8_7.x86_64.rpm 748 kB/s | 58 kB 00:00

(2/8): libXaw-1.0.13-10.el8.x86_64.rpm 1.1 MB/s | 194 kB 00:00

(3/8): libXft-2.3.3-1.el8.x86_64.rpm 386 kB/s | 67 kB 00:00

(4/8): libfontenc-1.1.3-8.el8.x86_64.rpm 375 kB/s | 37 kB 00:00

(5/8): xterm-331-1.el8_3.2.x86_64.rpm 4.9 MB/s | 528 kB 00:00

(6/8): xorg-x11-font-utils-7.5-41.el8.x86_64.rpm 819 kB/s | 104 kB 00:00

(7/8): xterm-resize-331-1.el8_3.2.x86_64.rpm 377 kB/s | 38 kB 00:00

(8/8): xorg-x11-fonts-misc-7.5-19.el8.noarch.rpm 19 MB/s | 5.8 MB 00:00

----------------------------------------------------------------------------------------------------------------------------------

Total 14 MB/s | 6.8 MB 00:00

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing : libXpm-3.5.12-9.el8_7.x86_64 1/8

Installing : libXaw-1.0.13-10.el8.x86_64 2/8

Installing : xterm-resize-331-1.el8_3.2.x86_64 3/8

Installing : libfontenc-1.1.3-8.el8.x86_64 4/8

Installing : xorg-x11-font-utils-1:7.5-41.el8.x86_64 5/8

Installing : xorg-x11-fonts-misc-7.5-19.el8.noarch 6/8

Running scriptlet: xorg-x11-fonts-misc-7.5-19.el8.noarch 6/8

Installing : libXft-2.3.3-1.el8.x86_64 7/8

Installing : xterm-331-1.el8_3.2.x86_64 8/8

Running scriptlet: xterm-331-1.el8_3.2.x86_64 8/8

Verifying : libXaw-1.0.13-10.el8.x86_64 1/8

Verifying : libXft-2.3.3-1.el8.x86_64 2/8

Verifying : libXpm-3.5.12-9.el8_7.x86_64 3/8

Verifying : libfontenc-1.1.3-8.el8.x86_64 4/8

Verifying : xorg-x11-font-utils-1:7.5-41.el8.x86_64 5/8

Verifying : xorg-x11-fonts-misc-7.5-19.el8.noarch 6/8

Verifying : xterm-331-1.el8_3.2.x86_64 7/8

Verifying : xterm-resize-331-1.el8_3.2.x86_64 8/8

Installed:

libXaw-1.0.13-10.el8.x86_64 libXft-2.3.3-1.el8.x86_64 libXpm-3.5.12-9.el8_7.x86_64

libfontenc-1.1.3-8.el8.x86_64 xorg-x11-font-utils-1:7.5-41.el8.x86_64 xorg-x11-fonts-misc-7.5-19.el8.noarch

xterm-331-1.el8_3.2.x86_64 xterm-resize-331-1.el8_3.2.x86_64

Complete!

[root@instance ~]#

DisplayAdd1

TechnoTechDB

Tuesday, 19 December 2023

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

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

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.

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

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

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

Monday, 18 December 2023

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

Wednesday, 13 December 2023

How to fix CheckName: TBLSPACE_FLASHBACK_OFF issue during Oracle Auto Upgrade

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

Tuesday, 26 September 2023

How to install VNC in Linux

Wednesday, 12 July 2023

Some Important MOS DOC ID for Oracle Real Application Testing (RAT)

Tuesday, 4 July 2023

WGET Command to download any patchs or binary from Oracle Support site in Linux.

Silent Mode - Oracle Database Installation and DB creation.

Friday, 30 June 2023

How to Enable X11 in Linux

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

Report Abuse

Labels

DisplayAdd1

Tuesday, 19 December 2023

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.

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

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

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

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

Monday, 18 December 2023

Wednesday, 13 December 2023

SQL> select name, flashback_on from v$tablespace ;NAME FLA------------------------------ ---SYSTEM YESSYSAUX YESUNDOTBS1 YESTEMP YESUSERS YESDATA_SCOTT NOINDX_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 bytesFixed Size 12178656 bytesVariable Size 1.6643E+10 bytesDatabase Buffers 1.5502E+10 bytesRedo Buffers 54927360 bytesDatabase 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 YESSYSAUX YESUNDOTBS1 YESTEMP YESUSERS YESDATA_SCOTT YESINDX_SCOTT YES

Tuesday, 26 September 2023

Wednesday, 12 July 2023

Tuesday, 4 July 2023

Friday, 30 June 2023

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

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