大家好，以下是我的oracle系列培训课程的第八讲观看地址，本讲主要介绍如何实现跨平台迁移数据库！
主要涉及内容有：
1：介绍和演示如何将windows操作系统上的数据库迁移至linux服务器上，并将数据文件存储由原来的NTFS文件系统转成存储在ASM磁盘组上
2：介绍迁移完成后的系列收尾工作！
大家在观看过程中有任何疑问或者建议，都可以在本文的评论区留言！
视频地址：http://edu.51cto.com/lession/id-11376.html 相互学习，共同进步！
附上dbconsole重建过程：
|
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
|
[oracle@vm1 bak]$ emca -deconfig dbcontrol db -repos drop -silent -PORT
1521
-SID win2 -SYS_PWD
123456
-DBSNMP_PWD
123456
-SYSMAN_PWD
123456
[oracle@vm1 bak]$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Aug
14
,
2013
10
:
26
:
07
PM
EM Configuration Assistant, Version
11.2
.
0.3
.
0
Production
Copyright (c)
2003
,
2011
, Oracle. All rights reserved.
Enter the following information:
Database SID: win2
Listener port number:
1521
Listener ORACLE_HOME [ /u01/app/
11.2
.
0
/grid ]: /u01/app/oracle/product/
11.2
.
0
/db_1
Password
for
SYS user:
Password
for
DBSNMP user:
Password
for
SYSMAN user:
Email address
for
notifications (optional):
Outgoing Mail (SMTP) server
for
notifications (optional):
ASM ORACLE_HOME [ /u01/app/
11.2
.
0
/grid ]: /u01/app/
11.2
.
0
/grid
ASM SID [ +ASM ]:
ASM port [
1521
]:
ASM username [ ASMSNMP ]:
ASM user password:
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/
11.2
.
0
/db_1
Local hostname ................ vm1
Listener ORACLE_HOME ................ /u01/app/oracle/product/
11.2
.
0
/db_1
Listener port number ................
1521
Database SID ................ win2
Email address
for
notifications ...............
Outgoing Mail (SMTP) server
for
notifications ...............
ASM ORACLE_HOME ................ /u01/app/
11.2
.
0
/grid
ASM SID ................ +ASM
ASM port ................
1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP
-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository
is
dropped the database will be put
in
quiesce mode.
----------------------------------------------------------------------
Do you wish to
continue
? [yes(Y)/no(N)]: y
Aug
14
,
2013
10
:
27
:
30
PM oracle.sysman.emcp.EMConfig perform
INFO: This operation
is
being logged at /u01/app/oracle/cfgtoollogs/emca/win2/emca_2013_08_14_22_26_07.log.
Aug
14
,
2013
10
:
27
:
31
PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (
this
may take a
while
) ...
Aug
14
,
2013
10
:
27
:
32
PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug
14
,
2013
10
:
27
:
32
PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (
this
may take a
while
) ...
Aug
14
,
2013
10
:
41
:
03
PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug
14
,
2013
10
:
41
:
24
PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (
this
may take a
while
) ...
Aug
14
,
2013
10
:
42
:
22
PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug
14
,
2013
10
:
42
:
23
PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener
for
vm1
Aug
14
,
2013
10
:
42
:
24
PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (
this
may take a
while
) ...
Aug
14
,
2013
10
:
42
:
31
PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug
14
,
2013
10
:
42
:
31
PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (
this
may take a
while
) ...
Aug
14
,
2013
10
:
43
:
50
PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug
14
,
2013
10
:
43
:
50
PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL
is
https:
//vm1:5500/em <<<<<<<<<<<
Aug
14
,
2013
10
:
43
:
52
PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************
Management Repository has been placed
in
secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed
in
the file: /u01/app/oracle/product/
11.2
.
0
/db_1/vm1_win2/sysman/config/emkey.ora. Ensure
this
file
is
backed up
as
the encrypted data will become unusable
if
this
file
is
lost.
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug
14
,
2013
10
:
43
:
52
PM
[oracle@vm1 bak]$ emctl status dbconsole
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LANG =
"en_us.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale (
"C"
).
Oracle Enterprise Manager 11g Database Control Release
11.2
.
0.3
.
0
Copyright (c)
1996
,
2011
Oracle Corporation. All rights reserved.
https:
//vm1:5500/em/console/aboutApplication
Oracle Enterprise Manager 11g
is
running.
------------------------------------------------------------------
Logs are generated
in
directory /u01/app/oracle/product/
11.2
.
0
/db_1/vm1_win2/sysman/log
|
附件：http://down.51cto.com/data/2363341
本文转自斩月博客51CTO博客，原文链接http://blog.51cto.com/ylw6006/1274409如需转载请自行联系原作者
ylw6006
