Listener failed
Team,
During a database activity, we did not freeze the cluster due to some reason,the listener went down due to the activity however database team has confirmed that DB is up and online.
Initially, when i tried to check the faulted resource it was not showing.But, when I tried to clear and online the listener resource, it went to Waiting_to_online and then it failed.
Could you please statehow we can resolve and make the listener online.
Below are the information,
A turks RUNNING 0
A madagascar RUNNING 0
-- GROUP STATE
-- Group System Probed AutoDisabled State
B ClusterService turks Y N OFFLINE
B ClusterService madagascar Y N ONLINE
B DB_TRS_PRD turks Y N OFFLINE
B DB_TRS_PRD madagascar Y N PARTIAL
-- RESOURCES FAILED
-- Group Type Resource System
D DB_TRS_PRD Netlsnr trsprd_LSNR madagascar
================================================================
Main.cf O/P -
/etc/VRTSvcs/conf/config/main.cf
include "OracleASMTypes.cf"
include "types.cf"
include "Db2udbTypes.cf"
include "OracleTypes.cf"
include "SybaseTypes.cf"
cluster TRS-PRD-MG (
UserNames = { admin = cmnFmhMjnInnLvnHmk,
rengasak = JiiMjeHljEikEdfDef,
g023154 = hifEfiEciGjiHhiP,
sparisd = aPPsMSnONjPNoNMlMR,
guptan2 = JljQifKmlNltHhkKliLi,
g035006 = hqqWrnQqqSqyPlqVns }
Administrators = { admin, rengasav, g023154, sparisd, guptau5, g035006 }
)
system turks (
)
system madagascar (
)
group ClusterService (
SystemList = { turks = 0, madagascar = 1 }
AutoStartList = { turks, madagascar }
OnlineRetryLimit = 3
OnlineRetryInterval = 120
)
NIC csgnic (
Device = en2
NetworkHosts = { "132.189.210.1" }
)
NotifierMngr ntfr (
SmtpServer = "mapintmail@infi.com"
SmtpRecipients = { "systemsunix@infi.com" = Error }
)
ntfr requires csgnic
// resource dependency tree
//
// group ClusterService
// {
// NotifierMngr ntfr
// {
// NIC csgnic
// }
// }
group DB_TRS_PRD (
SystemList = { madagascar = 0, turks = 1 }
Frozen = 1
)
IP trsprd_ora_vip (
Device = en2
Address = "132.189.210.138"
NetMask = "255.255.255.0"
)
LVMVG trsprd_ora_lvmvg (
VolumeGroup = db_trsprd
MajorNumber = 40
)
Mount db_trsprd_arch (
MountPoint = "/db_trsprd/arch"
BlockDevice = "/dev/trsprd_arch"
FSType = jfs2
FsckOpt = "-y"
)
Mount db_trsprd_backup (
MountPoint = "/db_trsprd/backup"
BlockDevice = "/dev/trsprd_backup"
FSType = jfs2
FsckOpt = "-y"
)
Mount db_trsprd_data1 (
MountPoint = "/db_trsprd/data1"
BlockDevice = "/dev/trsprd_data1"
FSType = jfs2
FsckOpt = "-y"
)
Mount db_trsprd_data2 (
MountPoint = "/db_trsprd/data2"
BlockDevice = "/dev/trsprd_data2"
FSType = jfs2
FsckOpt = "-y"
)
Mount db_trsprd_data3 (
MountPoint = "/db_trsprd/data3"
BlockDevice = "/dev/trsprd_data3"
FSType = jfs2
FsckOpt = "-y"
)
Mount db_trsprd_dba (
MountPoint = "/db_trsprd/dba"
BlockDevice = "/dev/trsprd_dba"
FSType = jfs2
FsckOpt = "-y"
)
Mount db_trsprd_oracle (
MountPoint = "/db_trsprd/oracle"
BlockDevice = "/dev/trsprd_oracle"
FSType = jfs2
FsckOpt = "-y"
)
Mount db_trsprd_redo1 (
MountPoint = "/db_trsprd/redo1"
BlockDevice = "/dev/trsprd_redo1"
FSType = jfs2
FsckOpt = "-y"
)
Mount db_trsprd_redo2 (
MountPoint = "/db_trsprd/redo2"
BlockDevice = "/dev/trsprd_redo2"
FSType = jfs2
FsckOpt = "-y"
)
Mount db_trsprd_temp (
MountPoint = "/db_trsprd/temp"
BlockDevice = "/dev/trsprd_temp"
FSType = jfs2
FsckOpt = "-y"
)
Netlsnr trsprd_LSNR (
Critical = 0
Owner = oracle
Home = "/db_trsprd/oracle/product/11.2.0.2"
TnsAdmin = "/var/opt/oracle"
Listener = LISTENER_TRSPRD
EnvFile = "/oracle/home/.profile"
)
Oracle trsprd_ORA (
Critical = 0
Sid = trsprd
Owner = oracle
Home = "/db_trsprd/oracle/product/11.2.0.2"
EnvFile = "/oracle/home/.profile"
)
Proxy trsprd_NIC (
TargetResName = csgnic
)
db_trsprd_arch requires trsprd_ora_lvmvg
db_trsprd_backup requires trsprd_ora_lvmvg
db_trsprd_data1 requires trsprd_ora_lvmvg
db_trsprd_data2 requires trsprd_ora_lvmvg
db_trsprd_data3 requires trsprd_ora_lvmvg
db_trsprd_dba requires trsprd_ora_lvmvg
db_trsprd_oracle requires trsprd_ora_lvmvg
db_trsprd_redo1 requires trsprd_ora_lvmvg
db_trsprd_redo2 requires trsprd_ora_lvmvg
db_trsprd_temp requires trsprd_ora_lvmvg
trsprd_LSNR requires trsprd_ORA
trsprd_LSNR requires trsprd_ora_vip
trsprd_ORA requires db_trsprd_arch
trsprd_ORA requires db_trsprd_backup
trsprd_ORA requires db_trsprd_data1
trsprd_ORA requires db_trsprd_data2
trsprd_ORA requires db_trsprd_data3
trsprd_ORA requires db_trsprd_dba
trsprd_ORA requires db_trsprd_oracle
trsprd_ORA requires db_trsprd_redo1
trsprd_ORA requires db_trsprd_redo2
trsprd_ORA requires db_trsprd_temp
trsprd_ora_vip requires trsprd_NIC
// resource dependency tree
//
// group DB_TRS_PRD
// {
// Netlsnr trsprd_LSNR
// {
// IP trsprd_ora_vip
// {
// Proxy trsprd_NIC
// }
// Oracle trsprd_ORA
// {
// Mount db_trsprd_temp
// {
// LVMVG trsprd_ora_lvmvg
// }
// Mount db_trsprd_backup
// {
// LVMVG trsprd_ora_lvmvg
// }
// Mount db_trsprd_arch
// {
// LVMVG trsprd_ora_lvmvg
// }
// Mount db_trsprd_redo2
// {
// LVMVG trsprd_ora_lvmvg
// }
// Mount db_trsprd_redo1
// {
// LVMVG trsprd_ora_lvmvg
// }
// Mount db_trsprd_oracle
// {
// LVMVG trsprd_ora_lvmvg
// }
// Mount db_trsprd_dba
// {
// LVMVG trsprd_ora_lvmvg
// }
// Mount db_trsprd_data2
// {
// LVMVG trsprd_ora_lvmvg
// }
// Mount db_trsprd_data1
// {
// LVMVG trsprd_ora_lvmvg
// }
// Mount db_trsprd_data3
// {
// LVMVG trsprd_ora_lvmvg
// }
// }
// }
// }
=======================================================