Best Of
Re: adding different sized disks to an existing disk group (normal redundancy) on an Oracle 19c cluster
You will need to perform the operation via SQL*Plus using the ALTER DISKGROUP command. This error is caused by an intentional Oracle ASM validation check that enforces uniform disk sizes within an existing normal redundancy disk group where all current members are equally sized. The solution is to explicitly instruct ASM to use only a portion of the new disks that matches the size of the existing 4TB disks by adding the SIZE clause to your command. You must specify a size that precisely matches the TOTAL_MB of your current disks (e.g., SIZE 4096G), which will effectively make the new disks appear as 4TB to ASM, thus satisfying the requirement for uniformity. For proper redundancy, it is also critical to add each new disk into its own new failgroup. This specific operation bypasses the ASMCA GUI limitation and allows the disk group to be extended successfully.
FYI: Based on the error message and your description, the issue stems from a specific feature introduced in Oracle ASM version 12.1.0.2. This feature enforces a check that prevents the addition of disks of a different size to a normal or high redundancy disk group if all the existing disks in that group are of an equal size.
Re: Standby Active Duplicate Fails With ORA-19661: datafile 3 could not be verified due to corrupt block
Hi,
There is a very good document to build standby database without any issue. So i strongly recommend you to follow the below document to build the standby without any deviation.
Creating a Physical Standby database using RMAN restore database from service (Doc ID 2283978.1)
Thanks
Sethu
Re: ADAPEXSCHREG.sql
Hi,
I have some information that it will be included in the next patch, or something like that.
Patch: 36839803: ORACLE APEX INTEGRATION ENHANCEMENT
Regards,
asahide
Re: where can i find doc id 2038801.1 ?
Hi
There is an outage in MOS at the moment, it will be resolved soon and you can see the Note.
Best Regards,
Bharat
Re: AR Collection Issue (APP-AST-207338: Your resource does not have a valid role type and role assigned
This Solution works..
Make sure you Import first (Import Resources) if Resource is not available.
Navigate to Resource Manager > Import Resources.
Continue with …Navigate to Resource Manager > Resources
Re: AR Collection Issue (APP-AST-207338: Your resource does not have a valid role type and role assigned
Thanks the solution is working...
Regards,
Shankar
Re: Query for PTAEO Combinations
To expand on what J has provided, this will include the award information also.
select Distinct gaa.award_number, pp.segment1 project_number, pt.task_number, peia.expenditure_type, hou.name Organization
from pa_expenditure_items_all peia, pa_expenditures_all pe, hr_all_organization_units hou, pa_projects_all pp, pa_tasks pt
, gms_award_distributions gad
, gms_awards_all gaa
where peia.project_id = pp.project_id
and peia.task_id = pt.task_id
and hou.organization_id = nvl(override_to_organization_id, incurred_by_organization_id)
and peia.expenditure_id = pe.expenditure_id
and peia.expenditure_item_id = gad.expenditure_item_id
and gad.award_id = gaa.award_id
order by award_number, pp.segment1, pt.task_number;
Regards,
Shane
