Password manages and maintains the security management and maintenance of the part that has been operated. Cachegroup managing user password is not a complex change. However, this is used for production, and the poor comparison of easy leads to failure. Profile Click here to cachegroup Manage user password changes. Easy to get started brother learning.
1. Change the Sys.odbc.ini configuration file in the primary and standby node
$ cd $TT _home/info
$ VI Sys.odbc.ini
[$DSN]
oraclenetservicename=ora11g
ORACLEPWD=CGPASSWD # #此处即改动后的password
2. Stop the main and standby nodes cacheagent and replication
Master node:
$ ttadmin-cachestop $DSN
$ ttadmin-repstop $DSN
Or
Ttisql-connstr <DSN>-V 1-e "call Ttcachestop;bye;"
Ttisql-connstr <DSN>-V 1-e "call Ttcachestop;bye;"
Standby node:
$ ttadmin-cachestop $DSN
$ ttadmin-repstop $DSN
Or
Ttisql-connstr <DSN>-V 1-e "call Ttcachestop;bye;"
Ttisql-connstr <DSN>-V 1-e "call Ttcachestop;bye;"
3, in the TT Library main backup node synchronization change cache Group management user password:
Master node:
Ttisql-connstr <DSN>-V 1-e "Call Ttcacheuidpwdset (' cgadmin ', ' cgpasswd '); bye;"
Standby node:
Ttisql-connstr <DSN>-V 1-e "Call Ttcacheuidpwdset (' cgadmin ', ' cgpasswd '); bye;"
4. Open the Cacheagent and replication process:
Master node:
$ Ttadmin-cachestart $DSN
$ Ttadmin-repstart $DSN
Or
Ttisql-cachestart <DSN>-V 1-e "call Ttcachestart;bye;"
Ttisql-repstart <DSN>-V 1-e "call Ttcachestart;bye;"
Standby node:
$ ttadmin-cachestop $DSN
$ ttadmin-repstop $DSN
Or
Ttisql-connstr <DSN>-V 1-e "call Ttcachestart;bye;"
Ttisql-connstr <DSN>-V 1-e "call Ttrepstart;bye;"
5. Restart the cacheagent process again on the primary and standby node:
Master node:
$ Ttadmin-cachestart $DSN
$ Ttadmin-repstart $DSN
Or
Ttisql-cachestart <DSN>-V 1-e "call Ttcachestart;bye;"
Ttisql-repstart <DSN>-V 1-e "call Ttcachestart;bye;"
Standby node:
$ ttadmin-cachestop $DSN
$ ttadmin-repstop $DSN
Or
Ttisql-connstr <DSN>-V 1-e "call Ttcachestart;bye;"
Ttisql-connstr <DSN>-V 1-e "call Ttrepstart;bye;"
6. After restarting the cache group, execute the ttstatus command on the primary and standby node to check the cache group and the replication process execution status respectively.
$ttstatus
--Check the primary and standby replication and cache group Refresh status:
Ttisql-connstr <DSN>-V 1-e "call Ttbookmark;bye;"
Ttisql-connstr <DSN>-V 1-e "Select ' PERM ' type,
To_char (Round (perm_allocated_size/1024)),
To_char (Round (perm_in_use_size/1024)),
To_char (Round (perm_in_use_high_water/1024)),
To_char (Round (perm_in_use_size*100/perm_allocated_size,2))
From Sys.monitor
UNION ALL
Select ' TEMP ' type,
To_char (Round (temp_allocated_size/1024)),
To_char (Round (temp_in_use_size/1024)),
To_char (Round (temp_in_use_high_water/1024)),
To_char (Round (temp_in_use_size*100/temp_allocated_size,2))
From Sys.monitor;
Call Ttblockinfo;bye; "
7, change the TT end Cache Group management user password operation standard process
Log in to the master node and change the cache group management user password:
Master node:
$ ttisql $DSN
command> alter user cgadmin identified by "CGPASSWD";
User altered.
The command succeeded.
8, after the master node changes successfully. Login Standby node Authentication password:
$ttisql "dsn= $DSN; uid=cgadmin;pwd=szng!123"
Copyright (c) 1996-2011, Oracle. All rights reserved.
Type?
or ' help ' for help, type ' exit ' to quit Ttisql.
Connect "dsn=cbe;uid=ttcbe;pwd=szng!123";
Command>
At this point, the main standby password synchronization, change password success.
Precautions
9, check the master and standby synchronization
Check the primary and standby synchronization conditions via Ttisql-connstr <DSN>-v 1-e "call Ttbookmark;bye;" command.
Check Tterrors.log log Information
Check Cachegroup Refresh Status
=============end=================================================================
Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.
TimesTen Change cachegroup Management user Oracle end and TT End password "TimesTen operation and Repair base"
