tag:blogger.com,1999:blog-3383202751155475552024-03-21T21:37:50.784+00:00Durham OracleAn eclectic view of the world of Oracle.
Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.comBlogger148125tag:blogger.com,1999:blog-338320275115547555.post-14843750394485032662024-01-10T10:01:00.003+00:002024-01-10T10:06:45.911+00:00ORA-02374 ORA-12899 ORA-02372 multi-byte character issues<span style="font-family: arial;"><br /><b>Multi-byte characters and problem resolution when going from on-prem to OCI <br /></b><br />When doing a data pump from on-prem to the cloud you will often hit errors with conversion errors. <br /><br />Plenty of background information but little on resolving this, so putting this together as a reminder when going forward. <br /><br />Typical errors when doing datapump - <br /><br /><span style="color: #2b00fe;">ORA-02374: conversion error loading table "ABC"."STANDARD_LETTERS" <br />ORA-12899: value too large for column NAME (actual: 51, maximum: 50) <br />ORA-02372: data for row: NAME : 0X'4D65746572205374726174656779202D204D6574657220696E' <br />…….. <br />. . imported "ABC"."STANDARD_LETTERS" 45.80 MB 1143 out of 1146 rows <br />……. <br />ORA-02374: conversion error loading table "ABC"."AFFECTED_ADDRESSES" <br />ORA-12899: value too large for column OCCUPIER_NAME (actual: 51, maximum: 50) <br />ORA-02372: data for row: OCCUPIER_NAME : 0X'4D52205354414E49534C41555320434841464553554B41202D' <br />….. <br />. . imported "ABC"."AFFECTED_ADDRESSES" 94.30 MB 10799942 out of 10799944 rows </span><br />......</span><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">One approach would be “data cleanse” the offending tables but this means having to search for multi-byte characters and often this can mean millions of rows. <br /><br />Also, there can be a reluctance to change any source data (and can be problematic identifying those characters). <br /><br />To avoid this, we have been changing the table data type and re-importing the data. <br /><br />Using the above errors as examples - <br /><br />For test db from source: <br /><br /><span style="color: #2b00fe;">SQL> desc ABC.AFFECTED_ADDRESSES <br /><br />Name Null? Type <br />----------------------------------------- -------- ---------------------------- <br />.. <br />OCCUPIER_NAME VARCHAR2(50) <br />..</span><br /><br /></span><div><span style="font-family: arial;">For the test db in OCI (we change to 50 char to allow for multi-byte characters) : <br /><br /><span style="color: #2b00fe;">SQL>alter table ABC.AFFECTED_ADDRESSES modify OCCUPIER_NAME varchar2 (50 char); <br /><br />SQL> desc ABC.AFFECTED_ADDRESSES <br /><br />Name Null? Type <br />----------------------------------------- -------- ---------------------------- <br />.. <br />OCCUPIER_NAME VARCHAR2(50 CHAR) <br />..</span><br /><br />Now on running the import for the table – <br /><br />.<span style="color: #2b00fe;"> . imported "ABC"."AFFECTED_ADDRESSES" 94.30 MB 10799944 rows <br /></span><br />Remember <b><span style="color: red;">table_exists_action=truncate</span></b> in the parameter file to “clear” the table prior to importing the data. <br /><br />While this approach works, if you have 1 row fail for a few million rows this is not ideal having to run an import again. <br /><br />To get around this and to avoid having to change the column datatype, an option is to generate the missing rows from the source database. <br /><br />From the datapump log we can see the offending row - <br /><br /><span style="color: #2b00fe;">ORA-02374: conversion error loading table "ABC"."STANDARD_LETTERS" <br />ORA-12899: value too large for column NAME (actual: 51, maximum: 50) <br />ORA-02372: data for row: NAME : 0X'<b>4D65746572205374726174656779202D204D6574657220696E</b>' </span><br /><br />Use script to identify row data (run for all the offending rows)…. <br /><br /><span style="color: #2b00fe;">SQL> select name FROM ABC.STANDARD_LETTERS WHERE NAME like '%' || utl_raw.cast_to_varchar2 ('<b>4D65746572205374726174656779202D204D6574657220696E'</b>) || '%' <br /></span><br /><span style="color: #2b00fe;">Strategy - installaltion £600 letter …etc </span><br /><br />However, we still need to generate the insert statement to insert the problem row to the table. <br /><br />The easy option is to use Toad and select the table from the schema browser <br /><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjpBzYNbQSLed43mO8yqRqKSSyZQmvTOjJuyY92-WdS2xg5SKOmCkwCKtnTJk4PDNwuNP360wVrC9xAhPRwTyd9Cl2F4Xa8wLR8xAb1DWWH9-nb3zvMU2jIuN_YQeFxWai4j3xea_DiLTVHfxNyPVVr7eWDeXZMhtZMPaiILnn4duKVrOmpYQsryAoET6E" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: arial;"><img alt="" data-original-height="476" data-original-width="940" height="162" src="https://blogger.googleusercontent.com/img/a/AVvXsEjpBzYNbQSLed43mO8yqRqKSSyZQmvTOjJuyY92-WdS2xg5SKOmCkwCKtnTJk4PDNwuNP360wVrC9xAhPRwTyd9Cl2F4Xa8wLR8xAb1DWWH9-nb3zvMU2jIuN_YQeFxWai4j3xea_DiLTVHfxNyPVVr7eWDeXZMhtZMPaiILnn4duKVrOmpYQsryAoET6E" width="320" /></span></a></div><span style="font-family: arial;"><br /><br /><br />From the export dataset button use the drop-down option and select “create insert statement”</span></div><div><span style="font-family: arial;"> <br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgDOxAB79TJT5ooyhN8_ishlq5KX-ocCBmbxKw6WLZo6I0uh6g6WkzJYzWvriD1lvrsugMb2mdH_VaW00oD1pN-XVJB4RsxA6bAL2CCLR9Gj--BIIenaEs0tRi7gOyhc__DXT9vMNrHQrWo6myHW692mOFgui4eTROoofBJLxVHfAMtvLZG-fUGdG_C7HA" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: arial;"><img alt="" data-original-height="451" data-original-width="940" height="154" src="https://blogger.googleusercontent.com/img/a/AVvXsEgDOxAB79TJT5ooyhN8_ishlq5KX-ocCBmbxKw6WLZo6I0uh6g6WkzJYzWvriD1lvrsugMb2mdH_VaW00oD1pN-XVJB4RsxA6bAL2CCLR9Gj--BIIenaEs0tRi7gOyhc__DXT9vMNrHQrWo6myHW692mOFgui4eTROoofBJLxVHfAMtvLZG-fUGdG_C7HA" width="320" /></span></a></div><span style="font-family: arial;"><br /><br />You need to include the where clause for each of the offending rows – <br /><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjuFlqv9domffI6NuThCP1jcQ2KAHHyI-LJVZGxyzuYohbaEEIt5U6XGnYkuduPIDlKbbv4lb6VYEz9LDq6u0VocZx1Z4Z2CQoQ1A_SGFX7IaFFeHMNB1LIOBC1PgvvtOcCUp4Thpcx2tyWkyRwOmKnZ-GZtU3ETodpBcywpNUbli5z4bEzrr0kKBI37ic" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: arial;"><img alt="" data-original-height="642" data-original-width="940" height="219" src="https://blogger.googleusercontent.com/img/a/AVvXsEjuFlqv9domffI6NuThCP1jcQ2KAHHyI-LJVZGxyzuYohbaEEIt5U6XGnYkuduPIDlKbbv4lb6VYEz9LDq6u0VocZx1Z4Z2CQoQ1A_SGFX7IaFFeHMNB1LIOBC1PgvvtOcCUp4Thpcx2tyWkyRwOmKnZ-GZtU3ETodpBcywpNUbli5z4bEzrr0kKBI37ic" width="320" /></span></a></div><span style="font-family: arial;"><br /><br />This generates - <br /><br /><span style="color: #2b00fe;">SET DEFINE OFF; <br />Insert into STANDARD_LETTERS <br />(STAN_ID, NAME, SHORT_NAME, FILENAME, EMAIL, <br />STAN_BODY, VALID_DATE, CURRENT_VALID, PREVIEW, DOC_SOURCE, <br />STAN_COVLET_STAN_ID) <br />Values <br />(100, 'Strategy - installaltion > £600 letter', 'MS8', 'MS8.doc', 'N', <br />'', TO_DATE('02/04/2009 12:06:33', 'DD/MM/YYYY HH24:MI:SS'), 'Y', NULL, NULL, <br />NULL); <br />COMMIT; </span><br /><br />However : <br /><br /><span style="color: #2b00fe;">SQL> Insert into STANDARD_LETTERS;</span></span></div><div><span style="color: #2b00fe; font-family: arial;"><br />(STAN_ID, NAME, SHORT_NAME, FILENAME, EMAIL, <br />STAN_BODY, VALID_DATE, CURRENT_VALID, PREVIEW, DOC_SOURCE, <br />STAN_COVLET_STAN_ID) <br />Values <br />(100, 'Strategy - installaltion > £600 letter', 'MS8', 'MS8.doc', 'N', <br />'', TO_DATE('02/04/2009 12:06:33', 'DD/MM/YYYY HH24:MI:SS'), 'Y', NULL, NULL, <br />NULL); <br />(1001077, 'Strategy - installaltion > £600 letter', 'MS8', 'MS8.doc', 'N', <br />* <br /><br /></span></div><div><span style="font-family: arial;"><span style="color: #2b00fe;">ERROR at line 6: <br />ORA-12899: value too large for column "ABC"."STANDARD_LETTERS"."NAME" (actual: <br />51, maximum: 50) </span><br /><br />Which is the error we are seeing in datapump – not surprising. <br /><br />Removing the offending “£” (tempted to correct the spelling of installation!) <br /><br />We could have changed the datatype on the column to insert the pound but left “as is” to demonstrate the process. <br /><br /><span style="color: #2b00fe;">SQL> Insert into STANDARD_LETTERS <br />(STAN_ID, NAME, SHORT_NAME, FILENAME, EMAIL, <br />STAN_BODY, VALID_DATE, CURRENT_VALID, PREVIEW, DOC_SOURCE, <br />STAN_COVLET_STAN_ID) <br />Values <br />(100, 'Strategy - installaltion > 600 letter', 'MS8', 'MS8.doc', 'N', <br />'', TO_DATE('02/04/2009 12:06:33', 'DD/MM/YYYY HH24:MI:SS'), 'Y', NULL, NULL, <br />NULL); </span><br /><br /><span style="color: #2b00fe;">1 row created. </span><br /><br />After running the above for all the offending rows - on checking the row counts (as expected). <br /><br /><span style="color: #2b00fe;">SQL> select count(*) from ABC.AFFECTED_ADDRESSES; <br /><br /> COUNT(*) <br />---------- <br />10799944 <br /><br />SQL> select count(*) from ABC.STANDARD_LETTERS; <br /><br /> COUNT(*) <br />---------- <br />1146 </span><br /><br />Ensure to test on the test environment prior to updating any prod database, <br /><br />This is quite a simple example and worth further reading - any comments please let me know.</span><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">I may update this with a scripted solution and provide further detail going forward.<br /></span><br /> <p></p></div></div></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-8440725653815247012023-10-30T11:53:00.003+00:002023-10-30T11:53:31.375+00:00Patching in Oracle OCI <p> Good link for patching databases in Oracle OCI - will update this as we go along.</p><p><a href="https://www.pythian.com/blog/oci-database-cloud-service-patching-of-database-and-grid-infrastructure-using-oci-cli/" target="_blank">https://www.pythian.com/blog/oci-database-cloud-service-patching-of-database-and-grid-infrastructure-using-oci-cli/</a></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-48686086721158718522023-10-16T10:48:00.000+01:002023-10-16T10:48:11.086+01:00Linux port creating / testing<p><br /></p><span style="font-family: inherit;">Wanted to test Oracle Apex on port 8080 (default) but was not 100% sure Apex was running correctly or the firewall from the cloud was not blocking the port.<br /><br />The "nc" command can run the port and you can test without having the app running - <br /><br /><b>[root@test ~]# nc -l 8080 -v<br /><br />Ncat: Version 7.50 ( https://nmap.org/ncat )<br /><br />Ncat: Listening on :::8080<br /><br />Ncat: Listening on 0.0.0.0:8080</b><br /><br /><br /><br />This is particularly handy as the Oracle cloud servers have no web browser graphical output (OCI Linux ones anway - as far as I know) so not like you can fire up a web browser and connect that way.</span><p><br /></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-87811965008460142102023-08-29T09:55:00.006+01:002023-08-29T09:55:52.996+01:00Autonomous Database - comments<b>Changing time zone<br /></b> <br /> Default Autonomous Database Time Zone<br /><br /><div> The default Autonomous Database time zone is Coordinated Universal Time (UTC) and by default calls to SYSDATE and SYSTIMESTAMP return the date and time in UTC.<br /><br /><div> In order to change database time zone, you can run the following statement. <div><br /></div><div>This example sets the database time zone to UTC-5. <br /><br />ALTER DATABASE SET TIME_ZONE='-05:00'; <br /><br />Note:<br /><br /></div><div> You must restart the Autonomous Database instance for the change to take effect.<br /> After you set the database time zone, by default SYSDATE and SYSTIMESTAMP continue to return date and time in UTC (SYSDATE_AT_DBTIMEZONE is FALSE by default). If you set SYSDATE_AT_DBTIMEZONE to TRUE in a session, SYSDATE and SYSTIMESTAMP return the database time zone.<br /> <br /></div><div><a href="https://protect-eu.mimecast.com/s/t-0XCBnv3ilqDymh6tbqU?domain=docs.oracle.com">https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/autonomous-initialization-parameters.html#GUID-1D5E830F-[…]F-899AC3C85D07</a> <br /><br /><b>Immutable backups <br /></b><br /><br />All backups taken and managed by Oracle in Autonomous Database are immutable. </div><div><br /></div><div>Immutable backups cannot be deleted or modified. <br /><br />Backups are documented here <br /><br /><a href="https://protect-eu.mimecast.com/s/iqKLCD0x3tOpoymfA0IZZ?domain=docs.oracle.com">https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/backup-intro.html#GUID-3BF27FDE-F847-4A86-9C8B-4ED9B0C1D1B2</a> <br /><br /> </div></div></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-55582121213990896272023-08-11T09:54:00.008+01:002023-08-11T10:38:10.868+01:00Stopping Global cache blocks lost metric<br /><br />From Metalink<div><br /></div><div><table border="0" cellpadding="0" cellspacing="0" id="kmPgTpl:sd_r1:0:dv_rDoc:0:tl5" style="background-color: white; color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px; width: 100%;" summary=""><tbody><tr id="kmPgTpl:sd_r1:0:dv_rDoc:0:rl12"><td id="kmPgTpl:sd_r1:0:dv_rDoc:0:cf40" width="10"><img alt="" height="10" id="kmPgTpl:sd_r1:0:dv_rDoc:0:s13" src="https://support.oracle.com/epmos/adf/images/t.gif" width="10" /></td><td align="left" id="kmPgTpl:sd_r1:0:dv_rDoc:0:cf49"><span class="p_AFHoverTarget xq" id="kmPgTpl:sd_r1:0:dv_rDoc:0:ol22" style="color: black; font-size: 14.3px; font-weight: bold; padding: 0px 6px 0px 0px; text-align: right;"><label>EM 13c: How to disable "Global Cache Blocks Lost Metric" Using EMCLI <br />(Doc ID 2543134.1)</label></span></td></tr></tbody></table><br /><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=2543134.1&displayIndex=1" target="_blank">https://support.oracle.com/epmos/faces/DocumentDisplay?id=2543134.1&displayIndex=1</a><br /><br /><br /><b>SOLUTION </b><br /><br />cd <OMS_HOME>/bin<br /><br /><div> $emcli login -username=sysman<br /><br /></div><div> $emcli sync<br /><br /></div><div> $emcli modify_collection_schedule -targetType="oracle_database" -targetNames="<DBInstanceName>" -collectionName="rac_global_cache_10i" -collectionStatus=Disabled -preview="N" <br /><br /><b>Real world example </b><br /><br />[oracle@oms1 bin]$ $OMS_HOME/bin/emcli login -username=sysman -password=....... <br /><br />Login successful <br /><br />[oracle@oms1 bin]$ $OMS_HOME/bin/emcli sync <br /><br />Synchronized successfully <br /><br />[oracle@oms1 bin]$ emcli modify_collection_schedule -targetType="oracle_database" -collectionName="rac_global_cache_10i" -collectionStatus=Disabled -preview="N" -targetNames="DemoDB" <br /><br />Collection Name : rac_global_cache_10i <br /><br />DemoDB : Collection Schedule updated successfully. <br /><br />The collection schedule of the following metrics might be affected : <br /><br />rac_global_cache <br /><br /> <br /><br /></div></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-58908641235999078312023-01-18T15:49:00.000+00:002023-01-18T15:49:43.023+00:00DBCLI quick notesQuick notes re dbcli commands - <br /><br />[root@ ~]# <b>dbcli describe-system</b><br /><br />DbSystem Information<br />----------------------------------------------------------------<br />ID: c13eb0d0-...........<br />Platform: Vmdb<br />Data Disk Count: 8<br />CPU Core Count: 2<br />Created: August 3, 2022 4:49:59 PM BST<br /><br />System Information<br />----------------------------------------------------------------<br />Name: gi2iuoaa<br />Domain Name: s003.ldntier4prd.oraclevcn.com<br />Time Zone: Europe/London<br />DB Edition: EeHp<br />DNS Servers:<br />NTP Servers: 169........<br /><br />Disk Group Information<br />----------------------------------------------------------------<br />DG Name Redundancy Percentage<br />------------------------- ------------------------- ------------<br />Data External 100<br />Reco External 100<br /><br />[root@~]# <b>dbcli describe-database --dbName TIER.....</b>.<br /><br />#<br />Database details<br />----------------------------------------------------------------<br />ID: 24d80124-c9da-4037-b077-a9...<br />Description: TIER4P<br />DB Name: TIER4P<br />DB Version: 19.16.0.0.0<br />DB Type: Si<br />DB Edition: EE_HP<br />DBID: 2309127357<br />Instance Only Database: false<br />CDB: true<br />PDB Name: LLINKP<br />PDB Admin User Name: pdbuser<br />Class: Oltp<br />Shape:<br />Storage: ASM<br />DB Redundancy:<br />CharacterSet: AL32UTF8<br />National CharacterSet: UTF8<br />Language: AMERICAN<br />Territory: AMERICA<br />Home ID: bad88939-ce80-4691-9783-0f6ac6bedef8<br />Console Enabled: false<br />Level 0 Backup Day: Sunday<br />AutoBackup Enabled: false<br />Created: August 3, 2022 4:50:00 PM BST<br />DB Domain Name: s003.ldntier4prd.oraclevcn.com<br /><br /><br />[root@ ~]# <b>dbcli list-dbstorages</b><br /><br />ID Type DBUnique Name Status<br />---------------------------------------- ------ -------------------- ----------<br />2c5c6fe0-4497-ecc Asm TIm Configured<br /><br />[root@ ~]# <b>dbcli describe-dbstorage -i 2c5c6fe0-4497-ecc</b><div><br />Database Storage details<br />----------------------------------------------------------------<br />ID: 2c5c6fe0-4497-<br />DB Name: TIER4P<br />DBUnique Name: TIER4P_lhr2rm<br />DB Resource ID: 24d80124-c9da-40<br />Storage Type: ASM<br />DATA:<br />Location: +DATA/TIER4P_lhr2rm<br />Used Space: 993.42GB<br />Free Space: 3.02TB<br />REDO:<br />Location: +RECO/TIER4P_lhr2rm<br />Used Space: 36.98GB<br />Free Space: 782.88GB<br />RECO:<br />Location: +RECO/TIER4P_lhr2rm<br />Used Space: 36.98GB<br />Free Space: 782.88GB<br />State: ResourceState(status=Configured)<br />Created: August 3, 2022 4:50:01 PM BST<br />UpdatedTime: August 3, 2022 5:06:46 PM BST<br /><br />[root@ ~]# <b>dbcli describe-database --dbid 24d80124..................</b><br /><br />Database details<br />----------------------------------------------------------------<br />ID: 24d80124-c...<br />Description: TIER4P<br />DB Name: TIER4P<br />DB Version: 19.16.0.0.0<br />DB Type: Si<br />DB Edition: EE_HP<br />DBID: 2309127357<br />Instance Only Database: false<br />CDB: true<br />PDB Name: LLINKP<br />PDB Admin User Name: pdbuser<br />Class: Oltp<br />Shape:<br />Storage: ASM<br />DB Redundancy:<br />CharacterSet: AL32UTF8<br />National CharacterSet: UTF8<br />Language: AMERICAN<br />Territory: AMERICA<br />Home ID: bad88939-c<br />Console Enabled: false<br />Level 0 Backup Day: Sunday<br />AutoBackup Enabled: false<br />Created: August 3, 2022 4:50:00 PM BST<br />DB Domain Name: s003.ldntier4prd.oraclevcn.com<br /><br />[root@prd01tier4-dbs ~]# dbcli list-dbhomes<br /><br />ID Name DB Version Home Location Status<br /><br />------------------ ---------------------------------------- --------------------------------------------- ----------<br /><br />........9000_home1 19.16.0.0.0 /u01/app/oracle/product/19.0.0.0/dbhome_1 Configured<br /><br /><br />[root@ ~]# <b>dbcli describe-dbhome -i .....</b>.<br /><br />DB Home details<br />----------------------------------------------------------------<br />ID: bad88939-<br />Name: OraDB19000_home1<br />Version: 19.16.0.0.0<br />Home Location: /u01/app/oracle/product/19.0.0.0/dbhome_1<br />Status: Configured<br />Created: August 3, 2022 4:50:00 PM BST<br />Database Edition: EE_HP<br />Unified Auditing: false<br /><br /><br /></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-40461895182347439152022-06-22T17:41:00.006+01:002022-06-23T09:30:23.918+01:00Oracle "Floating" Services<p><span style="font-family: inherit;">Running a two node RAC 19c cluster.</span></p><p><span style="font-family: inherit;">Also, running a two node Data Guard 19c environment to provide resilience for the primary environment.</span></p><p><span style="font-family: inherit;">If you were to do a Data Guard switch you would need to manually change any connection strings to reflect the fact that that Data Guard environment is the "new" primary otherwise applications or SQL Developer / TOAD etc will be pointing to the "original" i.e now standby side.</span></p><p><span style="font-family: inherit;">However, there is a way to have your connections "float" between your Primary and Secondary environments. </span></p><p>Please note - SCAN listeners, RAC, DataGuard, TDE etc outside of this post.</p><p>++++++++++++++++++++</p><p>Example values -<b> very simplistic setup</b> for clarity :</p><p><span style="color: red;"><b>ENV_lhr34g - database. ENV1 & ENV2 (RAC instances) - pdbs read write</b></span></p><p><span style="color: red;"><b>ENV_lhr456 - database. ENV1 & ENV2 (Data Guard env) - pdbs read only (active dataguard)</b></span></p><p><span style="color: red;"><b>TEST - pluggable database</b></span></p><p><span style="color: red;"><b>TSTS - pluggable database service (example)</b></span></p><p><span style="color: red;"><b>db-1 & db2 (two nodes on 'Primary' side) </b></span></p><p><span style="color: red;"><b>db-3 & db-4 (two nodes on 'Secondary' i.e. 'DataGuard' side)</b></span></p><p>Remember after "switch over" these will swap.</p><p><span style="color: red;"><b>env1-scan.example.com - SCAN listener name on primary</b></span></p><p><span style="color: red;"><b>env2-scan.example.com - SCAN listener name on secondary (Data Guard side)</b></span></p><p>++++++++++++++++++++</p><p style="margin-bottom: 12pt;"><span style="font-family: inherit;">Added the service (after a bit of trial and error with syntax and options) -</span></p>
<p style="margin-bottom: 12pt;"><span style="font-family: inherit;"><span style="color: #2b00fe;"><b>[oracle@db-1
~]$ srvctl add service -d ENV_lhr34g -s TSTS -pdb TEST -l primary -r
"ENV1,ENV2"</b></span><o:p></o:p></span></p>
<p><span style="font-family: inherit;">Started the service - <o:p></o:p></span></p>
<p><span style="font-family: inherit;"><span style="color: #2b00fe;"><b>[oracle@db-1 ~]$ srvctl
start service -service TSTS -db ENV_lhr34g</b></span><o:p></o:p></span></p>
<p><span style="font-family: inherit;">Check<o:p></o:p></span></p>
<p><span style="color: #2b00fe; font-family: inherit;"><b>[oracle@db-1 ~]$ srvctl
status database -db ENV_lhr34g -v</b></span></p><p><span style="font-family: inherit;"><span style="color: #2b00fe;"><b>Instance ENV1 is running on node db-1 with online services TSTS. Instance status: Open.<br />
Instance ENV2 is running on node db-2 with online services TSTS. Instance status: Open.</b></span><o:p></o:p></span></p>
<p class="MsoNormal"><o:p><span style="font-family: inherit;"> Added a "TEST" entry to the tnsnames.ora on both primary nodes to test connection.</span></o:p></p><p class="MsoNormal"><o:p><span style="font-family: inherit;">Amended a default entry in the tnsnames.ora - you might want to adjust this entry to suit your environment.</span></o:p></p><p class="MsoNormal"><o:p><b><span style="color: #2b00fe;">TEST =(DESCRIPTION=(SDU=65535)(SEND_BUF_SIZE=10485760)(RECV_BUF_SIZE=10485760)(ADDRESS_LIST=(FAILOVER = ON)(LOAD_BALANCE = OFF)(ADDRESS=(PROTOCOL=TCP)(HOST=env1-scan.example.com)(PORT=1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = env2-scan.example.com)(PORT = 1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TSTS.example.com)))</span></b></o:p></p><p class="MsoNormal"><o:p><span style="font-family: inherit;">Login with that entry</span></o:p></p><span style="color: #2b00fe;"><b>sqlplus user1/password@TEST<br /><br />SQL> select host_name from gv$instance where instance_number=userenv('instance');<br /><br /></b></span><div><span style="color: #2b00fe;"><b>HOST_NAME<br />----------------------------------------------------------------<br />db-1</b></span><p class="MsoNormal"><span style="font-family: inherit;">Trying logging in and out a few times and SCAN listener will point you to either db-1 or db-2</span></p><h2 style="text-align: left;"><span style="font-family: inherit;"><b>Now amend the Data Guard
side </b></span></h2>
<p class="MsoNormal"><o:p><span style="font-family: inherit;">Add an entry on the DataGuard side but do not start the service - note the database name is the one on the DataGuard side.</span></o:p></p><p class="MsoNormal"><span style="color: #2b00fe;">[<b>oracle@db-3 ~]$ srvctl add service -d ENV_lhr456 -s TSTS -pdb TEST -l primary -r "ENV1,ENV2"</b></span></p>
<p class="MsoNormal"><span style="font-family: inherit;">DO NOT start the service
this will happen when you do a switchover !</span></p><p class="MsoNormal"><span style="font-family: inherit;">(If you try and start the service prior to switching over it will fail with an error and the only way to start it, is to stop the service on the primary first and then start the service on the Data Guard side. However, that would mean you would connect to the read only pdb on the Data Guard side and not the primary database. One way to ensure you always connect to the primary is to change the ordering of the HOST= option in the service name in the tnsnames.ora file so that the connection is correct - something I have not had a chance to try but may update this at a later date. If you do want to connect to the read only pdb on the secondary suggest an alternative service name is created. For simplicity suggest the service is only started on the primary - let the dataguard switchover look after it).</span></p><p class="MsoNormal"><span style="font-family: inherit;">Add a tnsnames entry as per the primary side on both Data Guard nodes.</span></p>
<p class="MsoNormal"><o:p><span style="font-family: inherit;">As the grid user you might want to run "crsctl stat res -t" to check the status of the services.</span></o:p></p><p class="MsoNormal"><o:p><span style="font-family: inherit;">e.g. </span></o:p></p><i><b><span style="color: #2b00fe;">ora.env_lhr346.tsts.svc<br /><br /> 1 OFFLINE OFFLINE STABLE<br />2 OFFLINE OFFLINE STABLE</span></b></i></div><div><span style="color: #2b00fe;"><b><i><br /></i></b></span></div><div><b><i>Will be "online online" if this is primary<br /></i></b><div><br /></div><div>To confirm your pdb connection is working simply do a <b>Data Guard switchover</b> (outside of the scope of this ) but for Oracle cloud simply a case of going into the Cloud console and enabling switchover.</div><div><br /></div><div>Once the switchover is complete - again check the connection but this time, the sqlplus connection will report the "new" primary (try logging in and out a few times to confirm you see db-3 and db-4 the new servers you should be connecting to). </div><div><br /></div><div>Also check "crsctl stat res -t" as above to confirm the service is now online.</div><div><br /></div><br /><span style="color: #2b00fe;"><i><b>sqlplus user1/password@TEST<br /><br />SQL> select host_name from gv$instance where instance_number=userenv('instance');<br /><br />HOST_NAME<br />----------------------------------------------------------------<br />db-3 <br /><br />SQL> show con_name;</b></i></span></div><div><span style="color: #2b00fe;"><i><b><br /></b></i></span></div><div><span style="color: #2b00fe;"><i><b>CON_NAME <br />------------------------------ <br />TEST</b></i></span><p class="MsoNormal"><o:p><span style="font-family: inherit;"> As always, any improvements, amendments or correction please let me know and always test on a "sandbox" environment prior to any production changes.</span></o:p></p><p class="MsoNormal"><o:p><span style="font-family: inherit;"><br /></span></o:p></p><p class="MsoNormal"><o:p><span style="font-family: inherit;"><br /></span></o:p></p>
<p class="MsoNormal"><o:p><span style="font-family: inherit;"> </span></o:p></p></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-37712258939392858752022-06-01T12:30:00.002+01:002022-06-01T12:30:18.792+01:00ORA-02266: Unique/Primary Keys In Table Referenced While Truncating Table<p><span style="font-family: arial;"> </span></p><p><span style="font-family: arial;"><br /></span></p><p><span style="font-family: arial;"><br /></span></p><p><span style="font-family: arial;">Trying to do a data only import into a table and hitting the error below :</span></p><p><span style="font-family: arial;">ORA-39120: Table "XYZ"."LOOKUPS" can't be truncated, data will be skipped. Failing error is:</span></p><p><span style="font-family: arial;">ORA-02266: unique/primary keys in table referenced by enabled foreign keys</span></p><div><div><p style="background: 0px 0px rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #070808; margin: 0px 0px 10px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background: 0px 0px; border: 0px; box-sizing: border-box; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: arial;">The primary key in the table( which we are truncating) , seems to be referring to a another child table with foreign key.</span></span></p><p style="background: 0px 0px rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #070808; margin: 0px 0px 10px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background: 0px 0px; border: 0px; box-sizing: border-box; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background: 0px 0px; border: 0px; box-sizing: border-box; color: black; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: arial;">Run below script to get the parent table , child table relation</span></span></span></p></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">set lines 200</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">COL CHILD_TABLE FOR a50</span></div><div><span style="font-family: arial;">col CONSTRAINT_NAME for a50</span></div><div><span style="font-family: arial;">col owner form a40</span></div><div><span style="font-family: arial;">col FK_column form a40</span></div><div><span style="font-family: arial;">col table_name form a50</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">select b.owner, b.table_name child_table,</span><span style="font-family: arial;"> c.column_name FK_column, b.constraint_name</span></div><div><span style="font-family: arial;"> from dba_constraints a, dba_constraints b, dba_cons_columns c</span></div><div><span style="font-family: arial;"> where a.owner=b.r_owner</span></div><div><span style="font-family: arial;"> and b.owner=c.owner</span></div><div><span style="font-family: arial;"> and b.table_name=c.table_name</span></div><div><span style="font-family: arial;"> and b.constraint_name=c.constraint_name</span></div><div><span style="font-family: arial;"> and a.constraint_name=b.r_constraint_name</span></div><div><span style="font-family: arial;"> and b.constraint_type='R'</span></div><div><span style="font-family: arial;"> and a.owner='&owner'</span></div><div><span style="font-family: arial;"> and a.table_name='&table_name'</span></div><div><span style="font-family: arial;"> and a.CONSTRAINT_TYPE='P'</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">Enter the values and then do a manual - alter table disable constraint.</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">For tables with multiple constraints this is easier i.e.</span></div><div><span style="font-family: arial;"> </span></div><div><span style="font-family: arial;"> select 'alter table ' || owner || '.' || table_name || ' disable constraint ' || constraint_name ||';' stmt from all_constraints</span></div><div><span style="font-family: arial;"> where r_constraint_name in (select constraint_name from all_constraints where table_name = 'LOOKUPS')</span></div></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">Run the output - remember to enable the constraints when complete - the db I was doing this was restricted so no issue of any others "hitting" the tables.</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">Import should now work.</span></div><div><br /></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-89366411424880846262022-05-27T10:34:00.004+01:002022-05-27T10:34:28.356+01:00Oracle PDB cloning in OCI with RAC / TDE and DataGuard enabled<p> </p><p>Oracle PDB cloning in OCI with RAC / TDE and DataGuard enabled</p><p></p><p class="MsoNormal"><b><span style="background: white; color: black; font-family: "Tahoma",sans-serif; font-size: 10.5pt;">Doc ID 1916648.1<o:p></o:p></span></b></p>
<p class="MsoNormal"><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=339297523964641&id=1916648.1&_afrWindowMode=0&_adf.ctrl-state=5cqsp6ypb_4#aref_section24">https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=339297523964641&id=1916648.1&_afrWindowMode=0&_adf.ctrl-state=5cqsp6ypb_4#aref_section24</a><br /></p>
<p class="MsoNormal"><o:p> </o:p>Worthwhile as there are lots of pitfalls , basically DG
breaks unless handled correctly.</p><p class="MsoNormal"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p>This non oracle guide is useful as well if you find it has
broken.</p><p class="MsoNormal"><o:p></o:p></p>
<a href="https://database-heartbeat.com/2020/12/31/create-pdbs-in-a-data-guard-environment-with-tde-enabled/">https://database-heartbeat.com/2020/12/31/create-pdbs-in-a-data-guard-environment-with-tde-enabled/</a><br /><p></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-74488650041551195962022-02-02T11:11:00.003+00:002022-02-02T11:11:55.076+00:00New user - linux password issue<p> <!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-GB</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="376">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hashtag"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Unresolved Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Link"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman",serif;}
</style>
<![endif]-->
</p><p class="MsoNormal"><span style="font-size: small;"><span style="font-family: inherit;">Hit a problem today changing a new user password today in Linux.<br /></span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">[root@prd01oua-dbg2
~]# passwd emcadm</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">Changing
password for user emcadm.</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;"><span style="background: yellow none repeat scroll 0% 0%;">passwd: Authentication token
manipulation error</span></span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">[root@prd01oua-dbg2
pam.d]# ls -ls system-auth</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">4
-rw-r--r-- 1 root root 1205 Feb 2 10:51 system-auth</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">In
system.auth</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">password
requisite pam_pwquality.so try_first_pass local_users_only
retry=3 authtok_type=</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">#password
sufficient pam_unix.so md5 shadow nullok try_first_pass
use_authtok</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">password
required pam_deny.so</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">change
to </span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">password
requisite pam_pwquality.so try_first_pass
local_users_only retry=3 authtok_type=</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">password
sufficient pam_unix.so md5 shadow nullok try_first_pass
use_authtok</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">password
required pam_deny.so</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal"><span style="font-size: small;"><span style="font-family: inherit;">Next we hit a password length problem</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">[root@prd01oua-dbg2
pam.d]# passwd emcadm</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">Changing
password for user emcadm.</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">New
password:</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">BAD
PASSWORD: The password is shorter than 15 characters</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">/etc/security/pwquality.conf</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">#
Password Minimum Length should be configured</span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">minlen=8</span></span><span style="font-size: small;"><span style="font-family: inherit;"></span></span><span style="font-size: small;"><span style="font-family: inherit;"></span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;"> </span></span></p><span style="font-size: small;"><span style="font-family: inherit;">
</span></span><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-size: small;"><span style="font-family: inherit;">Changing
password for user emcadm.</span></span></p>
<p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-family: "Courier New";">New
password:</span></p>
<p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-family: "Courier New";">Retype
new password:</span></p>
<p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-family: "Courier New";">passwd:
all authentication tokens updated successfully.</span></p>
<p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-family: "Courier New";">[root@prd01oua-dbg1
security]#</span></p><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-family: "Courier New";">Et voilla..... <br /></span></p><p class="MsoNormal" style="margin-left: 36.0pt;"><span style="font-family: "Courier New";"> </span></p>
Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-81085761812111289042021-10-05T11:47:00.002+01:002021-10-05T14:27:15.813+01:00Weblogic Version<span style="font-family: arial;">Needed to quickly check the Weblogic version that I was using - quick notes.</span><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">From <b><span style="background-color: white; color: #333333; font-size: 12px;">$WL_HOME/server/lib</span><span style="background-color: white; color: #333333; font-size: 12px;"> </span></b>run this :</span></div><div><span style="font-family: arial;"><br />[oracle@dev01-wls-1 lib]$ pwd<br /><br /><span style="color: red;">/u01/app/oracle/products/fmw_12214/wlserver/server/lib</span><br /><br />[oracle@dev01-wls-1 lib]$ <span style="color: red;">java -cp weblogic.jar weblogic.version -version -verbose</span><br /><br />WebLogic Server <span style="color: red;"><b>12.2.1.4.0</b> </span>Thu Sep 12 04:04:29 GMT 2019 1974621 ImplVersion: 12.2.1.4.0<br /><br />Oracle Security Developer Tools Security Engine ImplVersion: 3.1.0<br /><br />Oracle Security Developer Tools Crypto ImplVersion: 3.1.0<br /><br />Oracle Universal Connection Pool ImplVersion: 19.3.0.0.0<br /><br />etc...</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">There are other ways to check the version but this seems to the easiest and most comprehensive.</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">Download :</span></div><div><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDwJQMpnF90NWyfQtxtaC8yiOn4hQq7Z-IKsJsWu1ZerVxlZjuFicbaQCnnDo_FwF1H5Cokvo-4iVCoQXj0cxOOWiKXlUVsP-aNxiGkNl4xullHHN2Nbir77OpJxnkbGQlQqxqVC_nY1w/s1366/weblogic.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="593" data-original-width="1366" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDwJQMpnF90NWyfQtxtaC8yiOn4hQq7Z-IKsJsWu1ZerVxlZjuFicbaQCnnDo_FwF1H5Cokvo-4iVCoQXj0cxOOWiKXlUVsP-aNxiGkNl4xullHHN2Nbir77OpJxnkbGQlQqxqVC_nY1w/w400-h179/weblogic.GIF" width="400" /></a></div><br /><div><br /></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-48273033815586459422021-07-30T13:44:00.073+01:002021-08-18T14:43:53.438+01:00Clone / Refresh of a PDB from remote database<p><span style="font-family: Consolas;">Using the note from here - <br /></span></p><p><a href="https://oracle-base.com/articles/12c/multitenant-clone-remote-pdb-or-non-cdb-12cr1" style="font-family: Consolas;">https://oracle-base.com/articles/12c/multitenant-clone-remote-pdb-or-non-cdb-12cr1</a></p><p><span style="font-family: Consolas;">"Oracle-Base" always excellent</span><span style="font-family: Consolas;"> but please check this note on Metalink and the note below if using TDE.</span></p><p><span style="font-family: Consolas;"><span class="xq" id="kmPgTpl:r1:0:ol22" style="color: black; font-size: 130%; font-weight: bold;">Cloning PDB From PDB Fails With ORA-28357: Password Required To Open The Wallet (Doc ID 2415131.1)</span></span></p><p>
</p><p class="MsoNormal"><span style="font-family: Consolas;">Example database ORAPDB and example password used. <br /></span></p><p class="MsoNormal"></p><p class="MsoNormal"></p><p class="MsoNormal"><span style="font-family: Consolas;"></span></p><p class="MsoNormal"><span style="font-family: Consolas;">++++++++++++++++++++++++++++++ <br /></span></p><p class="MsoNormal"><span style="font-family: Consolas;">[oracle@dev01tier2-dbs admin]$ sqlplus / as sysdba</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 30
12:25:22 2021</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">Version 19.9.0.0.0</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">Copyright (c) 1982, 2020, Oracle.<span style="mso-spacerun: yes;"> </span>All rights reserved.</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">Connected to:</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">Oracle Database 19c EE High Perf Release 19.0.0.0.0 -
Production</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">Version 19.9.0.0.0</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> SQL> DROP DATABASE LINK clone_link;</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">DROP DATABASE LINK clone_link</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>*</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ERROR at line 1:</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ORA-02024: database link not found</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> SQL> CREATE DATABASE LINK clone_link CONNECT TO
remote_clone_user IDENTIFIED BY remote_clone_user USING 'ORAPDB';</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> Database link created.</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> SQL> DESC user_tables@clone_link</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>Name<span style="mso-spacerun: yes;">
</span>Null?<span style="mso-spacerun: yes;"> </span>Type</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">----------------------- -<span style="mso-spacerun: yes;"> </span>-------- ------------</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>TABLE_NAME<span style="mso-spacerun: yes;"> </span>NOT NULL
VARCHAR2(128)</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>TABLESPACE_NAME<span style="mso-spacerun: yes;">
</span>VARCHAR2(30)</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>…etc</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>HAS_SENSITIVE_COLUMN<span style="mso-spacerun: yes;"> </span>VARCHAR2(3)</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>ADMIT_NULL<span style="mso-spacerun: yes;">
</span>VARCHAR2(3)</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>DATA_LINK_DML_ENABLED<span style="mso-spacerun: yes;"> </span>VARCHAR2(3)</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>LOGICAL_REPLICATION<span style="mso-spacerun: yes;"> </span>VARCHAR2(8)</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> SQL> show pdbs</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>CON_ID
CON_NAME<span style="mso-spacerun: yes;"> </span>OPEN
MODE<span style="mso-spacerun: yes;"> </span>RESTRICTED</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">---------- ------------------------------ ----------
----------</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>2
PDB$SEED<span style="mso-spacerun: yes;"> </span>READ
ONLY<span style="mso-spacerun: yes;"> </span>NO</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>3 RADND<span style="mso-spacerun: yes;"> </span>READ WRITE NO</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>4
RADARPDB<span style="mso-spacerun: yes;"> </span>READ WRITE
NO</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>5 ORAPDB<span style="mso-spacerun: yes;"> </span>READ ONLY<span style="mso-spacerun: yes;"> </span>NO</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">SQL> drop pluggable database ORAPDB including datafiles;</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">drop pluggable database ORAPDB including datafiles</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">*</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ERROR at line 1:</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ORA-65025: Pluggable database ORAPDB is not closed on all
instances.</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> <span style="color: #ff00fe;"><b>// Will try anyway to create to show error</b> </span><br /></span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">SQL> CREATE PLUGGABLE DATABASE ORAPDB FROM ORAPDB@clone_link;</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">CREATE PLUGGABLE DATABASE SFSD FROM ORAPDB@clone_link</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">*</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ERROR at line 1:</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ORA-65012: Pluggable database ORAPDB already exists.</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">SQL> alter pluggable database ORAPDB close IMMEDIATE;</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">Pluggable database altered.</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">SQL> drop pluggable database ORAPDB including datafiles;</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">Pluggable database dropped.</span></p><p class="MsoNormal"><span style="font-family: Consolas;"> <b><span style="color: #ff00fe;">// Now we can create but... </span></b><br /></span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">SQL> CREATE PLUGGABLE DATABASE ORAPDB FROM ORAPDB@clone_link;</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">CREATE PLUGGABLE DATABASE ORAPDB FROM ORAPDB@clone_link</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">*</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ERROR at line 1:</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ORA-46697: Keystore password required.</span></p><div class="MsoNormal" style="text-align: left;"><b><span style="color: #ff00fe;"><span style="font-size: small;"><span style="font-family: Consolas;"><span>// See </span><span><span><span class="xq" id="kmPgTpl:r1:0:ol22">Doc ID 2415131.1</span></span></span></span></span></span></b></div><p class="MsoNormal"><span style="font-family: Consolas;"> SQL> CREATE PLUGGABLE DATABASE ORAPDB FROM ORAPDB@clone_link
keystore IDENTIFIED BY "Password#2021#";</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> Pluggable database created.</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> SQL> l</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>1* SELECT name,
open_mode FROM v$pdbs</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">SQL> /</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> NAME<span style="mso-spacerun: yes;"> </span>OPEN_MODE</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">---------------------------------------- ----------</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">PDB$SEED<span style="mso-spacerun: yes;"> </span>READ ONLY</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">RADND<span style="mso-spacerun: yes;"> </span>READ WRITE</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">RADARPDB<span style="mso-spacerun: yes;"> </span>READ WRITE</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ORAPDB<span style="mso-spacerun: yes;"> </span>MOUNTED</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> </span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">SQL> ALTER PLUGGABLE DATABASE ORAPDB OPEN;</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> Pluggable database altered.</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> SQL> show pdbs</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> <span style="mso-spacerun: yes;"> </span>CON_ID
CON_NAME<span style="mso-spacerun: yes;"> </span>OPEN MODE <span style="mso-spacerun: yes;"> </span>RESTRICTED</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">---------- ------------------------------ ----------
----------</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>2
PDB$SEED<span style="mso-spacerun: yes;"> </span>READ
ONLY<span style="mso-spacerun: yes;"> </span>NO</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>3 RADND<span style="mso-spacerun: yes;"> </span>READ WRITE NO</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>4
RADARPDB<span style="mso-spacerun: yes;"> </span>READ WRITE
NO</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"><span style="mso-spacerun: yes;"> </span>5 ORAPDB<span style="mso-spacerun: yes;"> </span>READ WRITE NO</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> SQL> alter session set container = ORAPDB;</span></p><span style="font-family: Consolas;">
</span><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">Session altered.</span></p><p class="MsoNormal"><span style="font-family: Consolas;"><span style="color: #ffa400;"></span><span style="color: #ff00fe;"></span></span></p><p class="MsoNormal"><span style="font-family: Consolas;"><span style="color: #ff00fe;"> <b>//Remember to perform sanity check against pdb - </b></span></span><span style="font-family: Consolas;"><span style="color: #ff00fe;"><b><span style="font-family: Consolas;"><span style="color: #ff00fe;">check for invalid objects etc..</span></span></b> </span></span></p><p class="MsoNormal"><span style="font-family: Consolas;"> 1* select owner, object_type, count(object_type) from
dba_objects where status != 'VALID' group by owner, object_type order by 1,2</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">SQL> /</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;"> OWNER<span style="mso-spacerun: yes;"> </span>OBJECT_TYPE<span style="mso-spacerun: yes;"> </span>COUNT(OBJECT_TYPE)</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">---------- ----------------------- ------------------</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ABC<span style="mso-spacerun: yes;">
</span>FUNCTION<span style="mso-spacerun: yes;">
</span>4</span></p><span style="font-family: Consolas;">
</span><p class="MsoNormal"><span style="font-family: Consolas;">ABC<span style="mso-spacerun: yes;"> </span>PACKAGE
BODY<span style="mso-spacerun: yes;"> </span>1</span></p><span style="font-family: Consolas;"></span><span style="font-family: Consolas;"></span><p class="MsoNormal"><span style="font-family: Consolas;">2 rows selected.</span></p><span style="font-family: Consolas;">
</span><p><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-GB</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="376">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hashtag"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Unresolved Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Link"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin-top:0cm;
mso-para-margin-right:0cm;
mso-para-margin-bottom:8.0pt;
mso-para-margin-left:0cm;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
</style>
<![endif]--></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-20656859483778451572021-07-12T11:34:00.021+01:002021-07-12T13:21:55.052+01:00Impdp issues...<p style="text-align: left;">If you ever end up with lots of invalid synonyms after impdp - quick sql to sort it out.</p><p style="text-align: left;">Just a note as no doubt this will happen again and I won't remember :(</p><p style="text-align: left;"></p><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"><br />SQL> select owner, object_type, count(object_type) from dba_objects where status != 'VALID' group by owner, object_type order by 1,2</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"> 2 /</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"><br />OWNER OBJECT_TYPE COUNT(OBJECT_TYPE)</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;">----- ----------- ----------</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;">CON29GIS2 SYNONYM 129</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"></span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"></span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"></span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"></span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"><br />SQL> select 'alter synonym '||owner||'.'||object_name||' compile; ' from dba_objects where status='INVALID' and object_type='SYNONYM' and owner='CON29GIS2' order by 1</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"> 2 /</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"><br />'ALTERSYNONYM'||OWNER||'.'||OBJECT_NAME||'COMPILE;'</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;">--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;">alter synonym CON29GIS2.ANSWERS compile;</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;">alter synonym CON29GIS2.ANSWER_COMBINATIONS compile;</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;">alter synonym CON29GIS2.API_CALLED compile;</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;">....etc</span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"> </span></span></div><div style="text-align: left;"><span style="font-size: small;"><span style="font-family: courier;"> </span></span></div><div style="text-align: left;"><span class="xq" id="kmPgTpl:r1:0:ol22" style="color: black; font-size: 130%; font-weight: bold;">JAVA CLASS and JAVA SOURCE Objects Become Invalid After Impdp. (Doc ID 1462622.1)</span></div><div style="text-align: left;"><span class="xq" id="kmPgTpl:r1:0:ol22" style="color: black; font-size: 130%; font-weight: bold;"> </span></div><p> SQL> select owner, object_type, count(object_type) from dba_objects where status != 'VALID' group by owner, object_type order by 1,2<br /> 2 /<br /></p><p><br />OWNER OBJECT_TYPE COUNT(OBJECT_TYPE)<br />----- ----------- ----------<br /> CON29R2 JAVA CLASS 76<br /> </p><p></p><p>SQL> select 'ALTER JAVA CLASS CON29R2."'||OBJECT_NAME||'" resolve;' from dba_objects where status !='VALID' and object_type = 'JAVA CLASS'<br /> 2 /<br /><br />'ALTERJAVACLASSCON29R2."'||OBJECT_NAME||'"RESOLVE;'<br />--------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />ALTER JAVA CLASS CON29R2."SFSexportBlob" resolve;<br />ALTER JAVA CLASS CON29R2."SFSLiveLinkAPI" resolve;<br />ALTER JAVA CLASS CON29R2."com/opentext/api/LAPI_ATTRIBUTES" resolve;<br />ALTER JAVA CLASS CON29R2."com/opentext/api/LAPI_ATTRSERVER" resolve;<br />ALTER JAVA CLASS CON29R2."com/opentext/api/LAPI_DOCUMENTS" resolve;</p><p></p><p>Alter user as approp.<br /></p><p></p><p><br /><br /></p><p style="text-align: left;"></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-21742537962628918362021-07-09T15:33:00.002+01:002021-07-09T15:33:27.620+01:00Script to resize Oracle database<p><br /></p><p><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">I have created a link and credit to this in the useful links section but as web pages can often disappear without notice - making a note here as this has proved to very useful :</span></p><p><br /></p><p><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">set verify off</span></p><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">column file_name format a50 word_wrapped</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><div><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">column smallest format 999,990 heading "Smallest|Size|Poss."</span></div><div><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">column currsize format 999,990 heading "Current|Size"</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">column savings format 999,990 heading "Poss.|Savings"</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">break on report</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">compute sum of savings on report</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">column value new_val blksize</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">select value from v$parameter where name = 'db_block_size'</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">/</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">select file_name,</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) smallest,</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">ceil( blocks*&&blksize/1024/1024) currsize,</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">ceil( blocks*&&blksize/1024/1024) -</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) savings</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">from dba_data_files a,</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">( select file_id, max(block_id+blocks-1) hwm</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">from dba_extents</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">group by file_id ) b</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">where a.file_id = b.file_id(+)</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">/</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">column cmd format a75 word_wrapped</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">select 'alter database datafile ''' || file_name || ''' resize ' ||</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) || 'm;' cmd</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">from dba_data_files a,</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">( select file_id, max(block_id+blocks-1) hwm</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">from dba_extents</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">group by file_id ) b</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">where a.file_id = b.file_id(+)</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">and ceil( blocks*&&blksize/1024/1024) -</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) > 0</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;" /><span style="background-color: white; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif;">/</span><br style="background-color: white; box-sizing: border-box; clear: both; color: #404040; font-family: "Oracle Sans", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif; font-size: 14px;" /></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-49966100332697040252021-06-24T16:58:00.008+01:002022-03-16T16:25:46.500+00:00Export users - roles & priv (draft)<p> </p><p><a href="https://stackoverflow.com/questions/57991488/how-to-export-users-in-oracle-with-its-roles-and-system-privileges-using-expdp">https://stackoverflow.com/questions/57991488/how-to-export-users-in-oracle-with-its-roles-and-system-privileges-using-expdp</a><br /></p><p> set long 20000</p><div><div> set lines 200</div><div> set pages 666</div></div><div> col DBMS_METADATA.GET_DDL('USER',:NAME) format a90</div><div><br /></div><div> variable name varchar2(50)</div><div><p> exec :name:='CON29';</p><br /><div><pre class="lang-sql s-code-block"><code class="hljs language-sql"><span class="hljs-keyword">SELECT</span> dbms_metadata.get_ddl(<span class="hljs-string">'USER'</span>, :name)
<span class="hljs-keyword">FROM</span> dual
<span class="hljs-keyword">UNION</span> <span class="hljs-keyword">ALL</span>
<span class="hljs-keyword">SELECT</span> dbms_metadata.get_granted_ddl(<span class="hljs-string">'ROLE_GRANT'</span>, grantee)
<span class="hljs-keyword">FROM</span> dba_role_privs
<span class="hljs-keyword">WHERE</span> grantee <span class="hljs-operator">=</span> :name
<span class="hljs-keyword">AND</span> ROWNUM <span class="hljs-operator">=</span> <span class="hljs-number">1</span>
<span class="hljs-keyword">UNION</span> <span class="hljs-keyword">ALL</span>
<span class="hljs-keyword">SELECT</span> dbms_metadata.get_granted_ddl(<span class="hljs-string">'DEFAULT_ROLE'</span>, grantee)
<span class="hljs-keyword">FROM</span> dba_role_privs
<span class="hljs-keyword">WHERE</span> grantee <span class="hljs-operator">=</span> :name
<span class="hljs-keyword">AND</span> ROWNUM <span class="hljs-operator">=</span> <span class="hljs-number">1</span>
<span class="hljs-keyword">UNION</span> <span class="hljs-keyword">ALL</span>
<span class="hljs-keyword">SELECT</span> dbms_metadata.get_granted_ddl(<span class="hljs-string">'SYSTEM_GRANT'</span>, grantee)
<span class="hljs-keyword">FROM</span> dba_sys_privs sp,
system_privilege_map spm
<span class="hljs-keyword">WHERE</span> sp.grantee <span class="hljs-operator">=</span> :name
<span class="hljs-keyword">AND</span> sp.privilege <span class="hljs-operator">=</span> spm.name
<span class="hljs-keyword">AND</span> spm.property <span class="hljs-operator"><></span> <span class="hljs-number">1</span>
<span class="hljs-keyword">AND</span> ROWNUM <span class="hljs-operator">=</span> <span class="hljs-number">1</span>
<span class="hljs-keyword">UNION</span> <span class="hljs-keyword">ALL</span>
<span class="hljs-keyword">SELECT</span> dbms_metadata.get_granted_ddl(<span class="hljs-string">'OBJECT_GRANT'</span>, grantee)
<span class="hljs-keyword">FROM</span> dba_tab_privs
<span class="hljs-keyword">WHERE</span> grantee <span class="hljs-operator">=</span> :name
<span class="hljs-keyword">AND</span> ROWNUM <span class="hljs-operator">=</span> <span class="hljs-number">1</span>
<span class="hljs-keyword">UNION</span> <span class="hljs-keyword">ALL</span>
<span class="hljs-keyword">SELECT</span> dbms_metadata.get_granted_ddl(<span class="hljs-string">'TABLESPACE_QUOTA'</span>, username)
<span class="hljs-keyword">FROM</span> dba_ts_quotas
<span class="hljs-keyword">WHERE</span> username <span class="hljs-operator">=</span> :name
<span class="hljs-keyword">AND</span> ROWNUM <span class="hljs-operator">=</span> <span class="hljs-number">1</span>
</code></pre></div><div><br /></div><div>SQL> /</div><div><br /></div><div>DBMS_METADATA.GET_DDL('USER',:NAME)</div><div>------------------------------------------------------------------------------------------</div><div><br /></div><div> CREATE USER "CON29" IDENTIFIED BY VALUES 'AbcDefGhi'</div><div> DEFAULT TABLESPACE "USERS"</div><div> TEMPORARY TABLESPACE "TEMPORARY"</div></div><div>.....etc</div><div><br /></div><div>Run against the new database to create the user.</div><div><br /></div><div><br /></div><div>In AIX to run against multiple DBs e.g.</div><div><br /></div><div><div>#!/usr/bin/env bash</div><div><br /></div><div>set -A array XYZDBA </div><div><br /></div><div>## Set the env b4 running this</div><div><br /></div><div>for i in "${array[@]}"</div><div><br /></div><div>do</div><div>exit | sqlplus -silent / as sysdba << EOF</div><div><br /></div><div>set head on</div><div>set feedback off</div><div>set long 30000</div><div>set lines 220</div><div>set pages 666</div><div><br /></div><div>## col DBMS_METADATA.GET_DDL('USER',:NAME) format a220</div><div>## </div><div>col DBMS_METADATA.GET_DDL('USER','XYZDBA') format a220</div><div><br /></div><div><br /></div><div>SELECT dbms_metadata.get_ddl('USER', '$i')</div><div> FROM dual......</div><div>(<span> same script as above )</span></div><div><br /></div><div>EOF</div><div>done</div><div><br /></div></div><div> </div><span style="font-family: arial;">This works too... <br /> <br />declare<br /> data CLOB;<br /> BEGIN<br /> SELECT dbms_metadata.get_ddl('USER','SFS') into data from dual;<br /> DBMS_XSLPROCESSOR.CLOB2FILE(data,'<span style="color: red;"><b>DIRECTORY**</b></span>','create_user.sql');<br /> <br /> END;</span><div><span style="font-family: arial;"> </span></div><div><span style="font-family: arial;"><span style="color: red;"><b>**DIRECTORY</b></span> - change as approp. e.g. DATA_PUMP_DIR find from dba_directories<br /></span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">For the tablespaces for the above..</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;"><div>SQL> SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON</div><div><br /></div><div>BEGIN</div><div> DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true);</div><div>SQL> SQL> 2 3 DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'PRETTY', true);</div><div>END;</div><div>/</div><div><br /></div><div>SELECT DBMS_METADATA.get_ddl ('TABLESPACE', tablespace_name)</div><div>FROM dba_tablespaces</div><div>WHERE tablespace_name = DECODE(UPPER('&1'), 'ALL', tablespace_name, UPPER('&1'));</div><div><br /></div><div> 4 5 SET PAGESIZE 14 LINESIZE 100 FEEDBACK ON VERIFY ON</div><div>SQL> SQL> 2 3 Enter value for 1: Enter value for 1: SQL></div><div>SQL> /</div><div>Enter value for 1: NWLMEAVX</div><div>Enter value for 1: NWLMEAVX</div><div><br /></div><div> CREATE TABLESPACE "NWLMEAVX" DATAFILE etc......</div><div><br /></div><div>You will need to alter to suit when going from ASM to Unix datafiles or vice-versa.</div><div><br /></div><div>see <a href="https://oracle-base.com/dba/script?category=script_creation&file=tablespace_ddl.sql">https://oracle-base.com/dba/script?category=script_creation&file=tablespace_ddl.sq</a></div><div><a href="https://oracle-base.com/dba/script?category=script_creation&file=tablespace_ddl.sql">l</a></div><div><br /></div></span></div><div><span style="font-family: arial;"><br /></span></div><div><br /></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-55406292377839315562021-06-11T09:33:00.008+01:002021-06-16T09:07:10.302+01:00PDBS on Oracle OCI and the joy of TDE<div>Some quick notes regarding PDBs on Oracle OCI</div><div><br /></div>When creating a new pdb in an Oracle OCI database hit an error when trying to create a tablespace during the build.<div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUMS_t8PrwAbKV6_FjX0UKzKxB9vgNwsR_J9sYM2YPgmPsemq8S_R5dMpztu2iTTlR5TlDZ96PUFYx0BzxE1aGHDKFX8FW1P5FDsxZtnS0LPr4sZLmHBZrJ8GOjv1rMVgK5MSO6bTIPGw/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="625" data-original-width="798" height="314" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUMS_t8PrwAbKV6_FjX0UKzKxB9vgNwsR_J9sYM2YPgmPsemq8S_R5dMpztu2iTTlR5TlDZ96PUFYx0BzxE1aGHDKFX8FW1P5FDsxZtnS0LPr4sZLmHBZrJ8GOjv1rMVgK5MSO6bTIPGw/w400-h314/image.png" width="400" /></a></div><br /><br />I opted to continue but had to sort out the issue after which is to do with "Transparent Data Encryption" - TDE on the tablespaces and you are not able to add any tablespaces.</div><div><br /></div><div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiN0Ye-1lcs612bFYhH529p2FivO-BQSuBo08L8xWkyIVJ1OVLoDOs6bOyPzzPTyrzQ2rA3ooEonEcJNtQZEt3QR84XJwATNw1W7zXXtZBW35q-ddDcKrvZs9aDx84L8pYEGWxfaFBhlU/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="632" data-original-width="800" height="316" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiN0Ye-1lcs612bFYhH529p2FivO-BQSuBo08L8xWkyIVJ1OVLoDOs6bOyPzzPTyrzQ2rA3ooEonEcJNtQZEt3QR84XJwATNw1W7zXXtZBW35q-ddDcKrvZs9aDx84L8pYEGWxfaFBhlU/w400-h316/image.png" width="400" /></a></div><br /></div><div><br /></div><div>Make sure you make a note of all passwords when building out databases as you are in big trouble with the keystore if you don't have the correct password and no way to reset the password as far as I know (at least not without the help of Oracle). <br /><br /><br />See this document :<br /><br /><b>Creating and Activating a Master Encryption Key for a PDB (in OCI and OCI-Classic) </b><div><b>(Doc ID 2469398.1)</b><br /><br />For the new pluggable database : <br /><br />SQL> select * from v$encryption_wallet <br /> <br />WRL_TYPE -------------------- WRL_PARAMETER -------------------------------------------------------------------------------- STATUS WALLET_TYPE WALLET_OR KEYSTORE FULLY_BAC ------------------------------ -------------------- --------- -------- --------- CON_ID ---------- FILE <br /><br /><b><span style="color: red;">OPEN_NO_MASTER_KEY</span></b> PASSWORD SINGLE UNITED UNDEFINED 4 <br /> <br /><br />SQL> ADMINISTER KEY MANAGEMENT SET KEY USING TAG 'tag' FORCE KEYSTORE IDENTIFIED BY Password# WITH BACKUP USING 'backup_10062021' 2 / <br /> <br />keystore altered. <br /> <br />So no single or double quotes surrounding the password.<br /><br />That was after closing the keystore and then reopening. <br /><br />SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE close identified by Password99# <br /><br />keystore altered. <br /> <br />As root :<br /><br />dbcli update-tdekey -i da29189a-b5eb-46f7-bde2-8c334dc21e19 -n DB123 -hp Password99#<br /><br />dbcli describe-job -i da29189a-b5eb-46f7-bde2-8c334dc21e19<br /><br />Job details<br />----------------------------------------------------------------<br /> ID: da29189a-b5eb-46f7-bde2-8c334dc21e19<br /> Description: TDE update DB123 - PDBs: [PDB123]<br /> Status: <span style="color: red;"><b>Success</b></span><br /> Created: June 10, 2021 4:24:39 PM BST<br /> Progress: 100%<br /> Message:<br /><br />Everything working as expected.<div><div style="box-sizing: border-box; font-family: "Segoe UI", system-ui, "Apple Color Emoji", "Segoe UI Emoji", sans-serif; font-size: 14px;"><div data-tid="messageBodyContainer"><div data-tid="messageBodyContent"><div><div><div><div><div><div><div><div><div><div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div></div></div></div></div><div><br /></div><div>See also : </div><div><br /></div><div><a href="https://database-heartbeat.com/2020/12/31/create-pdbs-in-a-data-guard-environment-with-tde-enabled/">https://database-heartbeat.com/2020/12/31/create-pdbs-in-a-data-guard-environment-with-tde-enabled/</a></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-81762232734422041322021-06-03T09:21:00.002+01:002023-05-22T15:46:41.337+01:00expdp / impdp as sysdba<p><br /><br />Example of importing with sysdba when you don't have any schema passwords - you could create yourself a user and give yourself dba privs but this is easier. </p><p></p><p>The expdp was just the reverse - putting this in a post as I have used this in the past but took an age to find it in my notes and the syntax is a bit odd to remember.<br /> <br /><br />[oracle@db301] $ impdp \'/ as sysdba\' SCHEMAS=ENGARDE_NORTH1REP DIRECTORY=DATA_PUMP_DIR DUMPFILE=ENGARDE_NORTH1REP.dmp LOGFILE=ENGARDE_NORTH1REP_import.log <br /><br /> Import: Release 12.1.0.2.0 - Production on Fri May 28 14:04:55 2021 <br /><br />Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. <br /><br /><br />Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production <br />With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options <br />Master table "SYS"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded <br />Starting "SYS"."SYS_IMPORT_SCHEMA_01": "/******** AS SYSDBA" SCHEMAS=ENGARDE_NORTH1REP DIRECTORY=DATA_PUMP_DIR DUMPFILE=ENGARDE_NORTH1REP.dmp LOGFILE=ENGARDE_NORTH1REP_import.log <br />Processing object type SCHEMA_EXPORT/USER <br />Processing object type SCHEMA_EXPORT/SYSTEM_GRANT <br />Processing object type SCHEMA_EXPORT/DEFAULT_ROLE <br />Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA <br />Processing object type SCHEMA_EXPORT/TABLE/TABLE <br />Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA <br />. . imported "ENGARDE_NORTH1REP"."FSM_NW_ACTIVITY" 988.7 MB 1952353 rows <br />. . imported "ENGARDE_NORTH1REP"."ALLOCATIONS" 623.4 MB <b>12463222 rows </b><br />. . imported "ENGARDE_NORTH1REP"."EVENTS" 539.0 MB 3761100 rows <br />. . imported "ENGARDE_NORTH1REP"."JOBDESC" 499.4 MB 8609289 rows <br />. . imported "ENGARDE_NORTH1REP"."ACTIVITIES" 252.1 MB 5394085 rows <br />. . imported "ENGARDE_NORTH1REP"."ASSETS" 23.13 MB 313412 rows <br />Processing object type SCHEMA_EXPORT/TABLE/COMMENT <br />Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX <br />Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT <br />Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS <br />Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS <br />Processing object type SCHEMA_EXPORT/STATISTICS/MARKER <br /><br />Job "SYS"."SYS_IMPORT_SCHEMA_01" successfully completed at Fri May 28 14:29:22 2021 elapsed 0 00:24:26 <br /><br /> <br />Quick check : <br /><br /> Connected to: <br /><br />Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production <br /><br />With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options <br /><br /> SQL> select count(*) from ENGARDE_NORTH1REP.ALLOCATIONS; <br /><br /> COUNT(*) <br />---------- <br /> <b>12463222</b></p><p></p><p><br /><span style="font-family: arial;"><b>Example of exporting tables with a parameter file </b><br /><br /> expdp system/secret_password parfile=expdp_TL_BACK_par<br /><br /> $ cat ./expdp_TL_BACK_par</span></p><p><span style="font-family: arial;"><br />DIRECTORY=dpump<br />DUMPFILE=expdp_TL_BACK_%U.dmp<br />LOGFILE=expdp_TL_BACK.log<br />FILESIZE=1000M<br />TABLES=nwgis.TL_BUILD<br />nwgis.TL_HANT<br />nwgis.TL_STRUC<br />nwgis.TL_WATER<br /></span><br /></p><p><b><span style="font-size: medium;">Need to know export size - </span></b></p><p style="text-align: left;"><span style="font-size: medium;">$ expdp \'/ as sysdba\' FULL=y ESTIMATE_ONLY=y NOLOGFILE=y</span></p><p style="text-align: left;"><span style="font-size: medium;">Export: Release 11.2.0.4.0 - Production on Mon May 22 15:16:42 2023</span></p><p style="text-align: left;"><span style="font-size: medium;">Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.</span></p><p style="text-align: left;"><span style="font-size: medium;">Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production</span></p><p style="text-align: left;"><span style="font-size: medium;">With the Real Application Testing option</span></p><p style="text-align: left;"><span style="font-size: medium;">Starting "SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" FULL=y ESTIMATE_ONLY=y NOLOGFILE=y</span></p><p style="text-align: left;"><span style="font-size: medium;">Estimate in progress using BLOCKS method...</span></p><p style="text-align: left;"><span style="font-size: medium;">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA</span></p><p style="text-align: left;"><span style="font-size: medium;">. estimated "LYODBA"."TARCCNF" 26.12 GB</span></p><p style="text-align: left;"><span style="font-size: medium;">. estimated "LYODBA"."TREPOS_TRANSC_ITEM" 22.46 GB</span></p><div style="text-align: left;"><span style="font-size: medium;">etc....</span></div><p>Total estimation using BLOCKS method: 365.6 GB</p><p>Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at Mon May 22 15:17:40 2023 elapsed 0 00:00:57</p><p><br /></p><p> <br /><br /> <br /><br /> </p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-10574538072776436582021-05-19T11:16:00.003+01:002021-05-25T16:09:21.048+01:00Forms & Reports<p> </p><p>Forms and reports are on the way out but in the meantime suggest you should follow this link if you want to install :</p><p><a href="https://oracle-base.com/articles/12c/oracle-forms-and-reports-12c-installation-on-oracle-linux-6-and-7">https://oracle-base.com/articles/12c/oracle-forms-and-reports-12c-installation-on-oracle-linux-6-and-7</a></p><p>Although oracle-base is excellent this site gives more detail if you want to cluster :</p><p><a href="https://docs.rackspace.com/blog/install-and-configure-Forms-and-Reports-for-high-availability-on-OEL/">https://docs.rackspace.com/blog/install-and-configure-Forms-and-Reports-for-high-availability-on-OEL/</a><br /></p><p>This is useful :</p><p><a href="https://www.ludovicocaldara.net/dba/weblogic-in-oci/">https://www.ludovicocaldara.net/dba/weblogic-in-oci/</a><br /></p><p>more to follow....</p><p><br /></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-72062946056441869802021-05-06T10:46:00.000+01:002021-05-06T10:46:07.148+01:00OCI - incident & escalation procedure<p>
</p><p><span style="font-family: Calibri;"><b>Oracle Cloud Infrastructure</b><br /></span></p><h2 style="text-align: left;"><span style="font-size: small;"><span style="font-family: Calibri;"><span style="color: black;">Incident Management & escalation</span> - Standard Process</span></span> </h2><p><span style="font-family: Calibri;"> For OCI incidents (outages, planned/unplanned downtime), general support and<br /> escalations, a standard process (in escalation order of below) must be adhered to. <br /><br /> 1.Oracle Cloud Support - <a href="https://www.blogger.com/#">https://support.oracle.com</a><br /></span> <span style="font-family: Calibri;"><br />Log a Service Request (SR) using your OCI CSI (Customer Support ID), ensuring you are in Cloud Support (not My Oracle Support). <br /></span> <span style="font-family: Calibri;"><br />Using Oracle support for the First Time using the customer Support ID <br /></span> <span style="font-family: Calibri;"><br /></span> <span style="font-family: Calibri;"><a href="https://www.blogger.com/#">https://docs.cloud.oracle.com/en-us/iaas/Content/GSG/Tasks/usingsupportfirsttime.htm#Using_Oracle_Support_for_the_First_Time</a> <br /></span> <span style="font-family: Calibri;"><br />Logging a ticket from inside OCI console <a href="https://www.blogger.com/#">https://docs.cloud.oracle.com/en-us/iaas/Content/GSG/Tasks/contactingsupport.htm</a> <br /></span> <span style="font-family: Calibri;"><br />Don’t be afraid to assign as Severity 1 or 2 to help get expedited service/attention <br /></span> <span style="font-family: Calibri;"><br />Regularly keep your SRs up-to-date (SRs can self-close in 5 days if left unattended) <br /></span> <span style="font-family: Calibri;"><br />2.Request Management Attention on an SR (if needed) <br /></span> <span style="font-family: Calibri;"><br /><a href="https://www.blogger.com/#">How To Request Management Attention on a Service Request (SR) with Oracle Support Services (Doc ID 199389.1)</a> <br /></span> <span style="font-family: Calibri;"><br />Request Duty Manager attention – call 0870 4000900 <br /></span> <span style="font-family: Calibri;"><br />3.Oracle Solutions Consulting (if 1 & 2 above are “failing”) <br /></span> <span style="font-family: Calibri;"><br />Get access/help from product specialists by contacting your OCI Account team. <br /><br /> 4.Contact your Technical Account Management (if 1, 2 & 3 above are “failing”)<br /> </span><span style="font-family: Calibri;"><br />Ensure you have the following available : </span></p><p><span style="font-family: Calibri;">Cloud Services Account Name: <br />Customer Account: <br />OCID: <br />Order ID <br />Subscription ID: <br />CSI Number: <br />Home Region: <br />Identity Domain:</span></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-80272072843753166552021-04-29T09:07:00.000+01:002021-04-29T09:07:15.920+01:00Oracle OEM 13.5<p>Not going to spend an age on this, just to say 13.5 is now available - a lot of information on the web already :</p><p><a href="https://www.markusdba.net/2021/04/10/upgrade-enterprise-manager-cloud-control-to-13-5/">https://www.markusdba.net/2021/04/10/upgrade-enterprise-manager-cloud-control-to-13-5/</a></p><p>Going to upgrade my "sandbox" OEM to 13.5 and will post on that instead.</p><p>Recently moved to 13.4 - mainly as the Adobe Flash end of support was at the end of 2020. </p><p>The migration from 13.2 to 13.4 was pretty painless but did hit a problem when moving the agents. </p><p></p><p class="MsoNormal"><b>EM 13c: OMS Communication to all Agents Failing with "[handshake has no peer]" but Agents are able to Upload Successfully to the OMS (Doc ID 2381313.1</b></p><i>/u02/app/oracle/middleware2/oracle_common/jdk/jre/lib/security<br /><br />Was<br /><br /># jdk.tls.disabledAlgorithms=MD5, SSLv3, DSA, RSA keySize < 2048<br /><br />jdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, DH keySize < 1024, \<br /><br />EC keySize < 224, 3DES_EDE_CBC, anon, NULL<br /><br />As per the doc from the original 13.2 version - this works<br /><br /># jdk.tls.disabledAlgorithms=MD5, SSLv3, DSA, RSA keySize < 2048<br /><br />jdk.tls.disabledAlgorithms=SSLv3, MD5withRSA, DH keySize < 768</i><br /><br />Not exactly sure what “revert back the changes made to disable the MD5withRSA algorithm” – I read it as per 13.2 ?<br /><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="mso-cellspacing: 0cm; mso-padding-alt: 0cm 0cm 0cm 0cm; mso-yfti-tbllook: 1184; width: 100%px;" summary=""><tbody><tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0; mso-yfti-lastrow: yes;"><td style="padding: 0cm 0cm 0cm 0cm; width: 7.5pt;" width="10"></td><td style="padding: 0cm 0cm 0cm 0cm;"></td></tr></tbody></table>
<p class="MsoNormal"><br />After a stop / start of OMS it was then ok.<br /></p>Hopefully 13.5 should be easy enough - not entirely sure what advantages over 13.4 but we will see.<p></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-47957221667829561372021-02-12T09:46:00.005+00:002021-02-12T09:48:21.101+00:00Oracle New Features<p> </p><p>This is an excellent video on probably the two big features going forward with Oracle 19.</p><p> </p><p></p><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="266" src="https://www.youtube.com/embed/AKrwOLS8SYU" width="320" youtube-src-id="AKrwOLS8SYU"></iframe> </div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: left;">Planning to run some Oracle 19 installations and patch at the same time and use the read only feature of the Oracle Home. Will post updates and let you know how I get on but in the meantime suggest you watch this video. <br /></div><br /> <p></p><p> <br /></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-18154034108096582552021-01-19T09:37:00.008+00:002023-10-10T14:59:41.244+01:00Oracle Cloud new instance<p><span style="font-family: arial;">I wanted a new test environment so re-created two instances on the always free option for the Oracle Cloud Infrastructure.</span></p><p><span style="font-family: arial;">Two things which I could not remember from the last time I did this was that the private key that you download when creating the instance, when you use login vi putty you hit an error.</span></p><p><span style="font-family: arial;">Basically the private key from OCI, the putty application does not like it, so you have to import and change it to a version that it does. Just need puttygen.</span></p><p><span style="font-family: arial;"><a href="https://www.puttygen.com/convert-pem-to-ppk">https://www.puttygen.com/convert-pem-to-ppk</a><br /></span></p><p>Or from the command line -</p><p>$ puttygen ssh-key-test.key -o private -o ssh-key-test.ppk</p><div>just use the OCI generated key and change it to .ppk as above.</div><p><span style="font-family: arial;">I tend to follow the notes from the excellent Oracle Base website to install Oracle but when using MobaXterm to run say the graphical Oracle Installer, after a fresh build on Oracle OCI instance you need to change the X11UseLocalhost parameter. Worth changing this to use password authentication at the same time so not dependent on using private keys (this is a test box for me so happy with just a password).</span></p><p><a href="https://docs.oracle.com/en-us/iaas/Content/Resources/Assets/whitepapers/run-graphical-apps-securely-on-oci.pdf"><span style="font-family: arial;">https://docs.oracle.com/en-us/iaas/Content/Resources/Assets/whitepapers/run-graphical-apps-securely-on-oci.pdf</span></a></p><p><span style="font-family: arial;"><br /></span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5_XE2dCAxTgE95D7DYdjsCbtzLadfDEeF_t79eIJ86LFKmgbnQ8qgjOMlAOyVUWZDJVjKapmv3nkTJcaYEZjwKKZ3utDzCtH-xPy7sBOKNBap9rGkg_bicwAMTUEyUB2RlsovT_Ktpp0/" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: arial;"><img alt="" data-original-height="465" data-original-width="608" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5_XE2dCAxTgE95D7DYdjsCbtzLadfDEeF_t79eIJ86LFKmgbnQ8qgjOMlAOyVUWZDJVjKapmv3nkTJcaYEZjwKKZ3utDzCtH-xPy7sBOKNBap9rGkg_bicwAMTUEyUB2RlsovT_Ktpp0/s16000/image.png" /></span></a></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;">If you want to install "figlet" which I use quite a lot you need to add this :</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;"><i>sudo rpm -ivh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm</i></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><a href="https://snapcraft.io/install/figlet/rhel"><span style="font-family: arial;">https://snapcraft.io/install/figlet/rhel</span></a></div><span style="font-family: arial;"><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;"><br /></span></div><div><div style="box-sizing: border-box;">After succesfully installing oracle 19c (follow the notes from Oracle Base) and fighting 19c with 1gig of memory when trying to connect the two servers needed to add port 1521 -</div><div style="box-sizing: border-box;"><br /><div data-tid="messageBodyContainer">
<div data-tid="messageBodyContent"><div>[root@durdb01 etc]# firewall-cmd --permanent --add-port=1521/tcp </div><div><span style="color: #04ff00;">success</span> </div><div>[root@durdb01 etc]# firewall-cmd --reload </div><div><span style="color: #04ff00;">success </span> </div><div> </div><div> [root@durdb01 ~]# firewall-cmd --list-all<br /> public (active)<br /> target: default<br /> icmp-block-inversion: no<br /> interfaces: ens3<br /> sources:<br /> services: dhcpv6-client ssh<br /> <b><span style="color: #04ff00;"> ports: tcp/1521 5556/tcp 9001/tcp 7777/tcp 14021/tcp 5557/tcp</span></b><br /> protocols:<br /> masquerade: no<br /> forward-ports:<br /> source-ports:<br /> icmp-blocks:<br /> rich rules:<br /><br /></div><div> </div><div> </div><div> </div><div>As OCI always free is limited to 1gig had to set the oracle memory parameters as :</div><div> </div><div>memory_max_target big integer 772M<br />memory_target big integer 0</div><div> </div><div>Added 8gig of swap - not a lot of memory to play with but then it is free. <br /></div><div><br /></div><div>Useful link - DataGuard using OCI:</div><div><br /></div><div><a href="https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/usingdataguard.htm">https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/usingdataguard.htm</a><br /></div><div> </div><div></div><div></div><div></div><div></div><div></div><div><br /><br /></div><div> <br /></div>
</div></div></div></div></span><br /><p></p>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-83360596673371444792020-12-10T15:25:00.001+00:002020-12-10T15:25:27.681+00:00Relinking Oracle Grid Home on RAC<p><span style="font-family: arial;"> </span></p><p><span style="font-family: arial;">Couple of notes from Oracle Metalink when</span><span style="font-family: arial;"> relinking Oracle and Grid Home.</span></p><p><span style="font-family: arial;"><br /></span></p><table border="0" cellpadding="0" cellspacing="0" id="kmPgTpl:sd_r1:0:dv_rDoc:0:tl5" style="background-color: white; color: #003d5b; width: 100%px;" summary=""><tbody><tr id="kmPgTpl:sd_r1:0:dv_rDoc:0:rl12"><td align="left" id="kmPgTpl:sd_r1:0:dv_rDoc:0:cf49"><span class="p_AFHoverTarget xq" id="kmPgTpl:sd_r1:0:dv_rDoc:0:ol22" style="padding: 0px 6px 0px 0px; text-align: right;"><label><span style="font-family: arial;"><span style="font-size: small;"><i><b><span style="color: black;">How To Relink The Oracle Grid Infrastructure Standalone (Restart) Installation Or Oracle Grid Infrastructure RAC/Cluster Installation (11.2 to 18.c). </span><span style="color: red;">(Doc ID 1536057.1)<br /></span></b></i></span><b><span style="color: red;"><br /></span></b></span></label></span></td></tr></tbody></table><div style="background-color: white; color: #333333;"><span style="font-family: arial;"><img alt="" height="5" id="kmPgTpl:r1:0:s111" src="https://support.oracle.com/epmos/adf/images/t.gif" width="10" /></span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;">Please note when relinking the grid home the <b>/u01/app/oraInventory/locks</b> directory had to have the permissions changed when the grid relink ran otherwise the relink did not work.</span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;"><br /></span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;">Also, after bringing back some of our boxes and running "<b>crsctl start crs</b>" the cluster was not starting on that node.</span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;"><br /></span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;">After running "<b>oracleasm listdisks</b>" - it turned out some of the diskgroups were missing.</span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;"><br /></span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;">Under investigation.</span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;"><br /></span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;">We ran "<b>oracleasm scandisks</b>" which discovered the disks but still no success with "<b>crsctl stat res -t"</b></span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;"><br /></span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;">The only option was to run "<b>crstcl stop crs -f</b>" and force it down. </span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;"><br /></span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;">Once restarted the server was ok.</span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;"><br /></span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;">Please check that <b>oracleasm scandisks</b> returns the expected values prior to running crsctl start crs.</span></div><div style="background-color: white; color: #333333;"><span style="font-family: arial;"><br /></span></div><div style="background-color: white;"><span style="font-family: arial;"><span style="color: #333333;">The text in </span><span style="color: red;"><b>red</b></span><span style="color: #333333;"> are the commands to run once you have </span><span style="color: red;">stopped all the services </span><span style="color: #333333;">on the node you are about to relink.</span></span></div><div style="background-color: white;"><span style="font-family: arial;"><span style="color: #333333;"><br /></span></span></div><div style="background-color: white;"><span style="font-family: arial;"><span style="color: #333333;"><a href="https://www.durham.computer/2020/04/stopping-node-in-oracle-rac-12c.html">https://www.durham.computer/2020/04/stopping-node-in-oracle-rac-12c.html</a><br /></span></span></div><div style="background-color: white;"><span style="font-family: arial;"><span style="color: #333333;"><br /></span></span></div><div style="background-color: white;"><span style="font-family: arial;"><span style="color: #333333;">If you need to "bounce" the server say for a kernel update please run "<b>crsctl disable crs</b>" or the clustering will start once the server restarts and you will have to stop everything again. Please remember to "<b>crsctl enable crs</b>" when you are happy.</span></span></div><div style="background-color: white;"><h2 style="padding-top: 0.5em; text-align: left;"><span style="font-family: arial; font-size: small;"><span style="color: #333333;">Abridged notes from the Metalink Note </span><span style="color: red;">1536057.1</span><span style="color: #333333;">) :</span></span></h2><h2 style="color: #333333; padding-top: 0.5em; text-align: left;"><span style="font-family: arial; font-size: small;">How To Relink The Oracle Grid Infrastructure RAC/Cluster Installation - v12.2</span></h2><p><span style="font-family: arial;">In order to relink the Oracle Grid Infrastructure RAC/Cluster Installation, please follow the next steps after <b>stopping all the services running</b>:</span></p><p style="color: black;"><span style="font-family: arial;"><br />1) As root OS user, please unlock the Grid Infrastructure Oracle Home (on every node) as follows (set the correct grid home env first) :</span></p><div class="kmcodeblock" style="background-color: #e0eaf1; border-color: rgb(196, 209, 230); border-style: solid; border-width: 1px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em;"><span style="color: red; font-family: arial;"><b># cd < Grid Infrastructure Oracle Home >/crs/install<br /># rootcrs.sh -unlock</b></span></div><p style="color: black;"><span style="font-family: arial;">2) As the Oracle Grid Infrastructure owner (on every node) relink the Grid Infrastructure Oracle Home as follows:</span></p><div class="kmcodeblock" style="background-color: #e0eaf1; border-color: rgb(196, 209, 230); border-style: solid; border-width: 1px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em;"><span style="color: red; font-family: arial;"><b>$ export ORACLE_HOME=< Grid Infrastructure Oracle Home ><br />$ < Grid Infrastructure Oracle Home>/bin/relink all</b></span></div><p style="color: black;"><span style="font-family: arial;">3) As root OS user again, please execute the next commands (on every node):</span></p><div class="kmcodeblock" style="background-color: #e0eaf1; border-color: rgb(196, 209, 230); border-style: solid; border-width: 1px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em;"><span style="color: red; font-family: arial;"><b># cd < Grid Infrastructure Oracle Home >/rdbms/install/<br /># ./rootadd_rdbms.sh<br /># cd < Grid Infrastructure Oracle Home >/crs/install<br /># rootcrs.sh -lock</b></span></div><p style="color: black;"><span style="font-family: arial;"><br /></span></p><div class="kmnotebox" style="background-color: #fff9d7; border: 1px solid rgb(193, 169, 13); padding: 10px;"><span style="font-family: arial;">Then "<span style="color: red;"><b>crsctl start crs</b></span>" - please see note above re oracleasm listdisks<br /></span></div><p style="color: black;"><span style="font-family: arial;"> <strong><span class="awizStartDelimiter"><br /></span></strong></span></p><div class="kmnotebox" style="background-color: #fff9d7; border: 1px solid rgb(193, 169, 13); color: black; padding: 10px;"><span style="font-family: arial;">Note: <strong>CRS services (CRS, CSS ASM instances, diskgroups, listeners, DB instances, etc.) will automatically start.</strong></span></div><p style="color: black;"><span style="font-family: arial;"><strong> <span class="awizEndDelimiter"></span></strong><br />4) Please review the relink.log file located at the following directory (to confirm or discard any error):</span></p><div class="kmcodeblock" style="background-color: #e0eaf1; border-color: rgb(196, 209, 230); border-style: solid; border-width: 1px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em;"><span style="color: red; font-family: arial;"><b>$ < Grid Infrastructure Oracle Home>/install/relink.log</b></span></div><p style="color: black; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><br /></p><p style="color: black; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><span style="font-size: medium;">See also :</span></p><p style="color: black; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><i style="color: #003d5b; font-family: arial; font-size: medium; text-align: right;"><b>Relinking Oracle Home FAQ ( Frequently Asked Questions) <span style="color: red;">(Doc ID 1467060.1)</span></b></i></p><p style="color: black; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><br /></p></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-60267431720299418632020-12-04T11:14:00.003+00:002020-12-04T13:11:08.918+00:00Last date from a group in oracle table<div><br /></div><div><span style="font-family: arial;">Asked to run a query against a two column table, one column having a procedure name and the other with the date the procedure was last ran. </span></div><div><span style="font-family: Arial;"><br /></span></div><div><span style="font-family: Arial;">e.g.</span></div><div><span style="font-family: Arial;"><br /></span></div><div><span style="font-family: Arial;">PROC_NAME START_DTM<br />------------------------------ ---------<br />TVM Cash Balance 05-NOV-20<br />TVM Cash Balance 12-NOV-20<br />TVM Cash Balance 02-DEC-20<br />TVM Cash Balance 01-DEC-20<br />TVM Cash Balance 03-DEC-20<br /><span style="color: red;"><b>TVM Cash Balance 04-DEC-20</b></span><br />TVM Cash Balance 30-SEP-20<br />TVM Cash Balance 18-SEP-20<br />TVM Cash Balance 01-SEP-20<br />TVM Cash Balance 29-SEP-20<br />TVM Cash Balance 12-SEP-20<br /></span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">We needed to select the last date for each procedure.</span></div><div><span style="font-family: arial;"></span><br /></div><div><span style="font-family: arial;">This works :</span></div><div><span style="font-family: arial;"></span><br /></div><div><span style="font-family: arial;"><i>select proc_name, max(start_dtm) from dw_main.proc_run_log where proc_name in (select distinct(proc_name) from dw_main.proc_run_log) group by proc_name order by proc_name;</i></span></div><div><span style="font-family: Arial;"><i><br /></i></span></div><div><span style="font-family: arial;"></span><i></i><br /></div><div><span style="font-family: arial;">PROC_NAME <span> </span> MAX(START</span><br /></div><div><span style="font-family: arial;">------------------------------ <span> </span><span> </span><span> </span> ---------</span><br /></div><div><span style="font-family: arial;">Summarize Tap RW Error Summary <span> </span>04-DEC-20</span><br /></div><div><span style="font-family: arial;">Summarize Tap Speed Summary <span> </span> 04-DEC-20<br />Summarize Txn Timing <span> </span>04-DEC-20<br />TVM Cash Balance <span> </span>04-DEC-20<br />Update Card Statuses <span> </span> 04-DEC-20</span></div><div><span style="font-family: arial;">....</span></div><div><span style="font-family: arial;">131 rows selected.</span></div><div><span style="font-family: arial;"></span><br /></div><div><span style="font-family: arial;"></span><br /></div><div><span style="font-family: arial;">We wanted to double check (and to show how this could also be achieved in pl/sql) to be absolutely certain so put this together (the sql is also easier to understand ):</span></div><div><i><br /></i></div><div><i><span style="font-family: Arial; font-size: x-small;">create or replace procedure ruslist<br /> is<br /> proc_rus varchar2(30);<br /> start_rus date;<br />CURSOR d1 IS SELECT distinct proc_name from dw_main.proc_run_log order by proc_name;<br />CURSOR d2 IS SELECT max(start_dtm) from dw_main.proc_run_log where proc_name = proc_rus;<br />BEGIN<br /> open d1;<br /> LOOP<br /> FETCH d1 into proc_rus;<br /> EXIT when d1% NOTFOUND;<br /> dbms_output.put( proc_rus);<br /> open d2;<br /> LOOP<br /> FETCH d2 into start_rus;<br /> EXIT when d2% NOTFOUND;<br /> dbms_output.put_line(' '||start_rus);<br /> END LOOP;<br />CLOSE d2;<br /> END LOOP;<br />CLOSE d1;<br />EXCEPTION<br /> WHEN OTHERS THEN<br /> raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);<br />END ruslist;<br /></span></i></div><div><span style="font-family: arial; font-size: x-small;"><i><br /></i></span></div><div><span style="font-family: arial;">......<br /></span></div><div><span style="font-family: arial;">Summarize Tap RW Error Summary 04-DEC-20<br />Summarize Tap Speed Summary <span> </span>04-DEC-20<br />Summarize Txn Timing <span> </span><span> </span><span> </span><span> </span><span> </span>04-DEC-20<br />TVM Cash Balance <span> </span><span> </span><span> </span><span> </span><span> </span><span> </span><span> </span>04-DEC-20<br />Update Card Statuses <span> </span><span> </span><span> </span><span> </span><span> </span><span> </span><span> </span>04-DEC-20</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">PL/SQL procedure successfully completed.</span></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: arial;">SQL></span><br /></div><div><span style="font-family: arial;"><br /></span></div><div><span style="font-family: Arial;">Happy days.</span></div><div><span style="font-family: arial;"></span><br /></div><span style="font-family: verdana; font-size: x-small;"></span><span style="font-family: verdana; font-size: x-small;"><div><span style="font-size: small;"></span><span style="font-family: arial;"></span><br /></div></span><div><span style="font-family: verdana;">
</span></div><span style="font-family: verdana;"><p style="line-height: 115%; margin: 0px 0px 13.33px;">
</p><p style="margin: 0px;"><br /></p></span><div><span style="font-family: verdana;">
</span></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0tag:blogger.com,1999:blog-338320275115547555.post-58283157035219130752020-11-25T10:41:00.009+00:002020-11-25T14:20:24.530+00:00A bit of fun.....<div><span style="font-family: inherit;"><br /></span><div><div style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><span style="font-family: inherit;"><img alt="" data-original-height="699" data-original-width="909" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyAHW6xT-h69MyDXeTHI_hJP_rUxXEkMxn-JJPi4khwO8UlDm3OHhg63zE5iRJwbVsmH6rRecZ2d-t8kd8xzMNI3OPiGd-L9SCt8iWZpwL-rKWeeHJKqu7HP7qg8BHl926GqbXYBbRiJA/w320-h246/image.png" style="text-align: center;" width="320" /></span></div><span style="font-family: inherit;">Although the games under MobaXTerm can be entertaining wanted something with a bit fun at a Linux level. Some interesting commands are "sl" - Steam Locomotive, to annoy admin people who can't type ls, "cowsay" (what can I say) and "figlet". </span></div><div><span style="font-family: inherit;"><br /></span></div><div><span style="font-family: inherit;">More here :</span></div><div><span style="font-family: inherit;"><br /></span></div><div><span style="font-family: inherit;"><a href="https://www.tecmint.com/20-funny-commands-of-linux-or-linux-is-fun-in-terminal/">https://www.tecmint.com/20-funny-commands-of-linux-or-linux-is-fun-in-terminal/</a><br /></span></div><div><i><b><br /></b></i></div><div><i><b><br /></b></i></div><div><i><b><br /></b></i></div><div><i><b><br /></b></i></div><div><b><i>$yum install sl</i></b></div><div><b><i>$yum install cowsay</i></b></div><div><b><i>$yum install figlet</i></b></div><div><b><i><br /></i></b></div><div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: inherit;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSJ6EWlynSANwKAnNNhljACYb_aP15ZdBh2XwYsCIxNfbF6YcqU6DkxVOcfueSgkI-PNyDyxCm_BsTxi2AwVJ-P0P1BF9qlkBGKKY8xg9RvcwwaN-J_6xuCsjaN0_hVA05Fy1uA0PgBFo/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="392" data-original-width="1067" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSJ6EWlynSANwKAnNNhljACYb_aP15ZdBh2XwYsCIxNfbF6YcqU6DkxVOcfueSgkI-PNyDyxCm_BsTxi2AwVJ-P0P1BF9qlkBGKKY8xg9RvcwwaN-J_6xuCsjaN0_hVA05Fy1uA0PgBFo/w400-h148/image.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: left;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9UZVXEExo0KYo7KfponuHQqeY8xQEXMyL-Ny0Wug6FFZ4sRaEf2THOzNQdQOE4WTe-NFdW5_TfSSAhObbUvrXOGZc0WsoTlN81EfkIwrWZZfRScoxNe0IuMBh5ILemdLdYhUYjNQZcYI/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="359" data-original-width="628" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9UZVXEExo0KYo7KfponuHQqeY8xQEXMyL-Ny0Wug6FFZ4sRaEf2THOzNQdQOE4WTe-NFdW5_TfSSAhObbUvrXOGZc0WsoTlN81EfkIwrWZZfRScoxNe0IuMBh5ILemdLdYhUYjNQZcYI/w400-h229/image.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: inherit;">Let me know if you have used any others or have your own silly commands.</span></div><br /><br /></div><span style="font-family: inherit;"><br /></span><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /><br /><span style="font-family: inherit; margin-left: 1em; margin-right: 1em;"></span></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /></div></div>Ian Smithhttp://www.blogger.com/profile/16052373760642512297noreply@blogger.com0