Dicas ORACLE DBA

Script: import os import weblogic.security.internal.SerializedSystemIni import weblogic.security.internal.encryption.ClearOrEncryptedService   def decryptString(domainPath, encryptedString):     es = weblogic.security.internal.SerializedSystemIni.getEncryptionService(domainPath)     ces = weblogic.security.internal.encryption.ClearOrEncryptedService(es)     decryptedString = ces.decrypt(encryptedString)     print "=" * 40     print " " * 10 +"Decrypted Password:" + decryptedString     print "=" * 40   try:     os.system('clear')     if len(sys.argv) == 3:         decryptString(sys.argv[1], sys.argv[2])     else:         print "=" * 40         print "INVALID ARGUMENTS"         print "Usage: java weblogic.WLST %s <ABSOLUTE DOMAIN_HOME PATH> <ENCRYPTED_PASSWORD>" %sys.argv[0]         print "e.g.:"         print "    java weblogic.WLST %s /domains/your_domain/ {AES}xxx-hash-xxx" %s

  DECLARE   l_sql_tune_task_id  VARCHAR2(100); BEGIN   l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (                           sql_id      => '6x2xfudxngmmj',                           scope       => DBMS_SQLTUNE.scope_comprehensive,                           time_limit  => 1200,                           task_name   => '6x2xfudxngmmj_AWR_tuning_task',                           description => 'Tuning task for query 6x2xfudxngmmj in AWR.');   DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id); END; / begin  DBMS_SQLTUNE.execute_tuning_task(task_name => '6x2xfudxngmmj_AWR_tuning_task'); END; / SELECT task_name, status    FROM dba_advisor_log   WHERE owner = 'SYSTEM';  SET LONG 10000; SET PAGESIZE 1000 SET LINESIZE 200 SELECT DBMS_SQLTUNE.report_tuning_task('6x2xfudxngmmj_AWR_tuning_task') AS recommendations    FROM dual; -- Interrupting EXEC DBMS_SQLTUNE.interrupt_tuning_task (task_name =&

Sometimes, we need to know wich users or groups is in a files structures on linux. It´s a simple hint, but for me is very useful for migrations, mainly in aplications migrations. To show owners (users): find . -printf '%u\n' | sort -t: -u To show group owners: find . -printf '%g\n' | sort -t: -u

Oracle Database 20c preview version available for virtual machine DB systems Services :  Database Release Date : Feb. 14, 2020 You can now provision a virtual machine DB system with Oracle 20c preview version software to do development and application testing. Preview version software is limited to virtual machine systems using the Fast Provisioning option (which uses Logical Volume Manager for storage management). For more information, see  Oracle Database Preview Version Availability . You must use Logical Volume Manage to show the 20c version option: