Database Reference
In-Depth Information
The configuration of the database tier is completed. Now it's time to test whether the listener and the database
can be started from any of the database nodes using
srvctl
. Execute the commands
srvctl stop database -d PROD
and
srvctl stop listener -l LISTENER_PROD
to stop the services. Then execute
srvctl start listener -l
LISTENER_PROD and srvctl start database -d PROD
to start the services. Try these commands from one node, and
then from the other node. Check the listeners after each test to see how the database instances are registered.
Listing 11-20 shows correctly registered services for one of the SCAN listeners. Please observe the following
characteristics of a correct configuration:
•
Two services are registered, named
PROD
and
ebs_patch
(
ebs_patch
is used by the online
patching feature of e-Business Suite R12.2 to provide the connectivity to the “patch edition” of
the database).
•
Each service has two registered instances, in this case
PROD1
and
PROD2
.
•
Each instance is registered with the virtual address of a database server. There are two such
servers in the example, named
s1-vip.odalab.com
and
s2-vip.odalab.com
.
Listing 11-20.
Database Services Registered with SCAN Listeners
[grid@s2 ~]$
. oraenv
ORACLE_SID = [grid] ?
+ASM2
The Oracle base has been set to /u01/app/grid
[grid@s2 ~]$
ps -ef | grep "tns.*SCAN"
grid 19280 1 0 Oct07 ? 00:05:24 /u01/app/11.2.0.3/grid/bin/tnslsnr LISTENER_SCAN1
-inherit
grid 81264 79505 0 15:35 pts/1 00:00:00 grep tns.*SCAN
[grid@s2 ~]$
lsnrctl services LISTENER_SCAN1
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-OCT-2013 15:36:02
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
Services Summary...
Service "PROD" has 2 instance(s).
Instance "PROD1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s1-vip.odalab.com)(PORT=1532)))
Instance "PROD2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s2-vip.odalab.com)(PORT=1532)))
Service "ebs_patch" has 2 instance(s).
Instance "PROD1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s1-vip.odalab.com)(PORT=1532)))
Instance "PROD2", status READY, has 1 handler(s) for this service...
Handler(s):