OracleSQLPlus - wendysmoak/wiki GitHub Wiki

=== SQL Plus for Oracle ===

'''1. Download one of the following files : '''

: http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html Oracle Database 10g Companion CD Release 2 (10.2.0.1.0) 10201_companion_win32.zip (653,693,751 bytes)

: http://www.oracle.com/technology/software/products/oracle9i/htdocs/winsoft.html Oracle9i Database Release 2 Client for Microsoft Windows 98/2000/NT/XP 92010NT_CLT.zip (625,543,653 bytes)

• You will be prompted to log in.
• You may have to create an account and accept the license agreement.

'''2. Unzip the file in a temporary location, such c:\temp\oracle_client '''

'''3. Execute the 'setup.exe' program'''

'''4. Choose an 'Oracle Home' and path (or accept the defaults)'''

'''5. Choose 'Custom' and select 'SQL Plus' and 'JDBC/THIN Interfaces' '''

'''6. Finish the install.'''

'''7. (ASU Only) Edit (or create) the $ORAHOME/network/admin/tnsnames.ora file as shown [http://www.eas.asu.edu/~cse494db/advRelational/setupHome.htm here]'''

'''8. Launch SQL Plus from the menu'''

• Start -> Programs -> Oracle -> Application Development -> SQL Plus