Dicas ORACLE DBA

  Usage oci setup repair-file-permissions [OPTIONS] Source: https://docs.oracle.com/en-us/iaas/tools/oci-cli/3.22.4/oci_cli_docs/cmdref/setup/repair-file-permissions.html#id3

 https://www.digitalocean.com/community/tutorials/how-to-install-perlbrew-and-manage-multiple-versions-of-perl-5-on-centos-7

[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...

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 

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

 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;