Monday, July 30, 2012

SQL commands to know database and instance name

SQL> Select name from v$database;
SQL> select instance_name from v$instance;
SQL> select * from global_name;
SQL> select global_name from global_name

Sunday, July 29, 2012

Tmadmin commands to monitor and configure dynamically

Tmadmin has almost 50 commands, and broadly can be categorized into 7

1.Universal Device List and transaction log
2.Start, shutdown and modify part or all of the configuration
3.Monitor the configuration and its performance
4.Global Transactions
6.Servers and its Groups
7.Use other commands

TMAdmin is a command interpreter that provides monitor and modification of the bulletin board.The command requires the

TUXCONFIG environmental variable to set

We can administrator only ne tmadmin process at a time.There are two commandline options aviable

-r (readyonly)
-c(configuration mode)
-v tmadmin to display TUXEDO version number and license number

TMAdmin miscellanmous commands

defualt (d) set default values for arguments of other commands
dump(du) dump current bulletin board into a file
ech(e) echo input command lines
help (h) print command list or command syntax
pageinate(page) pipe output of commands to a pager
quite(q) terminte the session
verbose(v) show output in verbose mode
!! repeat previous shell command
Repeat last tmadmin command

Default (d)

The default command of tmadmin allows to default values to be set for serveral frequentlyu used parameters.

Tmadmin display parameter commands

bbparms(bbp) print a summary of bulletin board parameters

bbsread(bbls) list IPC resources on machine mid

serverparms(srp) print parameters of the specified server
serviceparms(scp) print parameters of the specified service

Tmadmin Statistics (Note format of stats is different in verbose on and off modes)

bbstats(bbs) print a summary of the bulletin board's statistics

printclient(pclt) print names and other information about active client processes

printgroup(pg) print server group table information

printnet(pnw) print count of messages in and out for specified machines; indicates if machine is partitioned
printqueue(pq) print information for a specified queue or all queues

printserver(psr) print information for a specified server or all servers

printservice(psc) print information for a specified service or all services

shmstats(sstats) Available in SHM mode only. Enable option for more exact

Managing the Configuration

Command(abbr) Description
aborttrans(abort) notify the coordinator of a transaction, or a participant, to abort it
committrans(commit) notify a participant of a decided transaction to commit heuristically
printtrans(pt) print information from the global transaction table
advertise(adv) add a service to the service table
unadvertise(unadv) remove a service from the service table
suspend(susp) remove a service from the list of those available. Server or queue identifiers can be used to broaden

the scope.

resume(res) return a suspended service to the list of those available Server or queue identifiers can be used to

broaden the scope.

changeload(chl) change the load specified for a service

changepriority(chp) change the priority specified for a service
changetrantime(chtt) change the time limit specified for a service
config(conf) make changes in TUXCONFIG

Managing Transactions(Global Transaction Table (GTT) ):

pt (print transactions) commands