Hello,
I've created new service using dbms_service.start_service as described here: http://uhesse.com/2009/08/19/connect-time-failover-transparent-application-failover-for-data-guard/
On the test system it's working fine, but when I made the same things on production, I see that new service is not listed in the results of
lsnrctl status
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string TWO
db_unique_name string TWO
global_names boolean FALSE
instance_name string TWO
lock_name_space string
log_file_name_convert string
service_names string TWOLIVE, TWONLINE
lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 25-DEC-2012 14:10:03
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.x.xxx)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Start Date 24-DEC-2012 17:38:15
Uptime 0 days 20 hr. 31 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /home/oracle/ora11_r2.2/network/admin/listener.ora
Listener Log File /home/oracle/diag/tnslsnr/nvtwo/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.xx)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yy.yy.yy.yy)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "TWO" has 1 instance(s).
Instance "TWO", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
I've used, for instance:
SQL> begin
2 dbms_service.create_service('TWONLINE', 'TWONLINE');
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> begin
2 dbms_service.start_service('TWONLINE');
3 end;
4 /
PL/SQL procedure successfully completed.
It's single instance database, and I have no ideas what to check. Please help me.
Edited by: viconstg on 25.12.2012 15:00