ITPub博客

在测试服务器上，安装的mysql 5.5.14 测试人员在服务器上部署了apache、nginx、tomcat，并将整个/目录的权限设置为admin:admin在数据库上创建库时:mysql> create database `fmsivc0`;ERROR 1006 (HY000): Can't create database 'fmsivc0' (errno: 13)[root@b28-12181 servers]# ls -ltr总用量 104184drwx...

DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionOS:Oracle Linux 5.7非归档模式：SQL> archive log list;Database log mode              No Archive ModeAutomatic archival     ...

1、sbbdpt.o ssbbded.o bbedus.msb文件链接地址：     http://pan.baidu.com/s/1c0tHMCS2、DB:  Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production    OS:   Oracle Linux 5.73、[oracle@yoon lib]$ pwd/u01/oracle/produ...

mysql> show engine innodb status\G*************************** 1. row ***************************  Type: InnoDB  Name: Status: =====================================131226 17:12:38 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last...

OS:ORACLE-LINUX 5.7DB:11.2.0.3.0完全恢复查看现有的数据文件SQL> select name from v$datafile;NAME--------------------------------------------------------------------------------+DATA/yoon/datafile/system.256.823151193+DATA/yoon/datafile/sysaux.257.823151193+DATA/yoon/datafile/un...

之前为主从配置，后来分割成2个单实例。现在环境需要，重新配置为主从，之前参数都已配置好，直接启动，如下：mysql> change master to master_host='192.168.12.193',master_port=3306,master_user='master',master_password='123456',master_log_file='master-bin.000569',master_log_pos=107;ERROR 29 (HY000): Fi...

环境：OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production1、查看临时表空间信息：select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files;TABLESPACE FILE_NA...

SELECT TO_CHAR(s.sid)||','||TO_CHAR(s.serial#) sid_serial,NVL(s.username, 'None') orauser,s.program, r.name undoseg,t.used_ublk * TO_NUMBER(x.value)/1024/1024||'M' "Undo"FROM sys.v_$rollname r,sys.v_$session s,sys.v_$transaction t,sys.v_$parameter xWHERE s.taddr = t.addr AND r.usn = t.xidusn...

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production首先创建yoon数据库SQL> create tablespace yoon datafile '/u01/oracle/oradata/yoon/yoon01.dbf' size 50m;Tablespace created.SQL> create user...

RMAN> restore validate controlfile;Starting restore at 21-NOV-13using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=71 device type=DISKchannel ORA_DISK_1: starting validation of datafile backup setchannel ORA_DISK_1: readin...

OS:ORACLE-LINUX 5.71、下载"install_flash_player_11_linux.i386.tar.gz" 包2、自己创建个目录，解压[root@b28-122 flash]# tar -xvf install_flash_player_11_linux.i386.tar.gz3、查找插件目录[root@b28-122 mozilla]# find / -name mozilla/usr/lib64/mozilla/usr/share/mozil...

OS:ORACLE-LINUX 5.7DB：11.2.0.3[oracle@b28-122 ~]$ emctl status dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.3.0Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.https://b28-122.jd.com:1158/em/console/aboutApplicationOracle E...

约束是表中列的属性，用来维护数据结构完整性的一种手段约束的种类：NOT NULLUNIQUEPARIAMRY KEYFOREIGN KEYCHECKenble validate 检查现有数据和新数据是否符合约束enable novlidate 检查新数据是否符合约束disable validate 给表加锁disable novalidate 创建表的时候带有约束信息:create table e...

Oracle数据库表空间使用量查询：select b.file_name 物理文件名,b.tablespace_name 表空间,b.bytes/1024/1024 大小M,(b.bytes-sum(nvl(a.bytes,0)))/1024/1024 已使用M,substr((b.bytes-sum(nvl(a.bytes,0)))/(b.bytes)*100,1,5) 利用率from dba_free_space a,dba_data_files bwhere a.file_id=b.file_idg...

查看所有用户分区表及分区策略(1、2级分区表均包括)：SELECT p.table_name AS 表名, decode(p.partitioning_key_count, 1, '主分区') AS 分区类型,p.partitioning_type AS 分区类型, p.column_name AS 分区键,decode(nvl(q.subpartitioning_key_count, 0), 0, '无子分区', 1, '子分区') AS 有无子分区,q.subpartit...

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production添加控制文件：1.修改参数文件alter system set control_files = '/u01/oracle/oradata/yoon/control01.ctl','/u01/oracle/oradata/yoon/control03.ctl' scope=spfile;...

1、查看oralce是归档模式还是非归档模式SQL> select name,log_mode from v$database;NAME LOG_MODE---------------------------------------- ------------------------------------YOON ARCHIVELOGSQL> select name,log_mode from v$database;NAME LOG_MODE------------------------------------...

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production1、查看监听状态：SQL> !lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 12-NOV-2013 01:36:29Copyright (c) 1991, 2011, Oracle. All ...

jdbc 连接 oracle rac 的连接串如下：jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.210.100)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = devdb)))

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production一、在rman下启动和关闭数据库RMAN> shutdown immediateRMAN> startup二、现实rman默认配置信息RMAN> show all;RMAN configuration parameters for...