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