Pre-Install

Pre-Install - Open SQL Tools Input your username and pw...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
P L / S Q L Oracle10 g Developer: PL/SQL Programming 1 Account Setup
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Download Download “NewEnviromental.vbs” and “tnsnames.ora” into your z-drive Find the SQL-Plus from your computer and establish a shortcut in your z-drive. Oracle10 g Developer: PL/SQL Programming 2
Background image of page 2
P L / S Q L Things you need to do everytime you try to run Oracle Double click “NewEnviromental.vbs” Variable: TNS_ADMIN Value: c:/oracle Copy “tnsnames.ora” into path “c:/oracle” Go to “Control Panel” “Performance and maintenance” “System” “Advanced” “Environment Variables” “System Variable” Find “TNS_ADMIN” Oracle10 g Developer: PL/SQL Programming 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Oracle Account Each of you need to write down your preferred ID and PW. And give to me. I will set up for you in class Please be patient; It may take a while. Oracle10 g Developer: PL/SQL Programming 4
Background image of page 4
P L / S Q L First Log in Build a “short-cut to SQL Tools” in your Thawspace (T:)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Open SQL Tools Input your username and pw Check Bypass tnsnames.ora Host: pendragon.gannon.edu TCP Port: 1522 (default 1511) SID: dragon Test connect Oracle10 g Developer: PL/SQL Programming 5 P L / S Q L Testing In SQL Tools, open file c1Dbcreate execute (F5) New Input select firstname, lastname from bb_shopper execute Oracle10 g Developer: PL/SQL Programming 6 P L / S Q L Check your status in database Start All Programs Oracle - OraClient10g_home1 Enterprise Manager Console Check Add Selected Databases Uncheck DBQ OK Double Click Databases Double Click Dragon Input your username and PW Go to Security Users Click your ID Check your Role Oracle10 g Developer: PL/SQL Programming 7...
View Full Document

This note was uploaded on 01/17/2012 for the course GCIS 511 taught by Professor Liu during the Fall '10 term at Gannon.

Page1 / 7

Pre-Install - Open SQL Tools Input your username and pw...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online