Oracle Log on Notes
Authentication Procedures:
The Department of Information Technology Oracle Server authenticates users in one of two ways:
- Oracle password authentication
- Oracle Operating System authentication using Windows NT/Windows 2000
Individual students accounts use the first method. All ITEC students will have an Oracle account with the same name as their RU Network account. A Student's oracle password will not be the same as their RU network password. Students and faculty can set their Oracle account password by going to the following web site:
http://itecAdmin.asp.radford.edu/orapwmaint.htm
Once your Oracle account password is set you can start Oracle from an RU lab
computer by going to START-> Programs-> RU Courseware ->
As with all connections to Oracle, SQL Plus will require you to provide three pieces of information:
The final field may be referred to in the dialogue box as a "host string", "connect string", or "service name" depending on which Oracle component and which version of that component is running. Resolution of the service name can be accomplished using several different methods including Windows 2000 Active Directory Services. Currently, service name resolution on lab computers is being accomplished using defined service names. A defined service name is contained in the tnsnames.ora file on the workstation. The tnsnames entry points the client component toward an instance of the Oracle Database Server on a particular host using a particular network transport (tcp, named pipes, etc). All components associated with the Department of Information Technology site license require the host name/connect string "ITEC".
Older Oracle components, such as those being run in the Fashion and Interior Design area, can only use a defined service name. For Fashion and Interior Design that name is currently styles32.world.
Connecting to Oracle through RUCS and RUCS2
See notes below in "Connecting to your Oracle Account from off-campus ..." Section
Oracle instructors also use Oracle password authentication. With Oracle Password authentication the user must enter their Oracle UserId, Oracle password, and the proper connect/host string (such as Itec). Since the user is identifying themselves to Oracle it does not matter which Windows NT/Win 2000 account they are logged in with.
Oracle components currently installed at RU
General Purpose Computer labs at
- Oracle 9i version 9.2.0.1.0 for Windows 2000 client (including SQL+ 9.2.0.1.0 )
- At this time, Oracle Reports and Forms are NOT installed. The Fall 2002 database class will experience client/server computing by using thin clients connected to an Oracle Database through ODBC and OLEDB.
The Interior Design and Fashion Lab currently has the following Oracle client componets installed:
- Oracle Client version ???
Connecting to your Oracle Account from off-campus or from the residence halls
The easiest way to work with Oracle from at home is to Telnet to RUCS or RUCS2 using your normal Radford userid and password. If Radford is not your ISP make sure that you are using the FQDN for rucs which is rucs.radford.edu. After you have successfully authenticated the telnet session type sqlplus to execute the Oracle client. You will then be prompted to log in to. At this point you must specify the database service name as part of the user name as shown below:
Enter user-name: jdoe@itec
Enter password: ***************
An alternate way to connect from home or the dorm IF YOU USE RADFORD AS YOUR ISP is to install the Oracle client on your own computer. You are on your own here so proceed with caution. You would need to obtain a license and software for Oracle, Oracle Lite, or Personal Oracle. You can then make a connection back to the ITEC Oracle Server if you are connecting to an Oracle Authenticated Account. This can only be done from the residence halls or from off-campus when connecting via the Radford Modem Pool. A connection cannot be made from other Internet Service Providers such as AOL or MSN. This is because Oracle Network Traffic is blocked by the campus firewall.
If you are running Windows2000 you should:
1. Modify the tnsnames.ora file on your home computer to include the following entry (NOTE: do not delete any service definitions already in your tnsnames.ora file as these define your local database services):
ITEC.RADFORD
=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
itec.radford.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = itec.radford)
)
)
2. Modify the sqlnet.ora file on your home computer. If the line
SQLNET.AUTHENTICATION_SERVICES= (NTS)
is included CHANGE it to read:
SQLNET.AUTHENTICATION_SERVICES= (NONE)
3. If you are dialing in then go ahead and connect to Radford
4. Start SQL+ or another Oracle Component and log in but use ITEC.RADFORD as your host string instead of Itec.