Database Reference
In-Depth Information
Repeat the call to mkstore for all databases in the configuration. In the next step you need to make Oracle aware of the
wallet location. Edit the ~/tns_admin/sqlnet.ora file and add the following, changing the path to your wallet location.
SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION =
(SOURCE=
(METHOD = FILE) (METHOD_DATA =
(DIRECTORY=/home/oracle/tns_admin)
)
)
You can override the location where Oracle expects the net*8 configuration by setting the environment variable
TNS_ADMIN, as in the following:
[oracle@server1 ~]$ export TNS_ADMIN=/home/oracle/tns_admin
[oracle@server1 ~]$ tnsping $ORACLE_SID
TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 16-SEP-2013 00:23:55
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/home/oracle/tns_admin/sqlnet.ora
If all the databases in the configuration had their Broker services started by setting the initialization parameter
dg_broker_start to true, then you should be able to create a new configuration. The command used by Data Guard
Broker is called “create configuration.” The syntax is not too complex:
CREATE CONFIGURATION <configuration name> AS
PRIMARY DATABASE IS <database name>
CONNECT IDENTIFIER IS <connect identifier>;
Following our example, the configuration is created using the following little snippet:
[oracle@server1 ~]$ dgmgrl /@cdb1dca
DGMGRL for Linux: Version 12.1.0.1.0 - 64bit Production
Copyright (c) 2000, 2012, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected as SYSDBA.
DGMGRL> create configuration apress as
> primary database is "CDB1DCA"
> connect identifier is "CDB1DCA";
Configuration "apress" created with primary database "CDB1DCA"
DGMGRL>
Translated into plain English the Broker was instructed to create a new configuration, named apress using the
primary database CDB1DCA. The connection identifier should match an entry in tnsnames.ora . It will be used
whenever the Broker connects to a database in the configuration to query or modify properties. In the next step the
standby databases are added.
 
Search WWH ::




Custom Search