Database & Cloud – Page 6 – Finding the right solutions

Expdp and event ‘Streams AQ: enqueue blocked on low memory’

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 w...

05/07/2018Oracle4,986 viewsComments

Allow access to shared folder anonymously on Windows 10

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/testmount.cifs kernel mount options: ...

24/06/20183,128 viewsComments

Got ORA-28500 during ODBC configuration from Oracle 10g to MySQL

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...

21/06/2018Oracle1,313 viewsComments

‘lsnrctl status’ could not display the status of running listener correctly

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 th...

11/06/2018Oracle1,101 views1

ORA-12547 and sysctl -p

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 no...

11/06/2018Linux271 viewsComments

Systemd service was terminated abnormally during reboot

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...

10/06/2018Linux1,481 viewsComments

Will store all my database related scripts on GitHub

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 or...

08/06/2018Life123 viewsComments

du: option requires an argument — ‘X’

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# ...

03/06/2018Linux601 viewsComments

How to create udev rules of storage devices for ASM usage

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...

21/05/2018Linux1,442 viewsComments

Some strange behaviours of parted

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 partit...

16/05/2018Linux401 viewsComments

Register

Login

Retrieve password