- 博客(81)
- 收藏
- 关注
RSS订阅原创 Power小型机管理—VMware安装HMC系统管理小型机
HMC下载地址：ftp://ftp.software.ibm.com/software/server/hmc/recovery_images/ 可以选择HMC_Recovery_V7R740_1.iso，新版本在虚拟机中安装会有问题。HMC.ROM文件下载地址：点击打开链接在VMware中创建一个新的虚拟机，注意一下几点1.虚拟机的的客户机操作系统选择：其他Linux2
2014-09-19 22:09:16
4621
原创 Oracle修改ip或主机名后重建em和监听
oracle数据库修改ip和主机名的详细操作修改ip操作1.修改hosts文件中主机名对应的ip地址。2.重启服务器网络 service network restart3.一定要先删除原来的监听 emca -deconfig dbcontrol db -repos drop （如果不记得sysman的密码，可以先修改下alter user sy
2014-09-13 10:07:45
5525
原创 Linux 启动过程详解
启动第一步－－加载BIOS当你打开计算机电源，计算机会首先加载BIOS信息，BIOS信息是如此的重要，以至于计算机必须在最开始就找到它。这是因为BIOS中包含了CPU的相关信息、设备启动顺序信息、硬盘信息、内存信息、时钟信息、PnP特性等等。在此之后，计算机心里就有谱了，知道应该去读取哪个硬件设备了。启动第二步－－读取MBR众所周知，硬盘上第0磁道第一个扇区被称为MBR，也就是Ma
2014-09-12 16:25:57
1556
1
原创 Linux系统下自动删除前N天的日志文件
删除文件命令：find 对应目录 -mtime +天数 -name "文件名" -exec rm -rf {} \;实例命令：find /opt/soft/log/ -mtime +30 -name "*.log" -exec rm -rf {} \;find /opt/soft/log/ -mtime +30 -name "*.log" -exec rm -rf
2014-08-20 11:09:13
2869
1
原创 C#调用迅雷下载实例
目前只支持HTTP协议using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Runtime.InteropServices;using System.Threading;namespace ThunderSDK{ class Program
2014-08-19 09:53:26
4316
原创 Oracle 初始化参数文件pfile和spfile
pfile和spfile的区别pfile ：Oracle 9i之前，ORACLE一直采用PFILE方式存储初始化参数，该文件为文本文件，可以在操作系统级别修改。当spfile文件修改出现错误导致oracle无法启动时，可以使用 pfile文件启动数据库spfile：从Oracle 9i开始，Oracle引入了SPFILE文件，该文件为二进制格式，不能通过手工修改，只能在sql下通过alte
2014-07-25 14:43:59
2954
原创 Oracle OS认证和口令文件认证方法
OS认证1.在SQLNET.ORA（位于$ORACLE_HOME/NETWORK/ADMIN目录中）文件中，使用vi编辑，注释掉#SQLNET.AUTHENTICATION_SERVICES = (NONE)该行。2.检查当前OS用户是否属于DBA组。3.执行sqlplus / as sysdba 登录数据库。口令文件认证1.在SQLNET.ORA（位于$ORACLE_HOME
2014-07-25 13:54:49
1803
原创 调整oracle sga的大小导致 ORA-00851和ORA-00844错误
今天调整了下sga的大小，结果重启数据库的时候报如下错误。SQL>alter system set sga_max_size=1024M scope=spfile;SQL> shutdown immediateSQL> startupORA-00844: Parameter not taking MEMORY_TARGET into accountORA-00851: SGA_
2014-07-16 15:55:51
5516
原创 Redhat Linux kill指定进程名的四种方式
1、#pkill 进程名 2、#killall 进程名3、#kill -9 $(ps -ef|grep 进程名关键字|grep -v grep|awk '{print $2}')这个是利用管道和替换将 进程名对应的进程号提出来作为kill的参数。很显然上面的方法能完成但是过于复杂，下面这种就显得简单的多了4、#kill -9 $(pidof 进程名关键字)
2014-07-16 13:22:44
6642
原创 利用批处理bat获取系统日期前三天的日期
在管理服务器的时候经常要根据系统的日期判断上传哪一天的日志文件，例如是周一需要上传上周五的日志，其他日期则上传前一天的日志，日志文件是以日期命名的。这就需要获取前三天的日期，或者前n天的日期。批处理结合vbs可以实现，文件如下。if "%date:~13%"=="一" (set DaysAgo=3) else (set DaysAgo=1)>"%temp%\MyDate.vbs" echo
2014-07-11 09:10:36
6525
1
原创 RedHat6.5 安装OpenStack all in one-RDO方式
OpenStack是一个开源的云平台，由各个组件协同工作，安装非常复杂。RedHat有个关于Openstack的项目RDO，可以简化安装过程，但是如果真按RDO所说的三步去安装，发现安装过程中还是有很多报错，不得不查询Openstack的官方文档。本来准备在新出的RHEL7上安装的，发现缺少libselinux（epel7）的附加包，有可能还没编译。所有选择RedHat6.5作为底层操作系统。
2014-07-10 12:09:14
6198
原创 Redhat 7修改默认运行级别方法 --RHEL7使用systemd创建符号链接指向默认运行级别
今天装了下正式版的RHEL7，发现熟悉的inittab中没有了修改默认运行级别，打开inittab如下[root@localhost init.d]# vi /etc/inittab # inittab is no longer used when using systemd.## ADDING CONFIGURATION HERE WILL HAVE NO EFFECT ON YOUR
2014-07-04 22:20:21
9030
4
原创 OCP-1Z0-051-题目解析-第50题
50. SLS is a private synonym for the SH.SALES table. The user SH issues the following command: DROP SYNONYM sls; Which statement is true regarding the above SQL statement? A. Only the synonym
2014-07-01 10:14:14
2903
原创 OCP-1Z0-051-题目解析-第49题
49. The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR. Which statement would create a synonym ORD so that HR can execute the following q
2014-07-01 09:53:24
1357
原创 OCP-1Z0-051-题目解析-第48题
48. Which two statements are true regarding indexes? (Choose two.) A. They can be created on tables and clusters. B. They can be created on tables and simple views. C. You can create only one in
2014-07-01 09:45:59
1736
原创 在RedHat Linux系统中安装和配置snmp服务
检查系统是否安装snmp服务# rpm -qa|grep snmpnet-snmp-5.3.2.2-17.el5net-snmp-perl-5.3.2.2-17.el5net-snmp-devel-5.3.2.2-17.el5net-snmp-libs-5.3.2.2-17.el5net-snmp-utils-5.3.2.2-17.el5net-snmp-libs-5.
2014-07-01 09:23:55
11363
原创 OCP-1Z0-051-题目解析-第47题
47. View the Exhibit and examine the structure of ORD and ORD_ITEMS tables. The ORD_NO column is PRIMARY KEY in the ORD table and the ORD_NO and ITEM_NO columns are composite PRIMARY KEY in th
2014-06-30 21:32:27
1494
原创 OCP-1Z0-051-题目解析-第46题
46. Which statements are correct regarding indexes? (Choose all that apply.) A. When a table is dropped, the corresponding indexes are automatically dropped. B. A FOREIGN KEY constraint on a colum
2014-06-30 21:27:37
1519
原创 OCP-1Z0-051-题目解析-第45题
45. Which two statements are true about sequences created in a single instance database? (Choose two.) A. The numbers generated by a sequence can be used only for one table. B. DELETE would remov
2014-06-30 21:25:54
1443
原创 OCP-1Z0-051-题目解析-第44题
44. View the Exhibit and examine the structure of the ORD table. Evaluate the following SQL statements that are executed in a user session in the specified order: CREATE SEQUENCE ord_seq; SE
2014-06-30 21:17:58
1544
原创 RadHat搭建内网YUM源服务器
前言：随着内网linux服务器越来越多，在每台服务器上安装软件，都要先把安装盘上传上去，在配置本地yum服务，即麻烦又费时。可以在内网的一台linux服务器上安装yum服务，然后其他服务器直接修改repo文件使用yum服务就可以了。安装步骤如下：
2014-06-30 13:35:47
7238
原创 OCP-1Z0-051-题目解析-第43题
43. Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The SEQ1 sequence has generated numbers up to the ma
2014-06-29 22:03:29
1401
原创 OCP-1Z0-051-题目解析-第42题
42. Which three statements are true regarding views? (Choose three.) A. Views can be created only from tables. B. Views can be created from tables or other views. C. Only simple views can use in
2014-06-29 22:01:38
1345
原创 OCP-1Z0-051-题目解析-第41题
41. Which two statements are true regarding views? (Choose two.) A. A subquery that defines a view cannot include the GROUP BY clause. B. A view that is created with the subquery having the DI
2014-06-29 21:37:03
1452
原创 OCP-1Z0-051-题目解析-第40题
40. View the Exhibit to examine the description for the SALES and PRODUCTS tables. You want to create a SALE_PROD view by executing the following SQL statement: CREATE VIEW sale_prod AS SELECT p
2014-06-29 18:48:15
1349
原创 OCP-1Z0-051-题目解析-第39题
39. Evaluate the following command: CREATE TABLE employees (employee_id NUMBER(2) PRIMARY KEY, last_name VARCHAR2(25) NOT NULL, department_id NUMBER(2)NOT NULL, job_id
2014-06-29 18:46:51
2274
原创 OCP-1Z0-051-题目解析-第38题
38. Which two statements are true regarding views? (Choose two.) A. A simple view in which column aliases have been used cannot be updated.B. Rows cannot be deleted through a view if the view defi
2014-06-29 18:00:16
1178
原创 OCP-1Z0-051-题目解析-第37题
37. You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command? (Choose all that apply.) A. All data along with the table stru
2014-06-29 17:59:11
1397
原创 OCP-1Z0-051-题目解析-第36题
36. Examine the following SQL commands: SQL>CREATE TABLE warehouse ( warehouse_id NUMBER(4), roomno NUMBER(10) CONSTRAINT r_id CHECK(roomno BETWEEN 101 AND 200), location VARCHAR2(25),
2014-06-29 17:38:14
1469
原创 OCP-1Z0-051-题目解析-第35题
35. Which two statements are true regarding constraints? (Choose two.) A. A table can have only one primary key and one foreign key. B. A table can have only one primary key but multiple foreign k
2014-06-29 17:32:33
1303
原创 OCP-1Z0-051-题目解析-第34题
34. You created an ORDERS table with the following description: name Null Type ORD_ID NOT NULL NUMBER(2) CUST_ID NOT NULL NUMBER(
2014-06-29 17:25:40
1206
原创 OCP-1Z0-051-题目解析-第33题
33. You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement: 1) The order ID will be unique and cannot have null values. 2) The order
2014-06-29 17:13:40
1502
原创 OCP-1Z0-051-题目解析-第32题
32. Which CREATE TABLE statement is valid? A. CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date DATE NOT NULL); B. CREATE TABLE
2014-06-29 16:55:22
1282
原创 OCP-1Z0-051-题目解析-第31题
31. Evaluate the following SQL commands: SQL>CREATE SEQUENCE ord_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCYCLE; SQL>CREATE TABLE ord_items (ord_no NUMBER(4)D
2014-06-29 11:27:48
1611
转载 Oracle中NEXTVAL 和 CURRVAL的使用
可以通过在 SQL 语句中使用 NEXTVAL 或 CURRVAL 运算符来访问序列的值。必须用以 sequence.NEXTVAL 或 sequence.CURRVAL 格式驻留在同一个数据库中的序列名称（或同义词）来限定 NEXTVAL 或 CURRVAL。表达式也可以用所有者名来限定序列，如 zelaine.myseq.CURRVAL。可以指定 sequence 的 SQL 标识或有效同义词
2014-06-29 11:20:13
22934
原创 OCP-1Z0-051-题目解析-第30题
30. Evaluate the following CREATE TABLE commands: CREATE TABLE orders (ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER(4)); CREATE TABLE ord_items (ord_no NUMBER(
2014-06-29 11:09:11
1654
原创 OCP-1Z0-051-题目解析-第29题
29. Which two statements are true regarding constraints? (Choose two.) A. A foreign key cannot contain NULL values. B. The column with a UNIQUE constraint can store NULLS . C. A constraint is
2014-06-29 11:05:51
1315
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人