upgrade_12.1_to_12.2memo - 墨天轮文档

upgrade_12.1_to_12.2memo

szrsu

1021

12页

1次

2020-04-24

5墨值下载

源端：

[oracle@teststd pdb]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 7 10:35:05 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing

options

SQL>

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 TCYMOB0 READ WRITE NO

4 MACTVDB READ WRITE NO

5 TBILLMOB READ WRITE NO

6 ACCTESTDB READ WRITE NO

7 TEST READ WRITE NO

8 ACTVDB READ WRITE NO

SQL>

[oracle@teststd pdb]$ du -sh ./*

4.9G ./acctestdb

106G ./actvdb

2.9G ./mactvdb

4.0K ./pdbseed

5.1G ./tbillmob

3.0G ./tcymob0

115G ./test

tbillmob

目标端：

[oracle@newtest ~]$ export ORACLE_SID=test12cs

[oracle@newtest ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jun 7 10:32:23 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 PDBHR2 MOUNTED

5 APPCON1 READ WRITE NO

6 PDBHR1 MOUNTED

7 F2058686279_3_1 READ ONLY NO

8 F2058686279_3_2 READ ONLY NO

10 NONCDB_NEW MOUNTED

11 TEST_PDB MOUNTED

12 PDB4 READ WRITE NO

13 TCYMOB1_NEW12C MOUNTED

12.1 升级到 12.2

目标端

tbillmob =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.127.130.58)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = tbillmob)

)

[oracle@newtest admin]$ tnsping tbillmob

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 07-JUN-2017

10:41:02

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =

10.127.130.58)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME

= tbillmob)))

OK (0 msec)

SQL> create public database link tbillmob_link connect to pdb_mgr identified by

oracle using 'tbillmob';

Database link created.

SQL> select cdb,name from v$database@tbillmob_link;

CDB NAME

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

YES TESTDB

CREATE PLUGGABLE DATABASE tbillmob FROM tbillmob@tbillmob_link

file_name_convert=('/U01/app/oracle/oradata/new12c/NEW12C/tbillmob','/U01/app/or

acle/oradata/test12cs/tbillmob') ;

SQL> CREATE PLUGGABLE DATABASE tbillmob FROM tbillmob@tbillmob_link

file_name_convert=('/U01/app/oracle/oradata/new12c/NEW12C/tbillmob','/U01/app/or

acle/oradata/test12cs/tbillmob') ;

CREATE PLUGGABLE DATABASE tbillmob FROM tbillmob@tbillmob_link

ERROR at line 1:

of 12

5墨值下载

oracle 安装部署

关注

评论