摘要: ssh vi /etc/apt/sources.list su ssh username@ipaddress eg : ssh root@172.16.247.143 实验一 fdisk /dev/sdb (create partitions) mdadm --create /dev/md0 --l 阅读全文
posted @ 2015-03-30 22:57 Orchidelle 阅读(295) 评论(0) 推荐(0) 编辑
摘要: 数据库DBA任务: 管理数据库可用性 设计并创建数据库 管理物理结构 管理基于设计的存储 管理安全性 网络管理 备份与恢复 数据库调整与优化 关系型数据库(RDBMS) 多个表数据之间存在着关系 关系用来描述多个表之间的数据依存,包括一对一,一对多,多对多的关系。 这些关系在Oracle数据库中表现 阅读全文
posted @ 2015-03-30 10:19 Orchidelle 阅读(144) 评论(0) 推荐(0) 编辑
摘要: DDL commands --> create user / table / view / sequence alter DML --> data manipulation language (insert, select, update, delete) eg : SELECT ename FRO 阅读全文
posted @ 2015-03-26 12:52 Orchidelle 阅读(161) 评论(0) 推荐(0) 编辑
摘要: debug iapp through debug ip ftp debug iapp : to begin debugging of IAPP operations(in privileged EXEC mode) no debug iapp debug idmgr : to enable debu 阅读全文
posted @ 2015-03-23 17:53 Orchidelle 阅读(389) 评论(0) 推荐(0) 编辑
摘要: a hot potato : speak of an issue(mostly current) which many people are talking about and which is usually siaputed. add insult to injury : to further 阅读全文
posted @ 2015-03-20 15:35 Orchidelle 阅读(330) 评论(0) 推荐(0) 编辑
摘要: flow control the if statement syntax : IF condition1 THEN action1; [ELsIF condition2 THEN action2; [ELSE action3;] END IF; eg : IF condition THEN SQL 阅读全文
posted @ 2015-03-17 22:46 Orchidelle 阅读(158) 评论(0) 推荐(0) 编辑
摘要: SQL is not very flexible and it cannot be made to react differently to differing sutuations easily. In SQL queries we normally tell database what we w 阅读全文
posted @ 2015-03-11 22:52 Orchidelle 阅读(262) 评论(0) 推荐(0) 编辑
摘要: Procedural Language for SQL query a database and manipulate data understand the goals of the PL/SQL cursus explain the need for PL/SQL and the benefit 阅读全文
posted @ 2015-03-04 22:28 Orchidelle 阅读(341) 评论(0) 推荐(0) 编辑
摘要: clear license agent : to clear license agent statistics counters or connection statistics (in privileged EXEC mode) debug license : to enable controll 阅读全文
posted @ 2015-02-13 00:02 Orchidelle 阅读(210) 评论(0) 推荐(0) 编辑
摘要: absolute : to specify an absolute time for a time-range (in time-range configuration mode) no absolute buffer-length : to specify the maximum length o 阅读全文
posted @ 2015-02-11 21:33 Orchidelle 阅读(499) 评论(0) 推荐(0) 编辑