CIS 399 - Introduction to Oracle and SQL

test1 =
  (DESCRIPTION =
    (ADDRESS =
      (PROTOCOL = TCP)
      (HOST = ix.cs.uoregon.edu)
      (PORT = 1521)
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test1.ix.cs.uoregon.edu)
    )
  )

sqlplus username@test1

1. Log on to a workstation in the lab, using your ix username/password.
2. Open a command terminal by right-clicking on the desktop, and selecting the Tools->Terminal item.
3. In the terminal, execute the following commands for csh (copy and paste them - it's easier than typing):

   setenv ORACLE_HOME /local/apps/Databases/oracle_DS
   setenv ORACLE_SID test1
   setenv PATH ${PATH}:/local/apps/Databases/oracle_DS/bin
   frmbld.sh
   

   or the following commands for bash:

   ORACLE_HOME=/local/apps/Databases/oracle_DS
   export ORACLE_HOME
   ORACLE_SID=test1
   export ORACLE_SID
   PATH="${PATH}":/local/apps/Databases/oracle_DS/bin
   frmbld.sh
   

   When you connect to the database in form builder, enter your database username and password, and for database, enter "test1TCP".

1. Log on to the PC using the oracle account.
2. Start the windows explorer (Start -> Accessories -> Windows Explorer)
3. Select the menu item Tools -> Mount Network drive...
4. In the folder box, type \\acme.cs.uoregon.edu\username where username is your ix logon. Do NOT select the "Reconnect at logon" checkbox. Click "Finish".
5. You will be prompted for your ix username and password. Enter them. Do NOT select the "Remember my password" option.
6. Your solaris home directory will be mounted, and you will be able to access your forms.
7. Start the OC4J service by selecting Start -> All Programs -> Oracle Developer Suite - DevSuiteHome -> Forms Developer -> Start OC4J Instance. You can minimize the command window, but do not close it, or the service will be killed.
8. Start the Forms Builder by selecting Start -> All Programs -> Oracle Developer Suite - DevSuiteHome -> Forms Developer -> Forms Builder.
9. Open your form by browsing to the drive where your solaris home directory was mounted (i.e. Z:/...).
10. When you are finished testing, exit Forms Builder.
11. Stop the OC4J service by selecting Start -> All Programs -> Oracle Developer Suite - DevSuiteHome -> Forms Developer -> Stop OC4J Instance.
12. Disconnect your mounted drive by opening a Windows Explorer window (see #2, above), and select the menu item Tools -> Disconnect Network Drive. Select your drive, and click "OK".
13. Log out of the PC.

ALTER SESSION SET CURRENT_SCHEMA = schema;

SELECT SYS_CONTEXT('USERENV','CURRENT_SCHEMA') FROM DUAL;