1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
| [oracle@demo admin]$ tnsping oradb
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 21-NOV-2022 00:38:20
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.129)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oradb)))
OK (0 msec)
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 BBSPROD READ WRITE NO
4 PDB1 MOUNTED
5 PDB2 MOUNTED
6 XPROD READ WRITE NO
SQL> create database link oradb_link connect to system identified by oracle using 'oradb';
Database link created.
SQL> select 1 from dual@oradb_link;
1
----------
1
SQL> select name from v$datafile@oradb_link;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/oradb/system01.dbf
/u01/app/oracle/oradata/oradb/sysaux01.dbf
/u01/app/oracle/oradata/oradb/undotbs01.dbf
/u01/app/oracle/oradata/oradb/users01.dbf
SQL> create pluggable database pdb3 from non$cdb@oradb_link file_name_convert=('/u01/app/oracle/oradata/oradb','/u01/app/oracle/oradata/PRODCDB/pdb3');
Pluggable database created.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 BBSPROD READ WRITE NO
4 PDB1 MOUNTED
5 PDB2 MOUNTED
6 XPROD READ WRITE NO
7 PDB3 MOUNTED
SQL> alter pluggable database pdb3 open;
Warning: PDB altered with errors.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 BBSPROD READ WRITE NO
4 PDB1 MOUNTED
5 PDB2 MOUNTED
6 XPROD READ WRITE NO
7 PDB3 READ WRITE YES
ๅจPDB3้ๆง่ก่ๆฌ:
[oracle@demo admin]$ tnsping pdb3
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 21-NOV-2022 01:22:24
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.130)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = pdb3)))
OK (0 msec)
[oracle@demo ~]$ cd $ORACLE_HOME/rdbms/admin
[oracle@demo admin]$ sqlplus sys@pdb3 as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 21 01:23:37 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
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> @noncdb_to_pdb.sql
|
