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

[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]

[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]

[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]