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 (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:

[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  
pinger@pinger $ cd $ORACLE_HOME/bin
pinger@pinger $ sqlplus iepm@slacprod
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jun 13 16:49:59 2014
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
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.

  • No labels