270 likes | 435 Views
IS 426: Information Systems Construction in Modern Society. Downloading and exploring oracle development environments. Needed downloads. Oracle developer suite 10g http ://www.oracle.com/technetwork/developer-tools/developer-suite/downloads/index.html Oracle database express edition 11g
E N D
IS 426: Information Systems Construction in Modern Society Downloading and exploring oracle development environments
Needed downloads • Oracle developer suite 10g http://www.oracle.com/technetwork/developer-tools/developer-suite/downloads/index.html • Oracle database express edition 11g http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
Oracle developer suite 10g • Contains forms builder utility and Reports utility • http://www.oracle.com/technetwork/developer-tools/developer-suite/downloads/index.html
Oracle developer suite 10g - unzip • Unzip disk 1 and disk 2 files into disk 1 and disk 2 folders. • Starting with disk 1: • Try running setup file (Oops Error!) • Some configurations are needed to run the developer suite 10g.
Required configurations • Add 6.0, 6.1,6.2 versions to available windows versions.Disk1/install/oraparam • Right click on setup file -> properties-> compatibility -> check Run -> select windows XP Pack 2. • Computer-> properties->advanced->performance settings-> advanced-> change-> custom size to 2000 and 8000-> click set and OK
Error after changes- don’t forget to click on set in my computer properties
USEFUL CONFIGURATIONS VIDEOS- MUST SEE • http://www.youtube.com/watch?v=qYeic14YK-Y • http://www.youtube.com/watch?v=BU_QTlUQ1sk
Possible Error after starting your installation • Change path environment var. from computer properties. • Delete unwanted paths • Click retry. • Appears a lot so try to shorten the path
Disk 2 • You will be required to specify the stage folder path (disk 2). • Browse to disk 2 folder and click on stage folder. • Complete installation
INSTALLING DATABASE EXPRESS http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
INSTALLING DATABASE EXPRESS • Unzip the file • Start setup
SUCCESSFUL INSTALLATION! • Get started shortcut to start • Note: you might get error to start the page if you are using IE or chrome browsers. So change the settings to open the file with Firefox.
EXPLORING FORMS BUILDER Is426.wordpress.com
Connecting your database 11g express edition to Oracle Developer Suite 10g
Go to Net Configuration Assistant in your suiteHome Directory
Local net Service Name configuration • Add • Service name: XE • Network Protocol: TCP • Host name: your device’s name • Accept and finish!!
Connecting the forms builder • GO TO forms builder and try to connect to the XE database
Adding tables to your XE Database • Adding tables to the database can be done by writing SQL stmts using the Run SQL Command Line. • Example: • CREATE TABLE emp (att1 type, att2 type,…);