...
Code Block | ||||
---|---|---|---|---|
| ||||
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 |
...