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

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

{cslinux0:~} which sqldeveloper

/usr/local/bin/sqldeveloper

{cslinux0:~} sqldeveloper

3. 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

Editing Oracle from a Command Line

1. Get into “csoracle.utdallas.edu”, either using PuTTY on windows, or ssh within Mac or Linux.
2. Edit the bash profile to allow for use with oracle.

echo "if [ -f /oracle/env.sh ] ; then /oracle/env.sh; fi" >> ~/.bash_profile

3. Once you have modified the bash profile, logout then login.
4. Type the command ‘sqlplus’. Enter the information asked and wait for the Connection to Establish.
5. Advanced bash profile for command line Oracle connection:

If you have need to connect to multiple Oracle servers from a command line session, and you like controlling all the variables for your Oracle environment, the following section could be added to your bash profile:

#csoracle Oracle 11 environment

if [ $HOSTNAME="csoracle" ]

then

export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/oracle11/student
export ORACLE_PATH=$ORACLE_BASE/bin
export ORACLE_LISTENER_HOME=/oracle/oracle11/student/bin
export ORACLE_SID="student"
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib
export PATH=$PATH:$ORACLE_HOME/bin:$LD_LIBRARY_PATH:$ORACLE_PATH fi