ORACLE SQL DEVELOPER - installation

Note:

  • IE browser will prompt options: Run, Save or Cancel options. Select: Run
  • Firefox browser will prompt options: Save or Cancel. Select: Save then click on the downloaded file to run Ora SQL Developer.
  • Navigate to X:/Software/Oracle/products/sqldeveloper/sqldeveloper.exe, and click the file to launch Oracle SQL Developer 2.1.1
  • click Run

  • Again, click Run


  • Oracle splash screen


  • Select SQL Source (.sq;)


  • click on the “+” icon


  • A pop-up screen will appear


Populate the New Database Connection (e.g. for WWIS)

  1. enter Database Connection Name * you can name it as to your preference e.g. WWIS Production
  2. enter your user name
  3. enter your password
  4. Save Password: *remember if you save your password, it will expire every 120 days
  5. enter Host Name: uisdb.admsec.wwu.edu
  6. Select Service Name button
  7. enter Service Name WWIS
  8. click on Test button to test the database connection
  9. Click on the Save button to save the parms

  • Click on WWIS icon


  • sign in if you have not saved your password


  • results displayed



Configuring other database connections

Perform the above steps to set up other databases below (if required). The only data fields that you will be required to change are step changes will be for steps 1, 4 and 6.  Also step 3 if passwords are different .

For PPRD
Connection Name: PPRD  or other preferred name
Hostname: tisdb.admsec.wwu.edu
Service name pprd

For WISP
Connection Name: WISP Test  or other preferred name
Hostname: tisdb.admsec.wwu.edu
Service name: wisp

For WDEV
Connection Name: WDEV  Test Data warehouse
Hostname: wdevdb.admsec.wwu.edu
Service name wdev

For Dataw
Connection Name: Dataw  or other preferred name
Hostname: datadb.admsec.wwu.edu
Service name: dataw


Upon completion of the databases connections you had set up, you will be presented with the choices of databases that you can connect to: e.g. PPRD

  • click on PPRD


  • enter your user name and password



note: passwords can be saved when initially setting up a db connection, however passwords need to be changed every 120 days

Page Updated 04.10.2013