Dicas ORACLE DBA

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