Database & Cloud – Page 6 – Finding the right solutions

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,251 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/2018Linux1,060 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/2018Linux237 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,400 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/2018Life112 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/2018Linux567 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,339 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/2018Linux382 viewsComments

How to resolve inaccessible disc images in VirtualBox?

Sometimes when I moved or deleted some operating system installation discs, I found I could not release it in the VirtualBox, even I had detached it from all the Virtual Machines.So it was a littl...

25/04/2018244 viewsComments

ORA-29382 or ORA-06512 during database upgrade from 11.1 to 12.1

Last year, when I was migrating/upgrading a huge Oracle database from 11.1 to 12.1, I encountered one really tough issue and I found the reason after several months.The error messages were like th...

18/04/2018Oracle1,522 viewsComments

Register

Login

Retrieve password