startup and shutdown RAC ===========启动rac的顺序===========1.正常情况下，系统启动时，crs会自动带起来，不需要进行任何操作，如果发现crs没有起来，则可以使用以下命令进行操作# /etc/...
Data Guard RMAN-04006 和 ORA-01017 错误诊断 RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied...
yum 安装 rlwrap 1. 安装epel包，对于centos6可以使用以下命令行 yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.n...
查看哪个SP调用了对应的表 1.查询某个表被哪些存储过程（以下简称 SP）使用到 :select distinct object_name(id) from syscomments where id in(select obje...
rebuild index which avg_fragmentation_in_percent >30 点击(此处)折叠或打开 select 'ALTER INDEX ['+ind.name+'] ON [dbo].['+OBJE...
如何处理带有引号文本限定符的CVS 公司需要导入数据到MSSQLSERVER，但是对方给出的奇葩cvs文件是这样的:aa,bb,cc,dd,ee1,"thisis a",1,"this is a",12,"this is" a",2,"t...
lsnr配置报错use another port number 今天在配虚拟机oracle lsnr的时候老遇到 use another port number: the information provided for this listener is current...
SQLSERVER查看各磁盘可用空间 保存数据的表create table dc_DiskDetaill(Drive varchar(10),Size varchar(50),FreeSize varchar(50),Ge...
Sql Server 查看所有存储过程或视图的位置及内容 select a.name,a.[type],b.[definition] from sys.all_objects a,sys.sql_modules b where a.is_ms_shipped=0 and a.objec...
Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" 如何更改SQLSERVER2000的排序规则AlterdatebaseAlterdatebase数据库Chinese_PRC_BINALTERTABLEtbALTERCOLUMN...
how to modify the ENDPOINT_URL for Alwayson ALTER AVAILABILITY GROUP shdmag05modify replica on 'SH-DM-DB05'with( ENDPOINT_URL ='TCP://192.168.100.91:502...
db mirror delay SET NOCOUNT ONEXEC msdb.sys.sp_dbmmonitorupdate DECLARE @Cursor_MirroredDatabases CURSORDECLARE @command CHA...
创建ID和权限控制 USE [master]GOCREATE LOGIN <user name> WITH PASSWORD=,DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, ...
XML初次接触 with xmlnamespaces(default 'http://schemas.microsoft.com/sqlserver/2008/sqlaudit_data')SELECT top 5 CO...
关注
