当前位置: 首页 > news >正文

做垃圾站采集国外网站/网站链接交易

做垃圾站采集国外网站,网站链接交易,怎么做引流网站,郑州400建站网站建设1.组件信息 source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF set line 200 col COMP_NAME for a40 select comp_name,VERSION,STATUS from dba_registry; exit; EOF COMP_NAME VERSION …

1.组件信息

source /home/oracle/.bash_profile11g  && sqlplus "/ as sysdba"<<EOF

set line 200

col COMP_NAME for a40

select comp_name,VERSION,STATUS from dba_registry;

exit;

EOF

COMP_NAME                                VERSION                        STATUS

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

OWB                                      11.2.0.4.0                     VALID

Oracle Application Express               3.2.1.00.12                    VALID

Oracle Enterprise Manager                11.2.0.4.0                     VALID

OLAP Catalog                             11.2.0.4.0                     VALID

Spatial                                  11.2.0.4.0                     VALID

Oracle Multimedia                        11.2.0.4.0                     VALID

Oracle XML Database                      11.2.0.4.0                     VALID

Oracle Text                              11.2.0.4.0                     VALID

Oracle Expression Filter                 11.2.0.4.0                     VALID

Oracle Rules Manager                     11.2.0.4.0                     VALID

Oracle Workspace Manager                 11.2.0.4.0                     VALID

COMP_NAME                                VERSION                        STATUS

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

Oracle Database Catalog Views            11.2.0.4.0                     VALID

Oracle Database Packages and Types       11.2.0.4.0                     VALID

JServer JAVA Virtual Machine             11.2.0.4.0                     VALID

Oracle XDK                               11.2.0.4.0                     VALID

Oracle Database Java Packages            11.2.0.4.0                     VALID

OLAP Analytic Workspace                  11.2.0.4.0                     VALID

Oracle OLAP API                          11.2.0.4.0                     VALID

18 rows selected.

废弃的组件:EM

从18c开始,Oracle不会自动更新APEX组件,需要手动更新。

OLAP删除

2.查看刷新的物化视图

source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF

SELECT o.name FROM sys.obj$ o, sys.user$ u, sys.sum$ s WHERE o.type# = 42 AND bitand(s.mflags, 8) =8;

exit;

EOF

升级前确保无物化视图正在刷新

SQL> SELECT o.name FROM sys.obj$ o, sys.user$ u, sys.sum$ s WHERE o.type# = 42 AND bitand(s.mflags, 8) =8;

no rows selected

3.删除EM组件

source /home/oracle/.bash_profile11g && emctl stop dbconsole &&sqlplus '/ as sysdba'<<EOF

SET ECHO ON;

SET SERVEROUTPUT ON;

@/u01/app/oracle/product/19c/dbhome_1/rdbms/admin/emremove.sql

exit;

EOF

$ cd $ORACLE_HOME

$ rm -rf HOSTNAME_SID

$ rm -rf oc4j/j2ee/OC4J_DBConsole_HOSTNAME_SID

结果:

[oracle@19crac1 ~]$ source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF

> @/u01/app/oracle/product/19c/dbhome_1/rdbms/admin/emremove.sql

> exit;

> EOF

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 9 17:31:40 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> old  70:     IF (upper('&LOGGING') = 'VERBOSE')

new  70:     IF (upper('VERBOSE') = 'VERBOSE')

PL/SQL procedure successfully completed.

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

4.删除OLAP组件

source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF

@?/olap/admin/catnoamd.sql;

exit;

EOF

5.手动升级APEX组件

Ø 下载补丁包:http://www.oracle.com/technetwork/developer-tools/apex/all-archives-099381.html

[oracle@19crac1 ~]$ source .bash_profile11g

[oracle@19crac1 ~]$ cd apex

[oracle@19crac1 apex]$ ls -ltr

[oracle@19crac1 apex]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 9 20:16:40 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/

...set_appun.sql

PL/SQL procedure successfully completed.

检查APEX版本

source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF

COL COMP_NAME FORMAT A40

COL STATUS FORMAT A12

Set lines 200

SELECT COMP_NAME, STATUS, VERSION FROM DBA_REGISTRY WHERE COMP_NAME='Oracle Application Express';

exit;

EOF

结果

COMP_NAME                                STATUS       VERSION

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

Oracle Application Express               VALID        3.2.1.00.12

Ø 一定要注意归档空间的使用率,有可能归档满了,升级卡住

Ø 详细日志

6.确认兼容性参数

source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF

show parameter compatible;

exit;

EOF

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL>

NAME                                 TYPE        VALUE

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

compatible                           string      11.2.0.4.0

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

注意升级 19c 的 COMPATIBLE 参数的最小值为“11.2.0”, 确保您的 COMPATIBLE 参数设置为11.2.0或更高

7.配置FRA

source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF

show parameter db_recovery_file_dest;

exit;

EOF

8.清理回收站

source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF

 purge dba_recyclebin;

exit;

EOF

9.创建闪回点

source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF

create restore point syncdb_20200924_19c guarantee flashback database;

select name,guarantee_flashback_database,to_char(scn) from v\$restore_point;

exit;

EOF

结果:

SQL>

Restore point created.

SQL>

NAME

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

GUA TO_CHAR(SCN)

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

SYNCDB_20200924_19C

YES 994270            

10.收集数据字典统计信息

source /home/oracle/.bash_profile11g && sqlplus '/ as sysdba'<<EOF

EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;

exit;

EOF

11.备份数据库

$ . .bash_profile11g

$ rman target /

RUN

{

    ALLOCATE CHANNEL chan_name TYPE DISK;

    BACKUP DATABASE FORMAT '/tmp/orcl_2_%U' TAG before_upgrade;

    BACKUP CURRENT CONTROLFILE FORMAT '/tmp/controlfile';

}

12.升级前预检查

拷贝jar到/tmp

19c环境

[root@19crac1 ~]# su - oracle

[oracle@19crac1 ~]$ cp /u01/app/oracle/product/19c/dbhome_1/rdbms/admin/preupgrade.jar /tmp

11g环境下执行

source /home/oracle/.bash_profile11g && mkdir -p /home/oracle/nxtest/log && $ORACLE_HOME/jdk/bin/java -jar /tmp/preupgrade.jar FILE TEXT DIR /home/oracle/nxtest/log

结果:

==================

PREUPGRADE SUMMARY

==================

  /home/oracle/nxtest/log/preupgrade.log

  /home/oracle/nxtest/log/preupgrade_fixups.sql

  /home/oracle/nxtest/log/postupgrade_fixups.sql

Execute fixup scripts as indicated below:

Before upgrade:

Log into the database and execute the preupgrade fixups

@/home/oracle/nxtest/log/preupgrade_fixups.sql

After the upgrade:

Log into the database and execute the postupgrade fixups

@/home/oracle/nxtest/log/postupgrade_fixups.sql

Preupgrade complete: 2020-09-24T11:07:15

13.执行升级前修复脚本

[oracle@19crac1 ~]$ source .bash_profile11g

[oracle@19crac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 9 20:56:30 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> @/home/oracle/nxtest/log/preupgrade_fixups.sql

Executing Oracle PRE-Upgrade Fixup Script

Auto-Generated by:       Oracle Preupgrade Script

                         Version: 19.0.0.0.0 Build: 1

Generated on:            2020-09-24 11:07:11

For Source Database:     ORCL

Source Database Version: 11.2.0.4.0

For Upgrade to Version:  19.0.0.0.0

Preup                             Preupgrade

Action                            Issue Is

Number  Preupgrade Check Name     Remedied    Further DBA Action

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

    1.  min_recovery_area_size    NO          Manual fixup required.

    2.  parameter_min_val         NO          Manual fixup recommended.

    3.  em_present                NO          Manual fixup recommended.

    4.  invalid_objects_exist     NO          Manual fixup recommended.

    5.  apex_manual_upgrade       NO          Manual fixup recommended.

    6.  trgowner_no_admndbtrg     YES         None.

    7.  tablespaces_info          NO          Informational only.

                                              Further action is optional.

    8.  exf_rul_exists            NO          Informational only.

                                              Further action is optional.

    9.  rman_recovery_version     NO          Informational only.

                                              Further action is optional.

The fixup scripts have been run and resolved what they can. However,

there are still issues originally identified by the preupgrade that

have not been remedied and are still present in the database.

Depending on the severity of the specific issue, and the nature of

the issue itself, that could mean that your database is not ready

for upgrade.  To resolve the outstanding issues, start by reviewing

the preupgrade_fixups.sql and searching it for the name of

the failed CHECK NAME or Preupgrade Action Number listed above.

There you will find the original corresponding diagnostic message

from the preupgrade which explains in more detail what still needs

to be done.

PL/SQL procedure successfully completed.

14.修改废弃参数(此步骤在前面可以避免)

删除19c废弃或者不兼容的参数

source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF

alter system set sec_case_sensitive_logon=true;

exit;

EOF

15.修改oratab文件

echo "orcl:/u02/app/oracle/product/11.2.0/dbhome_1:N">>/etc/oratab

deep:/u01/app/oracle/product/19.3.0/db_1:N

prod:/u01/app/oracle/product/12.2.0/db_1:N

orcl:/u01/app/oracle/product/11.2.0/db_1:N

16.拷贝spfile至19c的home dbs下,并重启库至upgrade

[oracle@19crac1 nxtest]$ cp /u02/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl1.ora /u01/app/oracle/product/19c/dbhome_1/dbs/

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 1002437904 bytes

Fixed Size                  8903952 bytes

Variable Size             276824064 bytes

Database Buffers          708837376 bytes

Redo Buffers                7872512 bytes

Database mounted.

Database opened.

17.执行升级脚本(19c目录下)

[oracle@19crac1 nxtest]$ cd $ORACLE_HOME

[oracle@19crac1 dbhome_1]$ cd bin/

[oracle@19crac1 bin]$ ./dbupgrade -n 4 -l /home/oracle/nxtest

结果

Argument list for [/u01/app/oracle/product/19c/dbhome_1/rdbms/admin/catctl.pl]

For Oracle internal use only A = 0

Run in                       c = 0

Do not run in                C = 0

Input Directory              d = 0

Echo OFF                     e = 1

Simulate                     E = 0

Forced cleanup               F = 0

Log Id                       i = 0

Child Process                I = 0

Log Dir                      l = /home/oracle/nxtest –日志文件存放位置

Priority List Name           L = 0

Upgrade Mode active          M = 0

SQL Process Count            n = 4   --和CPU_COUNT参数一样即可

SQL PDB Process Count        N = 0

Open Mode Normal             o = 0

Start Phase                  p = 0

End Phase                    P = 0

Reverse Order                r = 0

AutoUpgrade Resume           R = 0

Script                       s = 0

Serial Run                   S = 0

RO User Tablespaces          T = 0

Display Phases               y = 0

Debug catcon.pm              z = 0

Debug catctl.pl              Z = 0

catctl.pl VERSION: [19.0.0.0.0]

           STATUS: [Production]

            BUILD: [RDBMS_19.4.0.0.0DBRU_LINUX.X64_190626]

/u01/app/oracle/product/19c/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19c/dbhome_1]

/u01/app/oracle/product/19c/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19c/dbhome_1]

catctlGetOraBaseLogDir = [/u01/app/oracle/product/19c/dbhome_1]

Analyzing file /u01/app/oracle/product/19c/dbhome_1/rdbms/admin/catupgrd.sql

Log file directory = [/home/oracle/nxtest]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/nxtest/catupgrd_catcon_73530.lst]

catcon::set_log_file_base_path: catcon: See [/home/oracle/nxtest/catupgrd*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/home/oracle/nxtest/catupgrd_*.lst] files for spool files, if any

Number of Cpus        = 2

Database Name         = orcldg

DataBase Version      = 11.2.0.4.0

Parallel SQL Process Count            = 4

Components in [orcldg]

    Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT JAVAVM ORDIM OWM SDO XDB XML XOQ]

Not Installed [DV EM MGW ODM OLS RAC WK]

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

Phases [0-107]         Start Time:[2019_12_11 09:00:06]

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

***********   Executing Change Scripts   ***********

Serial   Phase #:0    [orcldg] Files:1    Time: 81s

***************   Catalog Core SQL   ***************

Serial   Phase #:1    [orcldg] Files:5    Time: 34s

Restart  Phase #:2    [orcldg] Files:1    Time: 1s

***********   Catalog Tables and Views   ***********

Parallel Phase #:3    [orcldg] Files:19   Time: 14s

Restart  Phase #:4    [orcldg] Files:1    Time: 2s

*************   Catalog Final Scripts   ************

Serial   Phase #:5    [orcldg] Files:7    Time: 11s

*****************   Catproc Start   ****************

Serial   Phase #:6    [orcldg] Files:1    Time: 11s

*****************   Catproc Types   ****************

Serial   Phase #:7    [orcldg] Files:2    Time: 8s

Restart  Phase #:8    [orcldg] Files:1    Time: 1s

****************   Catproc Tables   ****************

Parallel Phase #:9    [orcldg] Files:67   Time: 23s

Restart  Phase #:10   [orcldg] Files:1    Time: 3s

*************   Catproc Package Specs   ************

Serial   Phase #:11   [orcldg] Files:1    Time: 42s

Restart  Phase #:12   [orcldg] Files:1    Time: 1s

**************   Catproc Procedures   **************

Parallel Phase #:13   [orcldg] Files:94   Time: 6s

Restart  Phase #:14   [orcldg] Files:1    Time: 1s

Parallel Phase #:15   [orcldg] Files:121  Time: 9s

Restart  Phase #:16   [orcldg] Files:1    Time: 1s

Serial   Phase #:17   [orcldg] Files:22   Time: 3s

Restart  Phase #:18   [orcldg] Files:1    Time: 2s

*****************   Catproc Views   ****************

Parallel Phase #:19   [orcldg] Files:32   Time: 13s

Restart  Phase #:20   [orcldg] Files:1    Time: 3s

。。。。。。

***************   Catproc CDB Views   **************

Serial   Phase #:31   [orcldg] Files:1    Time: 2s

Restart  Phase #:32   [orcldg] Files:1    Time: 2s

Serial   Phase #:34   [orcldg] Files:1    Time: 0s

*****************   Catproc PLBs   *****************

Serial   Phase #:35   [orcldg] Files:294  Time: 16s

Serial   Phase #:36   [orcldg] Files:1    Time: 0s

Restart  Phase #:37   [orcldg] Files:1    Time: 1s

Serial   Phase #:38   [orcldg] Files:6    Time: 5s

Restart  Phase #:39   [orcldg] Files:1    Time: 0s

***************   Catproc DataPump   ***************

Serial   Phase #:40   [orcldg] Files:3    Time: 35s

Restart  Phase #:41   [orcldg] Files:1    Time: 1s

******************   Catproc SQL   *****************

Parallel Phase #:42   [orcldg] Files:13   Time: 84s

Restart  Phase #:43   [orcldg] Files:1    Time: 2s

Parallel Phase #:44   [orcldg] Files:11   Time: 9s

Restart  Phase #:45   [orcldg] Files:1    Time: 3s

Parallel Phase #:46   [orcldg] Files:3    Time: 3s

Restart  Phase #:47   [orcldg] Files:1    Time: 2s

*************   Final Catproc scripts   ************

Serial   Phase #:48   [orcldg] Files:1    Time: 7s

Restart  Phase #:49   [orcldg] Files:1    Time: 2s

**************   Final RDBMS scripts   *************

Serial   Phase #:50   [orcldg] Files:1    Time: 12s

************   Upgrade Component Start   ***********

Serial   Phase #:51   [orcldg] Files:1    Time: 2s

Restart  Phase #:52   [orcldg] Files:1    Time: 2s

**********   Upgrading Java and non-Java   *********

Serial   Phase #:53   [orcldg] Files:2    Time: 283s

*****************   Upgrading XDB   ****************

Restart  Phase #:54   [orcldg] Files:1    Time: 2s

Serial   Phase #:56   [orcldg] Files:3    Time: 19s

Serial   Phase #:57   [orcldg] Files:3    Time: 5s

。。。。。。

****************   Upgrading ORDIM   ***************

Restart  Phase #:67   [orcldg] Files:1    Time: 2s

Serial   Phase #:69   [orcldg] Files:1    Time: 5s

Parallel Phase #:70   [orcldg] Files:2    Time: 29s

。。。。。

*****************   Upgrading SDO   ****************

Restart  Phase #:74   [orcldg] Files:1    Time: 1s

Serial   Phase #:76   [orcldg] Files:1    Time: 30s

Serial   Phase #:77   [orcldg] Files:2    Time: 5s

。。。。。。

*******   Upgrading ODM, WK, EXF, RUL, XOQ   *******

Serial   Phase #:95   [orcldg] Files:1    Time: 11s

Restart  Phase #:96   [orcldg] Files:1    Time: 2s

***********   Final Component scripts    ***********

Serial   Phase #:97   [orcldg] Files:1    Time: 3s

*************   Final Upgrade scripts   ************

Serial   Phase #:98   [orcldg] Files:1    Time: 274s

*******************   Migration   ******************

Serial   Phase #:99   [orcldg] Files:1    Time: 34s

***   End PDB Application Upgrade Pre-Shutdown   ***

Serial   Phase #:100  [orcldg] Files:1    Time: 2s

Serial   Phase #:101  [orcldg] Files:1    Time: 0s

Serial   Phase #:102  [orcldg] Files:1    Time: 60s

*****************   Post Upgrade   *****************

Serial   Phase #:103  [orcldg] Files:1    Time: 22s

****************   Summary report   ****************

Serial   Phase #:104  [orcldg] Files:1    Time: 3s

***   End PDB Application Upgrade Post-Shutdown   **

Serial   Phase #:105  [orcldg] Files:1    Time: 2s

Serial   Phase #:106  [orcldg] Files:1    Time: 0s

Serial   Phase #:107  [orcldg] Files:1     Time: 40s

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

Phases [0-107]         End Time:[2019_12_11 09:30:19]

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

Grand Total Time: 1814s

 LOG FILES: (/home/oracle/nxtest/catupgrd*.log)

Upgrade Summary Report Located in:

/home/oracle/nxtest/upg_summary.log

Grand Total Upgrade Time:    [0d:0h:30m:14s]

18.启动数据库

SQL> startup ORACLE instance started.

Total System Global Area 1002437904 bytes

Fixed Size                  8903952 bytes

Variable Size             276824064 bytes

Database Buffers          708837376 bytes

Redo Buffers                7872512 bytes

Database mounted.

Database opened.

19.执行升级后修复脚本

SQL> @/home/oracle/nxtest/log/postupgrade_fixups.sql

结果:

[oracle@19crac1 log]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 11 09:46:37 2019

Version 19.4.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.4.0.0.0

SQL> @/home/oracle/nxtest/log/postupgrade_fixups.sql

Session altered.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Package created.

No errors.

Package body created.

PL/SQL procedure successfully completed.

No errors.

Package created.

No errors.

Package body created.

No errors.

Executing Oracle POST-Upgrade Fixup Script

Auto-Generated by:       Oracle Preupgrade Script

                         Version: 19.0.0.0.0 Build: 1

Generated on:            2019-12-10 16:07:18

For Source Database:     ORCL

Source Database Version: 11.2.0.4.0

For Upgrade to Version:  19.0.0.0.0

Preup                             Preupgrade

Action                            Issue Is

Number  Preupgrade Check Name     Remedied    Further DBA Action

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

   19.  old_time_zones_exist      NO          Manual fixup recommended.

   20.  post_dictionary           YES         None.

   21.  post_fixed_objects        NO          Informational only.

                                              Further action is optional.

   22.  upg_by_std_upgrd          YES         None.

The fixup scripts have been run and resolved what they can. However,

there are still issues originally identified by the preupgrade that

have not been remedied and are still present in the database.

Depending on the severity of the specific issue, and the nature of

the issue itself, that could mean that your database upgrade is not

fully complete.  To resolve the outstanding issues, start by reviewing

the postupgrade_fixups.sql and searching it for the name of

the failed CHECK NAME or Preupgrade Action Number listed above.

There you will find the original corresponding diagnostic message

from the preupgrade which explains in more detail what still needs

to be done.

PL/SQL procedure successfully completed.

Session altered.

20.数据库状态查询

Col Comp_name Format a22

Col Status Format a12

Select Comp_name, status, Version

From Dba_Registry

Order by Comp_name;

set line 200

col COMP_ID format a10

col COMP_NAME format a35

select substr(comp_id,1,15) comp_id,substr(comp_name,1,30)

comp_name,substr(version,1,10) version,status

from dba_registry order by modified;

编译无效对象:

@?/rdbms/admin/utlrp.sql

注意: 之前版本的 utluNNNs.sql 在 19c 上被替换为 utlusts.sql

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

结果:

(1)注意这里的提示:大部分的组件状态都为upgrade,重新编译即可。

(2)标数据库的 time zone 文件版本比较老了,需要手动升级

21.升级time zine文件版本

echo "orcl:/u02/app/oracle/product/11.2.0/dbhome_1:N">>/etc/oratab

19c此升级脚本数据库自带

@?/rdbms/admin/utltz_upg_check.sql    ---检查当前版本

@?/rdbms/admin/utltz_upg_apply.sql    --更新应用

结果:

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

Session altered.

INFO: Starting with RDBMS DST update preparation.

INFO: NO actual RDBMS DST update will be done by this script.

INFO: If an ERROR occurs the script will EXIT sqlplus.

INFO: Doing checks for known issues ...

INFO: Database version is 19.0.0.0 .

INFO: Database RDBMS DST version is DSTv14 .

INFO: No known issues detected.

INFO: Now detecting new RDBMS DST version.

A prepare window has been successfully started.

INFO: Newest RDBMS DST version detected is DSTv32 .

INFO: Next step is checking all TSTZ data.

INFO: It might take a while before any further output is seen ...

A prepare window has been successfully ended.

INFO: A newer RDBMS DST version than the one currently used is found.

INFO: Note that NO DST update was yet done.

INFO: Now run utltz_upg_apply.sql to do the actual RDBMS DST update.

INFO: Note that the utltz_upg_apply.sql script will

INFO: restart the database 2 times WITHOUT any confirmation or prompt.

Session altered.

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

Session altered.

INFO: If an ERROR occurs, the script will EXIT SQL*Plus.

INFO: The database RDBMS DST version will be updated to DSTv32 .

WARNING: This script will restart the database 2 times

WARNING: WITHOUT asking ANY confirmation.

WARNING: Hit control-c NOW if this is not intended.

INFO: Restarting the database in UPGRADE mode to start the DST upgrade.

Database closed.

Database dismounted.

ORACLE instance shut down.

ORACLE instance started.

Total System Global Area 1002437904 bytes

Fixed Size                  8903952 bytes

Variable Size             612368384 bytes

Database Buffers          373293056 bytes

Redo Buffers                7872512 bytes

Database mounted.

Database opened.

INFO: Starting the RDBMS DST upgrade.

INFO: Upgrading all SYS owned TSTZ data.

INFO: It might take time before any further output is seen ...

An upgrade window has been successfully started.

INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.

Database closed.

Database dismounted.

ORACLE instance shut down.

ORACLE instance started.

Total System Global Area 1002437904 bytes

Fixed Size                  8903952 bytes

Variable Size             612368384 bytes

Database Buffers          373293056 bytes

Redo Buffers                7872512 bytes

Database mounted.

Database opened.

INFO: Upgrading all non-SYS TSTZ data.

INFO: It might take time before any further output is seen ...

INFO: Do NOT start any application yet that uses TSTZ data!

INFO: Next is a list of all upgraded tables:

Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"

Number of failures: 0

Table list: "APEX_190200"."WWV_FLOW_ACTIVITY_LOG1$"

Number of failures: 0

Table list: "APEX_190200"."WWV_FLOW_ACTIVITY_LOG2$"

Number of failures: 0

Table list: "APEX_190200"."WWV_FLOW_DEBUG_MESSAGES"

Number of failures: 0

Table list: "APEX_190200"."WWV_FLOW_DEBUG_MESSAGES2"

Number of failures: 0

Table list: "APEX_190200"."WWV_FLOW_FEEDBACK"

Number of failures: 0

Table list: "APEX_190200"."WWV_FLOW_FEEDBACK_FOLLOWUP"

Number of failures: 0

Table list: "APEX_190200"."WWV_FLOW_ISSUE_NOTIFICATIONS"

Number of failures: 0

Table list: "APEX_190200"."WWV_FLOW_WORKSHEET_NOTIFY"

Number of failures: 0

Table list: "APEX_190200"."WWV_QS_RANDOM_NAMES"

Number of failures: 0

Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"

Number of failures: 0

Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"

Number of failures: 0

INFO: Total failures during update of TSTZ data: 0 .

An upgrade window has been successfully ended.

INFO: Your new Server RDBMS DST version is DSTv32 .

INFO: The RDBMS DST update is successfully finished.

INFO: Make sure to exit this SQL*Plus session.

INFO: Do not use it for timezone related selects.

Session altered.

SQL> SELECT version FROM v$timezone_file;

   VERSION

----------

        32

22.编译失效对象

执行 utlrp.sql (多次) 来使它们生效,直到失效对象的个数不再改变。

@?/rdbms/admin/utlrp.sql

23.再次查询数据库状态

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

Oracle Database Release 19 Post-Upgrade Status Tool    12-11-2019 10:34:0

Database Name: ORCL

Component                               Current         Full     Elapsed Time

Name                                    Status          Version  HH:MM:SS

Oracle Server                             VALID      19.4.0.0.0  00:11:33

JServer JAVA Virtual Machine              VALID      19.4.0.0.0  00:02:42

Oracle XDK                                VALID      19.4.0.0.0  00:00:26

Oracle Database Java Packages             VALID      19.4.0.0.0  00:00:10

OLAP Analytic Workspace                   VALID      19.4.0.0.0  00:00:08

Oracle Text                               VALID      19.4.0.0.0  00:00:26

Oracle Workspace Manager                  VALID      19.4.0.0.0  00:00:45

Oracle Real Application Clusters          VALID      19.4.0.0.0  00:00:00

Oracle XML Database                       VALID      19.4.0.0.0  00:02:10

Oracle Multimedia                         VALID      19.4.0.0.0  00:00:39

Spatial                                   VALID      19.4.0.0.0  00:03:05

Oracle OLAP API                           VALID      19.4.0.0.0  00:00:08

Datapatch                                                        00:04:24

Final Actions                                                    00:05:07

Post Upgrade                                                     00:00:19

Post Compile                                                     00:00:02

Total Upgrade Time: 00:28:23

Database time zone version is 32. It meets current release needs.

务必保证各个组件状态都为VALID

24.更新oratab文件

vi /etc/oratab

orcl:/u01/app/oracle/product/19c/dbhome_1:N

25.检查失效对象

SQL> select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type order by owner,object_type;

OWNER           OBJECT_TYPE               COUNT(*)

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

APEX_190200     PACKAGE BODY                     3

EXFSYS          FUNCTION                         8

EXFSYS          PACKAGE BODY                     5

EXFSYS          PROCEDURE                        6

EXFSYS          TYPE                             1

EXFSYS          TYPE BODY                        2

26.删除闪回点

drop restore point syncdb_20191209_19c;

27.单库配置为RAC

SQL> alter system set cluster_database=true scope=spfile;

SQL> create pfile='/tmp/orcl.ora' from spfile;

echo "orcl2.instance_number=2

orcl1.instance_number=1" >>/tmp/orcl.ora

SQL> create spfile='+datadg/orcldg/spfile.ora' from pfile='/tmp/orcl.ora';

SQL> shutdown immediate

[oracle@19crac1 log]$ srvctl add database -db orcl -dbname orcl  -oraclehome /u01/app/oracle/product/19c/dbhome_1 -dbtype RAC -spfile '+datadg/orcldg/spfile.ora' -startoption open -stopoption immediate -diskgroup DATADG,ARCHDG

[oracle@19crac1 log]$ srvctl add instance -db orcl -instance orcl1 -n 19crac1

[oracle@19crac1 log]$ srvctl add instance -db orcl -instance orcl2 -n 19crac2

[oracle@19crac1 log]$ cd $ORACLE_HOME

[oracle@19crac1 dbhome_1]$ cd dbs

[oracle@19crac1 dbs]$ mv spfileorcl1.ora spfileorcl1.ora.bak

[oracle@19crac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 11 11:04:16 2019

Version 19.4.0.0.0

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

Connected to an idle instance.

SQL> create spfile='+datadg/orcldg/spfile.ora' from pfile='/tmp/orcl.ora';

File created.

SQL> startup

ORACLE instance started.

Total System Global Area 1002437904 bytes

Fixed Size                  8903952 bytes

Variable Size             612368384 bytes

Database Buffers          373293056 bytes

Redo Buffers                7872512 bytes

Database mounted.

Database opened.

修改service_name

SQL>alter system set service_name='orcl';--与源库保持一致

SQL> exit

节点二创建审计目录

[oracle@19crac2 dbs]cd /u01/app/oracle/admin/

[oracle@19crac2 dbs]mkdir -p orcldg/adump

[oracle@19crac2 dbs]SQL>startup

2个节点全部关闭数据库

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

用srvctl命令启动

[grid@19crac1 ~]$ srvctl start database -d orcl

资源状态:

[grid@19crac1 ~]$ crsctl stat res -t

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

Name           Target  State        Server                   State details       

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

Local Resources

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

ora.LISTENER.lsnr

               ONLINE  ONLINE       19crac1                  STABLE

               ONLINE  ONLINE       19crac2                  STABLE

ora.chad

               ONLINE  ONLINE       19crac1                  STABLE

               ONLINE  ONLINE       19crac2                  STABLE

ora.net1.network

               ONLINE  ONLINE       19crac1                  STABLE

               ONLINE  ONLINE       19crac2                  STABLE

ora.ons

               ONLINE  ONLINE       19crac1                  STABLE

               ONLINE  ONLINE       19crac2                  STABLE

ora.proxy_advm

               OFFLINE OFFLINE      19crac1                  STABLE

               OFFLINE OFFLINE      19crac2                  STABLE

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

Cluster Resources

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

ora.19crac1.vip

      1        ONLINE  ONLINE       19crac1                  STABLE

ora.19crac2.vip

      1        ONLINE  ONLINE       19crac2                  STABLE

ora.ARCHDG.dg(ora.asmgroup)

      1        ONLINE  ONLINE       19crac1                  STABLE

      2        ONLINE  ONLINE       19crac2                  STABLE

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

      1        ONLINE  ONLINE       19crac1                  STABLE

      2        ONLINE  ONLINE       19crac2                  STABLE

ora.DATADG.dg(ora.asmgroup)

      1        ONLINE  ONLINE       19crac1                  STABLE

      2        ONLINE  ONLINE       19crac2                  STABLE

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       19crac1                  STABLE

ora.OCRDG.dg(ora.asmgroup)

      1        ONLINE  ONLINE       19crac1                  STABLE

      2        ONLINE  ONLINE       19crac2                  STABLE

ora.asm(ora.asmgroup)

      1        ONLINE  ONLINE       19crac1                  Started,STABLE

      2        ONLINE  ONLINE       19crac2                  Started,STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

      1        ONLINE  ONLINE       19crac1                  STABLE

      2        ONLINE  ONLINE       19crac2                  STABLE

ora.cvu

      1        ONLINE  ONLINE       19crac1                  STABLE

ora.orcl.db

      1        ONLINE  ONLINE       19crac1                  Open,HOME=/u01/app/o

                                                             racle/product/19c/db

                                                             home_1,STABLE

      2        ONLINE  ONLINE       19crac2                  Open,HOME=/u01/app/o

                                                             racle/product/19c/db

                                                             home_1,STABLE

ora.qosmserver

      1        ONLINE  ONLINE       19crac1                  STABLE

ora.scan1.vip

      1        ONLINE  ONLINE       19crac1                  STABLE

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

28.调整密码文件位置

echo "orcl:/u02/app/oracle/product/11.2.0/dbhome_1:N">>/etc/oratab

[grid@19crac1 ~]$ asmcmd

ASMCMD> cd datadg

ASMCMD> pwcopy --dbuniquename orcl '/u02/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl1' '+datadg/orcldg/orapworcl'

copying /u02/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl1 -> +datadg/orcldg/orapworcl

ASMCMD-9453: failed to register password file as a CRS resource

29.手动注册crs资源(root用户)

[root@19crac1 ~]# cd /u01/app/19c/grid/bin/

[root@19crac1 bin]# ./srvctl modify database -d orcl -pwfile '+datadg/orcldg/orapworcl'

[root@19crac1 bin]# su - grid

Last login: Wed Dec 11 16:15:14 CST 2019

[grid@19crac1 ~]$ srvctl config database -d orcl

Database unique name: orcl

Database name: orcl

Oracle home: /u01/app/oracle/product/19c/dbhome_1

Oracle user: oracle

Spfile: +datadg/orcldg/spfile.ora

Password file: +datadg/orcldg/orapworcl

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: DATADG,ARCHDG

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: dba

OSOPER group: dba

Database instances: orcl1,orcl2

Configured nodes: 19crac1,19crac2

CSS critical: no

CPU count: 0

Memory target: 0

Maximum memory: 0

Default network number for database services:

Database is administrator managed

[grid@19crac1 ~]$

30.删除11204 db soft

[root@19crac1 bin]# rm -rf /u02

报错处理:https://www.cnblogs.com/djiankuo/p/6653180.html

[oracle@deep bin]$ ./dbupgrade -n 4 -l /home/oracle/nxtest

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

        LANGUAGE = (unset),

        LC_ALL = "",

        LANG = "en_US.utf-8"

    are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

Argument list for [/u01/app/oracle/product/19.3.0/db_1/rdbms/admin/catctl.pl]

For Oracle internal use only A = 0

Run in                       c = 0

Do not run in                C = 0

Input Directory              d = 0

Echo OFF                     e = 1

Simulate                     E = 0

Forced cleanup               F = 0

Log Id                       i = 0

Child Process                I = 0

Log Dir                      l = /home/oracle/nxtest

Priority List Name           L = 0

Upgrade Mode active          M = 0

SQL Process Count            n = 4

SQL PDB Process Count        N = 0

Open Mode Normal             o = 0

Start Phase                  p = 0

End Phase                    P = 0

Reverse Order                r = 0

AutoUpgrade Resume           R = 0

Script                       s = 0

Serial Run                   S = 0

RO User Tablespaces          T = 0

Display Phases               y = 0

Debug catcon.pm              z = 0

Debug catctl.pl              Z = 0

catctl.pl VERSION: [19.0.0.0.0]

           STATUS: [Production]

            BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]

相关文章:

Linux下Oracle 11g升级19c实录

1.组件信息 source /home/oracle/.bash_profile11g && sqlplus "/ as sysdba"<<EOF set line 200 col COMP_NAME for a40 select comp_name,VERSION,STATUS from dba_registry; exit; EOF COMP_NAME VERSION …...

haproxy实验-2

haproxy中的算法 静态算法&#xff1a;按照事先定义好的规则轮询公平调度&#xff0c;不关心后端服务器的当前负载、连接数和响应速度 等&#xff0c;且无法实时修改权重(只能为0和1,不支持其它值)&#xff0c;只能靠重启HAProxy生效。 static-rr&#xff1a;基于权重的轮询…...

動態PPTP代理IP是什麼?

PPTP即Point-to-Point Tunneling Protocol&#xff0c;點對點隧道協議&#xff0c;是一種常用的VPN協議&#xff0c;主要用於創建虛擬專用網路。通過將用戶的網路流量加密並通過一個中間伺服器傳輸&#xff0c;實現了對用戶IP地址的隱藏和數據的保護。而動態PPTP代理IP則是在傳…...

《全面解析 Nginx:从下载安装到高级应用与问题解决》

Nginx 一、Nginx 简介 什么是 Nginx 以及其功能 Nginx 是一款高性能的 HTTP 和反向代理的 Web 服务器&#xff0c;在处理高并发方面表现卓越&#xff0c;具备强大的能力来承受高负载&#xff0c;有相关报告指出其能够支持高达 50,000 个并发连接数。其显著特点为占用内存少、…...

python获取视频时长

今天有个需求&#xff0c;需要获取视频时长&#xff1a; 方法一&#xff1a;使用moviepy库打开视频文件并获取视频剪辑对象&#xff0c;然后通过剪辑对象获得视频时长。方法二&#xff1a;使用cv2库通过打开视频文件并获取帧率和总帧数两个属性&#xff0c;计算视频时长。 请…...

php-xlswriter实现数据导出excel单元格合并,内容从指定行开始写

最终效果图&#xff1a; 代码&#xff1a; public function export_data() {$list $this->get_list_organ();$content [];$content[] []; // 第2行不设置内容&#xff0c;设置为空foreach ($list as $key > $value) {$content[] [$value[organ_name], $value[clas…...

注意力模型QKV矩阵与位置向量计算

注意力模型QKV矩阵计算 在注意力机制中&#xff0c;Query (Q)、Key (K) 和 Value (V) 矩阵是通过对输入向量进行线性变换得到的&#xff0c;而这些矩阵的初始化与更新与神经网络的权重类似。 1. Q, K, V矩阵的初始化 线性变换&#xff1a;在注意力机制中&#xff0c;输入序列…...

glm4-9B-chat,使用提示工程激活模型最大潜力

文章目录 安全与免责申明简介GLM4-9B直接问答提示工程 激活能力 安全与免责申明 本文旨在研究大模型的安全&#xff0c;交流大模型目前安全方面的一些不足。 所有的实验与讨论的目的均是在进行科学研究的实验的需要。 简介 本文使用Ollama和LangChain&#xff0c;通过提示词…...

[Linux]在Ubuntu中如何正确安装python

一、在Ubuntu中python常见的安装方式 在Ubuntu中我们常用的python安装方式有使用包管理工具安装或者使用源码安装&#xff0c;下面我们来讲解一下这两种安装方式的优缺点。首先是使用包管理工具安装&#xff0c;我们可以直接使用“apt install python3.9”来安装一个我们想要的…...

[Vue3 + TS + Vite]文件选择器-组件

文件选择器组件代码 <script setup lang"ts"> import { ref, onMounted, defineProps, defineEmits, computed, toRaw } from vue;// 定义props interface Props {buttonTextUnactive?: string;buttonTextActive?: string;onFatherClick?: boolean; }// 定…...

Chrome书签搜索插件

效果展示 这是一个chroma插件&#xff0c;可以按住 ctrl/command B 进行搜索您的书签&#xff0c;并且点击打开您的书签。支持上下切换回车打开新页面。 扩展下载地址 bookmark-search 欢迎有任何问题给我提 issues...

MATLAB算法实战应用案例精讲-【人工智能】联邦学习(二)(附python代码实现)

目录 前言 几个高频面试题目 面向隐私保护的机器学习(PPML)和安全机器学习(Secure ML)的区别: 联邦学习、安全计算是什么关系? 联邦学习有哪些类型?如何区分横向联邦学习和纵向联邦学习? 什么是IID?什么是Non-iid? 联邦学习训练后的模型是一个公共的模型,而…...

在 C++ 中实现一个简单的图形用户界面(GUI)应用

在 C 中实现一个简单的图形用户界面&#xff08;GUI&#xff09;应用 图形用户界面&#xff08;GUI&#xff09;应用程序是现代软件开发中不可或缺的一部分。它们为用户提供了直观的交互方式&#xff0c;使得操作更加简单和高效。本文将介绍如何在 C 中实现一个简单的 GUI 应用…...

如何编写一个CMakeLists.txt文件(由简到难,较详细)

在Linux系统下&#xff0c;经常使用CMakeLists.txt文件来链接、编译C工程&#xff0c;大部分人clone的代码里都是有CMakeLists.txt文件的&#xff0c;只需要cmake .. 和make就完事了&#xff0c;但在工作中&#xff0c;你必须要有从无到有编写CMakeLists.txt文件的能力。 一、…...

数据结构----链表

一丶概念 链表又称单链表、链式存储结构&#xff0c;用于存储逻辑关系为“一对一”的数据。 和顺序表不同同&#xff0c;使用链表存储数据&#xff0c;不强制要求数据在内存中集中存储&#xff0c;各个元素可以分散存储在内存中。 二丶特点 特点&#xff1a;内存不连续…...

【Qt】内置对话框

一.Qt内置对话框 Qt 提供了多种可复⽤的对话框类型&#xff0c;即 Qt 标准对话框。Qt标准对话框全部继承于QDialog类。常⽤标准对话框如下&#xff1a; 二.内置对话框分类 1.消息对话框 QMessageBox 1.1 概念 消息对话框是应⽤程序中最常⽤的界⾯元素。消息对话框主要⽤于为…...

excel常规操作

一、去重 IF(COUNTIF($D$1:D2,D2)>1,"",C2) —— D是去重的列 二、不同列匹配 VLOOKUP(A1,E:F,2,0) vlookup(查找值, 查找区域, 返回查找区域的第几列数据, 精确查找输入参数"0"or"false" 或 模糊查找输入参数"1"or"true…...

uniapp webview子页面向父页面发送数据和触发事件,重点在第3条!!!

1、众所周知H5中iframe可以用过postmessage进行&#xff0c;从H5子页面向H5父页面进行通信。方法如下&#xff1a; // 子页面 window.parent.postMessage({ data: 你的消息 }, *);// 父页面 <iframe src"xxxxxxxxxxx"></iframe> window.addEventListene…...

【STM32实物】基于STM32+ESP32+手机APP设计的智能宠物喂食系统实物源码原理图PCB设计文档演示视频——(文末工程资料下载)

基于STM32+ESP32+手机APP设计的智能宠物喂食系统 演示视频 基于STM32+ESP32+手机APP设计的智能宠物喂食系统 摘 要 近年来,宠物在人们生活中越来越不可或缺,给人们带来的陪伴和快乐。然而,由于种种原因,主人不能时刻照顾宠物的饮食,所以宠物喂食装置变得尤为重要。传…...

EMC学习笔记5——辐射骚扰发射

辐射骚扰发射是基本的实验项目&#xff0c;目的是检验设备在工作时有没有产生意外的过强电磁辐射。 例如发电机&#xff0c;在工作时会产生意外的电磁波辐射&#xff0c;因为电子设备中隐藏了一些天线&#xff0c;这些隐藏的天线在辐射电磁波。 一、两种基本的天线结构 如前面…...

深入理解浏览器解析机制和XSS向量编码

基础部分 1.<a href"%6a%61%76%61%73%63%72%69%70%74:%61%6c%65%72%74%28%31%29">aaa</a> <a>标签可以识别&#xff0c;但是解析不了&#xff0c; 是在协议的编码顺序上&#xff0c;先认协议 URL 编码 "javascript:alert(1)" 2.<a …...

winform 大头针实现方法——把窗口钉在最上层

平时我们再使用成熟的软件的时候&#xff0c;会发现有个大头针的功能挺不错的。就是点一下大头针&#xff0c;窗口就会钉住&#xff0c;一直保持在最上面一层&#xff0c;这样可以一边设置参数&#xff0c;一边观察这个窗口里面的变化&#xff0c;比较方便。下面我就来简单实现…...

中间件|day1.Redis

Redis 定义 Redis 是一个开源&#xff08;BSD许可&#xff09;的&#xff0c;内存中的数据结构存储系统&#xff0c;它可以用作数据库、缓存和消息中间件。 它支持多种类型的数据结构&#xff0c;如 字符串&#xff08;strings&#xff09;&#xff0c; 散列&#xff08;hash…...

PMP到底有什么用?

PMP 就是项目管理证书&#xff0c;全称是项目管理专业人士资格认证&#xff0c;对于一个在项目管理岗位混迹五年的老油条来说&#xff0c;PMP 证书是敲开项目管理岗位的第一块砖&#xff0c;每年考 PMP 的人都很多&#xff0c;要是 PMP 证书没有价值&#xff0c;还会有那么多人…...

apache huidi 时间旅行Time Travel)机制

Apache Hudi(Hadoop Upserts Deletes and Incrementals)是一个数据管理框架,它帮助你高效地管理存储在分布式存储系统(如HDFS或云存储)上的大型数据集。其一个关键特性是“时间旅行”,这允许你在特定时间点查询数据的历史版本。 什么是Apache Hudi中的时间旅行? Apach…...

Python 数据可视化,怎么选出合适数据的图表

数据可视化最佳实践 1. 引言&#xff1a;为什么数据可视化最佳实践很重要 数据可视化是数据分析和决策过程中不可或缺的一部分。通过有效的可视化&#xff0c;复杂的数据可以转化为易于理解的信息&#xff0c;从而帮助观众快速做出正确的判断。然而&#xff0c;糟糕的可视化可…...

c# 元组

文章目录 元组的定义元组的使用示例使用场景创建一个列表 在 C# 中&#xff0c;元组&#xff08;Tuple&#xff09;是一种用于存储多个值的数据结构&#xff0c;它可以方便地将不同类型的多个值打包在一起。元组在 C# 7.0 及更高版本中得到了增强&#xff0c;允许更方便地创建和…...

自定义注解

目录 使用注解定义分布式锁 Aop例子 retention 表示在什么时候可以用&#xff0c;runtime表示在运行期可以用 target表示可以用在哪些上面 inherited表示可以被继承 切点和切面类 重点是 pjp.proceed(args) 这个就是执行目标方法&#xff0c;下面的这一段没啥意思 也可…...

报错:Can‘t find Python executable “python“, you can set the PYTHON env variable

将项目导入vscode,执行npm install命令后&#xff0c;报错了&#xff0c;报错的信息是node-sass安装失败&#xff0c;同时提示需要python环境的错误信息&#xff0c;这是因为安装node-sass失败了&#xff0c;而node-sass依赖于Python环境。 1.报错&#xff1a;Cant find Python…...

C++中的错误处理机制

异常的引出 如过你写过不少的程序的话&#xff0c;相信你应该遇到过一些程序所不能处理的错误而导致程序崩溃的问题吧&#xff0c;比如说&#xff1a;操作野指针&#xff0c;访问空指针&#xff0c;函数的除零错误&#xff0c;数组越界&#xff0c;在栈上开辟空间过大导致栈溢…...