|
by *) being used.
Enter value for temporary_tablespace:
Using tablespace TEMP as STDBYPERF temporary tablespace.
... Creating STDBYPERF user
... Installing required packages
... Granting privileges
NOTE:
SBCUSR complete. Please check sbcusr.lis for any errors.
SQL>
SQL> connect stdbyperf/&&stdbyuser_password
Connected.
SQL>
SQL> --
SQL> -- Build the tables
SQL> @@sbctab
SQL> Rem
SQL> Rem sbctab.sql
SQL> Rem
SQL> Rem Copyright (c) 1999, 2012, Oracle and/or its affiliates.
SQL> Rem All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem sbctab.sql
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem SQL*PLUS command file to create tables to hold standby database
SQL> Rem start and end "snapshot" statistical information
SQL> Rem
SQL> Rem NOTES
SQL> Rem Should be run as Standby Statspack user, stdbyperf
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem kchou 11/09/11 - Backport Bug#9695145 Missing Idle Events to
SQL> Rem Standby Statspack - RFI 10431923 Release 11.2.0.4
SQL> Rem kchou 11/09/11 - Backport kchou_bug-9695145 from main
SQL> Rem kchou 11/09/11 - Remove synonym STATS$IDLE_EVENT
SQL> Rem kchou 08/11/10 - Bug#9800868 - Add Missing Idle Events for
SQL> Rem 11.2.0.2for Statspack & Standby Statspack
SQL> Rem kchou 08/11/10 - Bug#9800868 - Add missing idle events to 11.2.0.2
SQL> Rem shsong 01/28/10 - add stats$lock_type
SQL> Rem shsong 08/18/09 - Add db_unique_name
SQL> Rem shsong 02/02/09 - remove stats$kccfn etc
SQL> Rem shsong 07/10/08 - add stats$kccfn etc
SQL> Rem shsong 02/28/07 - Fix bug
SQL> Rem wlohwass 12/04/06 - Created, based on spctab.sql
SQL> Rem
SQL>
SQL> set showmode off echo off;
If this script is automatically called from sbcreate (which is
the supported method), all STATSPACK segments will be created in
the STDBYPERF user default tablespace.
Using statspack_stdby tablespace to store Statspack objects
... Creating STATS$SNAPSHOT_ID Sequence
Sequence created.
... Creating STATS$... tables
Table created.
Table created.
Table created.
1 row created.
....
1 row created.
Commit complete.
View created.
NOTE:
SBCTAB complete. Please check sbctab.lis for any errors.
SQL>
SQL>
SQL> --
SQL> -- Add a standby database instance to the configuration
SQL> @@sbaddins
SQL> Rem
SQL> Rem sbaddins.sql
SQL> Rem
SQL> Rem Copyright (c) 2006, 2010, Oracle and/or its affiliates.
SQL> Rem All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem sbaddins.sql - Standby Database Statistics Collection Add Instance
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem SQL*PLUS command file which adds a standby database instance
SQL> Rem for performance data collection
SQL> Rem
SQL> Rem NOTES
SQL> Rem Must be run from standby perfstat owner, STDBYPERF
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem shsong 01/28/10 - remove v$lock_type
SQL> Rem shsong 08/18/09 - add db_unique_name to stats$standby_config
SQL> Rem shsong 03/04/07 - fix bug
SQL> Rem wlohwass 12/04/06 - Created
SQL> Rem
SQL>
SQL> set echo off;
The following standby instances (TNS_NAME alias) have been configured
for data collection
=== END OF LIST ===
THE INSTANCE YOU ARE GOING TO ADD MUST BE ACCESSIBLE AND OPEN READ ONLY
Do you want to continue (y/n) ----------------（添加备用节点）
Enter value for key: y
You entered: y
Enter the TNS ALIAS that connects to the standby database instance
-- |