Welcome to DBCloudSVC!
  • About…
Database & Cloud Database & Cloud Finding the right solutions
  • About…
bj
登录
站内

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 will ...
NeilZhang 26/08/2021Oracle275评论parameter spfile
Read More...

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 connec...
NeilZhang 04/07/2021Oracle1,554评论ASM Clusterware
Read More...

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 started...
NeilZhang 10/11/2020Oracle5,811评论Cluster GI
Read More...

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 them...
NeilZhang 17/08/2020Oracle386评论Clusterware openSUSE
Read More...

Install Oracle 11gR2 on RHEL8

First of all, I do not recommend to install Oracle 11gR2 on RHEL8, especially in the production environments. While if you have to do such installation for test or data migration, then you could refer...
NeilZhang 09/07/2020Oracle3,877评论11gR2 RHEL8
Read More...

Archivelog backups were not removed per backup policy

Suddenly our support guys found some archivelog backups were not deleted even they were not needed by the backup policy ( recover window of 7 days). At the beginning I thought maybe it was a similar i...
NeilZhang 30/11/2019Oracle150评论archivelog backup
Read More...

Talking about ‘recovery window of 7 days’

Sometimes we will keep the database backup for one week and set the retention policy to 'recovery window of 7 days'. So we will only keep the database backup for 7 days, right? In fact, it depends. If...
NeilZhang 05/10/2019Oracle233评论
Read More...

ORA-27102 out of memory on a system with huge memory

Today one customer said the data sync of Oracle Dataguard had issue and our guys checked the alert log then sent below errors to me: ORA-01034: ORACLE not available ORA-27102: out of memory Linux-x86_...
NeilZhang 23/07/2019Oracle1,744评论HugePage ORA-27102
Read More...

Maybe a dangerous configuration of ASM diskgroup with Normal Redundancy

These days my friend Zhiguo discussed with me about the vote disk issue of Normal Redundancy ASM disk group and I found maybe I made a big mistake. Nowadays more and more customers install two SSD dis...
NeilZhang 11/07/2019Oracle193评论ASM vote disk
Read More...

Key points for Oracle RAC patching

Several weeks ago I patched a 12.2 Oracle RAC and got several issues, I realized there were some key points I should follow during the RAC patching and list them here. 1. When patching the whole syste...
NeilZhang 16/06/2019Oracle134评论
Read More...

文章分页

1 2 3 … 5

添加小工具

点此为“分类归档侧边栏”添加小工具

Copyright © DBCloudSVC All rights reserved.

  • 繁
  • Database & Cloud Database & Cloud 本页二维码