ITPub博客

客户端的exp大版本必须与服务器端的大版本保持一致如果客户端版本过低，导入的时候会报 ORA-03120:two-task conversion routine:integer overflow过程如下：C:\Users\CSS115>exp hx_user/hxuser4655@134.12.81.7/sxlthxqf tables=yspz_xmlsjb_0420Export: Release 11.2.0.1.0 - Production on 星期五 4月 ...

超过2T的磁盘分区无法使用fdisk工具，可以使用parted工具进行操作

[oracle@kf210 ~]$ cat c.sh cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ init/rm *cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ table/rm *cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/02\ view/rm *cd /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/04\ procedure/rm *c...

[oracle@kf210 ~]$ cat count.shecho J1_G3_ZBQls -l /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/04\ procedure/ |grep "^-"| wc -lls -l /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ init/ |grep "^-"| wc -lls -l /u01/app/oracle/admin/QJBJ1DW/dpdump/j1_g3_zbq/01\ table/ |grep "^-"| wc -lls -l...

一直都说LVM可以在线增加空间，一直都没有试过 下面小试一下： 1.增加硬盘 2.创建PV 3.添加PV到VG 4.扩展LV 1.增加硬盘 该干嘛干嘛 添加后需要重启（有知道不用重启的办法吗） Sql代码  --这个是新添加的硬盘  ...

外部存储设备中的同一块磁盘，在不同的节点中名称可能是不一样的，如同一块磁盘，在第一个节点中的名称是hdisk5,在第二个节点中的名称可能是hdisk4。虽然ASM实例能够正确识别出这样的硬盘，但这种情况在一定程度上可能对管理员造成困惑。不管怎样，这块硬盘有一个属性在不同节点中是相同的，那就是它的PVID（即每个硬盘在系...

 环境：两个双节点RAC  主库：Hostname=rui1,rui2db_name=proddb_unique_name=primaryinstance_name=prod1,prod2service_names=primary 备库：hostname=zhang1,zhang2db_name=PRODdb_unique_name=standbyinstance_name=std1,std2se...

The Data Recovery Advisor workflow begins when you either suspect or discover afailure. You can discover failures in many ways, including error messages, alerts, tracefiles, and failed data integrity checks. the database can automatically diagnose failures when errors occur.The basic proc...

[root@node2 ~]# cat /home/grid/.bash_profile # .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then        . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHexport EDITOR=viexport ORACLE_SID=+ASM2...

场景：11.0.3.0-->11.0.4.0基于rman备份的恢复错误代码：ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADECause: The database was mounted for SHARED cluster access.解决方法：Set the CLUSTER_DATABASE initialization parameter to FALSE and restart the server w...

Enabling or Disabling the Standard Audit TrailYou enable the standard audit trail by setting the AUDIT_TRAIL initialization parameter. This setting determines whether to create the audit trail in the database audit trail, write the audit activities to an operating system file, or to di...

错误：通过emctl status dbconsole启动数据库em时起不来，有如下提示：Unable to determine consoleport. /u01/app/product/11.2.0/db_1/oc4j/j2ee/oc4j_dbconsole_orcle11g_orcl/config/*web_site.xml not found. No such file or directory解决方案：使用telnet 验证端口号 OEM端口号默认为1158，验证1158端口号...

kill掉此进程的父进程ppid的占用即可

In some situations, a business cannot afford to lose data regardless of the circumstances. In other situations, the availability of the database may be more important than any potential data loss in the unlikely event of a multiple failure. Finally, some applications require maximu...

1、  开闪回idle>alter database flashback on; Database altered. idle>select flashback_on fromv$database; FLASHBACK_ON------------------YES开闪回归档idle>create flashback archive fba1tablespace example quota 500m retention 1 year;...

第一步：查看RAC的server pool是基于admin-managed还是基于policy-managed[grid@node2 ~]$ srvctl config database -d prodDatabase unique name: prodDatabase name: prodOracle home: /u01/app/oracle/product/11.2.0/db_1Oracle user: oracleSpfile: +ORADATA/prod/spfileprod.oraDomain: Start options: ...

dbca -silent -createDatabase -templateName /tmp/Data_Warehouse.dbc -gdbname ora11g -sid ora11g -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 40 -emConfiguration LOCAL-templateName  模板路径+文件名-gdbname         全局数据库名-sid       &...

  mysql安装   1.1 Linux之下MySQL安装的三种方案的比较 具体内容参考这篇blog： http://blog.itpub.net/8183550/viewspace-680749/   一.1  windows 下安装(mysql-5.6.21-win32) 一.1.1  mysql server 安装   1登录   http://dev.mysql.com/downloads/   2进...

 隐隐约约感觉到学数据库多多少少以后会涉及到mysql，好吧，那就趁着现在工作不是很忙的时间抽空来学学mysql吧，把这几天视频中学习到的知识和笔记整理了一下发出来大家共同学习。。。 MySQL 5.6.21最新版下载    MySQL Enterprise Edition (commercial) 商业版第一步：登录mysql的官方网站htt...

Task 1: Determine if Platforms are Supported and Determine EndiannessThis task is only necessary if you are transporting the tablespace set to a platform different from the source platform.这步骤只是跨平台的时候才是必须If you are transporting the tablespace set to a platform different from t...