原理是先kill占用了数据库的那个进程，然后设置数据库为多用户模式。

 

USE master;
GO
DECLARE @SQL VARCHAR(MAX);
SET @SQL=''
SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)
FROM master..sysprocesses
WHERE dbid=DB_ID('数据库名');

EXEC(@SQL);

GO

 

ALTER DATABASE 数据库名 SET MULTI_USER;

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href=/blog_article/"configuration/gt;.xsl"

<!-- Put site-specific property overrides in this file. -->

<configuration>

<property>
     <name>fs.default.name</name>
     <value>hdfs://master:9000</value>
     <description></description>
</property>
<property>
<name>Hadoop.tmp.dir</name>
     <value>/myhadoop</value>
     <description></description>
</property>
</configuration>

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href=/blog_article/"configuration/gt;.xsl"

<!-- Put site-specific property overrides in this file. -->

<configuration>

<property>
     <name>dfs.replication</name>
     <value>2</value>
</property>


</configuration>

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href=/blog_article/"configuration/gt;.xsl"

<!-- Put site-specific property overrides in this file. -->

<configuration>

<property>
<name>mapred.job.tracker</name>
<value>master:9001</value>
</property>

</configuration>

   1、修改 node1虚拟机下的 /etc/hostname内容为 node1,node2虚拟机下的 /etc/hostname为node2

   2、在Master虚拟主机下， 添加认证公钥，并设置权限：

  3、配置集群的SSH服务

(1) 远程拷贝master的公钥到node1结点上

package com.yonge.zip;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.zip.ZipEntry;
import java.util.zip.ZipInputStream;
import java.util.zip.ZipOutputStream;

import org.apache.commons.io.IOUtils;

/**
 * 压缩目标文件为zip文件
 * @author wb-gaoy
 * @version $Id: CompressByZip.java,v 0.1 2013-1-8 上午10:18:16 wb-gaoy Exp $
 */
public class ZipUtil {

    public static void zip(File srcFile, File targetFile) throws IOException {
        ZipOutputStream zipOutputStream = null;
        FileOutputStream fileOutputStream = null;
        try {
            fileOutputStream = new FileOutputStream(targetFile);
            zipOutputStream = new ZipOutputStream(fileOutputStream);
            zip(zipOutputStream, srcFile, "");
        } finally {
            if (zipOutputStream != null) {
                zipOutputStream.close();
            }
            if (fileOutputStream != null) {
                fileOutputStream.close();
            }
        }
    }

    public static void zip(ZipOutputStream zipOutputStream, File srcFile, String baseURL)
                                                                                         throws IOException {

        baseURL = baseURL == null || baseURL.length() == 0 ? srcFile.getName() : baseURL
                                                                                 + "/"
                                                                                 + srcFile
                                                                                     .getName();
        if (srcFile.isDirectory()) {
            File[] files = srcFile.listFiles();
            if (files != null && files.length > 0) {
                for (File f : files) {
                    zip(zipOutputStream, f, baseURL);
                }
            } else {
                zipOutputStream.putNextEntry(new ZipEntry(baseURL + "/"));
            }
        } else {
            zipOutputStream.putNextEntry(new ZipEntry(baseURL));

            FileInputStream fileInputStream = null;
            try {
                //读数据
                fileInputStream = new FileInputStream(srcFile);
                byte[] bytes = new byte[1024];
                int length = -1;
                while ((length = fileInputStream.read(bytes)) != -1) {
                    zipOutputStream.write(bytes, 0, length);
                }
            } finally {
                if (fileInputStream != null) {
                    fileInputStream.close();
                }
            }
        }
    }

    public static void unzip(File srcFile, File targetFile) throws IOException {
        FileInputStream fileInputStream = null;
        ZipInputStream zipInputStream = null;
        FileOutputStream fileOutputStream = null;
        try {
            fileInputStream = new FileInputStream(srcFile);
            zipInputStream = new ZipInputStream(fileInputStream);
            if (!targetFile.exists()) {
                targetFile.mkdirs();
            }
            ZipEntry entry = zipInputStream.getNextEntry();
            File tempFile;
            while (entry != null) {
                tempFile = new File(targetFile, entry.getName());
                if (entry.isDirectory()) {
                    tempFile.mkdir();
                } else {
                    tempFile.getParentFile().mkdirs();
                    fileOutputStream = new FileOutputStream(tempFile);
                    IOUtils.copy(zipInputStream, fileOutputStream);
                }
                entry = zipInputStream.getNextEntry();
            }
        } finally {
            if (zipInputStream != null) {
                zipInputStream.close();
            }
            if (fileInputStream != null) {
                fileInputStream.close();
            }
            if (fileOutputStream != null) {
                fileOutputStream.close();
            }
        }
    }

    public static void main(String[] args) {
        File file = new File("C:\\ecmng\\site\\tmp\\test");
        try {
            //zip(file, new File("demo.zip"));
            unzip(new File("demo.zip"), file);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

• —软件人才免语言低担保 赴美带薪读研！—