MỤC ĐÍCH:
Hôm nay tôi sẽ chia sẻ với anh/em cách upgrade Oracle database từ version 11g lên version 12c sử dụng RMAN
Môi trường:
CÁC BƯỚC CHÍNH:
- Oracle Database 11.2.0.3 Rman Full Backup
- Oracle Database 12c Restore
- Alter database open
- Upgrade Database
BẮT ĐẦU
- Oracle Database 11.2.0.3 Rman Full Backup
Bước 1:- Kiểm tra Database name và archive log được bật trên database 11g.
[oracle@gg-11 ~]$ export ORACLE_SID=oradbwr
[oracle@gg-11 ~]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 11.2.0.3.0 Production on Fri Aug 3 01:26:53 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name,log_mode from v$database;
NAME LOG_MODE
——— ————
DBAVIET ARCHIVELOG
Bước 2:-Kiểm tra sau khi Upgrade lên 12c
SQL> create table tab1 (name varchar(10));
Table created.
SQL> insert into tab1 values(‘BINH’);
1 row created.
SQL> commit;
Commit complete.
Bước 3:- Tạo bản backup Full database 11g dùng rman
[oracle@gg-11 ~]$ export ORACLE_SID=dbaviet [oracle@gg-11 ~]$ rman target / Recovery Manager: Release 11.2.0.3.0 - Production on Fri Aug 3 01:26:53 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: DBAVIET (DBID=1410039869) RMAN> backup database plus archivelog; Starting backup at 03-AUG-18 current log archived using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=41 device type=DISK channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=2 RECID=1 STAMP=983150751 input archived log thread=1 sequence=3 RECID=2 STAMP=983150751 input archived log thread=1 sequence=4 RECID=3 STAMP=983150755 input archived log thread=1 sequence=5 RECID=4 STAMP=983150755 input archived log thread=1 sequence=6 RECID=5 STAMP=983150756 input archived log thread=1 sequence=7 RECID=6 STAMP=983150757 input archived log thread=1 sequence=8 RECID=7 STAMP=983150758 input archived log thread=1 sequence=9 RECID=8 STAMP=983150824 channel ORA_DISK_1: starting piece 1 at 03-AUG-18 channel ORA_DISK_1: finished piece 1 at 03-AUG-18 piece handle=/u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/o1_mf_annnn_TAG20180803T012704_fp6rjjmz_.bkp tag=TAG20180803T012704 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 03-AUG-18 Starting backup at 03-AUG-18 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/app/oracle/oradata/dbaviet/system01.dbf input datafile file number=00002 name=/u01/app/oracle/oradata/dbaviet/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/dbaviet/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/dbaviet/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-AUG-18 channel ORA_DISK_1: finished piece 1 at 03-AUG-18 piece handle=/u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/o1_mf_nnndf_TAG20180803T012705_fp6rjkt8_.bkp tag=TAG20180803T012705 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45 Finished backup at 03-AUG-18 Starting backup at 03-AUG-18 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=10 RECID=9 STAMP=983150870 channel ORA_DISK_1: starting piece 1 at 03-AUG-18 channel ORA_DISK_1: finished piece 1 at 03-AUG-18 piece handle=/u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/o1_mf_annnn_TAG20180803T012751_fp6rkz5m_.bkp tag=TAG20180803T012751 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 03-AUG-18 Starting Control File and SPFILE Autobackup at 03-AUG-18 piece handle=/u01/app/oracle/fast_recovery_area/DBAVIET/autobackup/2018_08_03/o1_mf_s_983150872_fp6rl0lw_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 03-AUG-18
Bước 4:- Copy rman backup pieces từ Server 11g sang Server 12c
Datafile và archivelog [oracle@gg-11 ~]$ cd /u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/ [oracle@gg-11 2018_08_03]$ scp o1_mf_nnndf_TAG20180803T012705_fp6rjkt8_.bkp o1_mf_annnn_TAG20180803T012751_fp6rkz5m_.bkp oracle@192.168.2.157:/u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/ oracle@192.168.2.157's password: --oracle o1_mf_nnndf_TAG20180803T012705_fp6rjkt8_.bkp 100% 993MB 26.8MB/s 00:37 o1_mf_annnn_TAG20180803T012751_fp6rkz5m_.bkp 100% 3072 3.0KB/s 00:00 Controlfile autobackup location [oracle@gg-11 2018_08_03]$ cd /u01/app/oracle/fast_recovery_area/DBAVIET/autobackup/ [oracle@gg-11 autobackup]$ scp 2018_08_03/o1_mf_s_983150872_fp6rl0lw_.bkp oracle@192.168.2.157:/u01/app/oracle/fast_recovery_area/DBAVIET/autobackup/ oracle@192.168.2.157's password: o1_mf_s_983150872_fp6rl0lw_.bkp
Bước 5:- Tạo và copy pfile $ passwordfile từ source 11g tới đích 12c
[oracle@gg-11 dbs]$ scp orapwdbaviet initdbaviet.ora oracle@192.168.2.157:/u01/app/oracle/product/12.2.0/dbhome_2/dbs
oracle@192.168.2.157’s password:
orapwdbaviet 100% 1536 1.5KB/s 00:00
initdbaviet.ora 100% 1046 1.0KB/s 00:00
2.Oracle Database 12c Restore
Bước 6:-Thay đổi tham số the pfile cho database 12c
compatible=’12.2.0.1.0′
Bước 7:- Tạo thư mục cho database 12c
[oracle@gg-12 dbs]$ mkdir -p /u01/app/oracle/oradata/dbaivet/
[oracle@gg-12 ]$ mkdir -p /u01/app/oracle/admin/dbaviet/adump
Bước 8 :- Startup database 12c trên Server 12c
[oracle@gg-12 dbs]$ export ORACLE_SID=dbaviet [oracle@gg-12 dbs]$ sqlplus '/as sysdba' SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 3 02:21:04 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 931135488 bytes Fixed Size 8627296 bytes Variable Size 301992864 bytes Database Buffers 616562688 bytes Redo Buffers 3952640 bytes SQL> create spfile from pfile; File created.
Bước 9 :- Restore Control file trên Server 12c.
[oracle@gg-12 ~]$ export ORACLE_SID=dbaviet [oracle@gg-12 ~]$ rman target / Recovery Manager: Release 12.2.0.1.0 - Production on Fri Aug 3 02:26:50 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: DBAVIET (not mounted) RMAN> restore controlfile from autobackup; Starting restore at 03-AUG-18 using channel ORA_DISK_1 recovery area destination: /u01/app/oracle/fast_recovery_area database name (or database unique name) used for search: DBAVIET channel ORA_DISK_1: AUTOBACKUP /u01/app/oracle/fast_recovery_area/DBAVIET/autobackup/o1_mf_s_983150872_fp6rl0lw_.bkp found in the recovery area
AUTOBACKUP search with format "%F" not attempted because DBID was not set channel ORA_DISK_1: restoring control file from AUTOBACKUP /u01/app/oracle/fast_recovery_area/DBAVIET/autobackup/o1_mf_s_983150872_fp6rl0lw_.bkp
channel ORA_DISK_1: control file restore from AUTOBACKUP complete output file name=/u01/app/oracle/oradata/dbaviet/control01.ctl output file name=/u01/app/oracle/fast_recovery_area/dbaviet/control02.ctl
Finished restore at 03-AUG-18
Bước 10:-Mount Database
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
Bước 11:-Catalog backup 11g với controlfile
RMAN> catalog start with '/u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/'; Starting implicit crosscheck backup at 03-AUG-18 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=42 device type=DISK Crosschecked 3 objects Finished implicit crosscheck backup at 03-AUG-18 Starting implicit crosscheck copy at 03-AUG-18 using channel ORA_DISK_1 Finished implicit crosscheck copy at 03-AUG-18 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u01/app/oracle/fast_recovery_area/DBAVIET/autobackup/o1_mf_s_983150872_fp6rl0lw_.bkp
searching for all files that match the pattern /u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/
no files found to be unknown to the database
Bước 12:-Restore Database
RMAN> restore database; Starting restore at 03-AUG-18 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=8 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/dbaviet/system01.dbf channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/dbaviet/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/dbaviet/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/dbaviet/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/o1_mf_nnndf_TAG20180803T012705_fp6rjkt8_.bkp channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/o1_mf_nnndf_TAG20180803T012705_fp6rjkt8_.bkp tag=TAG20180803T012705
channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:35 Finished restore at 03-AUG-18
Step13:-Recover database upto last sequence
RMAN> run {
set until sequence = 11; ( sequence number i lấy từ DB 11g)
recover database;
}
executing command: SET until clause
Starting recover at 03-AUG-18
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=10
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/o1_mf_annnn_TAG20180803T012751_fp6rkz5m_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/DBAVIET/backupset/2018_08_03/o1_mf_annnn_TAG20180803T012751_fp6rkz5m_.bkp tag=TAG20180803T012751
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fast_recovery_area/DBAVIET/archivelog/2018_08_03/o1_mf_1_10_fp6wvskv_.arc thread=1 sequence=10
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/DBAVIET/archivelog/2018_08_03/o1_mf_1_10_fp6wvskv_.arc RECID=10 STAMP=983155281
media recovery complete, elapsed time: 00:00:00
Finished recover at 03-AUG-183.Alter database open
Bước 14:-Kết nối sqlplus và open database
[oracle@gg-12 dbs]$ export ORACLE_SID=dbaviet
[oracle@gg-12 dbs]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 3 02:44:51 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure (we can’t open in normal mode)
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: “ACDRROWTSINTCOL#”: invalid identifier
Process ID: 4004
Session ID: 1 Serial number: 22560
4.Upgrade Database
Bước 15:- Startup upgrade và run script catctl.pl.
[oracle@gg-12 dbs]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 3 03:11:46 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade ORACLE instance started. Total System Global Area 931135488 bytes Fixed Size 8627296 bytes Variable Size 301992864 bytes Database Buffers 616562688 bytes Redo Buffers 3952640 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@gg-12 dbs]$ cd $ORACLE_HOME/rdbms/admin [oracle@gg-12 admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 4 catupgrd.sql Argument list for [catctl.pl] 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 = 0 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: [12.2.0.1.0] STATUS: [production] BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125] /u01/app/oracle/product/12.2.0/dbhome_2/rdbms/admin/orahome = [/u01/app/oracle/product/12.2.0/dbhome_2] /u01/app/oracle/product/12.2.0/dbhome_2/bin/orabasehome = [/u01/app/oracle/product/12.2.0/dbhome_2] catctlGetOrabase = [/u01/app/oracle/product/12.2.0/dbhome_2] Analyzing file /u01/app/oracle/product/12.2.0/dbhome_2/rdbms/admin/catupgrd.sql Log file directory = [/tmp/cfgtoollogs/upgrade20180803031607] catcon: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20180803031607/catupgrd_catcon_4242.lst] catcon: See [/tmp/cfgtoollogs/upgrade20180803031607/catupgrd*.log] files for output generated by scripts catcon: See [/tmp/cfgtoollogs/upgrade20180803031607/catupgrd_*.lst] files for spool files, if any Number of Cpus = 1 Database Name = oradbwr DataBase Version = 11.2.0.3.0 catcon: ALL catcon-related output will be written to [/u01/app/oracle/product/12.2.0/dbhome_2/cfgtoollogs/dbaviet/upgrade20180803031609/catupgrd_catcon_4242.lst]
catcon: See [/u01/app/oracle/product/12.2.0/dbhome_2/cfgtoollogs/dbaviet/upgrade20180803031609/catupgrd*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/product/12.2.0/dbhome_2/cfgtoollogs/dbaviet/upgrade20180803031609/catupgrd_*.lst] files for spool files, if any
Log file directory = [/u01/app/oracle/product/12.2.0/dbhome_2/cfgtoollogs/dbaviet/upgrade20180803031609]
Parallel SQL Process Count = 4 Components in [dbaviet]
Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT EM JAVAVM ORDIM OWM SDO XDB XML XOQ] Not Installed [DV MGW ODM OLS RAC WK] ------------------------------------------------------ Phases [0-115] Start Time:[2018_08_03 03:16:10] ------------------------------------------------------ *********** Executing Change Scripts *********** Serial Phase #:0 [oradbwr] Files:1 Time: 128s *************** Catalog Core SQL *************** Serial Phase #:1 [dbaviet] Files:5 Time: 67s
Restart Phase #:2 [dbaviet] Files:1 Time: 0s
Serial Phase #:109 [dbaviet] Files:1 Time: 60s
Serial Phase #:110 [dbaviet] Files:1 Time: 0s
Serial Phase #:111 [dbaviet] Files:1 Time: 107s
***************** Post Upgrade ***************** Serial Phase #:112 [dbaviet] Files:1 Time: 425s
**************** Summary report **************** Serial Phase #:113 [dbaviet] Files:1 Time: 2s
Serial Phase #:114 [dbaviet] Files:1 Time: 0s
Serial Phase #:115 [dbaviet] Files:1 Time: 40s
------------------------------------------------------ Phases [0-115] End Time:[2018_08_03 05:15:24] ------------------------------------------------------ Grand Total Time: 7161s LOG FILES: (/u01/app/oracle/product/12.2.0/dbhome_2/cfgtoollogs/dbaviet/upgrade20180803031609/catupgrd*.log) Upgrade Summary Report Located in: /u01/app/oracle/product/12.2.0/dbhome_2/cfgtoollogs/dbaviet/upgrade20180803031609/upg_summary.log
Grand Total Upgrade Time: [0d:1h:30m:21s]
Bước :- Recompile lại các Invalid objects dùng utlrp.sql
SQL> @?/rdbms/admin/utlrp.sql TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UTLRP_BGN 2018-08-03 05:24:35 DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid DOC> objects in the database. Recompilation time is proportional to the DOC> number of invalid objects in the database, so this command may take DOC> a long time to execute on a database with a large number of invalid DOC> objects. DOC> DOC> Use the following queries to track recompilation progress: DOC> DOC> 1. Query returning the number of invalid objects remaining. This DOC> number should decrease with time. DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6); DOC> DOC> 2. Query returning the number of objects compiled so far. This number DOC> should increase with time. DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED; DOC> DOC> This script automatically chooses serial or parallel recompilation DOC> based on the number of CPUs available (parameter cpu_count) multiplied DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu). DOC> On RAC, this number is added across all RAC nodes. DOC> DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel DOC> recompilation. Jobs are created without instance affinity so that they DOC> can migrate across RAC nodes. Use the following queries to verify DOC> whether UTL_RECOMP jobs are being created and run correctly: DOC> DOC> 1. Query showing jobs created by UTL_RECOMP DOC> SELECT job_name FROM dba_scheduler_jobs DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%'; DOC> DOC> 2. Query showing UTL_RECOMP jobs that are running DOC> SELECT job_name FROM dba_scheduler_running_jobs DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%'; DOC># PL/SQL procedure successfully completed. TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UTLRP_END 2018-08-03 05:33:52 DOC> The following query reports the number of invalid objects. DOC> DOC> If the number is higher than expected, please examine the error DOC> messages reported with each object (using SHOW ERRORS) to see if they DOC> point to system misconfiguration or resource constraints that must be DOC> fixed before attempting to recompile these objects. DOC># OBJECTS WITH ERRORS ------------------- 0 DOC> The following query reports the number of exceptions caught during DOC> recompilation. If this number is non-zero, please query the error DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors DOC> are due to misconfiguration or resource constraints that must be DOC> fixed before objects can compile successfully. DOC> Note: Typical compilation errors (due to coding errors) are not DOC> logged into this table: they go into DBA_ERRORS instead. DOC># ERRORS DURING RECOMPILATION --------------------------- 0 Function created. PL/SQL procedure successfully completed. Function dropped. ...Starting validation 05:34:07 ...Database user "SYS", database schema "APEX_050000", user# "121" 05:34:07 ...grant execute on "SYS"."DBMS_CRYPTO_INTERNAL" to APEX_050000 05:34:10 ...272 packages ...265 package bodies ...465 tables ...8 functions ...16 procedures ...4 sequences ...497 triggers ...1582 indexes ...255 views ...0 libraries ...14 types ...5 type bodies ...0 operators ...0 index types ...Begin key object existence check 05:34:17 ...Completed key object existence check 05:34:17 ...Setting DBMS Registry 05:34:17 ...Setting DBMS Registry Complete 05:34:17 ...Exiting validate 05:34:17 PL/SQL procedure successfully completed
Bước :-Check trạng thái database
SQL> select comp_name,version from dba_registry where status = 'VALID'; COMP_NAME VERSION ---------------- ------------------------------ Oracle Database Catalog Views 12.2.0.1.0 Oracle Database Packages and Types 12.2.0.1.0 JServer JAVA Virtual Machine 12.2.0.1.0 Oracle XDK 12.2.0.1.0 Oracle Database Java Packages 12.2.0.1.0 OLAP Analytic Workspace 12.2.0.1.0 Oracle Workspace Manager 12.2.0.1.0 Oracle Text 12.2.0.1.0 Oracle XML Database 12.2.0.1.0 Oracle Multimedia 12.2.0.1.0 Spatial 12.2.0.1.0 Oracle OLAP API 12.2.0.1.0 Oracle Application Express 5.0.4.00.12 13 rows selected.
Bạn đã thành công lên DB 12.2.0.1 bằng RMAN Backup Full.
Chúc bạn thành công.
* KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE trực tiếp từ tôi giúp bạn bước đầu trở thành những chuyên gia DBA, đủ kinh nghiệm đi thi chứng chỉ OA/OCP, đặc biệt là rất nhiều kinh nghiệm, bí kíp thực chiến trên các hệ thống Core tại VN chỉ sau 1 khoá học.
* CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
* Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile: 0902912888
⚡️ Skype: tranbinh48ca
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: http://bit.ly/ytb_binhoraclemaster
👨 Tiktok: https://www.tiktok.com/@binhoraclemaster?lang=vi
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhoracle
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội
=============================
học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,khóa học pl/sql, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle weblogic, middleware, hoc solaris, hoc linux, hoc aix, unix, oracle oca, oracle ocp, oracle ocm
