开发者社区> 潇湘隐者> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

Linux下Oracle 10.2.0.1升级到10.2.0.4总结

2016-04-25 2916

简介：
+关注继续查看

最近部署测试环境时，将测试环境ORACLE数据库从10.2.0.1升级到了10.2.0.4，顺便整理记录一下升级过程。

实验环境： 操作系统：Oracle Linux Server release 5.7 数据库：Oracle 10.2.0.1

下载解压补丁包

   1: [oracle@DB-Server tmp]$ unzip p6810189_10204_Linux-x86-64.zip 
   2:  
   3: [oracle@DB-Server Disk1]$ ls
   4: 10204_buglist.htm  install    patch_note.htm  response  runInstaller  stage

解压后生成Disk1目录，里面patch_note.htm 有详细的升级补丁的介绍，建议升级补丁前，应该好好看看patch_note.htm,里面介绍了Oracle Database、Oracle Real Application Clusters、Oracle Database Client、Oracle Database Vault等各类情况升级。

安装前任务

1：操作系统要求

如下所示，官方文档有system requirements，即必须满足操作系统要求才能打补丁，一般情况下很少有不满足条件。

System Requirements

The following are the system requirements for this patch set:

Operating System

Asianux 2.0

Asianux 3.0

Oracle Enterprise Linux 4.0/Oracle VM

Oracle Enterprise Linux 5.0/Oracle VM

Red Hat Enterprise Linux AS/ES 3.0

Red Hat Enterprise Linux AS/ES 4.0/Oracle VM

Red Hat Enterprise Linux AS/ES 5.0/Oracle VM

SUSE Linux Enterprise Server (SLES) 9

SUSE Linux Enterprise Server (SLES) 10

Oracle Database 10g (10.2.0.1) or later

2：检查设置环境变量

   1: [oracle@DB-Server ~]$ echo $ORACLE_HOME
   2: /u01/app/oracle/product/dbhome_1
   3: [oracle@DB-Server ~]$ echo $ORACLE_SID
   4: epps
   5: [oracle@DB-Server ~]$

3:查看安装补丁情况

   1: [oracle@DB-Server OPatch]$ ./opatch 
   2: Invoking OPatch 10.2.0.1.0
   3:  
   4: Oracle interim Patch Installer version 10.2.0.1.0
   5: Copyright (c) 2005, Oracle Corporation.  All rights reserved..
   6:  
   7:  
   8: Oracle Home       : /u01/app/oracle/product/dbhome_1
   9: Central Inventory : /u01/app/oracle/oraInventory
  10:    from           : /u01/app/oracle/product/dbhome_1/oraInst.loc
  11: OPatch version    : 10.2.0.1.0
  12: OUI version       : 10.2.0.1.0
  13: OUI location      : /u01/app/oracle/product/dbhome_1/oui
  14: Log file location : /u01/app/oracle/product/dbhome_1/cfgtoollogs/opatch/opatch-2014_Mar_11_15-22-45-CST_Tue.log
  15:  
  16:  
  17:  Usage: opatch [ -help ] [ -r[eport] ] [ command ]
  18:  
  19:             command := apply
  20:                        lsinventory
  21:                        query
  22:                        rollback
  23:                        version
  24:  
  25:  <global_arguments> := -help       Displays the help message for the command.
  26:                        -report     Print the actions without executing (deprecated).
  27:  
  28:  example:
  29:    'opatch -help'
  30:    'opatch apply -help'
  31:    'opatch lsinventory -help'
  32:    'opatch rollback -help'
  33:  
  34:  
  35: OPatch succeeded.
  36: [oracle@DB-Server OPatch]$ ./opatch lsinventory -all
  37: Invoking OPatch 10.2.0.1.0
  38:  
  39: Oracle interim Patch Installer version 10.2.0.1.0
  40: Copyright (c) 2005, Oracle Corporation.  All rights reserved..
  41:  
  42:  
  43: Oracle Home       : /u01/app/oracle/product/dbhome_1
  44: Central Inventory : /u01/app/oracle/oraInventory
  45:    from           : /u01/app/oracle/product/dbhome_1/oraInst.loc
  46: OPatch version    : 10.2.0.1.0
  47: OUI version       : 10.2.0.1.0
  48: OUI location      : /u01/app/oracle/product/dbhome_1/oui
  49: Log file location : /u01/app/oracle/product/dbhome_1/cfgtoollogs/opatch/opatch-2014_Mar_11_15-23-02-CST_Tue.log
  50:  
  51: Lsinventory Output file location : /u01/app/oracle/product/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory-2014_Mar_11_15-23-02-CST_Tue.txt
  52:  
  53: --------------------------------------------------------------------------------
  54: List of Oracle Homes:
  55:   Name          Location
  56:    OraDb10g_home1         /u01/app/oracle/product/dbhome_1
  57:  
  58: Installed Top-level Products (1): 
  59:  
  60: Oracle Database 10g                                                  10.2.0.1.0
  61: There are 1 products installed in this Oracle Home.
  62:  
  63:  
  64: There are no Interim patches installed in this Oracle Home.
  65:  
  66: --------------------------------------------------------------------------------
  67:  
  68: OPatch succeeded.

4:检查Oracle Time Zone Definitions

clip_image001

5：停止所有进程(Stop All Processes)

$ emctl stop dbconsole

$ isqlplusctl stop

$ lsnrctl stop

SQL> SHUTDOWN IMMEDIATE

   1: [oracle@DB-Server ~]$ emctl stop dbconsole
   2: TZ set to Asia/Chungking
   3: OC4J Configuration issue. /u01/app/oracle/product/dbhome_1/oc4j/j2ee/OC4J_DBConsole_DB-Server.localdomain_epps not found. 
   4: [oracle@DB-Server ~]$ isqlplusctl stop
   5: iSQL*Plus 10.2.0.1.0
   6: Copyright (c) 2003, 2005, Oracle.  All rights reserved.
   7: getnameinfo failed
   8: getnameinfo failed
   9: iSQL*Plus instance on port 5560 is not running ...
  10: [oracle@DB-Server ~]$ lsnrctl stop
  11:  
  12: LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-MAR-2014 15:33:20
  13:  
  14: Copyright (c) 1991, 2005, Oracle.  All rights reserved.
  15:  
  16: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.11)(PORT=1521)))
  17: The command completed successfully
  18:  
  19: [oracle@DB-Server ~]$ sqlplus / as sysdba
  20:  
  21: SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 11 15:34:02 2014
  22:  
  23: Copyright (c) 1982, 2005, Oracle.  All rights reserved.
  24:  
  25:  
  26: Connected to:
  27: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
  28: With the Partitioning, OLAP and Data Mining options
  29:  
  30: SQL> shutdown immediate;
  31: Database closed.
  32: Database dismounted.
  33: ORACLE instance shut down.

备份数据库

因为是测试数据库，可以做备份或不做备份关系不大，生产环境则必须先做一个冷备或热备。

安装补丁包

Oracle提供了两种方式安装补丁包，即图形化安装或静默安装。即Installing the Oracle Database 10g Patch Set Interactively 和

Installing the Oracle Database 10g Patch Set Noninteractively 安装。

下面我们先用Installing the Oracle Database 10g Patch Set Interactively

Installing the Oracle Database 10g Patch Set Interactively

1.Log in as the oracle user.

2.If you are not installing the software on the local computer, then run the following command on remote machine:

Bourne, Bash, or Korn shell:

$ export DISPLAY=localhost:0.0

C shell:

% setenv DISPLAY local_host:0.0

In this example, local_host is the host name or IP address of the computer that you want to use to display Oracle Universal Installer.

Now to enable X applications, run the following command on the machine that you want to use to display Oracle Universal Installer:

$ xhost + [fully_qualified_remote_host_name]

注意上面事项，否则有可能出现下面错误信息。

   1: [oracle@DB-Server Disk1]$ ./runInstaller 
   2:  
   3: Starting Oracle Universal Installer...
   4:  
   5: Checking installer requirements...
   6:  
   7: Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asian
   8:  
   9: ux-1, asianux-2 or asianux-3
  10:  
  11: Passed
  12:  
  13: All installer requirements met.
  14:  
  15: Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-03-11_03-39-25PM. Please wait ...[oracle
  16:  
  17: @DB-Server Disk1]$ Oracle Universal Installer, Version 10.2.0.4.0 Production
  18:  
  19: Copyright (C) 1999, 2008, Oracle. All rights reserved.
  20:  
  21: Xlib: connection to ":0.0" refused by server
  22:  
  23: Xlib: No protocol specified
  24:  
  25: Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.
  26:  
  27: :0.0
  28:  
  29: :0.0
  30:  
  31: OUI-10025:Unable to start an interactive install session because of the following error:Can't connect to X11 win
  32:  
  33: dow server using ':0.0' as the value of the DISPLAY variable. The DISPLAY environment variable should be set to 
  34:  
  35: <hostname or IP address>:<screen>, where the <screen> is usually '0.0'.
  36:  
  37: OUI-10026:Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY 
  38:  
  39: environment variable:
  40:  
  41: - For csh: % setenv DISPLAY 192.168.1.128:0.0
  42:  
  43: - For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY
  44:  
  45: Use the following command to see what shell is being used:
  46:  
  47: echo $SHELL
  48:  
  49: Use the following command to view the current DISPLAY environment variable setting:
  50:  
  51: echo $DISPLAY
  52:  
  53: - Make sure that client users are authorized to connect to the X Server.
  54:  
  55: OUI-10027:To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that star
  56:  
  57: ted the session and type the following command:
  58:  
  59: % xhost +
  60:  
  61: To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the nati
  62:  
  63: ve operating system such as 'xclock':
  64:  
  65: % <full path to xclock... see below>
  66:  
  67: If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
  68:  
  69: Typical path for 'xclock': '/usr/X11R6/bin/xclock'
  70:  
  71: [oracle@DB-Server ~]$ 
  72: 

[oracle@DB-Server Disk1]$ ./runInstaller

clip_image002

clip_image003

clip_image004

clip_image005

clip_image006

clip_image007

在root账号下执行/u01/app/oracle/product/dbhome_1/root.sh

clip_image008

clip_image009

安装后任务

升级数据库

可以使用手工升级数据库或使用DBUA界面安装数据库。下面我们选择使用手工升级数据库

clip_image010

1:Start the database in the UPGRADE mode

   1: [oracle@DB-Server ~]$ sqlplus / as sysdba
   2:  
   3: SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 11 16:27:30 2014
   4:  
   5: Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
   6:  
   7: Connected to an idle instance.
   8:  
   9: SQL> startup upgrade
  10: ORACLE instance started.
  11:  
  12: Total System Global Area 2483027968 bytes
  13: Fixed Size                  2085968 bytes
  14: Variable Size             603982768 bytes
  15: Database Buffers         1862270976 bytes
  16: Redo Buffers               14688256 bytes
  17: Database mounted.
  18: Database opened.

2.Set the system to spool results to a log file for later analysis:

SQL> SPOOL upgrade_info.log

3.Run the Pre-Upgrade Information Tool:

   1: SQL> @?/rdbms/admin/utlu102i.sql
   2: Oracle Database 10.2 Upgrade Information Utility    03-11-2014 16:30:19
   3: .
   4: **********************************************************************
   5: Database:
   6: **********************************************************************
   7: --> name:       EPPS
   8: --> version:    10.2.0.1.0
   9: --> compatible: 10.2.0.1.0
  10: --> blocksize:  8192
  11: .
  12: **********************************************************************
  13: Tablespaces: [make adjustments in the current environment]
  14: **********************************************************************
  15: --> SYSTEM tablespace is adequate for the upgrade.
  16: .... minimum required size: 544 MB
  17: .... AUTOEXTEND additional space required: 4 MB
  18: --> UNDOTBS1 tablespace is adequate for the upgrade.
  19: .... minimum required size: 400 MB
  20: .... AUTOEXTEND additional space required: 270 MB
  21: --> SYSAUX tablespace is adequate for the upgrade.
  22: .... minimum required size: 410 MB
  23: --> TEMP tablespace is adequate for the upgrade.
  24: .... minimum required size: 58 MB
  25: --> EXAMPLE tablespace is adequate for the upgrade.
  26: .... minimum required size: 69 MB
  27: .
  28: **********************************************************************
  29: Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
  30: **********************************************************************
  31: -- No update parameter changes are required.
  32: .
  33: **********************************************************************
  34: Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
  35: **********************************************************************
  36: -- No renamed parameters found. No changes are required.
  37: .
  38: **********************************************************************
  39: Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
  40: **********************************************************************
  41: -- No obsolete parameters found. No changes are required
  42: .
  43: **********************************************************************
  44: Components: [The following database components will be upgraded or installed]
  45: **********************************************************************
  46: --> Oracle Catalog Views         [upgrade]  VALID
  47: --> Oracle Packages and Types    [upgrade]  VALID
  48: --> JServer JAVA Virtual Machine [upgrade]  VALID
  49: --> Oracle XDK for Java          [upgrade]  VALID
  50: --> Oracle Java Packages         [upgrade]  VALID
  51: --> Oracle Text                  [upgrade]  VALID
  52: --> Oracle XML Database          [upgrade]  VALID
  53: --> Oracle Workspace Manager     [upgrade]  VALID
  54: --> Oracle Data Mining           [upgrade]  VALID
  55: --> OLAP Analytic Workspace      [upgrade]  VALID
  56: --> OLAP Catalog                 [upgrade]  VALID
  57: --> Oracle OLAP API              [upgrade]  VALID
  58: --> Oracle interMedia            [upgrade]  VALID
  59: --> Spatial                      [upgrade]  VALID
  60: --> Expression Filter            [upgrade]  VALID
  61: --> EM Repository                [upgrade]  VALID
  62: --> Rule Manager                 [upgrade]  VALID
  63: .
  64: **********************************************************************
  65: Miscellaneous Warnings
  66: **********************************************************************
  67: PL/SQL procedure successfully completed.

查看已经安装的补丁情况：

   1: [oracle@DB-Server OPatch]$ ./opatch lsinventory -all
   2: Invoking OPatch 10.2.0.4.2
   3:  
   4: Oracle Interim Patch Installer version 10.2.0.4.2
   5: Copyright (c) 2007, Oracle Corporation.  All rights reserved.
   6:  
   7:  
   8: Oracle Home       : /u01/app/oracle/product/dbhome_1
   9: Central Inventory : /u01/app/oracle/oraInventory
  10:    from           : /etc/oraInst.loc
  11: OPatch version    : 10.2.0.4.2
  12: OUI version       : 10.2.0.4.0
  13: OUI location      : /u01/app/oracle/product/dbhome_1/oui
  14: Log file location : /u01/app/oracle/product/dbhome_1/cfgtoollogs/opatch/opatch2014-03-11_16-55-25PM.log
  15:  
  16: Lsinventory Output file location : /u01/app/oracle/product/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-11_16-55-25PM.txt
  17:  
  18: --------------------------------------------------------------------------------
  19: List of Oracle Homes:
  20:   Name          Location
  21:    OraDb10g_home1         /u01/app/oracle/product/dbhome_1
  22:  
  23: Installed Top-level Products (2): 
  24:  
  25: Oracle Database 10g                                                  10.2.0.1.0
  26: Oracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0
  27: There are 2 products installed in this Oracle Home.
  28:  
  29:  
  30: There are no Interim patches installed in this Oracle Home.
  31:  
  32:  
  33: --------------------------------------------------------------------------------
  34:  
  35: OPatch succeeded.

clip_image011

关闭数据库，然后执行脚本：

SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

SQL> @?/rdbms/admin/catupgrd.sql

SQL> SPOOL OFF

@?/rdbms/admin/catupgrd.sql

clip_image012

   1: SQL> shutdown immediate;
   2:  
   3: Database closed.
   4:  
   5: Database dismounted.
   6:  
   7: ORACLE instance shut down.
   8:  
   9: SQL> startup
  10:  
  11: ORACLE instance started.
  12:  
  13: Total System Global Area 2483027968 bytes
  14:  
  15: Fixed Size 2085968 bytes
  16:  
  17: Variable Size 637537200 bytes
  18:  
  19: Database Buffers 1828716544 bytes
  20:  
  21: Redo Buffers 14688256 bytes
  22:  
  23: Database mounted.
  24:  
  25: Database opened.
  26:  
  27: SQL> @?/rdbms/admin/utlrp.sql
  28: 

验证

clip_image013

   1: SQL> COL COMP_NAME FOR A50
   2: SQL> COL VERSION FOR A12
   3: SQL> COL STATUS FOR A12
   4: SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
   5:  
   6: COMP_NAME                                          VERSION      STATUS
   7: -------------------------------------------------- ------------ ------------
   8: Oracle Database Catalog Views                      10.2.0.4.0   VALID
   9: Oracle Database Packages and Types                 10.2.0.4.0   VALID
  10: Oracle Workspace Manager                           10.2.0.4.3   VALID
  11: JServer JAVA Virtual Machine                       10.2.0.4.0   VALID
  12: Oracle XDK                                         10.2.0.4.0   VALID
  13: Oracle Database Java Packages                      10.2.0.4.0   VALID
  14: Oracle Expression Filter                           10.2.0.4.0   VALID
  15: Oracle Data Mining                                 10.2.0.4.0   VALID
  16: Oracle Text                                        10.2.0.4.0   VALID
  17: Oracle XML Database                                10.2.0.4.0   VALID
  18: Oracle Rule Manager                                10.2.0.4.0   VALID
  19:  
  20: COMP_NAME                                          VERSION      STATUS
  21: -------------------------------------------------- ------------ ------------
  22: Oracle interMedia                                  10.2.0.4.0   VALID
  23: OLAP Analytic Workspace                            10.2.0.4.0   VALID
  24: Oracle OLAP API                                    10.2.0.4.0   VALID
  25: OLAP Catalog                                       10.2.0.4.0   VALID
  26: Spatial                                            10.2.0.4.0   VALID
  27: Oracle Enterprise Manager                          10.2.0.4.0   VALID
  28:  
  29: 17 rows selected.
  30: 

如果你需要升级emca，那么可以通过emca –upgrade db命令实现。如下所示

   1: [oracle@DB-Server ~]$ emca -upgrade db
   2:  
   3: STARTED EMCA at Mar 12, 2014 2:59:18 PM
   4: EM Configuration Assistant, Version 10.2.0.1.0 Production
   5: Copyright (c) 2003, 2005, Oracle.  All rights reserved.
   6:  
   7: Enter the following information:
   8: ORACLE_HOME for the database to be upgraded: /u01/app/oracle/product/dbhome_1
   9: Database SID: epps
  10: Listener port number: 15
  11: ...........

版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

Oracle 关系型数据库 Shell Linux 数据库
Linux总结 Linux oracle Oracle数据库一键上云升级 Oracle数据库一键上云Linux Linux升级
开发者社区 > 数据库 > 文章
数据库备份
作者高分内容
更多
VIEW SERVER STATE permission was denied on object 'server', database 'master' 4279 MySQL server version for the right syntax to use near 'TYPE=MyISAM' 3966 SQL SERVER 2014 Agent服务异常停止案例 4545 MySQL 使用XtraBackup的shell脚本介绍 3519 SSRS 2008 ReportServerTempDB增长异常分析 3604
相关文章
喵宁一
Oracle数据库面试题总结
1、SQL语句分类 DQL（数据查询语言）select DML（数据操作语言）insert、delete、update DDL（数据定义语言）create、drop、alter DCL（数据控制语言）grant：把权限授予用户、revoke：把权限从用户收回 TPL（TCL，事务控制语言）：commit、rollback
0 0
游客tmj4hgt7bfvas
Oracle-分析函数_总结
Oracle-分析函数_总结
0 0
java3y
Oracle总结【SQL细节、多表查询、分组查询、分页】下
在之前已经大概了解过Mysql数据库和学过相关的Oracle知识点，但是太久没用过Oracle了，就基本忘了…印象中就只有基本的SQL语句和相关一些概念….写下本博文的原因就是记载着Oracle一些以前没注意到的知识点…以后或许会有用… 实例与数据库概念
0 0
java3y
Oracle总结【SQL细节、多表查询、分组查询、分页】上
在之前已经大概了解过Mysql数据库和学过相关的Oracle知识点，但是太久没用过Oracle了，就基本忘了…印象中就只有基本的SQL语句和相关一些概念….写下本博文的原因就是记载着Oracle一些以前没注意到的知识点…以后或许会有用… 实例与数据库概念
0 0
java3y
Oracle总结【视图、索引、事务、用户权限、批量操作】三
在Oracle总结的第一篇中，我们已经总结了一些常用的SQL相关的知识点了…那么本篇主要总结关于Oralce视图、序列、事务的一些内容… 在数据库中，我们可以把各种的SQL语句分为四大类… （1）DML（数据操纵语言）：select，insert，update，delete （2）DDL（数据定义语言）：create table，alter table，drop table，truncate table （3）DCL（数据控制语言）：grant select any table to scott/revoke select any table from scott （4）TCL（事务
0 0
java3y
Oracle总结【视图、索引、事务、用户权限、批量操作】二
在Oracle总结的第一篇中，我们已经总结了一些常用的SQL相关的知识点了…那么本篇主要总结关于Oralce视图、序列、事务的一些内容… 在数据库中，我们可以把各种的SQL语句分为四大类… （1）DML（数据操纵语言）：select，insert，update，delete （2）DDL（数据定义语言）：create table，alter table，drop table，truncate table （3）DCL（数据控制语言）：grant select any table to scott/revoke select any table from scott （4）TCL（事务
0 0
java3y
Oracle总结【视图、索引、事务、用户权限、批量操作】 一
在Oracle总结的第一篇中，我们已经总结了一些常用的SQL相关的知识点了…那么本篇主要总结关于Oralce视图、序列、事务的一些内容… 在数据库中，我们可以把各种的SQL语句分为四大类… （1）DML（数据操纵语言）：select，insert，update，delete （2）DDL（数据定义语言）：create table，alter table，drop table，truncate table （3）DCL（数据控制语言）：grant select any table to scott/revoke select any table from scott （4）TCL（事务
0 0
java3y
Oracle总结【PLSQL学习】 （三）
笔记
0 0
java3y
Oracle总结【PLSQL学习】 （二）
笔记
0 0
java3y
Oracle总结【PLSQL学习】 （一）
笔记
0 0
+关注
潇湘隐者
网名潇湘隐者/潇湘剑客、英文名Kerry，兴趣广泛，广泛涉猎，个性随意，不善言辞。执意做一名会写代码的DBA，混迹于IT行业
文章
问答
作者高分内容
更多
VIEW SERVER STATE permission was denied on object 'server', database 'master' 4279 MySQL server version for the right syntax to use near 'TYPE=MyISAM' 3966 SQL SERVER 2014 Agent服务异常停止案例 4545 MySQL 使用XtraBackup的shell脚本介绍 3519 SSRS 2008 ReportServerTempDB增长异常分析 3604
文章排行榜
最热
最新
1 承上启下：基于全域漏斗分析的主搜深度统一粗排 91555
2 复杂链表的复制 90660
3 【Transform3D】转换详解（看完就会） 88214
4 【flexbox弹性布局学习指南】CSS热门布局方案 68868
5 如何构建标签画像工程体系及实现方案 63378
6 DCM：中间件家族迎来新成员 61177
7 系统的混乱并业务本身之复杂，我们并不擅长处理『简单』 48289
8 超越10倍开发者 48162
9 ⚡Three.js-在场景中导入3D动画模型 46125
10 《JavaScript高级程序设计》__ 作用域&内存 37898
11 【从零开始学习深度学习】12. 什么是模型的训练误差？基于三阶多项式的欠拟合与过拟合训练过程演示 27906
12 记录下考Apsara Clouder云计算专项技能认证：云服务器ECS入门过程 20966
13 阿里云物联网平台设备分发实战 33512
14 ChatGPT 常见错误原因及解决方案：报错、回答不完整等 22533
15 学生速看！免费领取阿里云云服务器的详细攻略 4742
16 Python3，9行代码，对比两个Excel数据差异，并把差异结果重新保存。 8994
17 深聊性能测试，从入门到放弃之： Windows系统性能监控(一) 性能监视器介绍及使用。 9985
18 Python3，区区10行代码，批量把图片插入Excel指定单元格中，省下时间去烫头发。 3836
19 Python3，区区9行代码批量提取PDF文件的指定内容，我被震惊了.... 5682
20 Python3，os模块还可以这样玩，自动删除磁盘文件，非必要切勿操作。 11324
1 Java编程技巧之单元测试用例简化方法 62
2 语雀 117
3 如何选择离线数据集成方案-全量&增量 52
4 云时代，好用的数据迁移方案推荐 149
5 浅谈智能语音交互 127
6 Mysql深入优化（三） --- 查询缓存优化、内存管理及优化、MySQL锁问题 57
7 大数据知识面试题-Hive 53
8 【分享】宜搭集成自动化，Groovy节点一般用法，解析JSON数据 98
9 算法提升（二） 异或法 79
10 一封来自开发者社区的邀请函 183
11 【分享】在宜搭JS面板写了死循环如何解决 133
12 如何选择数据集成方式-离线&实时 151
13 网易游戏实时 HTAP 计费风控平台建设 222
14 Apache Tomcat 存在 JsonErrorReportValve 注入漏洞（CVE-2022-45143） 92
15 电影《流浪地球2》观后感 53
16 2023，不一样的数据库 117
17 公众号可订阅阿里云商标申请进度 51
18 Grid网格布局学习笔记 60
19 阿里云国际版创建ESC实例Linux系统 69
20 【数据设计与实现】第5章：同步与互斥 85
相关课程
更多
Linux MySQL服务器搭建与应用
12267
5
去学习
LINUX 企业常用服务
2937
7
去学习
SQL Server on Linux入门教程
4259
14
去学习
Linux 系统管理进阶
817
4
去学习
Linux文件管理命令
20078
9
去学习
线上Linux服务器优化经验
15720
14
去学习
推荐文章
2022藏经阁年度电子书榜单出炉！ 参与应用引擎 SAE评测，赢取CHERRY机械键盘等好礼 “第益课”大学生技术公益 乘风者计划邀您入驻社区，精彩权益即刻享
相关电子书
更多
EasyDBforOracle— 基于阿里云的Oracle最佳实践
立即下载
Oracle云上最佳实践
立即下载
迁移 ORACLE 最佳实践
立即下载