To update the NODEDETAILS database directly with SQLPlus, the Oracle SQL interpreter, log onto a SLAC Taylored host. Set the ORACLE_HOME environment variable to /usr/oracle
, e.g. setenv ORACLE_HOME /usr/oracle
(csh) or export ORACLE_HOME=/usr/oracle
(sh/bash/etc.).
Get the Guthrie NODEDETAILS IEPM password from escrow (see man escrow
), then run sqlplus from the command prompt. Unless you have defined ORACLE_HOME in your shells configuration file, e.g. in cshrc, then you will need to define it first:
jaredg@atreides > setenv ORACLE_HOME /usr/oracle jaredg@atreides > sqlplus iepm@slacprod SQL*Plus: Release 10.1.0.5.0 - Production on Tue Nov 25 17:59:24 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning and Real Application Testing options SQL>
Invoking sqlplus is done with the name of the command, a space, the database username, currently iepm, an at sign, and then the database connect string, currently slacprod.
SQL statements can then be entered at the SQL>
prompt. Punctuation is important in sqlplus. Always end insert, update, delete, select, create, and alter statements with a semicolon. By default, Oracle does all work in a transaction, so you must execute the commit;
command to save any changes you've made to the database or the rollback;
command to revert them after you have completed a set of changes. When finished use exit;
to leave SQLPlus.