Power by


Solve Index Fragmentation SQL Server 2000

** Myself&Forum&MS tech

Index Fragmentation SQL Server 2000

Find Index Fragmentation Statistics by DBCC SHOW CONTIG

USE [DATABASE_NAME]
DBCC SHOWCONTIG('TABLE_NAME')

--or--
USE [DATABASE_NAME]
DBCC SHOWCONTIG('TABLE_NAME') WITH ALL_LEVELS, TABLERESULTS, NO_INFOMSGS


#Example on SAP table RESB
use DEV
go
dbcc showcontig ('dev.RESB')
Logical Fragmentation < 10% Do Nothing
10% < Logical Fragmentation <=30% (Reorganize by “DBCC INDEXDEFRAG”)
Logical Fragmentation >30% (Rebuild by “DBCC DBREINDEX”)
Reorganizing an Index [Online operation smaller granularity ]
DBCC INDEXDEFRAG ([DATABASE_NAME], [TABLE_NAME], [INDEX_NAME])
GO

Rebuilding an Index [Online operation Most index types can be rebuilt online ]
USE [DATABASE_NAME];
GO
ALTER INDEX [INDEX_NAME] ON [SCHEMA.TABLE]
REBUILD WITH (FILLFACTOR=[FILL_FACTOR_VALUE_BETWEEN_0_100], ONLINE=[ON|OFF]);
GO

-- Rebuild all indexes in a table with using parameters --

Oracle11G New Diagnostic directory for alert log and Listener log with SAP directory structure

** Myself
#New directory for alert log
#Oracle 8,9,10G Alert log
/oracle/<SID>/saptrace/background/alert_<SID>.log
/oracle/DEV/saptrace/background/alert_DEV.log


#Oracle 11G Alert log
/oracle/<SID>/saptrace/diag/rdbms/<sid>/<SID>/trace/alert_<SID>.log
/oracle/DEV/saptrace/diag/rdbms/dev/DEV/trace/alert_DEV.log






#New directory for Listener log
#Oracle 8,9,10G Listener log
/oracle/<SID>/<VERSION 3Digit>_<BIT>/network/log/listener.log
/oracle/DEV/817_32/network/log/listener.log
/oracle/DEV/920_64/network/log/listener.log
/oracle/DEV/102_64/network/log/listener.log


#Oracle 11G Listener log
/oracle/<SID>/saptrace/diag/tnslsnr/<server name>/listener/trace/listener.log
/oracle/DEV/saptrace/diag/tnslsnr/sever1/listener/trace/listener.log

Reset password of SAP* user back to "pass" default password (DB level)

** Myself
for MS SQL   -> SQL Analyzer  (Example user SAP* client 000)

delete from SAPSR3.USR02 where  bname='SAP*' and mandt='000' ;

Problems DBVERIFY Oracle 10.2.0.5/11.2.0.X (bad num_itls:,csc(aaaa.bbbb) higher than,itl[] has higher commit scn

** Myself & SAP Note 1566406

Symptom
dbv report errors related to transaction layer.
Following messages can be reported by dbveryfy:

"bad num_itls: <itlCount>"


"csc(aaaa.bbbb) higher than block scn(xxxx.yyyy)


"itl[<itl_id>] has higher commit scn(aaaa.bbbb) than block scn (xxxx.yyyy)"


"Control <csc> greater than block <block scn>"


"Slot[<slot>] greater than block <block scn> "
Page <pageno> failed with check code <CheckCode>

CheckCode can be:
6051 - bad block scn
6052 - bad objd
6053 - bad segment id
6054 - bad csc
6055 - bad free list link
6056 - bad itl scn
6057 - bad # itls



Reason and PrerequisitesStarting with Oracle 10.2.0.5, DBVerify has been enhanced to identify more
logical block corruptions in the transaction layer like SCN logical

Problem Veritas cluster (VCS) with LVM Linux LVMVolumeGroup Concurrency Violation or DiskReservation Agent and reservation conflict error

** Myself
#This solution for disable monitor Disk and LVM. for VCS 5.1/VCS4.1
haconf -makerw
hatype -modify DiskReservation OfflineMonitorInterval 0
hatype -modify LVMVolumeGroup OfflineMonitorInterval 0
hatype -modify LVMLogicalVolume OfflineMonitorInterval 0
haconf -dump -makero

How to disable the Host Intrusion Prevention(IDS) Mcafee disable self-protect mode

** Credit Web
Summary
This article describes how to disable the Host Intrusion Prevention client when a connection to the ePolicy Orchestrator (ePO) 4.x server is not available.
Due to agent self protection, the Host Intrusion Prevention client cannot be uninstalled using Add or Remove programs or by manually stopping the McAfee Host Intrusion Prevention service while IPS protection is enabled.
Solution 1
If the Host Intrusion Prevention clientUI default unlock password has not yet been changed, disable the Host Intrusion Prevention client manually by unlocking the Host Intrusion Prevention client UI tray:
  1. Click Start, Run, type explorer and click OK.
  2. Navigate to: C:\Program Files\McAfee\Host Intrusion Prevention\
  3. Double-click McAfeeFire.exe.
  4. Click Task, Unlock User Interface.
  5. Type the unlock code, and select Administrator Password.
    NOTE: By default, the unlock code is abcde12345
  6. After the user interface is unlocked, click the IPS Policy tab. 
  7. Deselect Enable Host IPS and Enable Network IPS. (The Firewall Policy can be disabled on its own tab.)
  8. Select Task, Exit.
Solution 2

Short Describes Oracle Release Numbers ....

** Refer OraDoc
Describes moving between different releases of the Oracle database server.  describes what each part of a release number represents.
Example of an Oracle Release Number
Loading