ITPub博客

在图形化界面按下ctrl+alt+f[1-6] 切换到命令行； 在命令行按下alt+f7 进入图形界面。[@more@]

#/home/oracle> mv openssh-4.1p1_51.tar.z openssh-4.1p1_51.tar.Z #/home/oracle> uncompress openssh-4.1p1_51.tar.Z #/home/oracle> ls.bash_history bkup2 exp.leotab9.1013 import.sh.profile bkup3 exp.ts_labdata1.1013 openssh-4.1p1_51.tar.sh_history exp.1009 exp.ts_labdata3.1013 smit.logbkup exp.annytab8.1013 explog.leo.1013 smit.scriptbkup1 exp.annytab9.1013 expl

$ ps -ef|grep ora_ oracle 5996 1 0 16:10:24 - 0:00 ora_lgwr_orapp oracle 17100 1 0 16:10:24 - 0:00 ora_snp0_orapp oracle 17558 1 0 16:10:25 - 0:00 ora_snp1_orapp oracle 19498 1 0 16:10:24 - 0:00 ora_pmon_orapp oracle 20276 24436 1 16:13:29 pts/1 0:00 grep ora_ oracle 21704 1 0 16:10:24 - 0:00 ora_dbw0_orapp oracle 21934 1 0 16:10:24 - 0:00 ora_reco_orapp oracle 22192 1 0 16:10:24 - 0:00 ora_sm

windows 防火墙 导致 tnsping 不能成功[@more@]

@echo -------------- 开始归档日志备份 %date% %time% -------------------- >> f:testarch_backup.logxcopy d:oracleora92rdbms*.001 f:test /D /F >> f:testarch_backup.log@echo -------------- 归档日志备份结束 %date% %time% -------------------- >> f:testarch_backup.log@echo ---------------------------------------------------------------------------------- >> f:testarch_backup.log@echo. >> f:testarch_backup.log@echo. >> f:testarch_backup.log[@more@]

for /f "skip=7 tokens=4" %a in ('dir f:test') do @if exist %a @echo %a[@more@]用批处理实现的删除特定时间以前的文件发布：dxy 字体：[增加 减小] 类型：转载 使用for命令读取dir /tc /o-d /a的结果，可以分成4段，前两段为日期与时间，第3段为目录或文件大小，第4段为文件名或目录名。然后根据第1段和第2段与需要的时间进行比较，决定是否删除文件 @echo off rem cd /d f:temp rem mDateTime格式: yyymmddHHmm set mDateTime=200608161907 for /f "skip=4 tokens=1,2,3,4* delims=<>" %%i in ('dir /a /-

From : http://tolywang.itpub.net/post/48/462115Oracle EE(企业版, Enterprise Edition), SE(标准版, Standard Edition), SE1(标准版1, Standard Edition One) 区别是什么？ 1. SE1针对部门和小企业，SE针对中小企业和单位，EE针对大中型企业和单位。使用SE，就意味着用户不能使用EE的功能强大的选件，EE选件可以实现高性能、高可用性、高扩展性、高安全性和高级数据分析的功能。SE和SE1最多支持 500 GB 数据量，EE则高达 8,000,000,000 GB(80亿GB)，另外EE还支持数据压缩(compression)功能，特别适合存储资源有限、I/O量大的数据仓库。

1 ， 源库 exp ， 目标库 imp 时的环境变量要设为：LANG=zh_CN.ZHS16GBKNLS_LANG=american_america.ZHS16GBK否则，可能会遇到一些卡住。2 ， 源库在做 全库的 exp 时，不能指定 direct=y 否则也会报错。3 ， 参考语句：exp system/manager@test full=y file=(/oradata/artcvs01.dmp /oradata/artcvs02.dmp) filesize=2000M log=/oradata/test080508full.log buffer=20480000 feedback=1000 imp userid=system/manager file=/oradata/artcvs01.dmp full=y filesize=2000m log=/oradata/imp080508_2.log[@more@]

做 817 standby 时后台日志报以下错误信息，archivelog 不能传到 standby 服务器 Tue May 6 14:10:02 2008ARC0: Beginning to archive log# 3 seq# 438Tue May 6 14:10:02 2008Thread 1 advanced to log sequence 439 Current log# 1 seq# 439 mem# 0: /oraclesoft/oradata/orcl/redo01.logTue May 6 14:10:03 2008ARC0: Error 16032 attaching RFS server to standby instance at host 'standby'ARC0: Error 16032 creating archivelog file 'standby'ARC0: Completed archiving log# 3 seq# 438Tue May 6 15:41:01 2008 Subject:

mount 原始目录 新挂载目录例如# mount /dev/cdrom /media/cdrom &前提 /media/cdrom 必须存在 并且有权限哦。umount 挂在目录例如# umount /media/cdrom & 此时取消的是挂载目录 而不是原始目录。另外 umount命令时 容易提示 目录正忙 此时可以用 fuser -u /media/cdrom 查看 当前目录的访问用户情况。并且可以用fuser -k /media/cdrom 来杀掉此进程。再用 umount 来取消挂载 。[@more@]

tar在linux上是常用的打包、压缩、加压缩工具，他的参数很多，折里仅仅列举常用的压缩与解压缩参数 参数： -c ：create 建立压缩档案的参数； -x ： 解压缩压缩档案的参数； -z ： 是否需要用gzip压缩； -v： 压缩的过程中显示档案； -f： 置顶文档名，在f后面立即接文件名，不能再加参数 举例： 一，将整个/home/www/images 目录下的文件全部打包为 /home/www/images.tar [root@xoaocom ~]# tar -cvf /home/www/images.tar /home/www/images ← 仅打包，不压缩 [root@xoaocom ~]# tar -zcvf /home/www/images.tar.gz /home/www/images ←

用工具 WINISO53.zip[@more@]

FROM: http://msn.ynet.com/view.jsp?oid=37720049著名作家余华发表《悼魏东》，全文：　　余　华　　4月29日，这是平常的一天，因为你的突然离去，我必将终生铭记这一天。你是这样的一个朋友，值得我，值得很多人用一生的时间来不断回忆。有些人虽然活着，可是对他们的遗忘，也就意味着他们的不存在；你虽然辞世而去，可是你仍然活着，你会在我们的记忆里生生不息，而且历久弥新。如果这世上真的有人可以万寿无疆，你必然是其中的一个。　　魏东！我在写下你的名字时眼泪夺眶而出。因为你的名字在这一刻爆炸出无数往事，犹如夜空中的礼花

C:Documents and SettingsOracle.XP_ONE>set oracle_sid=orclC:Documents and SettingsOracle.XP_ONE>rman target /Recovery Manager: Release 10.2.0.1.0 - Production on Thu May 1 23:12:47 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: orcl (not mounted)RMAN> restore controlfile from 'c:3RJFA2A6_1_1';Starting restore at 08-05-01using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=156 devtype=DI

RMAN> catalog backuppiece2> 'D:oracleproduct10.2.0flash_recovery_areaORCLBACKUPSET2008_05_01O1_MF_NNNDF_TAG20080501T164457_41M0RB8C_.BKP';cataloged backuppiecebackup piece handle=D:ORACLEPRODUCT10.2.0FLASH_RECOVERY_AREAORCLBACKUPSET2008_05_01O1_MF_NNNDF_TAG20080501T164457_41M0RB8C_.BKP recid=97 stamp=653612555RMAN> run {2> set until logseq 17;3> set newname for datafile 1 to 'c:test_orcloradataSYSTEM01.DBF';4> set newname for datafile 2 to 'c:test_orcloradataUNDOTBS01.DBF';5&gt

先建立新用户并授权和 default tablespace quotaSQL> create user test identified by test; 用户已创建。 SQL> grant create session , connect to test; 授权成功。SQL> alter user test default tablespace tools;用户已更改。SQL> alter user test quota 50m on tools;用户已更改。C:Documents and SettingsAdministrator>exp userid=system/oracle@orcl owner=hr file=c:hr.dmpExport: Release 9.2.0.1.0 - Production on 星期三 4月 30 10:33:19 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights re

用 10G exp 导出 9I 数据时会报以下信息：D:oracleproduct10.2.0db_1BIN>exp userid=system/oracle@orcl owner=hrExport: Release 10.2.0.1.0 - Production on 星期三 4月 30 10:34:54 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.EXP-00056: 遇到 ORACLE 错误 6550ORA-06550: 第 1 行, 第 41 列:PLS-00302: 必须说明 'SET_NO_OUTLINES' 组件ORA-06550: 第 1 行, 第 15 列:PL/SQL: Statement ignoredEXP-00000: 导出终止失败D:oracleproduct10.2.0db_1BIN>[@more@]

i recall when i was young o i will play and always having fun with the neighbours next to me and we play until the setting sun try to be the best among the others in a game called spider battle it doesn't matter who is the best now those were days of my past a few years later when i go to school i was late for lessons all the time always daydreaming in the class till i don't even know the lesson is gone then my teacher always tell me never ever be lazy again what can i do now what can i say now

Hiding from the rain and snow, trying to forget but I won't let go. Looking at a crowded street, listening to my own heart beat. So many people all around the world Tell me where do I find someone like you, girl. Take me to your heart; take me to your soul; give me your hand before I'm old. Show me what love is, - haven't got a clue; show me that wonders can be true. They say nothing lasts forever, we're only here today; Love is now or never, bring me far away. Take me to your heart; take me to

Oracle Secure Backup Download Address :http://www.oracle.com/technology/software/products/securebackup/index.html[@more@]