ITPub博客

---查询cursor_sharing目前值及可选值SQL> select name,value,isdefault from v$parameter_valid_values where name like '%cursor_sharing%'NAME          &nb...

--必须以创建job用户删除job，不然报ora-23421,任务不在任务列表中sqlplus wisdomone/systemspool /oracle/deletejob.sql--生成批量删除job脚本select 'exec dbms_job.remove('||job||');' from dba_jobs where sc...

--测试version_count相关原因--业务会话SQL> conn scott/systemConnected.SQL> create table t_version(a int);Table created.SQL> select count(1) from t_version;  COUNT(1)----------  &nbsp...

http://www.eygle.com/archives/2010/01/rman_validate_backup.html

http://hpux.connect.org.uk/hppd/hpux/Sysadmin/tusc-8.1/

http://blog.chinaunix.net/uid-8504518-id-3491104.html

http://www.linuxidc.com/Linux/2012-07/66514.htm

http://wenku.baidu.com/view/672fac2fb4daa58da0114a08.html

1,新增存储或虚拟硬盘2,fdisk 新盘3,以root对新盘配置权限     chown oracle:oinstall /dev/sdc1 --/dev/sdc1为新盘分区后的设备文件名     chmod 777 /dev/sdc14,su ...

http://blog.csdn.net/tianlesoftware/article/details/5467273

http://junfengwang060905.blog.163.com/blog/static/94223330201161412546791/

----备份数据文件5-bash-3.2$ rman target sys/systembackup datafile 5 format '/oracle/rmanbackup/backupwisdomone.dbf';----恢复数据文件5到新的位置-bash-3.2$ rman target sys/systemRecovery Manager: Rele...

 inux下使用rlwrap开源工具，可以在oracle sqlplus下具有linux下命令行功能。比如上下翻命令，等等。一、安装[root@cms2 ~]#unzip rlwrap-0.28.zip[root@cms2 ~]# cd rlwrap-0.28[root@cms2 rlwrap-0.28]...

--前期测试挂的disk /dev/sdb1一直mount不成功，也检查了/etc/fstab基本是正确--经查询,可以在操作系统启动时查看系统日志，一分析是文件系统搞清了，正确是ext2而非ext3[root@rhel5 oracle]# more /var/log/messag...

---启动oracle sqlplus报错bash-3.2$ sqlplussqlplus: error while loading shared libraries: /oracle/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Perm...

http://linux.chinaunix.net/techdoc/install/2008/06/29/1013918.shtml 处理： mount -o remount,rw /dev/sda1 / vi /etc/fstab

username:company username,my name +. + xingpassword:the same as bofore but the first zimu uppered

http://www.askmaclean.com/archives/howto-change-11gr2-asm-disk-path.html

[root@rhel5 ~]# touch /nbfile[root@rhel5 ~]# ls -l /nbfile -rw-r--r-- 1 root root 0 Jun  5 02:57 /nbfile--chattr命令简介[root@rhel5 ~]# chattr --helpUsage: chattr [-RV] [-+=AacDdijsSu] [-v versio...

---root家目录[root@rhel5 ~]# pwd/root----查看所有文件[root@rhel5 ~]# ls -latotal 128drwxr-x---  2 root root  4096 Jun  4 04:08 .drwxr-xr-x 28 root root  4096 Jun  5 02:24 .....