Monthly Archives: marzo 2014

How to install Oracle Apex Listener 2.0.5 under Tomcat Application Server
  • 26
    Mar

How to install Oracle Apex Listener 2.0.5 under Tomcat Application Server

This guide refer to Oracle Apex Listener 2.0.5 and installed on debian like server under Tomcat Application Server (Tomcat 7 for this guide).   First you must download the package of APEX Listener from Oracle site and then unzip the package on your server with command (use “sudo” if you not have right permission for do this and...

Read More
Retrive sqldata through shell script
  • 18
    Mar

Retrive sqldata through shell script

It could be useful get data from DB by a  bash script Linux. Using a shell Bash is possible to create the following query: dir_in=`sqlplus -s $PMS_CONN_STRING <<EOF SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF select directory_path FROM all_directories WHERE directory_name = ‘GARBAGE_SFTP_AREA’; exit EOF Analyze this script. The query above, very simple, extracts...

Read More
How to install APEX 4.2.3
  • 11
    Mar

How to install APEX 4.2.3

This guide refer to APEX release 4.2.3 and installed on debian like server. First you must download the package of APEX from Oracle site and then unzip the package on your server with command (use “sudo” if you haven’t  right permission for do this and following S.O. commands): # unzip apex_4.2.3.zip   Move your apex directory, that it...

Read More