4. March 2008 by admin.

I was just thinking of whether it would be possible to run various programs on laptop using OracleXE with Sigma tables that could be automaticly linked to be downloaded/updated only when necessary. The advantage would be that we would only need to hook-up with VPN to update/download tables. All work could be done on laptop without any network hookup.

Posted in Uncategorized | No Comments »

4. March 2008 by admin.

Today I installer jdeveloper.  So far so good.  I now got jdeveloper installed  and have setup my AUD_TEST database on jdeveloper. wow! I can see the tables i created in XE.  OK… Now I got Oracle XE with the new APEX 301, Sqldeveloper, and now jdeveloper.

Posted in Uncategorized | No Comments »

4. March 2008 by admin.

Last week I created tables in OracleXE/APEX from my excel Mineral spreadsheet.  I’m not sure what columns (I have a hard time not calling them fields) I am going to need.  What are going to be the variables, how to write the script, etc.?  I imported cvs text files to create the tables. I also pulled data and tables from Sigma for PARCEL table using sqlplus spool over the VPN.

Posted in Uncategorized | No Comments »

15. February 2008 by admin.

This is a good summary of APEX -
What is Application Express? http://www.oracle.com/technology/products/database/application_express/html/what_is_apex.html

With Oracle XE and APEX301 working, the last two days I’m been using the Oracle Database 2 Day + Application Express Developer’s Guide and setting up the sample hr database and APEX application. I learned a lot, but got lost a lot also. I need to decide what workspace and Schema I need to set up for development. How much I use APEX to setup or PLSQL or sqldeveloper.I will return to developing thinking how to convert my excel spreadsheets and logic to use Oracle databases. When I have the databases setup I can begin some APEX. I guess I will begin with a single year and worry about the line adjustment values last, because these need last year’s past values. I’m not sure what I’ll do about past values, query databases or re-cal or store values.

Posted in Uncategorized | No Comments »

14. February 2008 by admin.

I guess I made the install overly complex.
Install Oracle XE with APEX301 - Revised
Last week I tried to Install Oracle XE with APEX301, but this is a revision.
I try to follow the Oracle instructions, with a small change.

Installed XE
password set to samepassword

======
THIS IS THE CHANGE FROM Oracle instructions…

Login as SYSTEM and
1. unlock hr and set password to samepassword
2. change anonymous user password to samepassword

===========
Extract apex301 to C:\oraclexe\app\oracle\product\10.2.0\server\apex
C:\oraclexe\app\oracle\product\10.2.0\server\apex>sqlplus sys/samepassword as sysdba
SQL> @apexins.sql samepassword SYSAUX SYSAUX TEMP /i/ NONE

installs apex301…[notice PATH]

=============
Once you complete the standard install,
you need to perform the following steps to complete the upgrade:

1. Install images [notice PATH, now images will install]
$ cd C:\oraclexe\app\oracle\product\10.2.0\server\apex
$ C:\oraclexe\app\oracle\product\10.2.0\server\apex>sqlplus sys/samepassword as sysdba
SQL> @apxldimg.sql C:\oraclexe\app\oracle\product\10.2.0\server

2. Update password
$ cd C:\oraclexe\app\oracle\product\10.2.0\server\apex
$ C:\oraclexe\app\oracle\product\10.2.0\server\apex>sqlplus sys/samepassword as sysdba
– change sys system password
SQL> @apxxepwd.sql samepassword

==============
login to http://127.0.0.1:8080/apex/apex_admin
user: Admin Password: samepassword
change password to samepassword
check out options
logout
Make shortcut on oracle start menu to apex_admin

login to your other users system, hr, sys
and make sure you can login

================
extract sqldeveloper.zip to folder c:/sqldeveloper
run sqldeveloper.exe and update
Connection Name: LocalXE
Username: sys
Password: samepassword
check Save Password
Role: SYSDBA
Test and Connect

Posted in APEX301 | No Comments »

9. February 2008 by admin.

Install Oracle XE with APEX301
Last week I tried to Install Oracle XE with APEX301.
This is what I did. I haven’t tested it yet.

Installed XE
Made all passwords same during setup

======

Login sys and
unlock hr and
reset password to same as sys
========

Create Development tablespace at sql command prompt

cd\
sqlplus sys/aujlb as sysdba
– CREATE TABLESPACE
CREATE TABLESPACE DEVELOPMENT datafile
‘C:\oraclexe\oradata\XE\development.dbf’ SIZE 20M;

– USER SQL
CREATE USER jburkhart IDENTIFIED BY aujlb
DEFAULT TABLESPACE DEVELOPMENT
TEMPORARY TABLESPACE TEMP;

– ROLES
GRANT “RESOURCE” TO jburkhart ;
GRANT “CONNECT” TO jburkhart ;
ALTER USER jburkhart DEFAULT ROLE “RESOURCE”,”CONNECT”;

– SYSTEM PRIVILEGES
GRANT CREATE DATABASE LINK TO jburkhart ;
GRANT UNLIMITED TABLESPACE TO jburkhart ;
GRANT CREATE SESSION TO jburkhart ;
GRANT ALTER SESSION TO jburkhart ;
GRANT CREATE SEQUENCE TO jburkhart ;
GRANT CREATE VIEW TO jburkhart ;

– QUOTAS
ALTER USER jburkhart QUOTA UNLIMITED ON DEVELOPMENT;

==========
login jburkhart and install first demo application
==========

sql command prompt - create apex301 tablespace

create a separate tablespace to store the objects
created by Oracle Application Express.

–Otherwise these objects will be created
in the SYSAUX and XE will be crippled.

cd\
sqlplus sys/aujlb as sysdba

create tablespace apex301 datafile
‘C:\oraclexe\oradata\XE\apex301.dbf’ SIZE 100M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K
SEGMENT SPACE MANAGEMENT auto;

===========
Extract apex301 to c:\apex
[do not use windowsXP default extract, all files won’t be extracted.]

Install apex301 to apex301 tablespace that was just created,
NOT SYSAUX as Oracle says.

$ cd c:/apex
$ sqlplus sys/aujlb as sysdba
SQL> @c:\apex\apexins aujlb apex301 apex301 temp /i/

installs apex301…

=============

Once you complete the standard install,
you need to perform the following steps to complete the upgrade:

1. — change image files - c:\apex\apxldimg.sql doesn’t work correctly,
this will show errors because XE stores images
in a oracle database structureas web folder,
not as image folder on drive.

Need to open in INTERNET EXPLORER
->File:-> Open as web folder-> http://127.0.0.1:8080/i/
enter system and password when asked by windows
you can now see the image folders.

Select ALL of the files and folders, EXCEPT ONE file,
and DELETE ALL.
Then copy all the files and folders from c:\apex\images
to the web folder.

2. Update password

$ cd c:/apex
$ sqlplus sys/aujlb as sysdba
– change sys system password

SQL> @c:/apex/apxxepwd.sql aujlb

==============

login to http://127.0.0.1:8080/apex/apex_admin
user: Admin Password: aujlb
change password to aujlb
check out options
logout
Make shortcut on oracle start menu to apex_admin

login to your other users eg[sys, hr, jburkhart]
and make sure you can login

==============

Try logins…

install SqlDeveloper

You should have a APEX301 on XE

==============

But, during the upgrade your jburkhart and hr users
lost their rights to create, etc.
either use sqlplus or sqldeveloper to assign rights
to these users or you can’t do much!

Well, If this works, I can now learn to develop
APEX applications on my laptop.

Posted in APEX301 | No Comments »