Pocket Oracle PDA Admin

Shareware Oracle DBA Application

By Sean & Lisa Ryan (c) 2005/2006

 

Updated: 12/10/2006

Make a donation:

The aim of POPA was to make a web-based application that could utilise a wireless PDA to allow its use as a mobile Oracle Database administrator’s tool.

View the Product Brochure here.
 
POPA is a custom web based application written in ASP, Server side JAVA, HTML and SQL. POPA uses ASP queries to access it’s own Oracle based repository of views, functions and tables.

This allows all the SQL complexity to reside on the Database server. All of POPA’s queries are custom written and based on years of DBA experience.
 
POPA combines custom code, SSL, Password encryption, PDA hardware, WI-FI, Bluetooth and Oracle technologies to combine into a single Windows © based solution.
 
Product Highlights:

  • Simple to use interface puts the power of over 70 Database monitoring queries and functions executed through use of stylus and touch screen into the DBA’s hand. There is no need to remember or type long queries.
  • A Comprehensive health check option is available, executing 15 major queries at the touch of a button. These are displayed in simple traffic light format which can be drilled down even further where needed.
  • The ability to run, save and load any custom written SQL is provided to allow the execution of SQL that POPA does not provide out of the pack.
  • The ability to run server side o/s commands, even allowing the shutdown and start-up of the Oracle © Database (in the event of problems).
     
    In order to insure compatibility POPA has been tested with the major Oracle © versions in the Market place. 8i , 9i and 10G and works with all.

 

The User Interface

 

 

Screen Elements: 

1) POPA: Restart the Application. Select this option to restart POPA at introduction screen.

2) Home: Go to Home screen (user interface screen).

3) Help: Launch Help for present screen. This option will provide you with a list of all help as well as the option of searching through all help files.

4) About: Show about information for the application and the developers.

5) Links: Go to links screen for general Internet DBA links.

6) Database Manager: Launch the Database Manager.

7) Lock Manager: Launch the Lock Manager.

8) Object Manager: Launch the Object Manager. 

9) Security Manager: Launch the Security Manager. 

10) Session Manager: Launch the Session Manager.

11) Tuning Manager: Launch the Tuning Manager.

12) Storage Manager: Launch the Storage Manager.

13) Health Check: Launch the Health Check (Manager).

14) SQL Window: Launch the SQL Window (Manager).

15) Shell Window: Launch the Shell Window (Manager).

16) Database Status – showing Database connected to. 

17) Clock: Showing system time.

Downloads

You can download the user manual here. (.rar compression) If you want the full version, email me and I can send it on. This version is reduced to user interface and install instructions only.

The Web code and Oracle repository script here. (.rar compression)

               Although POPA is free to use, you can make a donation below.

To pay by PayPal, click on this button: