database-assessment

database-assessment copied to clipboard

Enhancement Request Details

As a waverunner user I want to validate that if source environment is RMAN compatible .

Query to validate source platform compatibility:

For Oracle database 12.2 and lower versions:

set lines 200 pages 999 col platform_name for a30 col version_full for a20 col compatible_full for a20 Col support_status for a15 with vsrcinfo as ( SELECT platform_id, platform_name, (SELECT version FROM product_component_version where product like '%Oracle%Database%') version_full, (SELECT substr(version,1,2) FROM product_component_version where product like '%Oracle%Database%') version_first_digit, (SELECT substr(version,4,1) FROM product_component_version where product like '%Oracle%Database%') version_second_digit, (select value from v$parameter where name = 'compatible') compatible_full, (select substr(value,1,2) from v$parameter where name = 'compatible') compatible_first_digit, (select substr(value,4,1) from v$parameter where name = 'compatible') compatible_second_digit FROM v$database ) SELECT platform_id, platform_name, version_full, compatible_full, case when platform_name = 'Solaris Operating System (x86-64)' and to_number(version_first_digit) = 10 and to_number(version_second_digit) > 2 then 'SUPPORTED' when platform_name = 'Solaris Operating System (x86-64)' and to_number(version_first_digit) > 10 then 'SUPPORTED' when platform_name = 'Microsoft Windows x86 64-bit' and to_number(version_first_digit) = 11 and to_number(version_second_digit) >= 1 and to_number(compatible_first_digit) = 11 and to_number(compatible_second_digit) >= 1 then 'SUPPORTED' when platform_name = 'Microsoft Windows x86 64-bit' and to_number(version_first_digit) > 11 and to_number(compatible_first_digit) = 11 and to_number(compatible_second_digit) >= 1 then 'SUPPORTED' when platform_name = 'Microsoft Windows x86 64-bit' and to_number(version_first_digit) > 11 and to_number(compatible_first_digit) > 11 then 'SUPPORTED' when platform_name = 'Linux x86 64-bit' then 'SUPPORTED' else 'NOT_SUPPORTED' end as SUPPORT_STATUS from vsrcinfo; For Oracle database 18.0 and above versions (table structure changed):

col platform_name for a30 col version_full for a20 col compatible_full for a20 Col support_status for a15 with vsrcinfo as ( SELECT platform_id, platform_name, (SELECT version_full FROM product_component_version where product like '%Oracle%Database%') version_full, (SELECT substr(version_full,1,2) FROM product_component_version where product like '%Oracle%Database%') version_first_digit, (SELECT substr(version_full,4,1) FROM product_component_version where product like '%Oracle%Database%') version_second_digit, (select value from v$parameter where name = 'compatible') compatible_full, (select substr(value,1,2) from v$parameter where name = 'compatible') compatible_first_digit, (select substr(value,4,1) from v$parameter where name = 'compatible') compatible_second_digit FROM v$database ) SELECT platform_id, platform_name, version_full, compatible_full, case when platform_name = 'Solaris Operating System (x86-64)' and to_number(version_first_digit) = 10 and to_number(version_second_digit) > 2 then 'SUPPORTED' when platform_name = 'Solaris Operating System (x86-64)' and to_number(version_first_digit) > 10 then 'SUPPORTED' when platform_name = 'Microsoft Windows x86 64-bit' and to_number(version_first_digit) = 11 and to_number(version_second_digit) >= 1 and to_number(compatible_first_digit) = 11 and to_number(compatible_second_digit) >= 1 then 'SUPPORTED' when platform_name = 'Microsoft Windows x86 64-bit' and to_number(version_first_digit) > 11 and to_number(compatible_first_digit) = 11 and to_number(compatible_second_digit) >= 1 then 'SUPPORTED' when platform_name = 'Microsoft Windows x86 64-bit' and to_number(version_first_digit) > 11 and to_number(compatible_first_digit) > 11 then 'SUPPORTED' when platform_name = 'Linux x86 64-bit' then 'SUPPORTED' else 'NOT_SUPPORTED' end as SUPPORT_STATUS from vsrcinfo;

Version

None

What oracle database version are you seeing the problem on?

None

Which sql script version ?

None

Relevant log output

No response

@wpuziewicz Can you take a look at this? Maybe we can pull it in for 4.3.2?

This request can be fulfilled using data we already collect. We can add the SQL to the loader or we can put it in the report.