oracle数据库补丁列表查询
[oraprod@db01 oraprod ]$ sqlplus /as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 17 14:36:41 2014 Copyright (c) 1982, 2008, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.
[oraprod@db01 oraprod ]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 17 14:36:41 2014
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select * from v$version ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oraprod@db01 oraprod ]$ $ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 11.1.0.6.2
Oracle Interim Patch Installer version 11.1.0.6.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u01/PRODDB/db
Central Inventory : /u01/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.2
OUI version : 11.1.0.7.0
OUI location : /u01/PRODDB/db/oui
Log file location : /u01/PRODDB/db/cfgtoollogs/opatch/opatch2014-03-17_14-37-35PM.log
Lsinventory Output file location : /u01/PRODDB/db/cfgtoollogs/opatch/lsinv/lsinventory2014-03-17_14-37-35PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 11g 11.1.0.6.0
Oracle Database 11g Patch Set 1 11.1.0.7.0
There are 2 products installed in this Oracle Home.
Interim patches (10) :
Patch 7211965 : applied on Fri Dec 11 00:30:57 CST 2009
Created on 13 Feb 2009, 13:15:13 hrs UTC
Bugs fixed:
7211965
Patch 7253531 : applied on Fri Dec 11 00:28:34 CST 2009
Created on 24 Nov 2008, 04:11:42 hrs US/Pacific
Bugs fixed:
7253531
Patch 8639653 : applied on Fri Dec 11 00:18:33 CST 2009
Created on 12 Aug 2009, 00:44:39 hrs PST8PDT
Bugs fixed:
8639653
Patch 8409203 : applied on Fri Dec 11 00:16:08 CST 2009
Created on 7 Apr 2009, 14:57:08 hrs US/Pacific
Bugs fixed:
8409203, 8249087, 7281382
Patch 8338798 : applied on Fri Dec 11 00:13:22 CST 2009
Created on 23 Mar 2009, 19:32:26 hrs PST8PDT
Bugs fixed:
7327166, 8338798, 6815733, 8303523
Patch 8834636 : applied on Fri Dec 11 00:10:52 CST 2009
Created on 21 Sep 2009, 10:36:44 hrs PST8PDT
Bugs fixed:
8834636
Patch 8447623 : applied on Fri Dec 11 00:07:23 CST 2009
Created on 26 May 2009, 15:52:49 hrs PST8PDT
Bugs fixed:
8447623
Patch 8738008 : applied on Thu Dec 10 23:53:42 CST 2009
Created on 12 Oct 2009, 06:32:17 hrs PST8PDT
Bugs fixed:
8738008
Patch 7486407 : applied on Thu Dec 10 23:30:20 CST 2009
Created on 10 Nov 2008, 10:22:46 hrs US/Eastern
Bugs fixed:
7486407
Patch 8833297 : applied on Thu Dec 10 22:35:06 CST 2009
Created on 7 Oct 2009, 03:14:51 hrs PST8PDT
Bugs fixed:
6870937, 7627743, 7652888, 7299153, 8242410, 6059178, 8563946, 6955744
7497788, 6840740, 8244217, 8702276, 6981690, 8450529, 7432556, 7719143
7523787, 8251486, 8367827, 7613481, 8341623, 7515145, 7348847, 8416414
8250643, 8284633, 8230457, 8563948, 6900214, 7044551, 7318049, 8940197
7013124, 7432514, 7393258, 7553884, 7639121, 8563944, 8860821, 7606362
7426959, 7330434, 7708340, 7352414, 6452375, 7356443, 7341598, 8213302
7196532, 7446163, 8409848, 8236851, 8342506, 7593835, 7340448, 7309458
8290478, 8391256, 7462112, 7013817, 8499600, 7411865, 7331867, 7527650
6977167, 8855565, 6501490, 6598432, 7524944, 7706138, 6941717, 8402555
7494333, 7586451, 8402551, 7499353, 8408887, 7496908, 7511040, 7719148
7311601, 7497640, 7373196, 7424804, 7452373, 7597354, 6882739, 7366290
6851669, 8543737, 7318276, 8284438, 8324760, 7420394, 7834195, 7350127
7475055, 8563942, 7122161, 8361398, 7451927, 7705669, 7676737, 8301559
8224083, 8658581, 8211920, 8462173, 7206858, 8563945, 8855553, 8402637
8257122, 8199266, 7454752, 7516536, 7345904, 8352304, 7416901, 7426336
8352309, 6812439, 7219752, 8534338, 8542307, 8413059, 7572069, 7436280
7432601, 7311909, 7506785, 7460818, 7276960, 8855559, 7013835, 7378322
8402548, 7189645, 8563947, 8306933, 7477246, 7263842, 7480809, 8855575
8433270, 7556778, 8836375, 7330611, 8339352, 7225720, 8563943, 7036453
7628387, 8419383, 6970731, 7719668, 7203349, 8402562, 7680907, 7438445
8855577, 8243648, 7630416, 6851110, 6980597, 6618461, 7357609, 8855570
8369094, 8318050, 8306934, 7434194, 8833297, 7486595, 7716219, 8362693
6599920, 7628866, 7183523, 7412296, 7135702, 7720494, 7436152, 7175513
7602341, 6679303, 8339404, 7393804, 8856696, 7650993, 6980601, 7830065
7462709, 8563941, 8226397, 7515779
--------------------------------------------------------------------------------
OPatch succeeded.
[oraprod@db01 oraprod ]$
，
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1377
52
How to check tablespace size of oracle
Apr 11, 2025 pm 08:15 PM
To query the Oracle tablespace size, follow the following steps: Determine the tablespace name by running the query: SELECT tablespace_name FROM dba_tablespaces; Query the tablespace size by running the query: SELECT sum(bytes) AS total_size, sum(bytes_free) AS available_space, sum(bytes) - sum(bytes_free) AS used_space FROM dba_data_files WHERE tablespace_
How to import oracle database
Apr 11, 2025 pm 08:06 PM
Data import method: 1. Use the SQLLoader utility: prepare data files, create control files, and run SQLLoader; 2. Use the IMP/EXP tool: export data, import data. Tip: 1. Recommended SQL*Loader for big data sets; 2. The target table should exist and the column definition matches; 3. After importing, data integrity needs to be verified.
Why Use MySQL? Benefits and Advantages
Apr 12, 2025 am 12:17 AM
MySQL is chosen for its performance, reliability, ease of use, and community support. 1.MySQL provides efficient data storage and retrieval functions, supporting multiple data types and advanced query operations. 2. Adopt client-server architecture and multiple storage engines to support transaction and query optimization. 3. Easy to use, supports a variety of operating systems and programming languages. 4. Have strong community support and provide rich resources and solutions.
How to uninstall Oracle installation failed
Apr 11, 2025 pm 08:24 PM
Uninstall method for Oracle installation failure: Close Oracle service, delete Oracle program files and registry keys, uninstall Oracle environment variables, and restart the computer. If the uninstall fails, you can uninstall manually using the Oracle Universal Uninstall Tool.
How to create a table in oracle
Apr 11, 2025 pm 08:00 PM
Creating an Oracle table involves the following steps: Use the CREATE TABLE syntax to specify table names, column names, data types, constraints, and default values. The table name should be concise and descriptive, and should not exceed 30 characters. The column name should be descriptive, and the data type specifies the data type stored in the column. The NOT NULL constraint ensures that null values are not allowed in the column, and the DEFAULT clause specifies the default values for the column. PRIMARY KEY Constraints to identify the unique record of the table. FOREIGN KEY constraint specifies that the column in the table refers to the primary key in another table. See the creation of the sample table students, which contains primary keys, unique constraints, and default values.
How to solve garbled code in oracle
Apr 11, 2025 pm 10:09 PM
Oracle garbled problems can be solved by checking the database character set to ensure they match the data. Set the client character set to match the database. Convert data or modify column character sets to match database character sets. Use Unicode character sets and avoid multibyte character sets. Check that the language settings of the database and client are correct.
How to encrypt oracle view
Apr 11, 2025 pm 08:30 PM
Oracle View Encryption allows you to encrypt data in the view, thereby enhancing the security of sensitive information. The steps include: 1) creating the master encryption key (MEk); 2) creating an encrypted view, specifying the view and MEk to be encrypted; 3) authorizing users to access the encrypted view. How encrypted views work: When a user querys for an encrypted view, Oracle uses MEk to decrypt data, ensuring that only authorized users can access readable data.
What to do if the oracle can't be opened
Apr 11, 2025 pm 10:06 PM
Solutions to Oracle cannot be opened include: 1. Start the database service; 2. Start the listener; 3. Check port conflicts; 4. Set environment variables correctly; 5. Make sure the firewall or antivirus software does not block the connection; 6. Check whether the server is closed; 7. Use RMAN to recover corrupt files; 8. Check whether the TNS service name is correct; 9. Check network connection; 10. Reinstall Oracle software.
