Hi Guys,
Need your help.
In all of my 12cR2 RAC setup, the listener is listening to +APX service as it's automatically configured as part of local_listener in the APX instance.
Example, extracted from lsnrctl status listener:
Service "+APX" has 1 instance(s).
Instance "+APX1", status READY, has 1 handler(s) for this service...
However, I have this particular 12cR2 RAC setup and the listener doesn't listen to this service.
I need this to be in-placed basically for OEM monitoring for +APX instances.
When I check, I notice somehow the local_listener was not configured.
I tried to set it, but not able to (as below). Setting in scope=memory is fine but it is not permanent.
Kindly advise how can we do it for APX instances permanently?
grid@LINPROD01:/u01/app/grid/product/12cR2/dbs [+APX1]
> echo $ORACLE_SID
+APX1
grid@LINPROD01:/u01/app/grid/product/12cR2/dbs [+APX1]
> sqlplus "/as sysasm"
SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 6 09:00:01 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.28.184.81)(PORT=1621))' scope=BOTH;
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.28.184.81)(PORT=1621))' scope=BOTH
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
---> Not using PFILE either
grid@LINPROD01:/u01/app/grid/product/12cR2/dbs [+APX1]
> ls -ltr
total 24
-rw-r--r-- 1 grid oinstall 3079 May 15 2015 init.ora
-rw-r----- 1 grid oinstall 24 Mar 21 2018 lk_MGMTDB
-rw-rw---- 1 grid oinstall 3620 Jan 31 17:21 ab_+ASM1.dat
-rw-rw---- 1 grid oinstall 1544 Jan 31 17:21 hc_+APX1.dat
-rw-rw---- 1 grid oinstall 1544 Jan 31 17:22 hc_-MGMTDB.dat
-rw-rw---- 1 grid oinstall 1544 Jan 31 17:22 hc_+ASM1.dat