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

thanhdc

Junior – IT Sơ cấp
Aug 10, 2014
124
3
18
Triển khai cài đặt Oracle Real Application Clusters (RAC) - Part 4

Oracle Enterprise Manager Database Control:

Login:



Cluster Database: svuit


Cluster Database:svuit > Tablespaces

Cluster Database: svuit > Tablespace > View Tablespace: EXAMPLE

ASM Instances:

Automatic Storage Management: +ASM_srv001:

Database Instance: svuit_svuit1

Automatic Storage Management: +ASM_srv002

Database Instance: svuit_svuit2

Cluster Database: svuit

Cluster: cltr001 > Home

Cluster: cltr001 > Targets

Host: srv001 > Home

Host: srv001 > Targets

Host: srv002 > Home

Host: srv002 > Target


Automatic Storage Management Login:

Automatic Storage Management: +ASM1_srv001

Disk Group: ASMGRP001

Disk Group: ASMGRP001 > Files


Oracle SQL Developer:

Kết nối với user SYS


Kết nối với user HR:


Thực thi lệnh SQL:


ASMCMD:

Code:
[TABLE]
[TR]
[TD]C:\Users\Administrator>[B]set ORACLE_HOME=C:\app\11.2.0\grid[/B]
C:\Users\Administrator>[B]set ORACLE_SID=+ASM1[/B]

C:\Users\Administrator>[B]asmcmd[/B]
Connected to an idle instance.
[COLOR=#ff0000]ASMCMD>[/COLOR]
ASMCMD> help

            asmcmd [-V] [-v <errors|warnings|normal|info|debug>] [--privilege <sysasm|sysdba>] [-p]
[command]
asmcmd_no_conn_str

        Starts asmcmd or executes the command

        asmcmd [-V] [-v <errors|warnings|normal|info|debug>] [--privilege <sysasm|sysdba>] [-p] [com
mand]

        The environment variables ORACLE_HOME and ORACLE_SID determine the
        instance to which the program connects, and ASMCMD establishes a
        bequeath connection to it, in the same manner as a SQLPLUS / AS
        SYSASM.  The user must be a member of the OSASM group.

        Specifying the -V option prints the asmcmd version number and
        exits immediately.

        Specifying the -v option prints extra information that can help
        advanced users diagnose problems.

        Specify the --privilege option to choose the type of connection. There are
        only two possibilities: connecting as SYSASM or as SYSDBA.
        The default value if this option is unspecified is SYSASM.

        Specifying the -p option allows the current directory to be displayed
        in the command prompt, like so:

        ASMCMD [+DATA/ORCL/CONTROLFILE] >

        [command] specifies one of the following commands, along with its
        parameters.

        Type "help [command]" to get help on a specific ASMCMD command.';

        commands:
        --------

        md_backup, md_restore

        lsattr, setattr

        cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
        mkdir, pwd, rm, rmalias

        chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
        offline, online, rebal, remap, umount

        dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
        spmove, spset, startup

        chtmpl, lstmpl, mktmpl, rmtmpl

        chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
        mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr

        volcreate, voldelete, voldisable, volenable, volinfo
        volresize, volset, volstat
[/TD]
[/TR]
[TR]
[TD]ASMCMD> [B]ls[/B]
[I]ASMGRP001/[/I]
[/TD]
[/TR]
[TR]
[TD]ASMCMD>[B] ls +ASMGRP001/SVUIT/DATAFILE/[/B]
[I]EXAMPLE.264.887664961
SYSAUX.257.887664829
SYSTEM.256.887664829
UNDOTBS1.258.887664831
UNDOTBS2.265.887665135
USERS.259.887664831[/I]
[/TD]
[/TR]
[TR]
[TD]ASMCMD> [B]ls +ASMGRP001/CLTR00[/B]1
[I]ASMPARAMETERFILE/
OCRFILE/[/I]
[/TD]
[/TR]
[/TABLE]

ASM With SQLPlus
Code:
[TABLE]
[TR]
[TD]C:\Users\Administrator>[B]set ORACLE_HOME=C:\app\11.2.0\grid[/B]
C:\Users\Administrator>[B]set ORACLE_SID=+ASM1[/B]

C:\Users\Administrator>[B]sqlplus / as sysasm[/B]

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 13 23:44:35 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>
[/TD]
[/TR]
[TR]
[TD]SQL> [B]select * from v$instance;[/B]

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
              1 +asm1
SRV001
11.2.0.3.0        13-AUG-15 STARTED      YES          0 STOPPED
ALLOWED    NO  ACTIVE            UNKNOWN            NORMAL    NO
[/TD]
[/TR]
[TR]
[TD]https://oracle-base.com/articles/11g/asm-enhancements-11gr1
http://blog.whitehorses.nl/2010/02/16/three-ways-to-startup-an-asm-instance-on-a-server/[/TD]
[/TR]
[/TABLE]

SRVCTL:
Code:
[TABLE]
[TR]
[TD]C:\Users\Administrator>[B]srvctl config asm[/B]
ASM home: C:\app\11.2.0\grid
ASM listener: LISTENER
[/TD]
[/TR]
[TR]
[TD]C:\Users\Administrator>[B]srvctl config listener[/B]
Name: LISTENER
Network: 1, Owner: nt authority\system
Home: <CRS home>
End points: TCP:1521
[/TD]
[/TR]
[TR]
[TD]C:\Users\Administrator>[B]srvctl config database -d SVUIT[/B]
Database unique name: svuit
Database name: svuit
Oracle home: C:\app\Administrator\product\11.2.0\dbhome_1
Oracle user: nt authority\system
Spfile: +ASMGRP001/svuit/spfilesvuit.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: svuit
Database instances: svuit1,svuit2
Disk Groups: ASMGRP001
Mount point paths:
Services:
Type: RAC
Database is administrator managed
[/TD]
[/TR]
[TR]
[TD]C:\Users\Administrator>[B]crsctl check has[/B]
CRS-4638: Oracle High Availability Services is online
[/TD]
[/TR]
[TR]
[TD]https://mehmeteser.wordpress.com/2013/02/21/rename-host-has/[/TD]
[/TR]
[/TABLE]
 
Last edited:

About us

  • Securityzone.vn là một trang web chuyên về an ninh mạng và công nghệ thông tin. Trang web này cung cấp các bài viết, tin tức, video, diễn đàn và các dịch vụ liên quan đến lĩnh vực này. Securityzone.vn là một trong những cộng đồng IT lớn và uy tín tại Việt Nam, thu hút nhiều người quan tâm và tham gia. Securityzone.vn cũng là nơi để các chuyên gia, nhà nghiên cứu, sinh viên và người yêu thích an ninh mạng có thể trao đổi, học hỏi và chia sẻ kiến thức, kinh nghiệm và giải pháp về các vấn đề bảo mật trong thời đại số.

Quick Navigation

User Menu