convert cert.pfx to cer , key

Extract crt and key

openssl pkcs12 -in domain.pfx -clcerts -nokeys -out domain.crt
openssl pkcs12 -in domain.pfx -nocerts -nodes  -out domain.key 
openssl pkcs12 -in domain.pfx -out domain-ca.crt -nodes -nokeys -cacerts


Created pfx file from crt and key 

openssl pkcs12 -export -out nokey-domain.pfx -inkey domain.key -in domain.crt 

Disable bing.com

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NlaSvc\Parameters\Internet\EnableActiveProbing
change vule to 0

Installation failed; reason - load on module failed, failed to load security policy - Checkpoint Firewall

Running in  expert Mode


cpwd_admin stop -name FWM -path "$FWDIR/bin/fw" -command "fw kill fwm"
cpwd_admin start -name FWM -path "$FWDIR/bin/fwm" -command "fwm"

cpwd_admin stop -name CPD -path "$CPDIR/bin/cpd_admin" -command "cpd_admin stop"
cpwd_admin start -name CPD -path "$CPDIR/bin/cpd" -command "cpd"


check Process
cpwd_admin list

dell ERROR 1912 clear log

- reboot system
- ctrl+e login to iDRAC
- clear log

Configuration issues. "Quick stats on hostname is not up-to-date" vCenter 5.5

vpxd.quickStats.HostStatsCheck
vpxd.quickStats.ConfigIssues

To add the quickStats parameters to the Advanced Settings of the vCenter Server:

vpxd.quickStats.HostStatsCheck

Value: False

vpxd.quickStats.ConfigIssues

Value: False

reboot vCenter

Crontab delete Archivelog

#!/bin/bash

for i in DB1 DB2 ;
do
. oraenv << EOI
$i
EOI
rman target /   << EOI
sql "alter system switch logfile";
delete noprompt archivelog until time 'SYSDATE-7';
EOI
done;

Rebuid em on windows 2008 r2

open CMD as Administrator

set ORACLE_HOSTNAME=hostname
edit c:/windows/system32/driver/etc/host
ipaddress hosname

set ORACLE_UNQNAME=sid

emca -config dbcontrol db -repos recreate

Oracle Database Patchset 11.2.0.4

https://updates.oracle.com/ARULink/PatchSearch/process_form?bug=13390677

• 13390677 – 11.2.0.4 direct download link on MOS
• 742060.1 Release Schedule of Current Database Releases
• 880782.1 ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts
• 1562142.1 11.2.0.4 Patch Set – List of Bug Fixes by Problem Type
  • currently under construction!!!
  • 5479(!!!) BUGs are listed as fixed for now – will it be the MOST STABLE ?
• 1562139.1 11.2.0.4 Patch Set – Availability and Known Issues
  • document is under construction!!!
• 756671.1 Oracle Recommended Patches — Oracle Database
• 1392633.1 Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
• 1320966.1 Things to Consider Before Upgrading to 11.2.0.2 to Avoid Poor Performance or Wrong Results
• 1061295.1 Patch Set Updates – One-off Patch Conflict Resolution
• 837570.1 Complete Checklist for Manual Upgrades to 11gR2
• 785351.1 Oracle 11gR2 Upgrade Companion
• 1152016.1 Master Note For Oracle Database Upgrades and Migrations
• Oracle Database 11g Release 2 (11.2.0.3) New Features

Get Schemas size in Oracle

select owner, sum(bytes)/1024/1024 tsize
from dba_segments
group by owner
order by tsize desc;

netsh Command

# Add IP
netsh int ipv4 add address name="Local Area Connection 1" addr=10.114.1.35
 mask=255.255.255.240 skipassource=true

# List ip addresses
netsh int ipv4 show ipaddresses level=verbose

# Delete IP
netsh int ipv4 delete address "Local Area Connection 1" 10.114.1.35

rebuild em oracle

(MEIS) /export/home/oracle $ emca -config dbcontrol db -repos recreate

STARTED EMCA at Aug 6, 2013 11:22:20 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: MEIS
Listener port number: 1521
Listener ORACLE_HOME [ /data/oracle/product/11.2.0.2/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /data/oracle/product/11.2.0.2/dbhome_1

Local hostname ................ rman1
Listener ORACLE_HOME ................ /data/oracle/product/11.2.0.2/dbhome_1
Listener port number ................ 1521
Database SID ................ MEIS
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 6, 2013 11:22:50 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /data/oracle/cfgtoollogs/emca/MEIS/emca_
Aug 6, 2013 11:22:52 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 6, 2013 11:24:49 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug 6, 2013 11:24:50 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 6, 2013 11:30:10 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 6, 2013 11:30:16 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepos                                                                                                                                                             itory
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 6, 2013 11:31:16 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug 6, 2013 11:31:20 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 6, 2013 11:31:29 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 6, 2013 11:31:29 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 6, 2013 11:31:57 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 6, 2013 11:31:57 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://rman1:5500/em <<<<<<<<<<<
Aug 6, 2013 11:31:59 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /data/oracle/product/11.2.0.2/dbhome_1/rman1_MEIS/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 6, 2013 11:31:59 AM
(MEIS) /export/home/oracle $


emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

or

emca -deconfig dbcontrol db
emca -config dbcontrol db -repos recreate

Nesting FOR Command in Batch

FOR %A IN (1 2) DO FOR %A IN (A B) DO ECHO %A

Install agent EMC on Solaris 10 (Sparc)

Install EMC Agent: 

pkgadd -d HostAgent-Solaris-32-sparc-en_US-1.1.0.1.0366-1.pkg

pkgadd -d NaviCLI-Solaris-32-sparc-en_US-7.31.0.3.66-1.pkg
select l *

  
Edit Agent File:

vi agentID.txt
add
host
ip


ex:
nidadb.nida.ac.th
202.44.72.223

restart agent

/etc/init.d/agent stop
/etc/init.d/agent start


Install EMC PowerPath:

extact EMCPower.SOLARIS.5.3.P01.b009.tar

pkgadd -d .

install licence
cd /etc
emcpreg -add AAAA-BBBB-CCCC-DDDD-EEEE

./powercf -q  //verify device on host
./powermt config //verify device on host


set device policy as clariion open
=======================
powermt set policy=co dev=all
powermt save

Check HBA Port:

fcinfo hba-port

luxadm -e port

Hyper-V on ESXi5

- เปิด Service SSH ที่เครื่อง ESXi
echo ‘vhv.allow = “TRUE” ‘ >> /etc/vmware/config
- ติดตั้ง Windows 2012 ตามปกติ
- หลังจากติดตั้งเสร็จแล้วให้ไปแก้ไฟล์ .vmx ของ vmware guest ตัวที่เราติดตั้ง เช่น hyv-node-01.vmx
แก้บรรทัดคำสั่ง

    จาก guestOS = “Microsoft 2012″ หรือ ชื่ออื่น
    เป็น guestOS = “winhyperv”

เพิ่มบรรทัดคำสั่ง

    hypervisor.cpuid.v0 = FALSE

- สั่ง Power On Guest
- ติดตั้ง VMware Tools

credit:http://www.vmware.in.th/pumpith/vmware-%E0%B8%95%E0%B8%B4%E0%B8%94%E0%B8%95%E0%B8%B1%E0%B9%89%E0%B8%87-hyper-v-%E0%B8%9A%E0%B8%99-windows-2012-%E0%B9%83%E0%B8%99-esxi-5-1.html

awk + for shell

#!/bin/bash

ff=$(awk -F: '{print $1}' /etc/passwd | grep user )

for i in $ff ; do something in $i ; done

Get password from ORACLE local user

select dbms_metadata.get_ddl('USER', username) || '/' usercreate from dba_users where username like 'SCOTT';

select spare4 from user$ where name='SCOTT';

Install vSphere Client 5.1 on Windows 8

1. Use 7-zip to open the ~350MB executable and extract the contents
2. In Windows 8, run dotnetfx35.exe – it will prompt you to download and install .NET 2.0. I let it download and install the files it needed.
   Next, run vjredist64.exe (Assuming Windows 8 x64)
3. Right-Click VMware-viclient.exe, choose “Properties”
   On the “Compatibility” tab, check the “Run this program in compatibility mode for:” and choose “Windows 7″ from the list. Click “Ok”
4. Run the VMware-viclient installer as you normally would.

Uninstall AltirisAgent

C:\Program Files\Altiris\Altiris Agent>AeXAgentUtil.exe /uninstallagents /clean

VLAN Taging VMware

1.Virtual Switch Tagging (VST)
   - Trunk port set vlan 0
2.External Switch Tagging (EST)
   - Tag 802.1q Port to ESXi host
3.Virtual Guest Tagging (VGT)
  - Trunk port set vlan 4065 (all vlan)
  - Tag vlan on guest ( must install vmware tool driver )
  - set vlan id on device manager > network adapter > advance > vlan id

File Shared between Domain and Workgroup

@Domain Controller

Local Security Policy > Local Policies  > User Rights Assignment

access this computer from the network = everyone
Deny access to this computer from the network =! Guest , everyone

Local Security Policy > Local Policies  > Security Options

Network access: Let Everyone permissions apply to anonymous users = enable

Local Security Policy > Local Policies  > Security Options

Accounts: Limit local account use of blank passwords to console logon only : disable :df enable

ESXi Update Patch

esxcli --server=vmd-04.nida.local --username=root software vib update --depot=/vmfs/volumes/EMC_DataStore/Patch/ESXi510-201303001.zip

resize fast_recovery_area & clear archive log using RMAN

Resize fast_recovery area
==================
$ sqlplus / as sysdba

SQL>archive log list;
SQL>show parameter db_recovery_file_dest
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_
                                                 area
db_recovery_file_dest_size           big integer 8G

SQL> !du -ksh /u01/app/oracle/fast_recovery_area
  12G   /u01/app/oracle/c

SQL> alter system set db_recovery_file_dest_size=8G;
SQL> alter system switch logfile;


Clear Archive log used RMAN
=======================

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';

BACKUP FORMAT '/u02/rman_backup/%na_fullbackup_%U' TAG FULL_20130314 DATABASE PLUS ARCHIVELOG DELETE ALL INPUT;


Set Retention Policy
===============
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS ;

Enable-Mailbox used aSAMaccountName Exchange 2010

Used Exchange PowerShell

$mb = Get-User -OrganizationalUnit "domain.local/users" -RecipientTypeDetails User
$mb | Foreach{Enable-mailbox -Identity $_.Identity -Alias $_.sAMAccountName}

Delete Disconnect Mailbox in Exchange

Delete Disconnect Mailbox in Exchange

Get-MailboxStatistics -Database "Mailbox Database Name" | Where-Object {$_.DisconnectDate -Notlike $NULL} | FL DisplayName, DisconnectDate, MailboxGuid


copy MailboxGuid 

Remove-Mailbox -Database "Mailbox Database Name" -StoreMailboxIdentity MailboxGuid

Oracle application server 10

Os: solaris 10
Memory : 4G

Env:
User: oracle
Group: oinstall

Check memory
Prtconf | grep Mem

Create Project for install Oracle

Create Group

#groupadd oinstall
#groupadd dba
#groupadd oper

Create user

# useradd -g oinstall -G dba -d /export/home/oracle -s /usr/bin/bash oracle
# chown oracle:oinstall /export/home/oracle

Create Project

# projadd -U oracle -K "project.max-shm-memory=(priv,3g,deny)" user.oracle


Check Project Parameter

prctl -i project user.oracle
prctl -n project.max-shm-memory -i task `ps -o taskid= -p $$`

Edit Project Parameter

# projmod -sK "project.max-shm-memory=(priv,3g,deny)" user.oracle

Extract file

cpio –idmv < soa_Intel_Solaris_101310_disk1.cpio
cpio -idmv < soa_Intel_Solaris_101310_disk2.cpio

login to Console

./runInstaller

Error message

/export/home/oracle/sw/Disk1 $ ./runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be 5.9 or 5.10.    Actual 5.10
                                      Passed

Checking Temp space: must be greater than 250 MB.   Actual 11513 MB    Passed
Checking swap space: must be greater than 1535 MB.   Actual 11929MB    Passed
Checking operating system packages: SUNWarc,SUNWbtool,SUNWhea,SUNWlibm,SUNWlibms,SUNWsprot,SUNWtoo,SUNWi1of,SUNWxwfnt,SUNWi1cs,SUNWi15cs    Failed <<<<
    >>> Package SUNWi1cs is missing
    >>> Package SUNWi15cs is missing
Checking monitor: must be configured to display at least 256 colors    Failed <<<<
    >>> Could not execute auto check for display colors using command /usr/openwin/bin/xdpyinfo. Check if the DISPLAY variable is set.

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation, at which time they will be rechecked.

Continue? (y/n) [n]

Solve
pkgadd -d /cdrom/sol_10_910_x86/Solaris_10/Product SUNWi1cs SUNWi15cs

Oracle database 11g r2 Pre-Install on Solaris 10

User: oracle
Group: oinstall

Check memory
Prtconf | grep Mem

Create Group

#groupadd oinstall
#groupadd dba

Create user

# useradd -g oinstall -G dba -d /export/home/oracle -s /usr/bin/bash oracle
# chown oracle:oinstall /export/home/oracle

Create Project

# projadd -U oracle -K "project.max-shm-memory=(priv,4g,deny)" user.oracle
# projmod -sK "project.max-sem-nsems=(priv,256,deny)" user.oracle
# projmod -sK "project.max-sem-ids=(priv,100,deny)" user.oracle
# projmod -sK "project.max-shm-ids=(priv,100,deny)" user.oracle

Check Project Parameter

prctl -i project user.oracle
prctl -n project.max-sem-ids -i task `ps -o taskid= -p $$`

Edit Project Parameter

# projmod -sK "project.max-sem-nsems=(priv,256,deny)" user.oracle
# projmod -sK "project.max-sem-ids=(priv,100,deny)" user.oracle
# projmod -sK "project.max-shm-ids=(priv,100,deny)" user.oracle

Config Kernel Parameter in ‘/etc/system’

set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=300
set semsys:seminfo_semvmx=32767
set shmsys:seminfo_shmmax=2147483648
set shmsys:shminfo_shmmni=512
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmseg=150


Config Oracle env in ‘/export/home/oracle/.profile’

export PS1='($ORACLE_SID) $PWD $ '
export ORACLE_BASE=/u01/oracle
export ORACLE_OWNER=oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$PATH:/usr/openwin/bin:$ORACLE_HOME/bin:/usr/sbin:/usr/bin
export ORACLE_SID=EDCS1

Config Soft Limit $ Hard Limit in ‘/etc/system’
set max_nprocs=30000
set maxuprc=16384

ADD ndd config to '/etc/inittab'
tm::sysinit:/usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 9000 > /dev/console
tm::sysinit:/usr/sbin/ndd -set /dev/tcp tcp_largest_anon_port 65500 > /dev/console
tm::sysinit:/usr/sbin/ndd -set /dev/udp udp_smallest_anon_port 9000 > /dev/console
tm::sysinit:/usr/sbin/ndd -set /dev/udp udp_largest_anon_port 65500 > /dev/console


Install oracle DB
./runinstall

script-CHGPassword

dsquery

dsquery user OU=TestOU,DC=test,DC=int
dsmod user "CN=test01,CN=Users,DC=test,DC=int" -pwd A1b2C3d4 -mustchpwd yes

dsquery to dsmod

dsquery user OU=TestOU,DC=test,DC=int | dsmod  user -pwd A1b2C3d4 -mustchpwd yes

Password file
for /f “eol= tokens=1 delims=” %i in (c:\users.txt) do dsmod user “%i” –pwd <password> -mustchpwd yes –pwdneverexpires no

for /f “eol= tokens=1 delims=” %i in (c:\users.txt) do echo "%i"

for /F "tokens=1,2,* delims=, " %i IN (c:\user.txt) DO @echo user is %i passsword %j

for /F "tokens=1,2,* delims=, " %i IN (c:\tko.cvs) DO @echo user is %i passsword %j



Changepasswd by text file (delimeter,)

for /F "tokens=1,2,* delims=, " %i IN (c:\user.txt) DO dsquery user OU=TestOU,DC=test,DC=int -samid %i | dsmod user CN=%i,OU=TestOU,DC=test,DC=int -pwd %j -mustchpwd yes

for /F "tokens=1,2 delims=," %i IN (c:\user.txt) DO dsquery user OU=TestOU,DC=test,DC=int -samid %i | dsmod user -pwd %j -mustchpwd yes -pwdneverexpires no

for /F "tokens=1,2 delims=," %i IN (c:\user.txt) DO dsquery user OU=TestOU,DC=test,DC=int -samid %i | dsmod user -pwdneverexpires yes

NetAPP halt command

Shutdown NetApp

- login to NetApp SP-1
- halt -f
- login to netApp SP-2
- halt -f
- wait 5 minute and then turn off Controller 's swich and Disk Shellf

Exchange Pre-Install Setup

Start windows powershell as administrator

Import-Module ServerManager

Add-WindowsFeature NET-Framework,RSAT-ADDS,Web-Server,Web-Basic-Auth,Web-Windows-Auth,Web-Metabase,Web-Net-Ext,Web-Lgcy-Mgmt-Console,WAS-Process-Model,RSAT-Web-Server,Web-ISAPI-Ext,Web-Digest-Auth,Web-Dyn-Compression,NET-HTTP-Activation,RPC-Over-HTTP-Proxy -Restart

Set-Service NetTcpPortSharing -StartupType Automatic



Exchange admin privilege's user On Active Directory

schemas admin
enterprise admin

Netbackup Basic Comand

Netbackup Basic Comand
- nbemmcmd –getemmserver
- nbemmcmd –listhosts

Add ESXhost.local to host file ex. c:\windows\system\driver\etc\host

Delete credential host
- nbemmcmd –deletehost –machinename EXSHost.local –machinetype virtual_machine

Ghost device in VMware

To remove hidden and ghosted devices:
Click Start > Run, type cmd.exe, and click OK. The Command Prompt window opens.

Run this command:

    set devmgr_show_nonpresent_devices=1

Run this command to start Device Manager from this Command Prompt:

    devmgmt.msc

In Windows device manager

Click View > Show Hidden Devices.
Expand the Network Adapters tree.
Right-click the dimmed network adapter and click Uninstall.
Close the Device Manager.