Page History

Arash 5/25/2023 (see Incident INC0407886) recommends: 
cottrell@pinger ~]$ 
[cottrell@pinger ~]$ setenv ORACLE_HOME /afs/slac.stanford.edu/package/oracle/f/19.3.0
[cottrell@pinger ~]$ $ORACLE_HOME/bin/sqlplus iepm@slacprod
SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 26 16:14:30 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Enter password:  #See escrow edit -c iepm iepmacct
Last Successful login time: Fri May 26 2023 15:30:55 -07:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL> insert into country (country_id, country, continent, tld)
   2  values (country_seq.nextval, 'Korea,Western DPRKSamoa', 'East AsiaOceania', 'kpws'); #Don't forget semi-colon (); Good idea to edit and save this document
1 row created.
SQL> commit;
Commit complete.
SQL> exit;
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
[cottrell@pinger ~]$

On the new host pinger-test use:
[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 Fri Jan 21 20:20:38 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Enter password:     
SQL> insert into country (country_id, country, continent, tld)
  2  values (country_seq.nextval, 'Bermuda', 'Latin America', 'bm');
1 row created.
SQL> commit;
Commit complete;
SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning and Real Application Testing options
52cottrell@pinger:~>

Or on the old host pinger use:
[cottrell@pinger ~]$ setenv ORACLE_HOME /usr/oracle
[cottrell@pinger ~]$ sqlplus iepm@slacprod
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jan 21 13:13:48 2022
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Enter password: 
[cottrell@pinger ~]$ echo $ORACLE_HOME
/usr/oracle
[cottrell@pinger ~]$ setenv ORACLE_HOME /usr/oracle
[cottrell@pinger ~]$ sqlplus iepm@slacprod
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jan 21 13:32:15 2022
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Enter password: 
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL> insert into country (country_id, country, continent, tld)
  2  values (country_seq.nextval, 'Fiji', 'Oceania', 'fj');
1 row created.
SQL> commit;
Commit complete.
SQL> exit;
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
[cottrell@pinger ~]$ 
[cottrell@pinger ~]$ date
Fri Jan 21 13:40:21 PST 2022