据了解,SiteGroups将获取当前网站集中的所有组.但是Groups和AssociatedGroups之间有什么区别？ MSDN定义说,Groups将获得该网站的所有“跨站点”(！)组. AssociatedGroups从这个名字很容易理解.

那么群组返回什么？有人可以用一个例子来解释我吗？

AssociatedGroups返回“人员和组”页面左侧菜单中可见的所有组.这些组可能无法访问当前站点(如果安全设置不会从父站点继承).在这种情况下,其中一些将不会列在“组”属性中.

要查看差异,请在子网站中创建新组,而不给出任何权限.该组将在“关联组”和“左”菜单中可见,但不会列在“组”或“站点权限”页面中.

问题：

I am new to ASM and I am trying to move my non-ASM database to an ASM database.

Here is the situation :

- 1 ASM database version 12.1.0.2.0

- 1 non-ASM database version 11.2.0.1.0

- ASM database is up and running and the diskgroup is mounted

- non-ASM database is also up and running

- Cluster Synchronization Services seems ok,I issued the following command :

$ crsctl check css

$ CRS-4529: Cluster Synchronization Services is online

So far,to move my database to an ASM-database I performed the following steps :

1. Changed the location of my non-ASM control_file parameter to my created ASM disks

sql> alter system set control_files=‘+DGROUP1‘ scope=spfile;

2. Set the parameter DB_CREATE_FILE_DEST to my ASM disk

sql> alter system set db_create_file_dest=‘+DGROUP1‘ scope=spfile;

3. Shutdown and startup nomount my non-ASM database

sql> shutdown immediate

sql> startup nomount

4. Restored control file from the existing one

rman target /

restore controlfile from ‘/oracle/dbfile/ORCL/ORCL/control01.ctl‘;

This is where I am stuck as I have the following error :

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 11/21/2016 16:02:52

ORA-19504: Failed to create file "+DGROUP1"

ORA-17502: ksfdcre:4 Failed to create file +DGROUP1

ORA-15001: diskgroup "DGROUP1" does not exist or is not mounted

ORA-15055: unable to connect to ASM instance

ORA-12547: TNS:lost contact

ORA-19600: input file is control file  (/oracle/dbfile/ORCL/ORCL/control01.ctl)

ORA-19601: output file is control file  (+DGROUP1)

Does anyone as an idea on how to fix this issue ?

Thanks very much,

 =========================================================================================================

答案：

:

Yep,where is the error:

TNS-00517: Lost contact

    nt secondary err code: 32

    nt OS err code: 0

ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/grid/app/oracle/product/11.2.0/grid2/bin/oracle)(ARGV0=oracle+ASM_asmb_orcl)(ENVS=‘ORACLE_HOME=/grid/app/oracle/product/11.2.0/grid2,ORACLE_SID=+ASM‘)(ARGS=‘(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))‘))(enable=setuser))

The error has to do with permissions in your directory. Follow the steps in this article to fix the issue.

https://daviewning.wordpress.com/2015/04/10/ora-15055-unable-to-connect-to-asm-instance-and-ora-12547-tnslost-contact/

You have to change the permission on

$GRID_HOME/bin/

chmod 6751 oracle

And $ORACLE_HOME/bin/

chmod 6751 oracle

Then try again.

======================================================================================================

问题举例二（转载飞总）参考：

rac和dg的目录不一样，都采用asm管理磁盘

控制文件备份/home/oracle/rman/control2ipl7sft_82_1 文件存在

[[email protected] ~]# su - oracle
[[email protected] ~]$ rman target sys/[email protected] auxiliary /
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 16 21:44:14 2014
copyright (c) 1982,2011,Oracle and/or its affiliates.  All rights reserved.
connected to target database: GNNT (DBID=1162592830)
connected to auxiliary database: GNNT (not mounted)
RMAN> duplicate target database for standby;
Starting Duplicate Db at 16-OCT-14
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_disK_1
channel ORA_AUX_disK_1: SID=760 device type=disK
contents of Memory Script:
{
   restore clone standby controlfile;
}
executing Memory Script
Starting restore at 16-OCT-14
using channel ORA_AUX_disK_1
channel ORA_AUX_disK_1: starting datafile backup set restore
channel ORA_AUX_disK_1: restoring control file
channel ORA_AUX_disK_1: reading from backup piece /home/oracle/rman/control2ipl7sft_82_1
channel ORA_AUX_disK_1: ORA-19870: error while restoring backup piece /home/oracle/rman/control2ipl7sft_82_1
ORA-19504: Failed to create file "+DATADG01/dg01/controlfile/control01.ctl"
ORA-17502: ksfdcre:3 Failed to create file +DATADG01/dg01/controlfile/control01.ctl
ORA-15001: diskgroup "DATADG01" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete

[[email protected] ~]$ asmcmd ls -l
State    Type    Rebal  Name
MOUNTED  norMAL  N      DATADG01/
MOUNTED  norMAL  N      FRADG01/
[[email protected] ~]$ id
uid=1100(grid) gid=1000(oinstall) 组=1000(oinstall),1020(asmadmin),1021(asmdba),1022(asmoper),1300(dba)
[[email protected] ~]# su - oracle
[[email protected] ~]$ sqlplus / as sysdba

sql*Plus: Release 11.2.0.4.0 Production on Thu Oct 16 22:37:04 2014

copyright (c) 1982,2013,Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning,Automatic Storage Management,Data Mining
and Real Application Testing options

sql>  select name,type,state,total_mb,free_mb from v$asm_diskgroup;

NAME                           TYPE   STATE         TOTAL_MB    FREE_MB
------------------------------ ------ ----------- ---------- ----------
DATADG01                       norMAL MOUNTED          40960      40840
FRADG01                        norMAL MOUNTED          40960      40854
[[email protected] ~]$ id
uid=1101(oracle) gid=1000(oinstall) 组=1000(oinstall),1300(dba),1301(oper)
[[email protected] rman]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 16 23:26:13 2014

copyright (c) 1982,Oracle and/or its affiliates.  All rights reserved.

connected to target database: GNNT (not mounted)

RMAN> restore controlfile from ‘/home/oracle/rman/control2ipl7sft_82_1‘;                      

Starting restore at 16-OCT-14
using target database control file instead of recovery catalog
allocated channel: ORA_disK_1
channel ORA_disK_1: SID=1893 device type=disK

channel ORA_disK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/16/2014 23:26:35
ORA-19870: error while restoring backup piece /home/oracle/rman/control2ipl7sft_82_1
ORA-19504: Failed to create file "+DATADG01/dg01/controlfile/control01.ctl"
ORA-17502: ksfdcre:3 Failed to create file +DATADG01/dg01/controlfile/control01.ctl
ORA-15001: diskgroup "DATADG01" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplet

ASMCMD> ls
ONLINELOG/
controlfile/
datafile/
tempfile/
ASMCMD> pwd
+DATADG01/dg01
ASMCMD> exit

[[email protected] ~]$ ls -l /dev/asm*
brw-rw---- 1 grid asmadmin 8,16 10月 16 23:30 /dev/asmdata01
brw-rw---- 1 grid asmadmin 8,32 10月 16 23:30 /dev/asmdata02
brw-rw---- 1 grid asmadmin 8,48 10月 16 23:30 /dev/asmfra01
brw-rw---- 1 grid asmadmin 8,64 10月 16 23:30 /dev/asmfra02
[[email protected] ~]$ 

通过udev 设置：

KERNEL=="sd*",BUS=="scsi",PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent",RESULT=="36000c29196640f0bb64cbb6a20333009",NAME="asmdata01",OWNER="grid",GROUP="asmadmin",MODE="0660"   KERNEL=="sd*",RESULT=="36000c29912bdf56b54e0da578f17b8ff",NAME="asmdata02",RESULT=="36000c29603fa50e5f0a5a0537fac7962",NAME="asmfra01",RESULT=="36000c2939990b39898c449f35ac1ef9c",NAME="asmfra02",  GROUP="asmadmin",MODE="0660"故障原因：由于oracle用户无法访问asm disk 权限，导致restore失败，遇到类似情况，可以尝试dbca创建数据库测试，应该不会发现asm磁盘组解决方法：二选一1. 磁盘组所组修改为asmdba2. oracle用户加上所属组asmadmin

这是aspx标记：

<div>
    <asp:ListBox ID="lstStates" runat="server" AutopostBack="True"
    OnSelectedindexChanged="lstStates_SelectedindexChanged" SelectionMode="Multiple">
    </asp:ListBox>
</div>
<div>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
    <ContentTemplate>
    <asp:Panel ID="pnlCounty" runat="server">
    <asp:ListBox ID="lstCounties" runat="server" SelectionMode="Multiple">
    </asp:ListBox>
    </asp:Panel>
    </ContentTemplate>
    <Triggers>
    <asp:AsyncPostBackTrigger ControlID="lstStates" EventName="SelectedindexChanged" />
    </Triggers>
    </asp:UpdatePanel>
    <asp:UpdateProgress ID="UpdateProgress2" runat="server" displayAfter="1"
                        AssociatedUpdatePanelID="UpdatePanel1">
    <Progresstemplate>
    <img src="../images/loader2.gif" />
    Loading Counties...
    </Progresstemplate>
    </asp:UpdateProgress>
</div>

但是,文章建议注入一些JavaScript来弥补这个错误;我已将其修改为(希望)符合您的需求：

<script type="text/JavaScript" language="JavaScript">
    function pageLoad()
    {      
       var manager = Sys.WebForms.PageRequestManager.getInstance();
       manager.add_endRequest(endRequest);
       manager.add_beginRequest(OnBeginRequest);
    }
    function OnBeginRequest(sender,args)
    {
      var postBackElement = args.get_postBackElement();
      if (postBackElement.id == 'lstStates')
      { 
     $get('UpdateProgress2').style.display = "block";  
      }
   }
</script>

routes.MapHttpRoute(
                name: "Controller only",routeTemplate: "api/{controller}"
            );

但是，这会导致RouteCollection不包含MapHttpRoute的定义的错误。我是否安装了一些DLL？
据我看到，我已经安装了所有正确的DLL和版本。