Skip to content

Oracle Help

 

Creating a User Account

  1. Log into “csoracle.utdallas.edu”, using and ssh client.
  2. At the command prompt, execute /usr/local/bin/oam.pl
  • The program will display the login, and prompt for a password. No special characters may be used – only upper and lowercase alpha and numeric.
  • Make sure the program exits successfully, check for any errors.

 

The Development Environment

Oracle fully supports, and encourages, the use of SQL Developer for Oracle Database 11g.

The Computer Science Lab Manager will troubleshoot Oracle problems only from within the SQL Developer environment.

SQL Developer is installed in the EC Open Access Lab on all Windows computers. To install SQL Developer on your personal computer, the free download is available at http://www.oracle.com/technology/software/products/sql/index.html.

 

Windows SQLDeveloper

  1. Open SQL Developer from the Start Menu.
  2. To connect to Oracle using SQLDeveloper, Right-click Connections, then click new Connection.
  • Enter a Connection Name, then enter the username and password
  • Set Role is default
  • The connection type is basic
  • The hostname is csoracle.utdallas.edu
  • The port is 1521
  • The SID is student.
  • Click test; the status should show up as Success.
  • Connect

 

 

Linux SQLDeveloper

  1. X must be enabled to use this application: either with an XDMCP session to an available server; or

export your display from an ssh session with X tunneling. For example,

{cslinux0:~} export DISPLAY=10.176.11.118:0.0

  1. Sqldeveloper is available on the CS Linux systems in the binary folder.

{cslinux0:~} which sqldeveloper

/usr/local/bin/sqldeveloper

{cslinux0:~} sqldeveloper

 

  1. To connect to Oracle using SQLDeveloper, Right-click Connections, then click new Connection.
  • Enter a Connection Name, then enter the username and password
  • Set Role is default
  • The connection type is basic
  • The hostname is csoracle.utdallas.edu
  • The port is 1521
  • The SID is student.
  • Click test; the status should show up as Success.
  • Connect