ITPub博客

错误原因：由于操作系统没有开启默认共享，导致Oracle无法检查环境可用性解决方法：1、在运行中（或键盘按 Win+R）输入regedit打开注册表，找到HKEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesLanmanServerParameters 选中Parameters，在右边名称中找到AutoShareWks 项，在其右键菜单中 ，点击修改，将其“数值数...

一主一从步骤：1、配置master主机的my.cnf，配置内容如下：[mysqld]user=mysqlpid-file=/var/run/mysqld/mysqld.pidsocket=/var/run/mysqld/mysqld.sockport=3306basedir=/usrdatadir=/var/lib/mysqltmpdir=/tmplog-bin=master-binlog-bin-index=master-bin.indexserver-id=1配置完之后重启，使my.cn...

#filename:dirfilerepl.py#功能：批量更新指定目录下的所有文件的指定字段import os,sys#path='D:\ctl'def replfile(path):  for dirpath,dirs,filenames in os.walk(path):    #for dirpath,dirs,filenames in os.walk(path):        for file in filenames:    &nb...

This procedure displays the call stack at the point where an exception was raised, evenif the procedure is called from an exception handler in an outer scope. The output issimilar to the output of the SQLERRM function, but not subject to the same sizelimitation. SyntaxDBMS_UTILITY.FORMAT...

database buffer cache 通过db_cache_size和SGA_target来控制。默认值：If SGA_TARGET is set: If the parameter is not specified, then the defaultis 0 (internally determined by the Oracle Database). If the parameter isspecified, then the user-specified value indicates a minimum value forthe memory ...

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) （直接使用mysql登陆）ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)（使用-u-p登陆，但密码错误）忘记密码：/etc/init.d/mysql stopmysqld_safe --user=mysql --skip-grant-...

You can use the information in the CHAINED_ROWS table to reduce or eliminate migratedand chained rows in an existing table. Use the following procedure.1. Use the ANALYZE statement to collect information about migrated and chainedrows. ANALYZE TABLE order_hist LIST CHAINED ROWS;2. Quer...

Valid for ReplicatUse the HANDLECOLLISIONS and NOHANDLECOLLISIONS parameters to control whether or notReplicat tries to resolve duplicate-record and missing-record errors when applying SQL onthe target. These errors can occur during an initial load, when data from source tables isbeing loaded t...

 建立计划任务，实现自动备份 1. 开启块跟踪 [oracle@aix213 ~]$sqlplus / as sysdba  SQL*Plus:  Release  10.2.0.1.0  -  Production  on  Tue  Jun  17 14:24:48 2014  Copyright (c) 1982, 2005, Oracle.  All rights ...

Running the rootcrs.pl command flags -deconfig -force enables you todeconfigure Oracle Clusterware on one or more nodes without removing installedbinaries. This feature is useful if you encounter an error on one or more cluster nodesduring installation when running the root.sh command, such as...

1、网站oracle数据（192.168.4.17）（月中需要清理） 1）数据内容：    中国标准服务网网站数据库，包括开发的网站用户及订单系统数据、网站信息发布系统trswcm的数据及专家系统数据。 2）存放位置192.168.4.17：/disk/backup/oracle_backup/10.3.1.1：/oracle/expdata/new_expdata/下对应的月份...

SCN_TO_TIMESTAMP :PurposeSCN_TO_TIMESTAMP takes as an argument a number that evaluates to a systemchange number (SCN), and returns the approximate timestamp associated with thatSCN. The returned value is of TIMESTAMP data type. This function is useful any timeyou want to know the timestamp a...

select * from fn_dblog('','')

文件格式如下：1$一地在要工$1$修改长度可以用（修改长度，要保证不短与已有数据，以保证原有数据不出错）2$一地在要工$0$修改长度可以用（修改长度，要保证不短与已有数据，以保证原有数据不出错）3$一地在要工$1$修改长度可以用（修改长度，要保证不短与已有数据，以保证原有数据不出错）4$一地在要工$0$修改长度可以...

When you drop a table, the database does not immediately remove the spaceassociated with the table. The database renames the table and places it and anyassociated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time. This feature is call...

restore headeronly from disk='D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\scott.bak'

通过内容进行过滤grep 关键字 文件名如下：[root@source ~]# cat anaconda-ks.cfg # Kickstart file automatically generated by anaconda.#version=DEVELinstallcdromlang en_US.UTF-8keyboard usnetwork --onboot no --device eth0 --bootproto dhcp --noipv6rootpw  --iscrypted $6$JvEQdLOWp...

CREATE VIEW v_user_viewas(SELECT uu_uugr_ug_uo_ugrr_ur.id,uu_uugr_ug_uo_ugrr_ur.groupid,uu_uugr_ug_uo_ugrr_ur.groupname,uu_uugr_ug_uo_ugrr_ur.identifier,uu_uugr_ug_uo_ugrr_ur.username,uu_uugr_ug_uo_ugrr_ur.account,uu_uugr_ug_uo_ugrr_ur.password,uu_uugr_ug_uo_ugrr_ur.position,uu_uugr_ug_uo...

查看虚拟机编辑器中Nat模式下的网关，如下图所示将虚拟机的网关全部设置为192.168.206.2即可