2012年02月_shenghuiping2001

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创 Hacmp failover test

今天的hacmp test:Environment: Hacmp: 5.4Problem: When stop one primary node, The service Ip address can not switch to another node.Reason: When execute below command: smit clstop

2012-02-26 18:36:42 501 1

原创 oracle 体系架构 - （绝对原创）（二）

This I will continue to intruduce Instance and Media recovery structure:Step1: The Oracle server provide a number of standard views to obtain information on the database and instance, These vi

2012-02-24 11:46:11 499

原创 oracle 体系架构（绝对原创）（一）

This I will intruduce Instance and Media recovery structure: After completing this lesson, you should be able to do the following: 1: Describle the Oracle process, memory structures, and

2012-02-24 10:34:24 566

原创跟我学plsql - 写可执行的语句（二）

This I will intruduce How to write excelent PLSQL:Step1: The scope of variables: 1: The internal variables can be only used in internal declaration. 2: The external variables can be use

2012-02-21 11:04:34 528

原创跟我学plsql - 写可执行的语句（一）

This I will intruduce the PLSQL:Step1: Using Literals: 1: Character and date literals must be enclosedin quotation marks 2: Number can be simple values or in scientific notation. e

2012-02-20 11:17:00 872

原创跟我学plsql - 定义变量（二）

This I will continue to intruduce the PLSQL: Guidelines for Declaring and initializing PL/SQL variables 1: Follo naming conventions. 2: Using meaningful identifiers for variables.

2012-02-20 10:06:24 835

原创跟我学plsql - 定义变量（一）

Class 1:This I will intruduce the PLSQL: First, list the useful of plsql: 1: variable,constant, and data types 2: Control structures such as conditional statement and loops 3: Reusable p

2012-02-18 22:48:32 6385

原创 11g 新特性之 plsql

This day I will introduce the 11G plsql:Step1: Let us create one sequence first: create sequence dept_seq start with 101; Now I had viewed the sequence had created in left side: SEQENCE

2012-02-18 18:10:32 506

转载 SCO UNIX 快速上手

前言：这是应该我的UNIX的“讲义”吧，虽然只有一个“学生”，但我还是很认真的“备课”了，我尽量做到通俗易懂，让从未接触过UNIX的朋友快速入门。呵呵，匆匆，错误难免！以后一定花更多的时间整理，为自己，也为需要它的朋友！苏华，首先，我和你一起看看UNIX的目录，因为我觉得清楚了目录，才能对UNIX的框架有个大概的印象！当然这里讲的是系统正常运转所必须的，并且一定不能删除或

2012-02-17 16:38:26 556

原创 ora-00257 默认的 db_recovery_dest 满用户不能登入（解决）

This afternoon, customer had faced one problem:The user can not not connect to database,ora-00257 error log occur:Caustion: The achivelog is full 1: Even we delete the archivelog from

2012-02-15 18:42:00 1528

原创我来说说监控 oracle session

This I will highlight the oracle session monitor: I will do a workshop to begin this:Step1: Open one session to update one row data: SQL> select * from t1; ID----------

2012-02-15 11:34:09 1097

转载关于oracle 锁的实际解决方法

$lock视图的各个列及其说明ADDR RAW(4) 在内存中锁定的对象的地址KADDR RAW(4) 在内存中锁的地址SID NUMBER 保持或申请锁的会话的标识号TYPE VARCHAR2(2) 锁的类型。 TX＝行锁或事务锁；TM＝表锁或DML锁；UL＝PL/SQL用户锁

2012-02-14 11:55:57 552

原创关于 oacle 锁做的小实验

This time I will introduce about the Oracle lock: Let us begin at one workshop: Step1: Open two session to connect to an open database: then I will check the session number: S

2012-02-14 11:54:12 377

原创 Manage Undo tablespace (datafile + v$rollstat + 01555)

This time I will introduce some about tablespace UNDO: There are three types tablespace : Permanent temporary undo Step1: If you want to see the tablespace type, you can use bel

2012-02-12 17:55:03 524 1

原创 oracle EXP & IMP 维护 + 字符集的处理

This time I will introduce the Oracle import and export utilities:After Completing this lesson, You should be able to do the following:1: Describe the use of the export and Import utilities.2: D

2012-02-10 21:53:05 764

原创 ORA-00600: [keltnfy-ldmInit]

1:今天重启数据库的报错：SQL> startup mountORA-03113: end-of-file on communication channel看一下alert.log:...PMON started with pid=2, OS id=7359PSP0 started with pid=3, OS id=7361MMAN started with pid=

2012-02-07 16:19:51 536

原创 rman 维护 - ( crosscheck + retention + keep + catalog)

This time ,I will introduce the Rman maintenance:After completing this lession, you should be able to do the following: 1: Perform Cross-checking of backups and copies. 2: Update the repositor

2012-02-05 19:20:45 658

原创 tsm 上创建一个有admin 权限的账号

tsm 上创建一个有admin 权限的账号：Step1:cd /opt/tivoli/tsm/client/ba/bin./dsmadmc -admin -adminupdate admin sheng(new admin ID) sheng(new admin password)Step2:test: ./dsmadmc -sheng -shengtsm: T

2012-02-04 23:00:34 2633

原创备份成功，可在磁带没有 - (测试成功) - 2012-02-04

今天发现备份成功，可是在磁带上没有内容：成功：[root@aoracle bin]# ./dsmc selective /tmp/test.sh IBM Tivoli Storage ManagerCommand Line Backup/Archive Client Interface Client Version 5, Release 5, Level 1.0 C

2012-02-04 17:36:20 1680 1

原创 tsm 备份的监控脚本 - cankao

#! /bin/sh# Author: Sheng Huiping# Date: Feb 1 2012#Date=`date +%Y_%m_%d`log=/tmp/tsm/tsm_backup_$Date.log# List the TSM backup event for one day:/usr/tivoli/tsm/client/ba/bin/dsmadmc -i

2012-02-03 14:53:46 1240