Dynamic Management Views

http://www.sqlteam.com/article/dynamic-management-views

Solaris Containers

http://www.datadisk.co.uk/html_docs/sun/solaris_zones.htm

Changing the IP on Solaris 10 requires editing two files:

Changing the IP on Solaris 10 requires editing two files:

1. /etc/hosts
2. /etc/inet/ipnodes

If you are changing network address, you will need to change the router address in the file:
1. /etc/defaultrouter

Changing the hostname now only requires editing these files:

1. /etc/hosts
2. /etc/nodename
3. /etc/hostname.

is the driver name followed by the instance number of the interface. ie. hme0, bge0, ce0, qfe0

You can find all your network interfaces by drivername and instance# by running the following command: prtconf -D | grep network

Note: the following hosts files are no longer used in solaris 10.
/etc/net/ticlts/hosts
/etc/net/ticots/hosts
/etc/net/ticotsord/hosts

Rebooting the computer should bring up the new ip and hostname.

uname -S `hostname`

OEM reconfiguration:

emca -config dbcontrol db -repos recreate

STARTED EMCA at Apr 28, 2010 1:25:15 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: y
Listener port number: 1521
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 ................ /oracle/oracle/product/10.2.0/db_1

Database hostname ................ solaris2
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 28, 2010 1:25:33 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/oracle/product/10.2.0/db_1/cfgto ollogs/emca/orcl/emca_2010-04-28_01-25-14-PM.log.
Apr 28, 2010 1:25:34 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Apr 28, 2010 1:25:36 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Apr 28, 2010 1:27:12 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Apr 28, 2010 1:27:13 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 28, 2010 1:30:24 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 28, 2010 1:30:29 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 28, 2010 1:32:04 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 28, 2010 1:32:04 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://solaris2:5500/em <<<<<<<<<< <
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 28, 2010 1:32:04 PM

MSTSC

So instead of calling mstsc /console /v:servername
you should now use mstsc /admin /v:servername.

Updating Ip addresses of windows clustering and sql server on Windows Server 2003 with SAN

disable sql server clustering services ( manual)
disable mstdc servcies ( manual)
disable windows clustering services( automatic)
turn off machines
turn on machines
change ip address of two nodes(public and private)
start one node clustering service
connect windows cluster wiht local connection (.)
update windows cluster's ip address
start another node's clustering service ( automatically sychnchronize clusserting information)
update msdtc service's ip address
update sql server clustering's ip address