Connecting to CSE Oracle Database using SQLPlus and Oracle SQLDeveloper

  • 1. To use SQLPlus or SQLDeveloper: From any linux lab workstation Xterm, type the command: source /usr/local/etc/oracle.bash




  • 2. To use sqlplus, type the command: sqlplus yourUid@oracle


    • Here is a link to online help for sqlplus.

  • 3. To use sqldeveloper, type the command: sqldeveloper




  • 4. Once app appears, click on icon to create new connection:




  • 5. Enter your CSE ORACLE userid:passwd and Oracle server information:




  • 6. Test your connection with inserted parameters:




  • 7. Connect to the CSE Oracle Database server and get to work!:



  • 8. Click on help to get started. In addition here is a link to an online tutorial.


  • 9. Connection process is similar from CEC windows workstations. Click on SQl Developer icon under CSE Programs and create new connection as above.