Note there is also a script at /afs/slac/package/pinger/guthrie/node.pl that provides some read and write access to the NODEDETAILS database.
To update the NODEDETAILS database directly with SQLPlus, the Oracle SQL interpreter, log onto a SLAC Taylored host cottrell@pinger-test.slac.stanford.edu. 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 edit -c iepm iepmacct), 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:
| No Format |
|---|
jaredg@atreides >[cottrell@cent7a ~]$ source /afs/slac/package/oracle/common/18.3.0.csh enter the SID SLACPROD [cottrell@cent7a ~]$ sqlplus SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 24 19:28:25 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Enter user-name: iepm Enter password: Last Successful login time: Mon Jan 24 2022 18:30:02 -08:00 Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.13.0.0.0 SQL>quit ~~~~~~~~~~~~~/afs/slac/package/oracle/common/18.3.0.csh contains~~~~ #!/bin/csh setenv ORACLE_HOME /afs/slac/package/oracle/f/18.3.0 setenv PATH ${PATH}:$ORACLE_HOME/bin setenv LD_LIBRARY_PATH ${LD_LIBRARY_PATH}:$ORACLE_HOME/lib setenv TNS_ADMIN /afs/slac/package/oracle/common echo "enter the SID" set ttask=$< setenv TWO_TASK `echo $ttask` ~~~~~~~~~~Or~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [cottrell@pinger-test ~]$ setenv ORACLE_HOME /afs/slac.stanford.edu/package/oracle/f/19.3.0 [cottrell@pinger-test ~]$ $ORACLE_HOME/bin/sqlplus iepm@slacprod SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 24 18:05:51 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Enter password: Last Successful login time: Mon Jan 24 2022 18:05:37 -08:00 Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.13.0.0.0 SQL> quit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.13.0.0.0 [cottrell@pinger-test ~]$ ~~~~~Older~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ pinger@pinger $ setenv ORACLE_HOME /usr/oracle jaredg@atreides >pinger@pinger $ cd $ORACLE_HOME/bin pinger@pinger $ sqlplus iepm@slacprod SQL*Plus: Release 1011.1.0.56.0 - Production on TueFri NovJun 2513 1716:49:59:24 20082014 Copyright (c) 1982, 20052007, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 10g11g Enterprise Edition Release 1011.2.0.43.0 - 64bit Production With the Partitioning and Real Application Testing options SQL> option SQL> |
Invoking sqlplus is done with the name of the command, a space, the 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 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.