This is an old revision of the document!

Upgrade to 14

To Do

SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" 
       FROM sys.v_$parameter WHERE name = 'spfile';

There is an “open_cursors=300” in C:\app\Jas\product\11.2.0\dbhome_1\database\SPFILEJAS.ORA
This file does not have even read permissions and cannot be edited.
You can view it from an admin shell by typing it.
Start sqlplus with sys/jwars as sysdba
shutdown;
create pfile from spfile;
edit pfile and change open_cursors=500
save pfile
create spfile from pfile;
quit sqlplus
type the spfile to confirm changes
From: https://asktom.oracle.com/ords/asktom.search?tag=spfile-parameter
open_cursors=500 blows up
open_cursors=1000 works

hci 14 gets Ora-12154 - TNS could not resolve the connect identifier specified
current version of AbtOracle8DatabaseManager»connectToDataSourceNamed: aDataSourceName logonSpec: aLogonSpec promptEnabled: aBoolean ifError: anErrorBlock is the problem.
created AbtDbmOracleBaseApp V 14.0.0 [573].1 with previous version.
updated DK - All Oracle, DK - All Oracle XD, DK - Jacs Oracle, and DK - Oracle Back End which is unused.
updated and repackaged HCI, Sim, Jacs, Env, and VP. All work.

hci 14 cannot connect to Oracle. hci 13 can.
vp 14 cannot find map, then blows up looking for geoviewer.dll.
vp 9.2 from 1/24 runs ok with no explicit path in ini file
vp 14 runs ok with no explicit path in ini file after re-copying jas*.dlls from jas9
vp Help → About is ok