Pular para o conteúdo principal


Postagens recentes

How to Disable WebLogic Server Diagnostic Framework (WLDF)

[weblogic@yourhost ]$ cd $MW_HOME/oracle_common/common/bin/ [weblogic@yourhost bin]$ ./wlst.sh Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands wls:/offline> connect('weblogic','password','t3://host_ip:port') Connecting to t3://xx.xx.xx.xx:7001 with userid weblogic ... Successfully connected to Admin Server "AdminServer" that belongs to domain "WeblogicDomain". Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. wls:/WeblogiDomain/serverConfig/> edit() Location changed to edit tree. This is a writable tree with DomainMBean as the root. To make changes you will need to start an edit session via startEdit(). For more help, use help('edit'). wls:/WeblogiDomain/edit/> startEdit() Starting an edit session ... Started edit session, be sure

Changing profile Java Color Scheme through plsql

sqlplus apps/apps set serveroutput on DECLARE BEGIN         dbms_output.disable;         dbms_output.enable(100000);         stat := FND_PROFILE.SAVE('FND_COLOR_SCHEME', 'OLIVE', 'SITE');         IF stat THEN                 dbms_output.put_line( 'Stat = TRUE - profile updated' );         ELSE                 dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );         END IF;         commit; END; / Below, some values that you can use: BLUE KHAKI OLIVE PURPLE RED SWAN TEAL TITANIUM 

Recompile JSP EBS - R12.2

1. Backup $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/ $ mv _pages _pages_old 2. Stop services cd $ADMIN_SCCRIPTS_HOME ./adapcctl.sh stop ./admanagedsrvctl.sh stop oafm_server1 ./admanagedsrvctl.sh stop oacore_server1 3. Compile the jsps manually  cd $FND_TOP/patch/115/bin/ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p             4. Checking $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages $ ls -ltr  5. Start services cd $ADMIN_SCCRIPTS_HOME ./admanagedsrvctl.sh start oacore_server1 ./admanagedsrvctl.sh start oafm_server1 ./adapcctl.sh start 6. Clear your web browser cache

Changing EBS Profile using PL/SQL

 DECLARE    stat   BOOLEAN; BEGIN    DBMS_OUTPUT.DISABLE;    DBMS_OUTPUT.ENABLE (100000);    stat := fnd_profile.SAVE ('SITENAME', 'VALOR DESEJADO', 'SITE');    IF stat    THEN       DBMS_OUTPUT.put_line ('Stat = TRUE - profile updated');    ELSE       DBMS_OUTPUT.put_line ('Stat = FALSE - profile NOT updated');    END IF;    COMMIT; END;

How-to decrypt password from boot.properties

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

Running SQL Tuning Advisor Manually

  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 =&