Info on Oracle/SQLplus/ProC

Online documentation is available at :

  • http://desktop.msfc.nasa.gov/oracle815doc/server.815/index.htm
  • http://technet.oracle.com/docs/content.html (oracle requires you to sign up for free web access).

    You can download the oracle client online from: http://otn.oracle.com/software/products/oracle8i/htdocs/winsoft.html

    Orcale Server Information

    PROTOCOL = TCP
    HOST = vcmr-57.server.rpi.edu
    PORT = 1521
    SERVICE_NAME = ora8

    ProC/C++ on Windows PCs

    NOTE: sqllib80.lib has been replaced by orasql8.lib. So you should replace SQLLIB80.LIB in the project with ORASQL8.LIB.
    It appears that the correct path should be C:\projects\code\db\apps\ora81\precomp\lib\msvc\oraSQL8.LIB
    Also note that you should remove the old sqllib80.lib file from the project and you should add this new one.

    Also note that the orant directory is now replaced by ora81. You should set the correct path by finding the proc.exe file.
    Use the following information:
    Program.PC - C:\Apps\Ora81\Bin\Proc $(ProjDir)\$(InputName).pc
    include=$(ProjDir)\..\..include include="$(MSDEVDIR)\..\vc\include"

    Instead of the "Include" directory under the ProC directory, you'll probably find the "public" directory, which contains all header files. This path should work:
    C:\projects\code\db\apps\ora81\precomp\public

    You should be able to write programs on the PCs that access the Oracle databases including the movies database.

    The tnsnames.ora files will need to include the Oracle server information. Note that there are several tnsnames.ora files on a PC. The PC labs should be set to go.

    ProC/C++ on UNIX machines

    The Oracle pre-compilers and sqlplus are available on the RCS IBM systems. After you enter
    setup oracle-8.0
    . oraenv

    proc command and others are put in the path.

    Look in these directories
    /campus/oracle/8.0/rs_aix43/bin (programs)
    /campus/oracle/8.0/rs_aix43/precomp/public (includes, etc)
    /campus/oracle/8.0/rs_aix43/precomp/demo/proc (pre-compiler demos)
    /campus/oracle/8.0/rs_aix43/precomp/lib (pre-compiler libraries)
    /campus/oracle/8.0/rs_aix43/lib (Oracle libraries)

    Here is a sample MAKEFILE. This will call proc pre-compiler etc. automatically, so all you have to do is make changes to program.pc as required.

    Other Questions

     

    How to change your password in Academic Oracle?

    Academic Oracle (version 8.1.5) runs on an AIX server in the RCS network.

    1. First login to an IBM machine using your RCS user id and RCS password.

    > ssh rcs-ibm.rpi.edu

    2. In the command line, setup the Oracle environment.

    First type the following two commands (there is space between the period "." and "oraenv"):

    > setup oracle
    > . oraenv

    It will ask you the following question:

    ORACLE_SID = [ora8] ?

    Press enter to accept the sid.

    3. Startup SQLPLUS using your Oracle user id and given Oracle password.

    SQLPLUS is a client program for accessing Oracle. Start SQLPLUS by typing the following command (substitute your Oracle user id below for "userid"):

    > sqlplus userid@ora8

    You should see the following commands appear:

    SQL*Plus: Release 8.0.5.0.0 - Production on Wed Sep 12 14:19:19 2001

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Enter password:

    Enter your Oracle password when asked.

    Connected to:
    Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production

    SQL>

    To exit from SQLPLUS, you can simply type "quit". You should see:

    SQL> quit
    Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production

    4. Changing password in SQLPLUS.

    To change your password, you need to write the following command:

    SQL> alter user userid identified by newpassword ;

    User altered.

    Write your userid in plain text, without @ora8. Write your newpassword in plain text, no quotes are allowed. Your password should begin with a letter. All commands in SQLPLUS should end with a semicolon (";").