Database Reference
In-Depth Information
$ sqlplus
app_user/secret@taf_net_svc.oradbpro.com
SQL> SET PAUSE "Hit enter to continue ..."
SQL> SET PAUSE ON
SQL> SELECT * FROM audit_actions;
Hit enter to continue ...
ACTION NAME
---------- ----------------------------
0 UNKNOWN
1 CREATE TABLE
…
As a DBA, verify that the TAF settings are in effect.
SQL> SELECT inst_id, sid, serial#, audsid, logon_time, service_name,
failover_type, failover_method, failed_over
FROM gv$session
WHERE username='APP_USER';
INST_ID SID SERIAL# AUDSID LOGON_TIME SERVICE_NAME FAILOVER_TYPE
------- --- ------- ------ ------------------- ------------ -------------
2 143 4139 120036 05.08.2007 19:27:58 TAF_INST_SVC SELECT
FAILOVER_METHOD FAILED_OVER
--------------- -----------
BASIC NO
Now stop the service on instance 2 that hosts the client (
INST_ID=2
in the result of the
preceding
SELECT
). The name of instance 2 is TEN2. A service may be stopped from any instance in
the cluster.
SQL> EXEC dbms_service.stop_service('TAF_INST_SVC', 'TEN2')
PL/SQL procedure successfully completed.
This removes the service from instance 2 in
GV$ACTIVE_SERVICES
:
SQL> SELECT name FROM gv$active_services WHERE inst_id=2;
NAME
------------------
TEN.oradbpro.com
SYS$BACKGROUND
SYS$USERS
It also removes the instance TEN2 from the listener's services summary.
$ lsnrctl services listener_dbserver1
…
Service "taf_inst_svc_net_name.oradbpro.com" has 1 instance(s).
Instance "TEN1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
