Hi all, I'm a new Oracle user.
I need some tips about the following issue.
I've a Oracle-Linux 6 distro with the users:
ORACLE: uid=501(oracle) gid=501(oinstall) groups=501(oinstall),503(beoper),502(dba)
GRID: uid=500(grid) gid=501(oinstall) groups=501(oinstall),502(dba)
[grid]$ srvctl config listener -l listener_dbm2test
Name: LISTENER_DBM2TEST
Home: /u01/app/oracle/product/11.2.0/dbhome_1
End points: TCP:1524
[oracle@oradev scripts]$ ll /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
-rw-r--r-- 1 oracle oinstall 1830 Oct 11 15:05 /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
[oracle@oradev scripts]$ less /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
LISTENER_DBM2TEST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradev.lan.local)(PORT = 1524))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1524))
)
)
ADR_BASE_LISTENER_DBM2TEST = /u01/app/oracle
SECURE_REGISTER_LISTENER_DBM2TEST = (TCP)
SID_LIST_LISTENER_DBM2TEST =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DBM2TEST)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = DBM2TEST)
)
)
The following statements run without problems:
oracle > lsnrctl stop listener_DBM2TEST
oracle > lsnrctl start listener_DBM2TEST
oracle > ps -ef | grep tns
oracle 57943 1 0 15:59 ? 00:00:00 /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr listener_DBM2TEST -inherit
Instead if i try to use srvctl like grid user:
srvctl start listener -l LISTENER_DBM2TEST
I received this error:
PRCR-1079 : Failed to start resource ora.LISTENER_DBM2TEST.lsnr
CRS-5010: Update of configuration file "/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora" failed: details at "(:CLSN00014:)" in "/u01/app/11.2.0/grid/log/oradev/agent/ohasd/oraagent_grid/oraagent_grid.log"
CRS-2674: Start of 'ora.LISTENER_DBM2TEST.lsnr' on 'oradev' failed
cat /u01/app/11.2.0/grid/log/oradev/agent/ohasd/oraagent_grid/oraagent_grid.log
2017-10-11 16:03:36.439: [ AGFW][2564695808] {0:0:12637} Agent received the message: RESOURCE_START[ora.LISTENER_DBM2TEST.lsnr oradev 1] ID 4098:38097
2017-10-11 16:03:36.439: [ AGFW][2564695808] {0:0:12637} Preparing START command for: ora.LISTENER_DBM2TEST.lsnr oradev 1
2017-10-11 16:03:36.439: [ AGFW][2564695808] {0:0:12637} ora.LISTENER_DBM2TEST.lsnr oradev 1 state changed from: OFFLINE to: STARTING
2017-10-11 16:03:36.440: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] (:CLSN00107:) clsn_agent::start {
2017-10-11 16:03:36.440: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] LsnrAgent::start {
2017-10-11 16:03:36.440: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] getOracleHomeAttrib: oracle_home = /u01/app/oracle/product/11.2.0/dbhome_1
2017-10-11 16:03:36.441: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] CssLock::lock s_siha_mtex, got lock CLSN.listener.ora
2017-10-11 16:03:36.441: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] TNS ADMIN is set to /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/
2017-10-11 16:03:36.441: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] ConfigFile::getValue name enable_global_dynamic_endpoint_listener_dbm2test value
2017-10-11 16:03:36.442: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] (:CLSN00014:)Failed to open file /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
2017-10-11 16:03:36.442: [ AGENT][1631729408] {0:0:12637} UserErrorException: Locale is
2017-10-11 16:03:36.442: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] clsnUtils::error Exception type=2 string=
CRS-5010: Update of configuration file "/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora" failed: details at "(:CLSN00014:)" in "/u01/app/11.2.0/grid/log/oradev/agent/ohasd/oraagent_grid/oraage
nt_grid.log"
2017-10-11 16:03:36.442: [ AGFW][1631729408] {0:0:12637} sending status msg [CRS-5010: Update of configuration file "/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora" failed: details at "(:C
LSN00014:)" in "/u01/app/11.2.0/grid/log/oradev/agent/ohasd/oraagent_grid/oraagent_grid.log"
] for start for resource: ora.LISTENER_DBM2TEST.lsnr oradev 1
2017-10-11 16:03:36.442: [ AGENT][1631729408] {0:0:12637} UserErrorException: Locale is
2017-10-11 16:03:36.442: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] CssLock::unlock s_siha_mtex, released lock CLSN.listener.ora
2017-10-11 16:03:36.442: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] LsnrAgent::start Exception FileException
2017-10-11 16:03:36.442: [ AGFW][2564695808] {0:0:12637} Agent sending reply for: RESOURCE_START[ora.LISTENER_DBM2TEST.lsnr oradev 1] ID 4098:38097
2017-10-11 16:03:36.442: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] CRS-5010: Update of configuration file "/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora" failed: details a
t "(:CLSN00014:)" in "/u01/app/11.2.0/grid/log/oradev/agent/ohasd/oraagent_grid/oraagent_grid.log"
2017-10-11 16:03:36.442: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] LsnrAgent::start }
2017-10-11 16:03:36.442: [ora.LISTENER_DBM2TEST.lsnr][1631729408] {0:0:12637} [start] (:CLSN00107:) clsn_agent::start }
2017-10-11 16:03:36.442: [ AGFW][1631729408] {0:0:12637} Command: start for resource: ora.LISTENER_DBM2TEST.lsnr oradev 1 completed with status: SUCCESS
Can someone help me please?