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 database username, currently iepm, an at sign, and then the database connect string, currently slacprod.
...