广告

本站里的文章大部分经过自行整理与测试

2015年9月10日星期四

SQL Developer - msvcr100.dll 问题

sqldeveloper64W.exe - System Error
The program can't start because MSVCR100.dll is missing from your computer.
Try reinstalling the program to fix this problem.

出现以上错误的话, 
只需要到以下复制档案


C:\Program Files\Java\jdk1.8.0_60\bin\msvcr100.dll

到以下位置

C:\sqldeveloper\sqldeveloper\bin\msvcr100.dll

Oracle database 12c - 加 SCOTT 户口

sqlplus / as sysdba

SQL> select * from ALL_USERS where USERNAME = 'C##SCOTT';
no rows selected

SQL> @C:\scott.sql;

SQL> conn c##scott/tiger

SQL> select table_name from user_tables;
SQL> select * from SALGRADE;

scott.sql (C:\app\orcl\product\12.1.0\dbhome_1\RDBMS\ADMIN\utlsampl.sql)
SET TERMOUT OFF
SET ECHO OFF
DROP USER C##SCOTT CASCADE;

CREATE USER C##SCOTT IDENTIFIED BY tiger;

GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO C##SCOTT container=all;

ALTER USER C##SCOTT default TABLESPACE USERS;
ALTER USER C##SCOTT temporary TABLESPACE TEMP;

CONNECT C##SCOTT/tiger

CREATE TABLE DEPT
       (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,
DNAME VARCHAR2(14) ,
LOC VARCHAR2(13) ) ;
CREATE TABLE EMP
       (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);

INSERT INTO DEPT VALUES
(10,'ACCOUNTING','NEW YORK');
INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');
INSERT INTO DEPT VALUES
(30,'SALES','CHICAGO');
INSERT INTO DEPT VALUES
(40,'OPERATIONS','BOSTON');
INSERT INTO EMP VALUES
(7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20);
INSERT INTO EMP VALUES
(7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30);
INSERT INTO EMP VALUES
(7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30);
INSERT INTO EMP VALUES
(7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20);
INSERT INTO EMP VALUES
(7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,30);
INSERT INTO EMP VALUES
(7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30);
INSERT INTO EMP VALUES
(7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10);
INSERT INTO EMP VALUES
(7788,'SCOTT','ANALYST',7566,to_date('13-JUL-87','dd-mm-rr')-85,3,NULL,20);
INSERT INTO EMP VALUES
(7839,'KING','PRESIDENT',NULL,to_date('17-11-1981','dd-mm-yyyy'),5,NULL,10);
INSERT INTO EMP VALUES
(7844,'TURNER','SALESMAN',7698,to_date('8-9-1981','dd-mm-yyyy'),1500,0,30);
INSERT INTO EMP VALUES
(7876,'ADAMS','CLERK',7788,to_date('13-JUL-87', 'dd-mm-rr')-51,1100,NULL,20);
INSERT INTO EMP VALUES
(7900,'JAMES','CLERK',7698,to_date('3-12-1981','dd-mm-yyyy'),950,NULL,30);
INSERT INTO EMP VALUES
(7902,'FORD','ANALYST',7566,to_date('3-12-1981','dd-mm-yyyy'),3,NULL,20);
INSERT INTO EMP VALUES
(7934,'MILLER','CLERK',7782,to_date('23-1-1982','dd-mm-yyyy'),1300,NULL,10);

CREATE TABLE BONUS
(
ENAME VARCHAR2(10) ,
JOB VARCHAR2(9)  ,
SAL NUMBER,
COMM NUMBER
) ;

CREATE TABLE SALGRADE
      ( GRADE NUMBER,
LOSAL NUMBER,
HISAL NUMBER );

INSERT INTO SALGRADE VALUES (1,700,1200);
INSERT INTO SALGRADE VALUES (2,1201,1400);
INSERT INTO SALGRADE VALUES (3,1401,2);
INSERT INTO SALGRADE VALUES (4,2001,3);
INSERT INTO SALGRADE VALUES (5,3001,9);

COMMIT;

EXIT

2015年9月9日星期三

Vmware - usb 开机

1. 下载 plpbt-5.0.15.zip (Plop Boot Manager 5.0)

http://www.plop.at/en/bootmanager/download.html

将档案里面的 plpbt.iso 解压到 C:\..

2. 在 Virtual Machine Settings -> CD/DVD -> Use ISO image file: C:\plpbt.iso

3. 到 Virtual Machine - BIOS 改开机次序

Power On -> Power On to Firmware -> Boot 
-> 
1. CD-ROM Drive
2. Removable Devices
3. Hard Drive
4. Network boot from Intel E1000e

Save & Exit..

4. 插入 USB Drive, 选 USB 开机

2015年9月4日星期五

KMSpico 激活工具

KMSpico 可激活的产品:
  • Office 2010/2013/2016
  • Windows 10 所有版本
  • Windows 8, Windows 8.1 所有版
  • Windows Server 2016 (Theorically)
  • Windows 7 Professional/N/Enterprise/N 专业版, 企业版
  • Windows Vista Business/N/Enterprise/N 商业版, 企业版
  • Windows Server Technical Preview Build 9841/9860/9926 所有版本
  • Windows Server 2008/2008R2 Standard/Datacenter/Enterprise 标准版/数据中心版/企业版
  • Windows Server 2012/2012R2 Standard/Datacenter/Enterprise 标准版/数据中心版/企业版
使用方法:
Win7 需装 .NET 4.0
  1. 首次管理员身份运行 "卸载服务.bat" 清除服务
  2. 然后管理员身份执行 KMSpico_setup.exe 安装
  3. 耐心等待(安装完即可全自动激活!)

KMSpico v10.1.6

Win10 英文专业版




可以下载到 Win 10 英文专业版 32 / 64 bit

如果要 activate product key, 可用以下工具

KMSpico v10.1.6
访问 nmj1

2015年9月3日星期四

Vmware Workstation unrecoverable error: (vcpu-0)


VMware Workstation unrecoverable error: (vcpu-0)

vcpu-0:VERIFY vmcore/vmm/main/physMem_monitor.c:1123

A log file is available in "..\Virtual Machines\OS X 10.10\vmware.log".  

You can request support.  

To collect data to submit to VMware support, choose "Collect Support Data" from the Help menu.

You can also run the "vm-support" script in the Workstation folder directly.

We will respond on the basis of your support entitlement.

解决方法

去 .. \ Virtual Machines \ OS X 10.10 \ OS X 10.10.vmx

用 Notepad++ 打开档案, 然后确保有以下2项设置,
没有就加, 但不能重复

smc.present = "TRUE"
smc.version = 0

即可