Posts Tagged ‘oracle’

Steps to install Oracle Express Edition (XE) database 10g on Ubuntu 11.10 (Oneiric). Download the Oracle XE deb package (free registration is required). Double click the downloaded file and select to install it. In terminal run sudo /etc/init.d/oracle-xe configure. You will be prompted to enter the following parameters: HTTP port number, database listener port number, […]

Saturday, February 4th, 2012 at 11:21 | 0 comments
Categories: Database, Linux
Tags: ,

Installing Oracle BI Enterprise Edition (OBIEE) will by default also install the OC4J application server. On Windows machines, it is not installed as a service, instead it runs in a dedicated command shell window. By default, OC4J will start automatically at the session startup, not only bringing up the annoying command line window but also […]

Tuesday, May 19th, 2009 at 15:29 | 0 comments
Tags: ,

To prompt the user for a value when running SQL statements in SQL*Plus use the & symbol. The query below will prompt for variable “name” twice: select ‘Hello ‘ || ‘&name’ from dual union all select ‘Goodbye ‘ || ‘&name’ from dual; To prompt for any given variable only once and use the entered value […]

Saturday, May 9th, 2009 at 10:02 | 0 comments
Categories: Database
Tags: ,

Oracle Database XE (Express Edition, sometimes also referred to as Apex) comes with an embedded web interface for administration. By default the HTTP port of this web interface is 8080. This can be checked by running the query below when logged in as system: SQL> select dbms_xdb.gethttpport from dual; In order to change the port […]

Tuesday, April 21st, 2009 at 13:48 | 1 comment
Categories: Database
TOP