techxplore blog

Archive for November, 2007

27 Nov

Post-installation Task for Oracle Application Express 3.0

Oracle Application Express Post-installation task: Restart Processes(ex. listener, etc.. ) Choose the HTTP Server Configuring the Embedded PL/SQL Gateway run apex_epg_config.sql passing the file system path to the base directory where Application Express was unzipped. if apex_3.0.zip was unzip in C:\oracle\product\10.2.0\db_1\ ex. @apex_epg_config C:\oracle\product\10.2.0\db_1; Unlock the ANONYMOUS account ALTER USER ANONYMOUS ACCOUNT UNLOCK; Verify Oracle [...]

27 Nov

Resetting Application Express Admin Password

Just as a preliminary, to work around the access to “apex_admin” you can perform the following steps: (1) Go to you ApEx installation folder (where apexins.sql is located. (2) log into sqlplus as sys (3) ALTER SESSION SET CURRENT_SCHEMA = FLOWS_030000 (4) @builder/f4050 *note, I also ran @builder/f4550 and @builder/f4700 by accident and these were [...]

27 Nov

Installing Oracle Application Express 3.0

Steps in installing Oracle Application Express: Download apex_3.0.zip file Unzip apex_3.0.zip Copy extracted directory “apex” to $ORACLE_HOME ex. $ORACLE_HOMEC:\oracle\product\10.2.0\db_1\  Change working directory to apex ex. cd C:\oracle\product\10.2.0\db_1\apex start sqlplus and connect as SYS ex. sqlplus sys/ as sysdba run apexins.sql with the following five arguments – password – password of the Application Express Administrator (ex. [...]

27 Nov

Not so Useful Laptop in Training

Having a laptop is useful. I can go places with it and do some web development; I can also use it in class trainings. It’s very handy and the features are the same as desktop computer. One moment during the training class I have with some Mongolian folks, I need to show a video clip [...]

27 Nov

Possible Developer Topics for Oracle Application Express Class

Outlined below are the possible topics for Oracle Application Express Developer’s Guide Session: Creating Reports Generating Reports Using Wizards Editing Report Attributes Adding Links in Reports Saving or Printing Reports in Different Formats Creating Forms Creating a Form on a Table With a Report Creating a Tabular Form Creating a Master-Detail Form Editing Form Attributes [...]

27 Nov

Windows XP Installation Requirements for Oracle Application Express 3.0

Oracle Application Express can be installed in different operating system platforms. Outlined here are the installation requirements in Windows XP environment. Topics: Oracle Database Requirement Browser Requirement HTTP Server Requirements Disk Space Requirement Oracle XML DB Requirement Oracle Text Requirement PL/SQL Web Toolkit Oracle Database Requirement Oracle database release 9.2 or higher is the required [...]

27 Nov

Introduction to Oracle Application Express

Oracle Application Express an introduction to aspiring application developers. Topics: Oracle Application Express a Synopsis Architecture of Oracle Application Express About Application Express Environment User Roles in Application Express Oracle Application Express a Synopsis Oracle Application Express is a free web application development tool for Oracle database. Just by using a web browser and armed with a [...]

26 Nov

Technological Space Saving Digital Frames

The old photo frames or photo albums are becoming a thing of the past. Photos are one of the most treasured things we have at home and we keep tons of it. But we do seldom have the time to open it up and look at them. We only have the time to open them [...]

25 Nov

Out of the Box Collaboration Tool

In many growing companies or businesses communication and collaboration are difficult areas to respond. This is especially when the offices spans different geographical location. For example satellite centers of higher education spread throughout multiple locations definitely will have some collaboration barriers. There are problems like the ability to communicate effectively and efficiently with various regional [...]

24 Nov

Predicting Future PageRank

People are going crazy about PageRank. It seems that it’s everything, maybe for those living based on it. Google’s latest PageRank update really did hit a lot of people. Most sites that have links or ad links we’re hit by PageRank penalty. My site was not spared, before I have PR5 but now it’s down [...]