Triển khai Oracle Real Application Clusters (RAC) - Part 5

thanhdc · Aug 15, 2015

Triển khai cài đặt Oracle Real Application Clusters (RAC) - Part 5

Install and Deinstall DBconsole

Liêt kê tất cả Oracle Database Users:

Code:

[TABLE]
[TR]
[TD]SQL> [B]show user[/B]

USER is "[B]SYS[/B]"

SQL> [B]select * from all_users;[/B]

USERNAME                          USER_ID CREATED
------------------------------ ---------- ---------
BI                                     89 13-AUG-15
PM                                     88 13-AUG-15
SH                                     87 13-AUG-15
IX                                     86 13-AUG-15
OE                                     85 13-AUG-15
[B]HR                                     [/B]84 13-AUG-15
SCOTT                                  83 03-NOV-11
OWBSYS                                 78 03-NOV-11
APEX_030200                            77 03-NOV-11
APEX_PUBLIC_USER                       75 03-NOV-11
FLOWS_FILES                            74 03-NOV-11
SPATIAL_CSW_ADMIN_USR                  69 03-NOV-11
SPATIAL_WFS_ADMIN_USR                  66 03-NOV-11
MDDATA                                 64 03-NOV-11
OWBSYS_AUDIT                           82 03-NOV-11
OLAPSYS                                60 03-NOV-11
MDSYS                                  57 03-NOV-11
SI_INFORMTN_SCHEMA                     56 03-NOV-11
ORDPLUGINS                             55 03-NOV-11
ORDDATA                                54 03-NOV-11
ORDSYS                                 53 03-NOV-11
ANONYMOUS                              46 03-NOV-11
XDB                                    45 03-NOV-11
CTXSYS                                 43 03-NOV-11
EXFSYS                                 42 03-NOV-11
XS$NULL                        2147483638 03-NOV-11
WMSYS                                  32 03-NOV-11
APPQOSSYS                              31 03-NOV-11
DBSNMP                                 30 03-NOV-11
ORACLE_OCM                             21 03-NOV-11
DIP                                    14 03-NOV-11
OUTLN                                   9 03-NOV-11
SYSTEM                                  5 03-NOV-11
[B]SYS                                     [/B]0 03-NOV-11

34 rows selected.
[/TD]
[/TR]
[/TABLE]

Change password User ASMSNMP:

Code:

[TABLE]
[TR]
[TD][COLOR=#000000][FONT=Calibri]C:\Users\Administrator>[B]set ORACLE_HOME=C:\app\11.2.0\grid[/B][/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]C:\Users\Administrator>[B]set ORACLE_SID=+ASM1[/B][/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]C:\Users\Administrator>[B]sqlplus / as sysasm[/B][/FONT][/COLOR][INDENT][I][COLOR=#000000][FONT=Calibri]SQL*Plus: Release 11.2.0.3.0 Production on Fri Aug 14 12:22:37 2015[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Copyright (c) 1982, 2011, Oracle.  All rights reserved.[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Connected to:[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production[/FONT][/COLOR]
[/I][COLOR=#000000][FONT=Calibri][I]With the Real Application Clusters and Automatic Storage Management option[/I]s[/FONT][/COLOR]
[/INDENT]
 [COLOR=#000000][FONT=Calibri]SQL>[B] Alter user asmsnmp identified by new_password;[/B][/FONT][/COLOR][INDENT][I][COLOR=#ff0000][FONT=Calibri]User altered.[/FONT][/COLOR][/I]
[/INDENT]
[/TD]
[/TR]
[/TABLE]

Gỡ bỏ Oracle Enterprise Manager Database Control:

Code:

 [TABLE]
[TR]
[TD][COLOR=#000000][FONT=Times New Roman]C:\Users\Administrator>[/FONT][/COLOR][B][COLOR=#000000][FONT=Times New Roman]emca -deconfig dbcontrol db -repos drop -cluster[/FONT][/COLOR][/B][INDENT]
[I][COLOR=#000000][FONT=Times New Roman]STARTED EMCA at Aug 14, 2015 11:37:30 AM[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]EM Configuration Assistant, Version 11.2.0.3.0 Production[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Copyright (c) 2003, 2011, Oracle.  All rights reserved.[/FONT][/COLOR]

[COLOR=#000000][FONT=Times New Roman]Enter the following information:[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Database unique name: [/FONT][/COLOR][B][COLOR=#000000][FONT=Times New Roman]svuit[/FONT][/COLOR][/B]
[COLOR=#000000][FONT=Times New Roman]Service name: [/FONT][/COLOR][B][COLOR=#000000][FONT=Times New Roman]svuit[/FONT][/COLOR][/B]
[COLOR=#000000][FONT=Times New Roman]Listener ORACLE_HOME [ C:\app\11.2.0\grid ]: [/FONT][/COLOR][B][COLOR=#000000][FONT=Times New Roman]C:\app\Administrator\product\11.2.0\dbhome_1[/FONT][/COLOR][/B]
[COLOR=#000000][FONT=Times New Roman]Password for SYS user[B]:*****[/B][/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Password for SYSMAN user[B]:*****[/B][/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Password for SYSMAN user: [B]*****[/B][/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]----------------------------------------------------------------------[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]WARNING : While repository is dropped the database will be put in quiesce mode.[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]----------------------------------------------------------------------[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Do you wish to continue? [yes(Y)/no(N)]: [/FONT][/COLOR][B][COLOR=#000000][FONT=Times New Roman]Y[/FONT][/COLOR][/B]
[COLOR=#000000][FONT=Times New Roman]Aug 14, 2015 11:38:53 AM oracle.sysman.emcp.EMConfig perform[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]INFO: This operation is being logged at C:\app\Administrator\cfgtoollogs\emca\svuit\emca_2015_08_14_11_37_29.log.[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Aug 14, 2015 11:38:59 AM oracle.sysman.emcp.util.DBControlUtil stopOMS[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]INFO: Stopping Database Control (this may take a while) ...[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Aug 14, 2015 11:39:35 AM oracle.sysman.emcp.EMReposConfig invoke[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]INFO: Dropping the EM repository (this may take a while) ...[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Aug 14, 2015 11:46:14 AM oracle.sysman.emcp.EMReposConfig invoke[/FONT][/COLOR]

[COLOR=#000000][FONT=Times New Roman]INFO: Repository successfully dropped[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]Enterprise Manager configuration completed successfully[/FONT][/COLOR]
[COLOR=#000000][FONT=Times New Roman]FINISHED[/FONT][/COLOR][COLOR=#000000][FONT=Times New Roman] EMCA at Aug 14, 2015 11:46:26 AM[/FONT][/COLOR][/I]
[/INDENT]
[/TD]
[/TR]
[TR]
[TD][COLOR=#000000][FONT=Times New Roman]ref: [URL="http://www.oracle-wiki.net/premium:startdocshowtoinstalldeinstalldbconsole"]How to Install and Deinstall DBconsole - Oracle Database[/URL][/FONT][/COLOR][/TD]
[/TR]
[/TABLE]

Cài đặt Oracle Enterprise Manager Database Control:

LOGIN:

SHOW TABLESPACES:

SHOW DATAFILES:

DATABASE USAGE STATISTICS:

CLUSTER: CLTR001

CLUSTER DATABASE:SVUIT

EMCTL:

Code:

[COLOR=#000000][FONT=Calibri]
[/FONT][/COLOR][TABLE]
[TR]
[TD][COLOR=#000000][FONT=Calibri]C:\Users\Administrator>[/FONT][/COLOR][B][COLOR=#000000][FONT=Calibri]set ORACLE_UNQNAME=svuit[/FONT][/COLOR][/B]

[COLOR=#000000][FONT=Calibri]C:\Users\Administrator>[/FONT][/COLOR][B][COLOR=#000000][FONT=Calibri]emctl status dbconsole[/FONT][/COLOR][/B]
[INDENT] [I][COLOR=#000000][FONT=Calibri]Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]https://srv001:1158/em/console/aboutApplication[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Oracle Enterprise Manager 11g is running.[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]------------------------------------------------------------------[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Logs are generated in directory C:\app\Administrator\product\11.2.0\dbhome_1/srv001_svuit/sysman/log[/FONT][/COLOR][/I]
[/INDENT]
 

 [COLOR=#000000][FONT=Calibri]C:\Users\Administrator>[/FONT][/COLOR][B][COLOR=#000000][FONT=Calibri]emctl status agent[/FONT][/COLOR][/B][INDENT][I][COLOR=#000000][FONT=Calibri]Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]---------------------------------------------------------------[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Agent Version     : 10.2.0.4.4[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]OMS Version       : 10.2.0.4.4[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Protocol Version  : 10.2.0.4.4[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Agent Home        : C:\app\Administrator\product\11.2.0\dbhome_1\srv001_svuit[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Agent binaries    : C:\app\Administrator\product\11.2.0\dbhome_1[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Agent Process ID  : 2024[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Agent URL         : https://srv001:3938/emd/main[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Repository URL    : https://srv001:1158/em/upload/[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Started at        : 2015-08-14 09:35:45[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Started by user   : SYSTEM[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Last Reload       : 2015-08-14 10:05:23[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Last successful upload                       : 2015-08-14 10:16:12[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Total Megabytes of XML files uploaded so far :    15.23[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Number of XML files pending upload           :        0[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Size of XML files pending upload(MB)         :     0.00[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Available disk space on upload filesystem    :    86.90%[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Data channel upload directory                : C:/app/Administrator/product/11.2.0/dbhome_1/srv001_s[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]vuit/sysman/recv[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Last successful heartbeat to OMS             : 2015-08-14 10:15:29[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]---------------------------------------------------------------[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]Agent is Running and Ready[/FONT][/COLOR][/I]
[/INDENT]
[/TD]
[/TR]
[TR]
[TD][COLOR=#000000][FONT=Calibri]ref: http://www.akadia.com/services/ora_dbconsole.html[/FONT][/COLOR][/TD]
[/TR]
[/TABLE]

ktc2608 · Sep 7, 2015

Cho mình hỏi tí.
Câu 1: Làm sao add thêm 1 note vào RAC bạn?
Câu 2: Nếu mô hình mình là stand alone, mình muốn chuyển qua RAC, thì làm thế nào để migrate data mà không bị downtime hoặc thời gian downtime ít nhất. Tổng dung lương khoảng 1TB đi.

Search

Search

Triển khai Oracle Real Application Clusters (RAC) - Part 5

thanhdc

Junior – IT Sơ cấp

ktc2608

Internship/Fresher

Similar Threads