Dicas ORACLE DBA

Using WLST, connect('weblogic','password,'localhost:7001') Run the following WLST command to attach an OWSM policy on the Spaces Web service endpoint: attachWebServicePolicy(application='webcenter', moduleName='webcenter', moduleType='web', serviceName='SpacesWebService',subjectName='SpacesWebServiceSoapHttpPort', policyURI='oracle/wss11_saml_token_with_message_protection_service_policy') Run the following WLST command to attach an OWSM policy on the Discussions Web service endpoint: attachWebServicePolicy(application='owc_discussions', moduleName='owc_discussions', moduleType='web', serviceName='OWCDiscussionsServiceAuthenticated',subjectName='OWCDiscussionsServiceAuthenticated', policyURI='oracle/wss10_saml_token_service_policy') Reference: Doc ID 1541024.1

Pre-Requiste: Install OAM 11.1.1.7 Install OHS 11.1.1.7 Install WebGate 11.1.1.7 Setup:  Configure Webgate Agent for OHS Register Webgate Agent to OAM 1. Configure Webgate Agent for OHS  Execute the following command to copy the required bits of agent from the Webgate_Home directory to the Webgate Instance location /u01/oracle/Middleware/Oracle_OAMWebGate1/webgate/ohs/tools/deployWebGate/deployWebGateInstance.sh -w /u01/oracle/Middleware/Oracle_WT1/instances/instance1/config/OHS/ohs1 -oh /u01/oracle/Middleware/Oracle_OAMWebGate1 Ensure that the LD_LIBRARY_PATH variable contains <Oracle_Home_for_Oracle_HTTP_Server>/lib: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/oracle/Middleware/Oracle_WT1/lib Execute the following command to copy the apache_webgate.template from the Webgate_Home directory to the Webgate Instance location: /u01/oracle/Middleware/Oracle_OAMWebGate1/webgate/ohs/tools/setup/InstallTools/E

Easily Install Oracle RDBMS 12cR1 on Oracle Linux 6

Purging statistics from the SYSAUX tablespace

--As  SYS Schema EXEC dbms_java.grant_permission('DENILSON', 'SYS:java.lang.RuntimePermission', 'writeFileDescriptor', ''); EXEC dbms_java.grant_permission('DENILSON', 'SYS:java.lang.RuntimePermission', 'readFileDescriptor', ''); EXEC dbms_java.grant_permission('DENILSON', 'SYS:java.io.FilePermission', '/bin/sh', 'execute'); connect denilson/denilson CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "host" AS import java.io.*; public class Host {   public static void executeCommand(String command) {     try {       String[] finalCommand;       if (System.getProperty("os.name").toLowerCase().indexOf("windows") != -1) {         finalCommand = new String[4];         finalCommand[0] = "C:\\winnt\\system32\\cmd.exe";         finalCommand[1] = "/y";         finalCommand[2] = "/c";         finalCommand[3] = command;    

CREATE OR REPLACE PROCEDURE send_mail (p_to        IN VARCHAR2,                                        p_from      IN VARCHAR2,                                        p_subject   IN VARCHAR2,                                        p_text_msg  IN VARCHAR2 DEFAULT NULL,                                        p_html_msg  IN VARCHAR2 DEFAULT NULL,                                        p_smtp_host IN VARCHAR2,                                        p_smtp_port IN NUMBER DEFAULT 587 ) AS   l_mail_conn   UTL_SMTP.connection;   l_boundary    VARCHAR2(50) := '----=*#abc1234321cba#*='; BEGIN -- Autentication Configuration l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port); utl_smtp.command(l_mail_conn,'AUTH LOGIN'); utl_smtp.command(l_mail_conn,utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(' denilson@denilson.com.br ')))); utl_smtp.command(l_mail_conn,utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_t

Download APEX from OTN http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html Install Apex for Full Development Environment @apexins.sql APEX_DATA APEX_FILES TEMP /i/ Change password for user ADMIN - The same script can be used for password lost @apxchpwd.sql Configure the Embedded PL/SQL Gateway @apex_epg_config.sql /u01/app/oracle/product Updating the Images Directory @apxldimg.sql /u01/app/oracle/product Change job_queue_processes parameter in database SELECT VALUE FROM v$parameter WHERE NAME = 'job_queue_processes'; ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20 scope=both; Enable XDB Service SELECT DBMS_XDB.GETHTTPPORT FROM DUAL; EXEC DBMS_XDB.SETHTTPPORT(8080); Create ACL to allow access DECLARE   ACL_PATH  VARCHAR2(4000); BEGIN   -- Look for the ACL currently assigned to 'localhost' and give APEX_040200   -- the "connect" privilege if APEX_040200 does not have the privilege yet.   SELECT ACL INTO ACL_PATH