DBORCLOUD Blog

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 following S.O. commands): # unzip apex_listener.2.0.5.287.04.27.zip –d apex_listener   Now you move the folder just created in the Oracle folder and give the right permissions to everyone for access this folder (for simplified I give an everyone full control). # mv Read More

Upgrade database Release 11gR2 to Release 12c

This Article show how to manual upgrade 11.2.0.3 Oracle database ti non-plugged Database 12c Starting from database 11203 SQL> select instance_name,version,statup_time,status from v$instance;   INSTANCE_NAME    VERSION       STARTUP_T    STATUS ————- —————————-  ———-       DB11          11.2.0.3.0   28-JAN-14   OPEN      Below Minimum database version that can be  directly upgraded to Oracle 12c Release 1 (12.1) Source Database     Target Database 10.2.0.5     12.1.x 11.1.0.7     12.1.x 11.2.0.2 or higher 12.1.x   The following database versions will require an indirect upgrade path: Source Database     Intermediate Upgrade Path for Target Database Target Database 11.2.0.1            —-> 11.2.0.2 or higher                             —-> 12.1.x 11.1.0.6     Read More

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 following S.O. commands): # unzip apex_listener.2.0.5.287.04.27.zip –d apex_listener   Now you move the folder just created in the Oracle folder and give the right permissions to everyone for access this folder (for simplified I give an everyone full control). # mv apex_listener Read More

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 a path from the system table all_directories where directory name is GARBAGE_SFTP_AREA. At the beginning, dir_in = indicate the variable where we’ll put the result (the value of directory_path field). With the symbol s COMMAND  bash execute the command between  and replace Read More

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 created from unzip command, to oracle folder with command: # mv apex <oraclefolder>/apex_app You change directory to apex_app and connect to database with SQLPlus: # sqlplus /nolog SQL> CONNECT SYS AS SYSDBA   You run the installation script of APEX SQL> @apexins.sql Read More

Create triggers on system events

System events are particular database states that can be used to fire a system trigger. Is possibile to create triggers for these events at DATABASE or SCHEMA level. When a triggering event occurs, the database will open an autonomous transaction scope, fire the trigger and commit any transaction imbedded in the trigger. The available system events are: AFTER STARTUP        Causes the DataBase to fire the trigger whenever the database is opened. This event is valid only with DATABASE, not with SCHEMA BEFORE SHUTDOWN      Causes the DataBase to fire the trigger whenever an instance of the Read More