Oracle – Page 3 – Database & Cloud

How to fix permission issues of Oracle RAC?

In last month, one engineer of our customers made a mistake and changed the file permissions of the whole RAC database wrongly, including GI and DB home.Of course the clusterware could not be star...

10/11/2020Oracle5,811 viewsComments

How to recreate the lost ASM password in Oracle Clusterware?

Last night my friend called me to check the network service issue after she added two SCAN IPs to one RAC system.She added these two IPs to resolve load balance issue as the customer found the con...

04/07/2021Oracle1,554 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

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

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

NFS Lock issue in NetApp NAS Server

On Jan 16, one Linux server crashed and the Oracle database could not be opened after server reboot, the prompt was the file was used by other process. It was surprising as we had restarted the serve...

24/01/20152,962 viewsComments

Read workshop of 12c now

I have read the new features of 12c for DBA, today begin to read workshop for guides. I plan to read the workshop first, then read the new features again, and after that, I will take the upgrade test ...

30/12/2015Oracle129 viewsComments

Pass the 1Z0-060 today

Today I took the 1Z0-060 test and passed it finally.I did feel great pressure before the test, as I still had so many things to learn until last night. I spent the whole last night to confirm some...

18/01/2016Oracle85 viewsComments

Have to postpone the test of 1Z0-068

Need more time to learn the RAC administration, and more practices to master it, so have to postpone the test to Next Wednesday.Hope I can pass it successfully....

15/02/2016Oracle219 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

Register

Login

Retrieve password