Oracle – Page 2 – Database & Cloud

VirtualBox VM caused system hung after laptop upgrade

In last week I upgraded my laptop from T420s to E485 to get maximum 32G memory also because the T420s was so old and the cooling system worked inefficiently, so during the summer it would become slowe...

10/06/2019Linux129 viewsComments

How to restore a database with hot backup and without resetlogs?

Normally when we restore the hot backup of a database, we will recover and open it with resetlogs option because during the restore procedure we have to restore the control file first.Last week I ...

06/05/2019Oracle518 viewsComments

ACFS-9459 & ACFS on Oracle 11.2.0.4 and RHEL7.4

Sometimes, when I installed the Oracle GI and run the asmca, I could create volume and acfs easily, while I never know the background of such things.This time, I need to create a shared cluster fi...

23/02/2019Linux1,307 viewsComments

Patch Set Update 11.2.0.4.190115 will not be installed on the GI home using opatch auto

First of all, let me show you the installation log: [root@node2 tmp]# /u01/app/11.2.0/grid/OPatch/opatch auto 28813878 -ocmrf /u01/ocm.rsp Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2....

22/02/2019Oracle1,258 viewsComments

Wonderful SQL format tool — SQL Pretty Printer

I tried to find a perfect SQL format tool for a long long time, while all the attempts failed until I found this one: SQL Pretty Printer.The online edition is here. It has many options and I think...

17/09/2018247 viewsComments

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

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

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,616 viewsComments

Register

Login

Retrieve password