How can I connect to Oracle and SQLPlus?

At Unix prompt, execute these following commands

1. setup oracle-7.0

2..oraenv

     When it asks

          ORACLE_SID = [ora7]?

     just press enter.

3. sqlplus [your username]@ora7

    Replace [your username] with your Oracle username.
    When it asks for the password, just put the password for your Oracle account, not your RCS account.

How can I compile an embedded SQL program?

1. Create your embedded program (i.e. example.pc).

2. Get the template for make to your directory by: At your program directory,

    cp /campus/oracle/7.0/@sys/precomp/demo/proc/proc.mk .

    The template "proc.mk" is MACHINE-DEPENDENT. So, you may need to COPY it to your program directory
    EVERYTIME YOU CHANGE THE MACHINE TYPE.

3.Compile the program by:

   make -f proc.mk build OBJS=[filename].o EXE=[filename]

   For instance, if your program name is example.pc, you can compile it by:

   make -f proc.mk build OBJS=example.o EXE=example

Common Errors

I get the error msg "Message file sp1<lang>.msb not found."
It is possible that the environment is not set properly. You probably do not put "." (dot) or space between ".  oraenv"

I cannot log into sql plus and it gives many lines of errors or
I cannot log into sql plus and it gives error message "ERROR: ORA-12545: TNS:name lookup failure"
You may forget to attach @ora7 to your username for login. Or if you type everything correctly, it is
probably a problem on the Oracle server machine (i.e., temporary out-of-service), please try again later.

I cannot use Oracle on the machines in the Library
You cannot run Oracle on the SunOS machines (i.e., the machines in the library). We only have Oracle for Solaris. You need to run it on either a remote access system or a campus IBM or SGI.

When changing the password, I get the error message " ORA-00922: missing or invalid option"
You do not suppose to put @ora7 with your username. The @ora7 is for finding your database schema when you are already in there (i.e., after successfully connecting to sqlplus), @ora7 is unknown for it.

How can I know that I change my password successfully?
You should get the message "User altered." after your alter command.

Why does my executable file resulted from Proc compiler have size = 0?
You are running out of space to save it. The executable file size is quite big (at least 1.7Mbs). If you face
this problem, you can use /tmp to temporarily keep your executable file. Please don't forget to remove it
when you don't need it anymore.

Exit to : Oracle Hints and Tips