Oracle – Page 3 – Database & Cloud

CIFS VFS: No response to cmd

I never thought mounting a shared filesystem maybe cause server reboot!One node in a three-node RAC database was rebooted without any reason, and I was contacted to find the possible reason.I ...

28/01/2018Linux819 viewsComments

Use GNS with Bind9 and DHCP in Oracle GI 12c

These days I tried to install my first Oracle 12c RAC in my test environment, and wanted to experience some new features I have not used before.I have been a Linux SA in several years ago, so at f...

30/01/2016Oracle584 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

Compile my first Pro*C program — unloader from asktom

These days I needed to export some tables to CSV files, and usually I could finish such task using SQLcl, but this time the table is too big (more than 120G) so although I still could export it with S...

29/04/2017Oracle478 viewsComments

Perl and new Intel CPUs with 4 level cache

Last day I took a task to fix a network issue about Oracle 12c on Windows.At the beginning, I though it was a misconfiguration issue, and could be fixed within one hour, or in some special situati...

22/02/2017Oracle441 viewsComments

Some issues during the Oracle RAC installation on openSUSE 15.2

In last week, I installed an Oracle RAC on openSUSE 15.2 and got some issues. Although the installation was successful finally, it still took me much more time than the same thing on RHEL.I list t...

17/08/2020Oracle386 viewsComments

SPFILE in RAC environments

Shared SPFILE is recommended strongly in RAC environment, and I want to tell you the reason in this post.The test environment is Oracle 12c 12.1.0.2, and the installed PSU is 21948354. SQL> se...

16/04/2016Oracle333 viewsComments

Could I ignore the SID clause in command ‘alter system’?

When we change the parameters in the RAC systems, I always recommend to specify the SID clause clearly, which means you know which or all instances will be modified.If you ignore it, the result wi...

26/08/2021Oracle275 viewsComments

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/2018Oracle271 viewsComments

Object dependence in Oracle

This afternoon I implemented a change to add a column to a table, then Wintel team did some tasks and asked application team to verify the update. After some minutes we got a S2 ticket from the user ...

17/12/2014Oracle270 viewsComments

Register

Login

Retrieve password