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:
Change password User ASMSNMP:
Gỡ bỏ Oracle Enterprise Manager Database Control:
Cài đặt Oracle Enterprise Manager Database Control:












LOGIN:

SHOW TABLESPACES:

SHOW DATAFILES:

DATABASE USAGE STATISTICS:


CLUSTER: CLTR001

CLUSTER DATABASE:SVUIT

EMCTL:
Install and Deinstall DBconsole
Liêt kê tất cả Oracle Database Users:
Mã:
[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]
Mã:
[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:
Mã:
[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:
Mã:
[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]
Sửa lần cuối:
Bài viết liên quan
Bài viết mới