1. How to connect to Oracle on acmeb?
After you logon, carry out the following steps: step 1 needs to be done ONCE .
(1) {acmeb} pico .profile and add the following lines
export ORACLE_HOME=/db1/oracle export ORACLE_SID=publ export PATH=$PATH:~/bin:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib(2) {acmeb} sqlplus /
SQL*Plus: Release 3.1.3.7.1 - Production on Wed Jan 13 18:14:59 1999
Copyright (c) Oracle Corporation 1979, 1994. All
rights reserved.
Connected to:
Oracle7 Server Release 7.1.6.2.0 - Production Release
With the distributed, replication and parallel query options
PL/SQL Release 2.1.6.2.0 - Production
SQL>
At this point you will be connected to Oracle and you could try some
SQL commands. However, please remember that you need to clean up what
you
do so that it doesn't interfere with your project later on!
2.Where can I find Oracle documents?
Oracle documents can be find at
http://technet.oracle.com/ . You must register before you can access
the documents. However, the membership is free. An alternate site for the
oracle server documentation is
http://www.dal.ca/~oracle/oradoc/DOC/products.htm .