Database Reference
In-Depth Information
7.
Clean up the current configuration in the database. Execute the following commands,
which need to be run from only
one
of the DB nodes.
[oracle@s1 ~]$
sqlplus apps
SQL>
exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
8.
Generate the new database context file on both database nodes by running the
adbldxml.
pl
utility from within the new
appsutil
directory, as in the following example. Adjust the
parameters as needed depending on which database node the utility is executed.
[oracle@s1 ~]$
cd $ORACLE_HOME/appsutil/bin
[oracle@s1 bin]$
adbldxml.pl appsuser=apps appspass=***
...
Enter Hostname of Database server:
s1
Enter Port of Database server:
1532
Enter SID of Database server:
PROD1
Enter Database Service Name:
PROD
Do you want to enable SCAN addresses[N]:
Y
Specify value for s_scan_name:
scan.odalab.com
Specify value for s_scan_port:
1521
Enter the value for Display Variable:
s1:0.0
The context file has been created at:
/u01/app/oracle/product/11.2.0.3/dbhome_3/appsutil/PROD1_s1.xml
Change the
s_virtual_hostname
and
s_db_listener
context parameters in both new
context files. Use the name of the new database listener, which was created in Step 5 of
this instruction list. The following example shows how the values are changed on
the first node:
9.
[oracle@s1 bin]$
egrep "s_virtual_hostname|s_db_listener" $ORACLE_HOME/appsutil/PROD1_s1.xml
<host oa_var="s_virtual_hostname">s1</host>
<DB_LISTENER oa_var="s_db_listener"></DB_LISTENER>
[oracle@s1 bin]$
vi $ORACLE_HOME/appsutil/PROD1_s1.xml
[oracle@s1 bin]$
egrep "s_virtual_hostname|s_db_listener" $ORACLE_HOME/appsutil/PROD1_s1.xml
<host oa_var="s_virtual_hostname">s1-vip</host>
<DB_LISTENER oa_var="s_db_listener">LISTENER_PROD</DB_LISTENER>
10.
Run the
adconfig.pl
utility on both nodes to create the initial configuration:
[oracle@s1 bin]$
perl adconfig.sh contextfile=$ORACLE_HOME/appsutil/PROD1_s1.xml
Enter the APPS user password:
...
AutoConfig completed successfully.
