ITPub博客

启动MYSQL[root@zhangruiu1 ~]# mysqld_safe &[1] 39558[root@zhangruiu1 ~]# 160520 20:40:35 mysqld_safe Logging to '/var/log/mysqld.log'.160520 20:40:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql[root@zhangruiu1 ~]# ps -ef | grep mysqlroot      43541 &nbs...

由于数据库异常down机造成undo数据文件损坏导致无法开库在将该undo数据文件剔除起库后重新创建undo文件后报下列错误：SQL> CREATE UNDO TABLESPACE undotbs_02 DATAFILE '/u01/app/oracle/oradata/PROD/undo01.dbf' SIZE 200m  REUSE AUTOEXTEND ON;CREATE UNDO TABLESPACE undotbs_02 DATAFILE '/u01/app/orac...

A physical standby database is an exact, block-for-block copy of a primary database. Aphysical standby is maintained as an exact copy through a process called Redo Apply,in which redo data received from a primary database is continuously applied to aphysical standby database using the database re...

1、关掉服务或本地监听srvctl stop service -d prod -s prod -n node1srvctl stop listener -n node12、查看VIP信息srvctl config vip -n node13、停止VIP资源进程srvctl stop vip -n node1查看是否已停止ifconfig -a4、更改VIP地址srvctl modify nodeapps -n mynode -A 192.168.6.202/255.255.255.0/eth0修改/e...

Crosschecks are useful because they can do the following:■ Update outdated information about backups that disappeared from disk or tape or became corrupted更新备份的过期信息■ Update the repository if you delete archived redo logs or other files with operating system commands如果之...

When the installer finds that the NTP protocol is not active, the Cluster Time Synchronization Service is installed in active mode and synchronizes the time across the nodes. If NTP is found configured, then the Cluster Time Synchronization Service is started in observer mode, and ...

4节点：bjscj1dw2.__db_cache_size=50465865728bjscj1dw3.__db_cache_size=45902462976bjscj1dw4.__db_cache_size=54492397568bjscj1dw1.__db_cache_size=46707769344bjscj1dw2.__java_pool_size=268435456bjscj1dw3.__java_pool_size=268435456bjscj1dw4.__java_pool_size=268435456bjscj1dw1.__java_pool_size=26...

错误如下：[oracle@node1 ~]$ emca -config dbcontrol db -repos create -clusterSTARTED EMCA at Apr 11, 2016 6:09:57 PMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle.  All rights reserved.Enter the following information:Database unique name: prod...

环境Linux 6.4Oracle Rac 11.2.0.4[root@web1 grid]# /u01/app/11.2.0/grid/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:    ORACLE_OWNER= grid    ORACLE_HOME=  /u01/app/11.2.0/grid...

在用户环境变量参数文件中需要加入以下参数信息umask 022含义为假如新建文件默认您访问权限是666,目录权限是777.在创建文件或目录时,系统把默认权限的值域umask的值相减,得到新建文件的访问权限(文件644,目录755).

   配置/etc/hosts时必须使用小写，如使用大写则会报此错误

##注册方法###注册方法:    在 注册时选择 License server ，填 http://idea.lanyus.com ，然后点击 OK

如果查看lun信息[root@BJLT2J1HDDB01 ~]# upadminUltraPath CLI #0 >UltraPath CLI #0 >show vlun------------------------------------------------------------------------------------------------------------------------------------------------- Vlun ID  Disk         &n...

A用户的过程如下：create or replace procedure ssasv_ename varchar(30);begin select ut.ename into v_ename from emp ut where rownum=1; dbms_output.put_line(v_ename);end;在A用户下执行此过程SQL> set serveroutput on SQL> exec ss;SMITHPL/SQL procedure successfully compl...

客户端的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（即每个硬盘在系...