{"id":535,"date":"2022-02-20T14:25:51","date_gmt":"2022-02-20T13:25:51","guid":{"rendered":"https:\/\/anjo.pt\/keyword-oracle\/?page_id=535"},"modified":"2022-02-20T14:26:55","modified_gmt":"2022-02-20T13:26:55","slug":"535-2","status":"publish","type":"page","link":"https:\/\/anjo.pt\/keyword-oracle\/535-2\/","title":{"rendered":"Blog &#8211; Keyword: Oracle"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-query is-layout-flow wp-block-query-is-layout-flow\"><ul class=\"wp-block-post-template is-layout-flow wp-block-post-template-is-layout-flow\"><li class=\"wp-block-post post-1173 post type-post status-publish format-standard category-audit category-cloning category-oracle category-security czr-hentry\">\n\n<div class=\"wp-block-group\" style=\"padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><h2 class=\"wp-block-post-title\"><a href=\"https:\/\/anjo.pt\/keyword-oracle\/2026\/07\/30\/copy-audit-and-unified-audit-across-databases\/\" target=\"_self\" >Copy Audit and unified audit across databases<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">The client had a special request: copy the audit data to another database &#8211; once -, for compliance reasons. The Audit data does not let it copy so easily. Before was usually in SYS schema, now it belongs to a special AUDSYS user. None allows to export data by default. To copy the audit data&hellip; <\/p><\/div>\n\n<div class=\"wp-block-post-date\"><time datetime=\"2026-07-30T13:37:39+02:00\">30.07.2026<\/time><\/div><\/div><\/div>\n\n<\/li><li class=\"wp-block-post post-1178 post type-post status-publish format-standard category-bug category-enterprise-manager category-oracle czr-hentry\">\n\n<div class=\"wp-block-group\" style=\"padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><h2 class=\"wp-block-post-title\"><a href=\"https:\/\/anjo.pt\/keyword-oracle\/2026\/07\/20\/1178\/\" target=\"_self\" >OEM 13.5 &#8211; Failed to allocate OCIEnv from Perl corrective actions<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">At a client, since Enterprise Manager 13.5 Release 1 Update 30 (RU 30) &#8211; the April June 2026 update -, that Corrective Action to extend tablespaces stopped to work. They got two production application completely frozen due to this! The symptoms were that the Perl script triggered by OEM Agent could not anymore connect to&hellip; <\/p><\/div>\n\n<div class=\"wp-block-post-date\"><time datetime=\"2026-07-20T10:00:00+02:00\">20.07.2026<\/time><\/div><\/div><\/div>\n\n<\/li><li class=\"wp-block-post post-1176 post type-post status-publish format-standard category-oracle czr-hentry\">\n\n<div class=\"wp-block-group\" style=\"padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><h2 class=\"wp-block-post-title\"><a href=\"https:\/\/anjo.pt\/keyword-oracle\/2026\/07\/16\/make-oracle-tablespace-management-easier-make-sure-to-have-autoextend-on-and-maxsize-unlimited\/\" target=\"_self\" >Make Oracle tablespace management easier &#8211; make sure to have autoextend on and maxsize unlimited<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">On several customers where databases exists since many years, it is common to find datafile and tablespace management to be inconsistent, mainly due to historical reasons and the DBA preferences at the time. It is common to see a mix of these patterns in a typical 8192 block size database using smallsize tablespaces: I try&hellip; <\/p><\/div>\n\n<div class=\"wp-block-post-date\"><time datetime=\"2026-07-16T10:36:28+02:00\">16.07.2026<\/time><\/div><\/div><\/div>\n\n<\/li><li class=\"wp-block-post post-1167 post type-post status-publish format-standard category-bug category-oracle czr-hentry\">\n\n<div class=\"wp-block-group\" style=\"padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><h2 class=\"wp-block-post-title\"><a href=\"https:\/\/anjo.pt\/keyword-oracle\/2026\/07\/10\/on-db-19-31-ora-600-kaf-lob-buffer-overwrite\/\" target=\"_self\" >On DB 19.31, ORA-600 [kaf lob buffer overwrite]<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">After Oracle support did not accepted that there is bug with huge LOB segments and High IO due space manager KTSJ, this time it worked faster. The move of the Table and LOB to a new Tablespace went ok, but soon we started seeing ORA-600 [kaf lob buffer overwrite] on the alertlog. These happened either&hellip; <\/p><\/div>\n\n<div class=\"wp-block-post-date\"><time datetime=\"2026-07-10T13:45:11+02:00\">10.07.2026<\/time><\/div><\/div><\/div>\n\n<\/li><li class=\"wp-block-post post-1170 post type-post status-publish format-standard category-bug category-oracle category-oracle-19c czr-hentry\">\n\n<div class=\"wp-block-group\" style=\"padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><h2 class=\"wp-block-post-title\"><a href=\"https:\/\/anjo.pt\/keyword-oracle\/2026\/07\/07\/high-io-due-space-manager-w00x-process-doing-db-sequential-read-all-the-time-ktsj-slave-bug\/\" target=\"_self\" >High IO due space manager (W00x process) doing db sequential read all the time &#8211; KTSJ\u00a0Slave bug?<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">On a client DB, after migrating it to OL8, the application started to complaint the DB seems slower. Checking the OEM, there is not much done by the application, but I see a good blue stripe from W00x processes doing sequential reads. Nonstop. This is a 19.31 single-instance database. After tracing these sessions, they are&hellip; <\/p><\/div>\n\n<div class=\"wp-block-post-date\"><time datetime=\"2026-07-07T19:14:31+02:00\">07.07.2026<\/time><\/div><\/div><\/div>\n\n<\/li><li class=\"wp-block-post post-1165 post type-post status-publish format-standard category-oracle-ai-26ai category-security czr-hentry\">\n\n<div class=\"wp-block-group\" style=\"padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><h2 class=\"wp-block-post-title\"><a href=\"https:\/\/anjo.pt\/keyword-oracle\/2026\/06\/30\/database-specific-password-wallet-with-26ai-client-the-new-seps_wallet_location-parameter\/\" target=\"_self\" >Database specific password wallet with 26ai client: the new SEPS_WALLET_LOCATION parameter<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">One inconvenient I had in the past with the usage of password wallets for Oracle users was their maintenance. With the years, there was just a lot of old entries. At the end you would do a script that would test all credentials and delete the ones which did not work or there was no&hellip; <\/p><\/div>\n\n<div class=\"wp-block-post-date\"><time datetime=\"2026-06-30T14:14:52+02:00\">30.06.2026<\/time><\/div><\/div><\/div>\n\n<\/li><\/ul><\/div>\n<\/div><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-535","page","type-page","status-publish","czr-hentry"],"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/pages\/535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=535"}],"version-history":[{"count":4,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/pages\/535\/revisions"}],"predecessor-version":[{"id":540,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/pages\/535\/revisions\/540"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}