精华内容
下载资源
问答
  • 下载相关补丁并上传至服务器#### 1、环境检查```--检查环境是否正常$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh /u02/app/oracle/product/19.0.0/db_1--根据补丁包,检查是否有冲突--grid$ORACLE_HOME/...

    > 下载相关补丁并上传至服务器

    #### 1、环境检查

    ```

    --检查环境是否正常

    $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh /u02/app/oracle/product/19.0.0/db_1

    --根据补丁包,检查是否有冲突

    --grid

    $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30557433

    $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30489227

    $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30489632

    $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/

    $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30655595

    --oracle

    $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30557433

    $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30489227

    ```

    > 系统空间检查

    ```

    --系统空间检查

    cat /tmp/patch_list_gihome.txt

    /u01/app/grid/soft/30501910/30557433

    /u01/app/grid/soft/30501910/30489227

    /u01/app/grid/soft/30501910/30489632

    /u01/app/grid/soft/30501910/

    /u01/app/grid/soft/30501910/30655595

    $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt

    cat /tmp/patch_list_dbhome.txt

    /u01/app/grid/soft/30501910/30557433

    /u01/app/grid/soft/30501910/30489227

    $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

    ```

    > 安装前分析

    ```

    --每个节点执行

    /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -analyze

    ```

    #### 2.安装

    ```

    --安装 每个节点执行,如数据库未开启,需手动应用sql

    /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -nonrolling

    --or

    --指定gi home,仅升级gi

    /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -oh /u01/app/19.0.0/grid -nonrolling

    --指定oracle home

    /u02/app/oracle/product/19.0.0/db_1/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -oh /u02/app/oracle/product/19.0.0/db_1 -nonrolling

    --应用sql

    sqlplus / as sysdba

    startup

    alter pluggable database all open;

    cd $ORACLE_HOME/OPatch

    ./datapatch -verbose

    cd $ORACLE_HOME/rdbms/admin

    sqlplus /nolog

    SQL> CONNECT / AS SYSDBA

    SQL> @utlrp.sql

    ```

    ###3.回滚

    ```

    --停机状态回滚,gi home ,oracle home

    /u01/app/19.0.0/grid/OPatch/opatchauto rollback /u01/app/grid/soft/30501910 -nonrolling -oh /u01/app/19.0.0/grid

    /u02/app/oracle/product/19.0.0/db_1/OPatch/opatchauto rollback /u01/app/grid/soft/30501910 -nonrolling -oh /u02/app/oracle/product/19.0.0/db_1

    ```

    ### 4.升级日志

    ```

    [root@rac19c bin]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -nonrolling

    OPatchauto session is initiated at Tue Mar 10 14:03:30 2020

    System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-10_02-03-37PM.log.

    Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2020-03-10_02-03-49PM.log

    The id for this session is M46H

    Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid

    Executing OPatch prereq operations to verify patch applicability on home /u02/app/oracle/product/19.0.0/db_1

    Patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/db_1

    Patch applicability verified successfully on home /u01/app/19.0.0/grid

    Verifying SQL patch applicability on home /u02/app/oracle/product/19.0.0/db_1

    SQL patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/db_1

    Preparing to bring down database service on home /u02/app/oracle/product/19.0.0/db_1

    Successfully prepared home /u02/app/oracle/product/19.0.0/db_1 to bring down database service

    Bringing down database service on home /u02/app/oracle/product/19.0.0/db_1

    Database service successfully brought down on home /u02/app/oracle/product/19.0.0/db_1

    Bringing down CRS service on home /u01/app/19.0.0/grid

    CRS service brought down successfully on home /u01/app/19.0.0/grid

    Performing prepatch operation on home /u02/app/oracle/product/19.0.0/db_1

    Perpatch operation completed successfully on home /u02/app/oracle/product/19.0.0/db_1

    Start applying binary patch on home /u02/app/oracle/product/19.0.0/db_1

    Binary patch applied successfully on home /u02/app/oracle/product/19.0.0/db_1

    Performing postpatch operation on home /u02/app/oracle/product/19.0.0/db_1

    Postpatch operation completed successfully on home /u02/app/oracle/product/19.0.0/db_1

    Start applying binary patch on home /u01/app/19.0.0/grid

    Binary patch applied successfully on home /u01/app/19.0.0/grid

    Starting CRS service on home /u01/app/19.0.0/grid

    CRS service started successfully on home /u01/app/19.0.0/grid

    Starting database service on home /u02/app/oracle/product/19.0.0/db_1

    Database service successfully started on home /u02/app/oracle/product/19.0.0/db_1

    Preparing home /u02/app/oracle/product/19.0.0/db_1 after database service restarted

    No step execution required.........

    Trying to apply SQL patch on home /u02/app/oracle/product/19.0.0/db_1

    SQL patch applied successfully on home /u02/app/oracle/product/19.0.0/db_1

    OPatchAuto successful.

    --------------------------------Summary--------------------------------

    Patching is completed successfully. Please find the summary as follows:

    Host:rac19c

    RAC Home:/u02/app/oracle/product/19.0.0/db_1

    Version:19.0.0.0.0

    Summary:

    ==Following patches were SKIPPED:

    Patch: /u01/app/grid/soft/30501910/30489632

    Reason: This patch is not applicable to this specified target type - "rac_database"

    Patch: /u01/app/grid/soft/30501910/30655595

    Reason: This patch is not applicable to this specified target type - "rac_database"

    ==Following patches were SUCCESSFULLY applied:

    Patch: /u01/app/grid/soft/30501910/30489227

    Log: /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-06-03PM_1.log

    Patch: /u01/app/grid/soft/30501910/30557433

    Log: /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-06-03PM_1.log

    Host:rac19c

    CRS Home:/u01/app/19.0.0/grid

    Version:19.0.0.0.0

    Summary:

    ==Following patches were SUCCESSFULLY applied:

    Patch: /u01/app/grid/soft/30501910/30489227

    Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log

    Patch: /u01/app/grid/soft/30501910/30489632

    Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log

    Patch: /u01/app/grid/soft/30501910/30557433

    Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log

    Patch: /u01/app/grid/soft/30501910/30655595

    Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log

    Patching session reported following warning(s):

    _________________________________________________

    [WARNING] The database instance 'testdb1' from '/u02/app/oracle/product/19.0.0/db_1', in host'rac19c' is not running. SQL changes, if any, will not be applied.

    To apply. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle).

    Refer to the readme to get the correct steps for applying the sql changes.

    OPatchauto session completed at Tue Mar 10 14:23:18 2020

    Time taken to complete the session 19 minutes, 49 seconds

    [oracle@rac19c OPatch]$ sqlplus / as sysdba

    SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 10 14:25:21 2020

    Version 19.6.0.0.0

    Copyright (c) 1982, 2019, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL> startup

    ORACLE instance started.

    Total System Global Area 2466250400 bytes

    Fixed Size 9137824 bytes

    Variable Size 754974720 bytes

    Database Buffers 1694498816 bytes

    Redo Buffers 7639040 bytes

    Database mounted.

    Database opened.

    SQL> alter pluggable database all open;

    Pluggable database altered.

    SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

    Version 19.6.0.0.0

    cd $ORACLE_HOME/OPatch

    [oracle@rac19c OPatch]$ cd $ORACLE_HOME/OPatch

    [oracle@rac19c OPatch]$ ./datapatch -verbose

    SQL Patching tool version 19.6.0.0.0 Production on Tue Mar 10 14:27:37 2020

    Copyright (c) 2012, 2019, Oracle. All rights reserved.

    Log file for this invocation: /u02/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_49511_2020_03_10_14_27_37/sqlpatch_invocation.log

    Connecting to database...OK

    Gathering database info...done

    Note: Datapatch will only apply or rollback SQL fixes for PDBs

    that are in an open state, no patches will be applied to closed PDBs.

    Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

    (Doc ID 1585822.1)

    Bootstrapping registry and package to current versions...done

    Determining current state...done

    Current state of interim SQL patches:

    No interim patches found

    Current state of release update SQL patches:

    Binary registry:

    19.6.0.0.0 Release_Update 191217155004: Installed

    PDB CDB$ROOT:

    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-JAN-20 01.14.24.263477 PM

    PDB MYPDB:

    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-JAN-20 01.30.58.580298 PM

    PDB PDB$SEED:

    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-JAN-20 01.30.58.580298 PM

    Adding patches to installation queue and performing prereq checks...done

    Installation queue:

    For the following PDBs: CDB$ROOT PDB$SEED MYPDB

    No interim patches need to be rolled back

    Patch 30557433 (Database Release Update : 19.6.0.0.200114 (30557433)):

    Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.6.0.0.0 Release_Update 191217155004

    No interim patches need to be applied

    Installing patches...

    Patch installation complete. Total patches installed: 3

    Validating logfiles...done

    Patch 30557433 apply (pdb CDB$ROOT): SUCCESS

    logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_TESTDB_CDBROOT_2020Mar10_14_28_58.log (no errors)

    Patch 30557433 apply (pdb PDB$SEED): SUCCESS

    logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_TESTDB_PDBSEED_2020Mar10_14_35_01.log (no errors)

    Patch 30557433 apply (pdb MYPDB): SUCCESS

    logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_TESTDB_MYPDB_2020Mar10_14_35_01.log (no errors)

    SQL Patching tool complete on Tue Mar 10 14:41:42 2020

    [oracle@rac19c OPatch]$ ./opatch lsinventory

    Oracle Interim Patch Installer version 12.2.0.1.19

    Copyright (c) 2020, Oracle Corporation. All rights reserved.

    Oracle Home : /u02/app/oracle/product/19.0.0/db_1

    Central Inventory : /u01/app/oraInventory

    from : /u02/app/oracle/product/19.0.0/db_1/oraInst.loc

    OPatch version : 12.2.0.1.19

    OUI version : 12.2.0.7.0

    Log file location : /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2020-03-10_14-25-09PM_1.log

    Lsinventory Output file location : /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-03-10_14-25-09PM.txt

    --------------------------------------------------------------------------------

    Local Machine Information::

    Hostname: rac19c

    ARU platform id: 226

    ARU platform description:: Linux x86-64

    Installed Top-level Products (1):

    Oracle Database 19c 19.0.0.0.0

    There are 1 products installed in this Oracle Home.

    Interim patches (2) :

    Patch 30557433 : applied on Tue Mar 10 14:08:14 CST 2020

    Unique Patch ID: 23305305

    Patch description: "Database Release Update : 19.6.0.0.200114 (30557433)"

    Created on 6 Jan 2020, 19:07:34 hrs PST8PDT

    Bugs fixed:

    30545281, 8476681, 14735102, 17428816, 19080742, 19697993, 20313356

    21374587, 21965541, 23296836, 23606241, 24687075, 25756945, 25806201

    25883179, 25986062, 25997810, 26476244, 26611353, 26739322, 26777814

    26872233, 27036163, 27044169, 27101798, 27126938, 27195935, 27244999

    27254335, 27359766, 27369515, 27406105, 27411022, 27423500, 27439716

    27453490, 27458357, 27489107, 27666312, 27710072, 27729678, 27846298

    27880025, 27934711, 27935464, 27941110, 27957203, 27967484, 28064977

    28072567, 28109326, 28125947, 28129791, 28181021, 28189466, 28204262

    28205555, 28209985, 28210681, 28271258, 28271693, 28279456, 28294563

    28313275, 28319114, 28326928, 28350595, 28371123, 28373960, 28375383

    28379065, 28381939, 28386259, 28390273, 28395302, 28397317, 28402823

    28410431, 28431445, 28435333, 28454215, 28463226, 28475242, 28484299

    28489419, 28492006, 28498976, 28502773, 28513333, 28521330, 28530171

    28534475, 28538439, 28542455, 28546290, 28547068, 28547926, 28558645

    28561704, 28567417, 28567819, 28569897, 28572407, 28572533, 28572544

    28572667, 28572834, 28578945, 28587723, 28589509, 28593682, 28594086

    28597221, 28601957, 28605066, 28606598, 28612239, 28620697, 28625862

    28627033, 28636532, 28639299, 28643718, 28644549, 28645570, 28646200

    28646939, 28649388, 28655209, 28663782, 28672457, 28673945, 28692103

    28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461

    28715727, 28718469, 28719348, 28720204, 28720418, 28721497, 28722229

    28730079, 28734355, 28740708, 28742555, 28749853, 28752923, 28755011

    28758722, 28760206, 28765983, 28767240, 28769456, 28772390, 28774416

    28776811, 28777214, 28781754, 28785531, 28789531, 28791852, 28795551

    28795734, 28802734, 28804517, 28810381, 28811560, 28815123, 28815355

    28817449, 28819640, 28820669, 28821847, 28824482, 28827682, 28831971

    28833912, 28835937, 28836716, 28844738, 28849776, 28854004, 28855520

    28855922, 28857552, 28862532, 28863432, 28863487, 28867992, 28873575

    28875089, 28876253, 28876639, 28878865, 28882784, 28884931, 28887305

    28888327, 28889730, 28892794, 28897512, 28899663, 28901126, 28905457

    28905615, 28907196, 28912691, 28915561, 28917080, 28918429, 28919145

    28922227, 28922532, 28922608, 28925634, 28925880, 28927452, 28932914

    28933158, 28935293, 28936114, 28937717, 28938698, 28940179, 28940281

    28941901, 28942455, 28945421, 28945994, 28949888, 28950868, 28951533

    28952168, 28954762, 28955606, 28955883, 28956908, 28957292, 28957723

    28958088, 28959493, 28960863, 28962775, 28965084, 28965095, 28965231

    28965376, 28966444, 28974083, 28977322, 28983095, 28983486, 28985478

    28986207, 28986231, 28986257, 28986326, 28986481, 28988482, 28989306

    28993295, 28993353, 28994307, 28996376, 29000000, 29001305, 29001888

    29002488, 29002784, 29002927, 29003407, 29003738, 29006318, 29006621

    29007321, 29007353, 29007775, 29008035, 29008669, 29009513, 29010126

    29011936, 29012609, 29013475, 29013832, 29014076, 29015118, 29017265

    29018655, 29019121, 29021063, 29021352, 29022986, 29024054, 29024552

    29024732, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575

    29031600, 29032234, 29032276, 29032457, 29032607, 29033052, 29033145

    29033200, 29033280, 29034587, 29037290, 29038528, 29038728, 29039089

    29039510, 29040739, 29043554, 29043651, 29043725, 29044763, 29044954

    29046482, 29047850, 29048178, 29048289, 29048498, 29048605, 29050357

    29050560, 29050765, 29050886, 29051702, 29051953, 29052726, 29053783

    29056024, 29056270, 29056560, 29056767, 29056894, 29059011, 29060216

    29061016, 29061959, 29062692, 29062848, 29062860, 29062868, 29110526

    29110783, 29110790, 29110797, 29110802, 29110805, 29111598, 29113282

    29113305, 29115857, 29117526, 29117642, 29118543, 29119077, 29120223

    29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125036

    29125374, 29125380, 29126345, 29127957, 29128693, 29128935, 29129450

    29129497, 29129712, 29130219, 29131539, 29132869, 29132938, 29133470

    29134447, 29135383, 29135649, 29136111, 29138641, 29139956, 29141316

    29141341, 29141685, 29142609, 29142667, 29143516, 29144995, 29145214

    29145730, 29149829, 29150338, 29151520, 29152357, 29155099, 29157051

    29157389, 29158680, 29158899, 29159909, 29159936, 29160174, 29162095

    29163156, 29163415, 29163437, 29163524, 29163567, 29167111, 29167342

    29167374, 29167940, 29168137, 29168219, 29168433, 29169073, 29169215

    29170232, 29171683, 29171942, 29172618, 29172826, 29173140, 29173373

    29173817, 29174004, 29176318, 29177466, 29177543, 29177886, 29178385

    29180313, 29180455, 29180559, 29180893, 29181153, 29181231, 29181620

    29181743, 29181923, 29182019, 29182517, 29182901, 29183912, 29184297

    29184666, 29185193, 29186456, 29189302, 29189307, 29189889, 29190235

    29190474, 29190663, 29190740, 29191541, 29192419, 29192468, 29192685

    29193207, 29194205, 29194367, 29194493, 29194827, 29194981, 29195279

    29195337, 29195758, 29196725, 29198092, 29198913, 29199635, 29199733

    29200316, 29200700, 29201494, 29201539, 29201787, 29202104, 29202461

    29202850, 29203122, 29203166, 29203425, 29203443, 29203604, 29205281

    29205323, 29205419, 29205463, 29205767, 29205918, 29206109, 29206605

    29207073, 29208260, 29208732, 29211457, 29211724, 29212012, 29212433

    29212611, 29213320, 29213351, 29213613, 29213775, 29213850, 29213879

    29214561, 29214960, 29216312, 29216723, 29216746, 29216984, 29217294

    29217472, 29217828, 29217848, 29218570, 29219205, 29219273, 29220079

    29221248, 29221891, 29221942, 29222031, 29222784, 29223833, 29223859

    29223967, 29224065, 29224605, 29225076, 29225168, 29225758, 29227602

    29228869, 29229164, 29229754, 29229844, 29229955, 29230252, 29230565

    29231133, 29232117, 29232154, 29232449, 29233415, 29233810, 29233953

    29234123, 29236573, 29237538, 29237575, 29237744, 29240307, 29240759

    29241345, 29241651, 29242017, 29242884, 29243958, 29245137, 29245160

    29246163, 29247415, 29247712, 29247906, 29248495, 29248552, 29248835

    29248858, 29249412, 29249991, 29250059, 29250317, 29251259, 29253184

    29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435

    29256426, 29259119, 29259320, 29260452, 29260956, 29261547, 29261548

    29261906, 29262512, 29262887, 29265448, 29266248, 29266899, 29267292

    29268412, 29269171, 29269228, 29269825, 29270585, 29273539, 29273570

    29273735, 29273812, 29273847, 29274428, 29274564, 29274627, 29275461

    29276272, 29277317, 29278218, 29278684, 29279658, 29279751, 29279854

    29281527, 29281691, 29281796, 29282233, 29282898, 29285197, 29285503

    29285788, 29285956, 29286037, 29286229, 29287130, 29287705, 29292837

    29293072, 29293574, 29297863, 29297915, 29298220, 29299049, 29299082

    29299844, 29301463, 29301566, 29302963, 29303918, 29304781, 29306226

    29306713, 29307638, 29311528, 29311588, 29312310, 29312672, 29312734

    29312753, 29312889, 29313347, 29313417, 29313525, 29314539, 29314636

    29317756, 29318410, 29319441, 29321489, 29323946, 29324568, 29324735

    29325087, 29325105, 29325257, 29325765, 29325993, 29327044, 29329042

    29329087, 29329807, 29330361, 29331066, 29331209, 29331380, 29331493

    29332292, 29332395, 29332763, 29332771, 29333500, 29336843, 29337310

    29337742, 29338315, 29338348, 29338453, 29338780, 29338913, 29339101

    29339155, 29341209, 29343086, 29343861, 29345937, 29346057, 29346211

    29346943, 29347620, 29348176, 29350052, 29350762, 29351386, 29351662

    29351716, 29351735, 29351749, 29352298, 29352724, 29352867, 29352947

    29353271, 29353432, 29353821, 29353960, 29355654, 29356547, 29356704

    29356711, 29356752, 29358509, 29358828, 29360252, 29360285, 29360672

    29360911, 29360950, 29361319, 29361472, 29361801, 29363151, 29364171

    29364177, 29366940, 29367019, 29367561, 29368253, 29368310, 29372541

    29373418, 29373588, 29374179, 29375355, 29375941, 29375984, 29376346

    29377804, 29377986, 29378029, 29378834, 29378913, 29379978, 29382641

    29382784, 29382815, 29383695, 29384781, 29384854, 29384864, 29385429

    29385652, 29386502, 29386635, 29386660, 29387073, 29387274, 29388020

    29388072, 29388094, 29388524, 29388830, 29389889, 29390011, 29390435

    29390785, 29391030, 29391237, 29391849, 29391925, 29392966, 29393291

    29394014, 29394140, 29394749, 29395657, 29397954, 29397996, 29398488

    29398863, 29399046, 29399100, 29399121, 29399336, 29399938, 29402131

    29404483, 29405012, 29405462, 29405651, 29405996, 29407804, 29408853

    29409149, 29409455, 29410311, 29410834, 29411037, 29411469, 29412066

    29412269, 29416688, 29417173, 29417719, 29417884, 29418165, 29420834

    29421059, 29423003, 29423016, 29423156, 29423826, 29424999, 29426241

    29429017, 29429264, 29429466, 29429566, 29430524, 29430866, 29431192

    29431485, 29432176, 29434301, 29435474, 29435652, 29436454, 29436514

    29436727, 29437594, 29437712, 29438277, 29438736, 29439522, 29441196

    29443187, 29443250, 29444072, 29444282, 29444602, 29446669, 29448498

    29449477, 29449845, 29449852, 29450193, 29450421, 29450812, 29450936

    29451386, 29452251, 29452576, 29452936, 29452953, 29454978, 29455424

    29456714, 29457312, 29457370, 29457502, 29457807, 29457978, 29460252

    29461420, 29461791, 29462594, 29462767, 29462957, 29463047, 29463528

    29464616, 29464779, 29465177, 29467622, 29469565, 29470291, 29471860

    29472618, 29476473, 29481584, 29483452, 29483532, 29483626, 29483672

    29483685, 29483712, 29483723, 29483771, 29485099, 29486181, 29488894

    29489436, 29489546, 29490256, 29492127, 29492939, 29493122, 29494245

    29495057, 29495684, 29497311, 29497588, 29497696, 29498198, 29500257

    29500826, 29502561, 29503543, 29503631, 29503827, 29504492, 29504682

    29505668, 29507270, 29507616, 29508681, 29509777, 29510278, 29511611

    29514479, 29515134, 29515240, 29515476, 29515766, 29515834, 29516300

    29516727, 29516766, 29517168, 29517883, 29521187, 29521688, 29521748

    29521862, 29522358, 29522561, 29522662, 29523055, 29523511, 29524599

    29525467, 29525886, 29526966, 29527595, 29527610, 29528368, 29529147

    29530440, 29530515, 29530812, 29530909, 29531654, 29531836, 29532532

    29536342, 29536445, 29538631, 29541742, 29541769, 29542084, 29542449

    29542643, 29543034, 29543956, 29546817, 29547010, 29547867, 29548427

    29548687, 29548722, 29549071, 29549104, 29549154, 29549730, 29552773

    29553141, 29557144, 29557261, 29557336, 29557556, 29558238, 29558975

    29559187, 29559446, 29559908, 29559981, 29564592, 29564593, 29565611

    29580394, 29580983, 29581771, 29584261, 29584693, 29586143, 29587765

    29597536, 29597754, 29598039, 29598046, 29598233, 29599008, 29599300

    29601461, 29602831, 29603460, 29603884, 29604002, 29604257, 29607136

    29607797, 29608000, 29610506, 29611020, 29611991, 29615824, 29616244

    29616414, 29618074, 29618190, 29620042, 29622936, 29625065, 29625804

    29625876, 29626154, 29626732, 29628200, 29629430, 29629650, 29629681

    29629745, 29631749, 29632095, 29632265, 29632611, 29633697, 29633753

    29633936, 29634643, 29635427, 29635717, 29635990, 29637362, 29637526

    29638285, 29641736, 29643721, 29645349, 29648928, 29651183, 29651520

    29653132, 29653246, 29655668, 29656819, 29657422, 29657960, 29661028

    29661065, 29661722, 29663368, 29664087, 29664161, 29665940, 29667994

    29668005, 29669413, 29670782, 29671363, 29672507, 29676089, 29677051

    29677173, 29677733, 29677927, 29679856, 29681987, 29683039, 29687214

    29687459, 29687718, 29687763, 29689145, 29689255, 29692694, 29694869

    29695425, 29695841, 29696310, 29700125, 29700460, 29700770, 29703932

    29707099, 29707896, 29708915, 29710188, 29710858, 29713810, 29715220

    29716194, 29716491, 29717659, 29719146, 29720133, 29721418, 29725476

    29725781, 29726695, 29739576, 29741976, 29742223, 29746962, 29747493

    29747648, 29747653, 29748285, 29748336, 29748513, 29749471, 29750673

    29751094, 29753244, 29754951, 29755821, 29756274, 29756444, 29757099

    29757264, 29757651, 29758217, 29758661, 29761678, 29761837, 29761911

    29765393, 29766207, 29766503, 29766679, 29768899, 29770750, 29771032

    29771242, 29773197, 29773842, 29775393, 29779196, 29782211, 29782823

    29782866, 29784106, 29785239, 29787292, 29787766, 29791152, 29791880

    29793318, 29794462, 29795712, 29795957, 29796378, 29797726, 29802695

    29804875, 29805772, 29809837, 29812489, 29813503, 29815713, 29817278

    29821582, 29825525, 29827852, 29831196, 29834506, 29836096, 29838485

    29838773, 29839715, 29840619, 29841267, 29841687, 29843277, 29843692

    29844226, 29845530, 29846126, 29846645, 29848084, 29848849, 29849100

    29850930, 29851733, 29853485, 29858121, 29858376, 29865188, 29865658

    29869086, 29869404, 29869887, 29870065, 29871098, 29873665, 29875459

    29875565, 29877608, 29878076, 29881478, 29881839, 29882729, 29884958

    29887111, 29888621, 29890740, 29891916, 29893132, 29897418, 29897863

    29900203, 29902327, 29902330, 29903299, 29903454, 29906678, 29907942

    29909658, 29912286, 29914449, 29915217, 29915848, 29916975, 29920025

    29921318, 29926466, 29927756, 29928210, 29937565, 29938225, 29940373

    29942096, 29942554, 29943670, 29944035, 29944660, 29945645, 29946388

    29951620, 29956016, 29957493, 29961609, 29962248, 29962927, 29962939

    29966768, 29967223, 29968085, 29970298, 29971027, 29971888, 29989783

    29989845, 29991257, 29997326, 30003187, 30006159, 30006985, 30007797

    30008125, 30008214, 30009710, 30015070, 30019864, 30024618, 30029806

    30032376, 30033547, 30034456, 30035598, 30038392, 30040157, 30042490

    30043610, 30044507, 30047702, 30047765, 30051176, 30051783, 30053036

    30058149, 30058453, 30059106, 30059109, 30066352, 30074349, 30074472

    30075037, 30076197, 30078675, 30079949, 30080266, 30081580, 30083488

    30084971, 30085897, 30086992, 30090568, 30092859, 30095591, 30095952

    30097092, 30098251, 30099454, 30101186, 30104555, 30106748, 30110224

    30110370, 30110518, 30114489, 30114534, 30127522, 30127904, 30131645

    30135396, 30142907, 30149658, 30150606, 30154633, 30155837, 30159329

    30164714, 30165493, 30165503, 30170104, 30174401, 30175291, 30177597

    30178250, 30187866, 30189516, 30191274, 30193165, 30206493, 30218044

    30223712, 30223847, 30224950, 30235919, 30246179, 30247305, 30252098

    30252156, 30253608, 30255143, 30264405, 30266791, 30269428, 30274188

    30282591, 30299817, 30312094, 30318638, 30324180, 30342878, 30365745

    30389229, 30402386, 30408515, 30412188, 30453442, 30458593, 30474167

    30474774, 30485255, 30534827, 30641755

    Patch 30489227 : applied on Tue Mar 10 14:06:26 CST 2020

    Unique Patch ID: 23305624

    Patch description: "OCW RELEASE UPDATE 19.6.0.0.0 (30489227)"

    Created on 7 Jan 2020, 03:37:45 hrs PST8PDT

    Bugs fixed:

    17787434, 25736599, 26675491, 27148384, 27222128, 27262781, 27572040

    27604329, 27760043, 27877830, 28302580, 28319989, 28406406, 28441307

    28470673, 28554809, 28621543, 28628631, 28642469, 28697242, 28697896

    28699321, 28704073, 28710663, 28747089, 28755846, 28762163, 28772816

    28785321, 28800508, 28805158, 28808652, 28815557, 28847541, 28847572

    28847655, 28852065, 28865162, 28870111, 28870496, 28871040, 28874416

    28874529, 28874678, 28877252, 28881191, 28881848, 28887933, 28888083

    28892095, 28911140, 28912188, 28917537, 28925250, 28925460, 28935956

    28940472, 28942694, 28951332, 28958624, 28963036, 28968779, 28973989

    28980448, 28984430, 28987100, 28995287, 29003207, 29003617, 29016294

    29018680, 29024876, 29026154, 29027933, 29030056, 29047127, 29051269

    29052850, 29053083, 29058476, 29111631, 29112455, 29117337, 29118754

    29123444, 29125708, 29125786, 29129476, 29130169, 29131772, 29132456

    29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631

    29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540

    29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091

    29191827, 29201143, 29201695, 29202442, 29209545, 29209972, 29210577

    29210610, 29210624, 29210683, 29213641, 29218185, 29219627, 29224294

    29225861, 29229839, 29231008, 29235934, 29242906, 29243749, 29244495

    29244766, 29244968, 29248723, 29249583, 29251564, 29254863, 29255616

    29257308, 29260224, 29261171, 29261695, 29266584, 29268887, 29271019

    29273360, 29274911, 29275362, 29276220, 29280752, 29282090, 29282666

    29285453, 29285621, 29288842, 29289634, 29290235, 29292232, 29293806

    29293928, 29294753, 29299830, 29307090, 29307109, 29311336, 29318127

    29329675, 29330791, 29338139, 29339299, 29342966, 29347106, 29351297

    29351881, 29357821, 29359713, 29360467, 29360775, 29367971, 29368725

    29376616, 29377086, 29379299, 29379381, 29380201, 29380253, 29380496

    29380527, 29381000, 29382296, 29385861, 29387212, 29390900, 29391301

    29392779, 29393649, 29395961, 29397888, 29398418, 29402110, 29407192

    29411931, 29413360, 29413448, 29416851, 29433434, 29438073, 29445982

    29450417, 29452365, 29457241, 29457319, 29460775, 29462569, 29465047

    29468589, 29470298, 29471399, 29473188, 29478378, 29485756, 29490266

    29495628, 29498957, 29499868, 29502953, 29504266, 29505022, 29505730

    29507560, 29510452, 29518947, 29524627, 29528119, 29529127, 29529530

    29529973, 29535802, 29537427, 29540165, 29542152, 29545235, 29549429

    29552763, 29555663, 29583036, 29585881, 29592188, 29593025, 29599431

    29599530, 29600906, 29601549, 29605539, 29618725, 29623009, 29632615

    29637215, 29641885, 29645874, 29655862, 29657866, 29659031, 29663838

    29671651, 29671851, 29671933, 29672162, 29672852, 29684210, 29684609

    29684672, 29686671, 29690422, 29692674, 29694497, 29721974, 29722328

    29741589, 29754146, 29760252, 29760705, 29769321, 29770006, 29770719

    29772541, 29780086, 29786752, 29797504, 29797626, 29798124, 29799836

    29805654, 29814993, 29817598, 29825944, 29828755, 29838281, 29839229

    29841704, 29851066, 29852422, 29853256, 29862652, 29862828, 29866585

    29867220, 29868392, 29876493, 29885967, 29893587, 29896074, 29909288

    29910893, 29921525, 29936936, 29939536, 29958570, 29972301, 29997804

    30006937, 30007337, 30009279, 30009884, 30012348, 30022613, 30028540

    30028697, 30032515, 30033476, 30039843, 30043518, 30047157, 30076461

    30080241, 30085531, 30123264, 30140462, 30142644, 30155486, 30159782

    30165554, 30191807, 30203000, 30210185, 30216942, 30226726, 30252076

    30300812, 30303080, 30422030, 30461079, 30461097, 30472602, 30482794

    30499905, 30559848, 3

    --------------------------------------------------------------------------------

    OPatch succeeded.

    [oracle@rac19c admin]$ sql

    SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 10 14:54:27 2020

    Version 19.6.0.0.0

    Copyright (c) 1982, 2019, Oracle. All rights reserved.

    Connected to:

    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

    Version 19.6.0.0.0

    SQL> select PATCH_ID,PATCH_TYPE,ACTION,STATUS,TARGET_VERSION from dba_registry_sqlpatch;

    PATCH_ID PATCH_TYPE ACTION STATUSTARGET_VERSION

    ---------- ---------- --------------- ------------------------- ---------------

    29517242 RU APPLY SUCCESS19.3.0.0.0

    30557433 RU APPLY SUCCESS19.6.0.0.0

    SQL>

    SQL> select banner from v$version;

    BANNER

    --------------------------------------------------------------------------------

    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

    SQL>

    ```

    展开全文
  • 关于Oracle XML Publisher的报价

    千次阅读 2007-07-30 15:58:00
    先说说BI Publisher,它其实就是XML publisher,这是Oracle公司为了规划未来的产品所做的一次调整。 这个产品的售卖方式,基本情况如下: 1、XML Publiser产品只按服务器CPU个数的方式进行购买,单CPU售价20万。 ...
           先说说BI Publisher,它其实就是XML publisher,这是Oracle公司为了规划未来的产品所做的一次调整。
    
           这个产品的售卖方式,基本情况如下:
           1、XML Publiser产品只按服务器CPU个数的方式进行购买,单CPU售价20万。
           2、另外技术工程师提供了另外一种报表方案,Forms and Reports中间件 + IDS报表开发工具,这套产品按单CPU方式卖,售价为30万;按用户数量卖,单一用户86000元。
     
           从网站上下载的版本是有30天授权的版本。但在本地进行测试,调整为30天以后软件系统还是可以运行的,但功能是否受限制不清楚。 
    这产品卖的可是够贵的!!经过讨论发现了Jasper Reports……
    展开全文
  • 1、Oracle10g数据库企业版费用为:9621*4*25*1.19*1.17=134万元 其中, 9621元为单用户标准价格,4为支持服务器CPU数目,每颗CPU支持25个用户数,1.19是服务费,1.17是增值税; 2、RAC (和企业版绑定出售,4颗CPU...
     1、Oracle10g数据库企业版费用为:9621*4*25*1.19*1.17=134万元   
      其中,   9621元为单用户标准价格,4为支持服务器CPU数目,每颗CPU支持25个用户数,1.19是服务费,1.17是增值税;   
        
      2、RAC   (和企业版绑定出售,4颗CPU需要4个RAC,RAC标准报价是企业版的一半):4810.5*4*25*1.19*1.17=66.98万元;   
        
      3、货物总价:134万+66.98万=200.98万元。   









    本文转自 jxwpx 51CTO博客,原文链接:http://blog.51cto.com/jxwpx/226685,如需转载请自行联系原作者
    展开全文
  • 你可以去Oracle官网看看Oracle报价,一套Oracle database动辄几十万,或者按年付费,一年大几万,这还是一个CPU的价格。 碰到集群你就等着哭吧。人员培训也是问题。Mysql很多人学数据库的时候多多少少都会用,使用...

    一个字,贵。你可以去Oracle官网看看Oracle的报价,一套Oracle database动辄几十万,或者按年付费,一年大几万,这还是一个CPU的价格。

    碰到集群你就等着哭吧。人员培训也是问题。Mysql很多人学数据库的时候多多少少都会用,使用方便,基本功能简单上手。你用Oracle,不找个专职DBA,碰到问题很麻烦。附Oracle产品价格(来源于Oracle官网,都是1 CPU的价格,N个CPU就要买N套):这个事Oracle Database 标准版安装在一个CPU的服务器上一年的价格

    在这里插入图片描述

    想一次性买断,没问题,请支付18万
    在这里插入图片描述

    用了数据库,还得中间件嘛,普通版的10万搞定

    在这里插入图片描述
    土豪钱多还可以上Weblogic套装,针对每个CPU的授权需要46万哦

    在这里插入图片描述

    展开全文
  • Oracle服务费是如何计算的?

    千次阅读 2008-04-08 17:06:00
    根据Oracle公司的销售政策,假如以Oracle11g产品为例,目前11g的报价是: 单cpu 4w美金;按用户算是800美金; 如果用户按照CPU方式购买: 2 CPU的一台服务器部署:8W美金,这个是购买价格;然后用户每年需要支付22%...
  • oracle的价格

    千次阅读 2007-11-12 16:40:00
    根据Oracle公司的销售政策,假如以Oracle11g产品为例,目前11g的报价是: 单cpu 4w美金;按用户算是800美金; 如果我按照CPU方式购买: 2 CPU的一台服务器部署:8W美金,这个是购买价格;然后我每年需要支付22%的...
  • Oracle公司的销售政策

    千次阅读 2013-08-27 16:30:51
    根据Oracle公司的销售政策,以Oracle11g产品为例,2008年11g的报价是:单cpu 4w美金;按用户算是800美金。 如果 用户按照CPU方式购买: 2 CPU的一台服务器部署:8W美金,这个是购买价格;然后用户每年需要...
  • Oracle 购买价格 和 服务费 计算方式https://blog.csdn.net/tianlesoftware/article/details/5430213 根据Oracle公司的销售政策,以Oracle11g产品为例,2008年11g的报价是:单cpu 4w美金;按用户算是800美金。 ...
  • Oracle 购买价格 和 服务费 计算方式

    万次阅读 2014-08-14 13:17:52
    根据Oracle公司的销售政策,以Oracle11g产品为例,2008年11g的报价是:单cpu 4w美金;按用户算是800美金。 如果 用户按照CPU方式购买: 2 CPU的一台服务器部署:8W美金,这个是购买价格;然后用户每年需要...
  • 根据Oracle公司的销售政策,假如以Oracle11g产品为例,目前11g的报价是: 单cpu 4w美金;按用户算是800美金; 如果 用户按照CPU方式购买: 2 CPU的一台服务器部署:8W美金,这个是购买价格;然后用户每年需要支付22...
  • 根据Oracle公司的销售政策,假如以Oracle11g产品为例,目前11g的报价是: 单cpu 4w美金;按用户算是800美金; 如果用户按照CPU方式购买: 2 CPU的一台服务器部署:8W美金,这个是购买价格;然后用户每年需要支付22%...
  • 我们的系统是 Spring+iBatis 的方案,数据库是 oracle。操作系统是 linux 或者 unix 客户要求我们把我们的系统部署到他们的服务器上,这个服务器和数据库都由他们来管理。 对于我们来说,我们的数据是非常宝贵...
  • 运维杂记-05

    2017-09-24 21:53:00
    DAS DELL MD系统 块存储 直连式存储 {数据库 一般不用于文件和日志}SAN 存储光纤连接IBM DS系统 DS5300 官方报价100多万控制器+笼子 光纤+到光纤交换机 服务器有HBA卡 pci-e 两个高可用,可以用于Oracle RACIBM DS...
  • | Java调用Oracle存储过程实现分页功能.rar 1.96 MB | jsp人事工资管理系统.rar 433.81 KB | struts+hibernate实现的教务选课信息管理系统.rar 831.76 KB | vb.net基于winform三层代码生成器2.0版.rar 4.10 MB | ...

空空如也

空空如也

1 2
收藏数 39
精华内容 15
热门标签
关键字:

oracle服务器报价