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 ORCALE_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>
The sqlplus command line is followed with 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. When finished with a session, use commit; to commit your changes to the database, as Oracle does all work inside a transaction by default, and use exit; to leave SQLPlus.