Thank you for accepting the OTN License Agreement; you may now download this software. See the for more information about Instant Client. The are at the foot of the page.

Oracle9i Release 2 Database Architecture on Windows. Oracle9i Release. Release of the 64-bit Oracle database on Windows Server 2003.

Sunni vs shia. Client-server version interoperability is detailed in. For example, Oracle Call Interface 18.3 can connect to Oracle Database 11.2 or later. Some tools may have other restrictions.

Version 18.3.0.0.0 Base - one of these packages is required Basic Package - All files required to run OCI, OCCI, and JDBC-OCI applications (77,673,698 bytes) (cksum - ) The 18.3 Basic package requires the. Basic Light Package - Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (39,072,222 bytes) (cksum - ) The 18.3 Basic package requires the.

Oracle Database 9i Upgrade: Oracle Database 9i 32-bit to Oracle Database 12c 64-bit on Windows Part 1 On a recent client engagement, I was tasked with performing an in-place upgrade of an Oracle 9i 32-bit database on Windows Server 2003 Enterprise SP 2 32-bit to Oracle Database 12c on Windows Server 2008 R2 Enterprise SP1 64-bit as part of a proof of concept (POC) to determine whether the application software would be compatible with Oracle database 12c. The Windows 2003 Server was configured with 8G of memory and was configured with AWE (Address Windowing Extensions) to allow the 32-bit 9i database to utilize the available memory on the server. The database was allocated 3TB of data storage, of which 2.1TB was used. Since this was Oracle 9i 32-bit, the database was configured to utilize filesystem storage for the physical datafiles and was configured with a 4K block size. Oracle on Windows Server fun begins! The version of the 9i database was Oracle 9.2.0.3.

The direct upgrade path to Oracle 12c is 9.2.0.3 to 9.2.0.8 to 12.1.0.2. However, Oracle 12c on Windows is only compatible with Windows Server 2008 and above. Oracle 9i is not compatible with a Windows OS above Windows 2003. The way to bridge this issue is to use and intermediate upgrade to Oracle 11.2.0.4. Oracle 11.2.0.4 is compatible on Windows Server 2003 and Windows Server 2008. So to perform an in-place upgrade from 9i 32-bit to 12c 64-bit, I had to use the following process: • Create a snap copy of the filesystem storage holding the database data files.

This copy included the database control files and the database password file. • Install Oracle 9.2.0.3 32-bit on a Windows 2003 64-bit VM server, attach the snap copy of the database files to it, use the ORADIM utility to create an Oracle Service for the database and start the database. At this point I ran into the issue of the AWE (or lack thereof) for the 9i 32-bit memory configuration. AWE cannot be configured for the Windows 2003 64-bit OS; yet, the 9i 32-bit database required it to be able to start up with the memory that it was configured for. I ended up having to reduce the memory configuration for the 9i database overall to a value less than 300M and was able to successfully bring the database up.

• Patch the Oracle 9i 32-bit software to version 9.2.0.8 32-bit. • Install Oracle 11.2.0.4 64-bit software on the Windows Server 2003 64-bit.

• Perform an in-place upgrade from Oracle 9.2.0.8 32-bit to Oracle 11.2.0.4 64-bit. • Take a new snap copy of the database datafile storage on the Windows 2003 64-bit server.

• Install Oracle 11.2.0.4 on a Windows Server 2008 R2 SP1 64-bit VM server, attach the 2 nd copy of the database files to it, use the ORADIM utility to create an Oracle Service for the 11g database and start the database. • Install Oracle 12.1.0.2 64-bit software on the Windows Server 2008 R2 64-bit. • Perform an in-place upgrade from Oracle 11.2.0.4 64-bit to Oracle 12.1.0.2 64-bit.