(Show Contents)

Using ARCHIBUS with Oracle 10g Release 2

If you are using Oracle 10g, make certain you are using the Release 2 patch level.

Note: While these Oracle patches resolve application errors in the 10g version of Oracle, they do not resolve all issues with the Database Update Wizard (UPW). Please use Oracle 10g Release 1 to perform upgrades using the UPW.

The following patches must be downloaded and installed according to the instructions provided with each patch.

• Patch 4547817 Oracle Client/RDBMS version 10.2.0.2
• Patch 5502226 Oracle Client/RDBMS version 10.2.0.2 Patch 8

Using  Patch 4547817

The instructions provided here are for Patch 4547817 ONLY.  For Patch 5502226, please follow the Oracle instructions.  The patches are available at https://metalink.oracle.com/Oracle Metalink (user account is required).

The patch set installation is a two-part process.

1. First the patch set binaries must be installed against the %ORACLE_HOME% the database is running out of.
2. Second, upgrade the data dictionary of the database so that it is at the same version level as the Oracle binaries by running the "Post Installation Tasks" of the patch set against every database that is running out of the %ORACLE_HOME%.

One Database

If there is only one database, run:

1. C:\> sqlplus /NOLOG
2. SQL> CONNECT SYS/password AS SYSDBA
3. SQL> STARTUP UPGRADE
4. SQL> SPOOL patch.log
5. SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catupgrd.sql
6. SQL> SPOOL OFF

Multiple Databases

If you have multiple databases running on the same %ORACLE_HOME%, you must perform the "Post Installation Tasks" against each database individually. Do not attempt to perform the tasks against multiple databases at the same time.

1. Make sure the OracleService [SID] is started for the first database.
2. Open a command line session window.
3. Set the default SID that you need to connect to by issuing the command:
   
   set ORACLE_SID=[SID_NAME]
    
4. Launch an SQL*Plus session in the command line window from %ORACLE_HOME%\bin:
   
   sqlplus /nolog
    
5. Perform the "Post Installation Tasks" until complete against the database, making sure you connect to the database using a local (bequeath) connection:
   
   SQL> connect sys/[password] as sysdba
    
6. When this database is complete, disconnect from the database and exit the SQL*Plus session.
7. In the same command line session window, set the next database you need to connect to as the default:
   
   set ORACLE_SID=[SID_NAME]
    
8. Launch an SQL*Plus session in the command line window from %ORACLE_HOME%\bin and complete the "Post installation Tasks" against the next database.
9. Once the "Post Installation Tasks" are complete for one database, disconnect from the database, exit the SQL*Plus session, and set the next database that requires the "Post installation Tasks'" to be completed against it as the default database (set ORACLE_SID=[SID_NAME]) .