SQL*Plus: Release 9.2.0.4.0 - Production on Mon Oct 27 13:28:27 2025
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production
~]$ lsnrctl stop
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 27-OCT-2025 13:28:51
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle9i)(PORT=1521))) The command completed successfully
~]$ /soft/4547809/Disk1/runInstaller
-- The SHARED_POOL_SIZE and JAVA_POOL_SIZE are each 150 MB or more. ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release9.2.0.8.0- Production on Mon Oct 2713:41:372025
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string ?/dbs/spfile@.ora SQL> SQL>SHOWPARAMETER SHARED_POOL_SIZE
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ shared_pool_size big integer486539264 SQL> SQL>SHOWPARAMETER JAVA_POOL_SIZE
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ java_pool_size big integer33554432
SQL> exit Disconnected from Oracle9i Enterprise Edition Release9.2.0.8.0-64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release9.2.0.8.0- Production
~]$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.8.0- Production on27-OCT-202513:47:17
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
TNSLSNR for Linux: Version 9.2.0.8.0- Production Systemparameter file is/u01/app/oracle/product/9.2.0/network/admin/listener.ora Log messages written to/u01/app/oracle/product/9.2.0/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle9i)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle9i)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 9.2.0.8.0- Production StartDate27-OCT-202513:47:17 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /u01/app/oracle/product/9.2.0/network/admin/listener.ora Listener Log File /u01/app/oracle/product/9.2.0/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle9i)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
~]$ sqlplus "/ as sysdba"
SQL*Plus: Release9.2.0.8.0- Production on Mon Oct 2713:41:372025
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>column comp_name format a35 SQL>SELECT comp_name, status, substr(version,1,10) as version from dba_registry;
COMP_NAME STATUS VERSION ----------------------------------- ----------- ------------------------------ Oracle9i Catalog Views VALID 9.2.0.8.0 Oracle9i Packages and Types VALID 9.2.0.8.0 Oracle Workspace Manager VALID 9.2.0.1.0 JServer JAVA Virtual Machine VALID 9.2.0.8.0 Oracle XDK for Java VALID 9.2.0.10.0 Oracle9i Java Packages VALID 9.2.0.8.0 Oracle interMedia VALID 9.2.0.8.0 Spatial VALID 9.2.0.8.0 Oracle Text VALID 9.2.0.8.0 Oracle XML Database VALID 9.2.0.8.0 Oracle Ultra Search VALID 9.2.0.8.0 Oracle Data Mining VALID 9.2.0.8.0 OLAP Analytic Workspace UPGRADED 9.2.0.8.0 Oracle OLAP API UPGRADED 9.2.0.8.0 OLAP Catalog VALID 9.2.0.8.0
15rows selected.
opatch lsinventory.
~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 1.0.0.0.55 Copyright (c) 2006 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under OPatch/docs for usage reference. We also recommend using the latest OPatch version. For the latest OPatch version and other support related issues, please refer to document 293369.1 which is viewable from metalink.oracle.com
Oracle Home = /u01/app/oracle/product/9.2.0 Location of Oracle Universal Installer components = /u01/app/oracle/product/9.2.0/oui Location of OraInstaller.jar = "/u01/app/oracle/product/9.2.0/oui/jlib" Oracle Universal Installer shared library = /u01/app/oracle/product/9.2.0/oui/lib/linux/liboraInstaller.so Location of Oracle Inventory Pointer = /etc/oraInst.loc Location of Oracle Inventory = /u01/app/oracle/product/9.2.0/inventory Path to Java = /u01/app/oracle/product/9.2.0/jre/1.4.2/bin/java Log file = /u01/app/oracle/product/9.2.0/.patch_storage/<patch ID>/*.log
