Database & Cloud

Our daily expdp backup job became abnormally and it would last more than one day, while in the past it just took about 40 minutes. From the v$session view I found the expdp related processes were wait...

These days we tried to mount a shared folder on RHEL5 but always got below error: [root@olinux511 /]# mount -t cifs -v -o guest,ro //192.168.56.1/Tools /tmp/test mount.cifs kernel mount options: unc=/...

These days I tried to configure ODBC to access MySQL from Oracle 10g, and I believed all of my configurations were correct, while when I run a select statement from Oracle database, I always got below...

My friend got this issue and wanted to know the reason, so I built a test VM to verify it. The dbss scirpt was used to start their instances and he found if he run 'dbss start' then he could get the c...

This night I installed an Oracle 12c database on SLES12SP3 to test the dbss script on SLES system and found it worked well until I rebooted the server. After the reboot, I found the database was not o...

To start/stop all the instances on a server, I created a script named dbss (database start/stop) and it worked well on AIX, RHEL5/6 and SLES11, while I found it could not work on RHEL7/SLES12 with sys...

I will rewrite all my database related scripts and store them on the GitHub in this year. Will update them one by one as below order: orabackup  --> one script for all database backup oraprep  --&g...

Several days ago I encountered this little issue and I found it was very interesting. :) I got a capacity issue and when I run 'du -sh *' I got error message similar with below: root@debian:/tmp# du -...

When I install the Grid Infrastructure(GI), usually I need to configure the udev rule for the storage devices to get a persistent device names and set the right owner, group and permissions on them fo...

Last night when I made partitions of one large 3T flash disk, I got some issues with the parted command. The flash disk would be used as an Oracle ASM disk, so I preferred to split it to two partition...