![\"Empty](\"https:\/\/kingbase-bbs.oss-cn-beijing.aliyuncs.com\/qywx\/blogImage\/2883626b-09b4-4009-bdc2-636b687ab8e1.webp\")
<\/p>\n<\/p>\n
Reducing Oracle licensing costs requires a technical strategy that addresses structural licensing metrics, such as processor core factors and virtualization rules, which inflate Total Cost of Ownership (TCO). This checklist provides a structured, executable procedure for migrating to KingbaseES, a commercial database software, focusing on compatibility verification, data integrity, and rollback procedures.<\/p>\n
KingbaseES V009R002C012 enhances Oracle compatibility in SQL, PL\/SQL, and client interfaces. To enable this mode, configure the database instance parameters.<\/p>\n
Set Compatibility Parameter:<\/strong> Restart Instance:<\/strong> Verify Configuration:<\/strong> Expected Output:<\/em> KingbaseES supports specific PL\/SQL features to minimize refactoring. Verify the following constructs in your source code and target environment.<\/p>\n Update and verify SQL queries using compatible functions supported in KingbaseES V009R002C012.<\/p>\n Replace Oracle-specific system view queries with KingbaseES equivalents. V009R002C012 supports the following views for migration auditing:<\/p>\n Verification Query:<\/strong><\/p>\n Perform checksum comparisons to ensure data integrity between Oracle and KingbaseES.<\/p>\n In case of critical failure, revert to the Oracle environment using the following steps.<\/p>\n Set the Use checksum functions like Stop KingbaseES services, restore the Oracle database from the pre-migration backup using RMAN or similar tools, and verify Oracle availability.<\/p>\n Yes, KingbaseES V009R002C012 supports views such as KingbaseES supports initialization of nested tables and VARRAYs using the \ud83d\udca1 More Resources<\/strong><\/p>\n If you would like to dive deeper into KingbaseES and its application practices across various industries, we have compiled the following official resources to help you get started quickly and develop and operate with efficiency:<\/p>\n Open Source Resources:<\/strong><\/p>\n Welcome to explore the resources above and begin your Kingbase journey!<\/p>\n","protected":false},"excerpt":{"rendered":" Enterprise Reduce Oracle Licensing Cost: Technical Migration Checklist Reducing Oracle licensing costs requires a technical strategy that addresses structural licensing metrics, such as processor core factors and virtualization rules, which…<\/p>\n","protected":false},"author":1239,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"meta_description":"","_kingbase_seo_description":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1552","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.kingbaseglobal.com\/blog\/wp-json\/wp\/v2\/posts\/1552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kingbaseglobal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kingbaseglobal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kingbaseglobal.com\/blog\/wp-json\/wp\/v2\/users\/1239"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kingbaseglobal.com\/blog\/wp-json\/wp\/v2\/comments?post=1552"}],"version-history":[{"count":0,"href":"https:\/\/www.kingbaseglobal.com\/blog\/wp-json\/wp\/v2\/posts\/1552\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.kingbaseglobal.com\/blog\/wp-json\/wp\/v2\/media?parent=1552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kingbaseglobal.com\/blog\/wp-json\/wp\/v2\/categories?post=1552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kingbaseglobal.com\/blog\/wp-json\/wp\/v2\/tags?post=1552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nExecute the following SQL command to set the compatibility level to Oracle:<\/p>\nALTER SYSTEM SET compatibility_mode = 'oracle';\n<\/code><\/pre>\n<\/li>\n
\nRestart the KingbaseES instance to apply the configuration changes.<\/p>\n# Example command for service restart\nsystemctl restart kingbasees\n<\/code><\/pre>\n<\/li>\n
\nCheck the current compatibility setting:<\/p>\nSHOW compatibility_mode;\n<\/code><\/pre>\noracle<\/code><\/p>\n<\/li>\n<\/ol>\nStep 2: Migrate and Validate PL\/SQL Packages<\/h3>\n
\n
NEW<\/code> keyword.\n\n
-- Example PL\/SQL block for verification\nDECLARE\n TYPE nested_table_type IS TABLE OF VARCHAR2(100);\n nt nested_table_type := nested_table_type();\nBEGIN\n nt := nested_table_type('A', 'B'); -- Verify NEW initialization compatibility\n DBMS_OUTPUT.PUT_LINE('Nested Table Init OK');\nEND;\n<\/code><\/pre>\n<\/li>\n%ROWTYPE<\/code> parameters execute without type mismatch errors.<\/li>\nDETERMINISTIC<\/code> keyword is declared in the package header.\n-- Verify package header declaration\nCREATE OR REPLACE PACKAGE test_pkg IS\n FUNCTION calc_value(p_id NUMBER) RETURN NUMBER DETERMINISTIC;\nEND test_pkg;\n<\/code><\/pre>\n<\/li>\nPARALLEL_ENABLE<\/code> subclauses allow safe multi-process calls.<\/li>\nStep 3: Adapt and Verify SQL Syntax<\/h3>\n
\n
CONCAT<\/code> with arbitrary arguments.\n-- Verify flexible CONCAT\nSELECT CONCAT('A', 'B', 'C') FROM dual;\n<\/code><\/pre>\n<\/li>\nTIMESTAMPADD<\/code> and multi-format TO_TIMESTAMP<\/code>.\n-- Verify TIMESTAMPADD\nSELECT TIMESTAMPADD(HOUR, 1, SYSDATE) FROM dual;\n\n-- Verify Multi-format TO_TIMESTAMP\nSELECT TO_TIMESTAMP('2023-10-27 10:00:00', 'YYYY-MM-DD HH24:MI:SS') FROM dual;\n<\/code><\/pre>\n<\/li>\nLISTAGG<\/code> with optional WITH GROUP<\/code> clause.\n-- Verify LISTAGG WITH GROUP\nSELECT LISTAGG(column_name, ',') WITHIN GROUP (ORDER BY column_name) FROM table_name;\n<\/code><\/pre>\n<\/li>\n<\/ul>\nStep 4: Replace and Validate System Views<\/h3>\n
\n
V$VERSION<\/code>: Database version information.<\/li>\nV$SESSION<\/code>: Active session details.<\/li>\nV$LOCKED_OBJECT<\/code>: Current lock status.<\/li>\nALL_PART_INDEXES<\/code>, DBA__PART_INDEXES<\/code>, USER_PART_INDEXES<\/code>.<\/li>\n<\/ul>\n-- Verify system view availability\nSELECT * FROM V$VERSION;\nSELECT * FROM V$SESSION WHERE ROWNUM = 1;\n<\/code><\/pre>\nStep 5: Data Integrity Verification<\/h3>\n
\n
-- Oracle: Generate checksums for a table\nSELECT MD5(TO_CHAR(COL1) || TO_CHAR(COL2)) AS row_checksum\nFROM source_table;\n<\/code><\/pre>\n<\/li>\n-- KingbaseES: Generate checksums for migrated table\nSELECT MD5(COL1::TEXT || COL2::TEXT) AS row_checksum\nFROM migrated_table;\n<\/code><\/pre>\n<\/li>\nRollback Procedure<\/h2>\n
\n
systemctl stop kingbasees\n<\/code><\/pre>\n<\/li>\n
\nUse your standard Oracle backup restoration method (e.g., RMAN) to restore the database to the pre-migration state.<\/p>\n# Example RMAN restore command\nrman target \/\nRESTORE DATABASE;\nRECOVER DATABASE;\nALTER DATABASE OPEN RESETLOGS;\n<\/code><\/pre>\n<\/li>\n
\nConfirm that Oracle services are running and applications can connect.<\/li>\n<\/ol>\nTroubleshooting Common Issues<\/h2>\n
\n
FAQ<\/h2>\n
How do I enable Oracle compatibility mode in KingbaseES?<\/h3>\n
compatibility_mode<\/code> parameter to 'oracle'<\/code> using ALTER SYSTEM<\/code> and restart the instance. This aligns the SQL parser and PL\/SQL engine with Oracle\u2019s behavior.<\/p>\nWhat specific SQL commands verify data integrity during migration?<\/h3>\n
MD5<\/code> or CHECKSUM<\/code> on both Oracle and KingbaseES to compare row-level data. Example: SELECT MD5(COL1::TEXT || COL2::TEXT) FROM table_name;<\/code><\/p>\nWhat is the rollback procedure if migration fails?<\/h3>\n
Does KingbaseES support Oracle system views for migration auditing?<\/h3>\n
V$VERSION<\/code>, V$SESSION<\/code>, V$LOCKED_OBJECT<\/code>, and partition index views (ALL_PART_INDEXES<\/code>, DBA__PART_INDEXES<\/code>, USER_PART_INDEXES<\/code>).<\/p>\nHow does KingbaseES handle PL\/SQL nested tables and VARRAYs?<\/h3>\n
NEW<\/code> keyword, matching Oracle\u2019s collection variable initialization syntax.<\/p>\n
\n\n
\n