...
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:
No Format |
---|
[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.
...