Password management has always been a part of operational security management, Cachegroup management user password Modification although not complex, but for production, modification is relatively easy to cause failure. Here is a description of Cachegroup management user password modification, easy to get started brother learning.
1. Modify 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 # #此处即修改后的密码
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. Synchronously modify the Cache group management user password in the main backup node of the TT library:
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 main 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 the cache group is successfully restarted, execute the ttstatus command on the primary and standby node to check the cache group and the replication process running state 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, modify the TT end Cache Group management user password operation standard process
Log in to the master node and modify the Cache Group Admin user password:
Master node:
$ ttisql $DSN
command> alter user cgadmin identified by "CGPASSWD";
User altered.
The command succeeded.
8, after the master node has been successfully modified, the 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, master and Standby password synchronization, change the password successfully.
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=================================================================
