You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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.

  • No labels