Oracle9i Patch Set 9206 Installation Guide (for Windows)

We can see that the process of installing patchset 9206 is incomplete, mainly because the database has not been upgraded after the installation. I can't help but write out my experience and hope to help you. The level is limited, and errors or omissions are inevitable. Please forgive me
I used this method to successfully upgrade and the database runs normally. But when I want to drop the database back to 9.2.0.1, but there is a problem, see my post: http://www.cnoug.org/viewthread.php? Tid = 80133. I hope the experts will answer my questions...

Oracle 9i Patch Set 9.2.0.6 Installation Guide

Statement: The content in readme.html in "p3948480_9206_winnt.zip" is for reference only. This document does not contain the package p4269928_9206_winnt.zip.

1. download the patch set
I downloaded it here: http://apollo.solusoft.com/win/rdbms/92/

2. Preparations before installation
1. log on to Windows as administrator on the database server
2. Stop all Oracle-related services. These service names are usually headers of Oracle
3. Stop the Distributed Transaction Coordinator Service
4. Back up all Oracle database-related files (including Oracle database software and data files), copy these files to a safe place based on the original directory structure, and mark or record them

Iii. Installation
1. Extract the Oracle 9ipatch set p3948480_9206_winnt.zip to a temporary directory and run the <patch set path> \ disk1 \ setup.exe
2. Click "Next" on the "welcome" Form"
3. On the "specify file location" form, the Source Path is <path of the patch set> \ disk1 \ stage \ products. xml by default. This value usually does not need to be changed
4. on the "specify file location" form, click the drop-down button in the "name" column of "target", and select the name of the Oracle Home Directory to install the patch from the drop-down menu, at the same time, record the path name listed in the "path", which will be used in the aftermath after installation. Then click "Next"
5. list all the patches to be installed in the summary form. Check whether some content is marked in red (for example, whether the disk space is sufficient ). Click "Install" after confirmation"
6. InstallProgramExecute the installation until the installation is completed. Click "exit" on the "installation end" Form"
Note: If a prompt box with garbled characters appears during the installation process, you need to restart Windows, and then re-run "preparations before installation" and "installation "......

Iv. aftercare after installation
1. Check the table space length and set parameter values
1.1 start the database and Log On As A sys user
1.1.1. Start the database instance service. The service name is usually oracleservicesid. The SID is the Instance name.
1.1.2. Start the listener service. The service name is generally oracleorahometnslistener. Orahome is the name of the Oracle Home Directory.
1.1.3. run SQL plus and Log On As sys

C: \> sqlplus/nolog
SQL> connect sys/password as sysdba

Password is the password of the Sys user.
1.2 check the system tablespace length. If the installed database software includes the jserver component, ensure that the system tablespace has at least 10 MB of available space.
1.2.1. Enter the following command at the SQL> prompt:

Select tablespace_name, sum (bytes)/(1024*1024) as free_space
From dba_free_space
Where tablespace_name = 'system'
Group by tablespace_name;

Free_space lists the available space of the system tablespace, in megabytes. If the value is less than 10, you need to increase the capacity of the system tablespace; otherwise, you do not need to perform the following steps:
12. 2. Enter the following command at the SQL> prompt:

Select file_name, round (Bytes/(1024*1024), 0) total_space
From dba_data_files
Where tablespace_name = 'system ';

The data file names belonging to the system tablespace and the size of these files are listed in the results. The file size is listed in the total_space column in megabytes.
1.2.3. Enter the following command at the SQL> prompt:

Alter database datafile 'data _ filename' resize new_size;

This command is used to expand the size of the specified data file, which also expands the capacity of the system tablespace.
If there are multiple files listed in step 2nd, select one of them as long as the disk where the file is located has enough space. Use one of the file names to replace the data_filename in the Command (note that the complete path must be included and the single quotation marks must be retained), and replace new_size with the new capacity. The new capacity can be calculated using the following formula:
New capacity ≥ original capacity + (10-system tablespace available space)
Note: You can specify the unit for the new capacity. k indicates thousands, and M indicates megabytes. Such as 150 K, 150 m
1. 3. Set the shared_pool_size parameter. Originally, Oracle suggested to adjust java_pool_size. However, if too many Java applications are not used, this parameter will not be adjusted.
1.3.1. Check the size of shared_pool_size. Enter the following command at the SQL> prompt:

Show parameter shared_pool_size;

The value column shows the size of the corresponding parameter. Note that the value is calculated in bytes. The two parameter values are as follows:
Physical memory capacity (m) shared_pool_size (m)
512 50
1024 100
2048 150
If the value of this parameter is smaller than the above recommended value, it should be increased to the recommended value; otherwise, the following steps do not need to be performed
1.3.2. Check whether the system uses the initialization parameter file or the system parameter file. Enter the following command at the SQL> prompt:

Show parameter pfile;

If init is included in the value column, the system uses the initialization parameter file. If spfile is included, the system uses the system parameter file.
1.3.3. If the system uses the initialization parameter file, you need to edit the file using notepad or other plain text editors to increase the value of the preceding parameters to the recommended value.
1.3.4. If the system uses a system parameter file, enter the following command at the SQL> prompt:

Alter system set shared_pool_size = 'new _ size' scope = spfile;

New_size is the recommended value.
1.4 shut down the database. Run the following command at the SQL> prompt:

Shutdown

2. Upgrade the database
2.1 enter the following command at the SQL> prompt:

Startup migrate
Spool c: \ patch. Log
@ Orahome \ RDBMS \ admin \ catpatch. SQL
Spool off

Note: orahome is the path of the Oracle Home directory specified during patch installation. Executing catpatch. SQL is a very time-consuming process. It takes 50 minutes to execute it on my own machine.
2.2 check whether c: \ patch. log is incorrect, and check the component list, version, and status displayed when running catpatch. SQL.
If necessary, re-run catpatch. SQL or report the error to the Development Department to confirm the cause and solution of the error.
2.3 restart the database. Enter the following command at the SQL> prompt:

Shutdown
Startup

2.4 run utlrp. SQL to recompile all invalid PL/SQL packages. Enter the following command at the SQL> prompt:

@ Orahome \ RDBMS \ admin \ utlrp. SQL

3. Restart the Distributed Transaction Coordinator Service
4. Back up database files