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...
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 ...
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...
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:
# /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.0/grid/OPatch/cr...
OracleWonderful 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...
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...
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...
‘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...
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...
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...
5