Tuesday, 29 October 2013

Convert logs to cvs with exclude some columns

Param (

$FILE_IN="access.log",
$FILE_OUT="access.csv",
$FILE_TMP="tmp.csv"
)

$datetime = get-date -f yyddMM-hhmm

cat $FILE_IN | where { $_ -match "^[0-9]"} | % { $_ -replace '\s+',"," } | foreach {Write-output "$(($_ -split ',')[1,4,5])" } | % { $_ -replace '\s+',"," } | Out-File -append -filePath $FILE_TMP

$FILE_OUT=$FILE_OUT.replace("csv",$datetime + ".csv")
Write-output $FILE_OUT
Copy-Item $FILE_TMP $FILE_OUT


Tuesday, 15 January 2013

RMAN-06059: expected archived log not found

If rman unable to find archivelog run crosscheck


change archivelog all crosscheck;


Monday, 31 December 2012

Tuesday, 18 December 2012

Recreate control file error ORA-01194:

How to recreate controlfile

http://oracleinstance.blogspot.com/2010/09/re-create-lost-controlfile.html


Monday, 5 November 2012

Weblogic clone/ change ip of manage server



BEA-090482 - BAD_CERTIFICATE


1. Disable Flags
Put the following flags at the right places.
Node Manager: -Dweblogic.nodemanager.sslHostNameVerificationEnabled=false
Admin Server: -Dweblogic.security.SSL.ignoreHostnameVerification=true

2. Recreate the Certificates - The recommended way.
Node manager by default uses the WebLogic demo identity keystore. The keystore is generated at install time using the CertGen utility. The generated private key uses the common name (cn) resolved by Java.

2.1 Set the PATH
. $WL_HOME/server/bin/setWLSEnv.sh

2.2 Backup DemoIdentity.jks under $WL_HOME/server/lib

2.3 Generate the private key.
java utils.CertGen -cn -keyfilepass DemoIdentityPassPhrase -certfile newcert -keyfile newkey

2.4 Import the key generated above to the keystore.
java utils.ImportPrivateKey -keystore DemoIdentity.jks -storepass DemoIdentityKeyStorePassPhrase -keyfile newkey.pem -keyfilepass DemoIdentityPassPhrase -certfile newcert.pem -alias demoidentity

2.5 Copy DemoIdentity.jks to $WL_HOME/server/lib

2.6 Restart your nodemanager.

Tuesday, 25 September 2012

Loop xargs

$ find . -iname "*.mp3" -print0 | xargs -0 -I mp3file mplayer mp3file

Connect to iscsi disk debian

List device
iscsiadm -m discovery -t st -p 192.168.42.236

192.168.42.236:3260,1 iqn.2012-08.sc-nas-004.istgt:disk1

Connect:
iscsiadm -m discovery -t st -p 192.168.42.236 "iqn.2012-08.sc-nas-004.istgt:disk2" --portal "192.168.42.236:3260" --login