Oracle RAC issues and troubleshooting




-Relocating VIP to another node
----------------------------------

crsctl stop res ora.node1.vip
crsctl start res ora.node1.vip
crsctl stop res ora.node2.vip
crsctl start res ora.n0de2.vip
crsctl start res ora.node1.vip
crsctl relocate resource ora.node1.vip -n node1

--CRSD Not Starting uP
------------------------


ps -ef|grep crsd.bin
Next, check the status of ora.crsd, if offline try starting the CRS with ora.crsd:
crsctl stat res -t -init
crsctl start res ora.crsd -init

-- Starting Listener
------------------------

srvctl start listener -n node2

srvctl stop listener -n node1
srvctl stop scan_listener -i 1
srvctl stop scan_listener -i 3

--Start the LISTENER and LISTENER_SCAN2,LISTENER_SCAN3  from GRID_HOME
----------------------------------------------------------------------

srvctl start listener -n node1
srvctl start scan_listener -i 1
srvctl start scan_listener -i 2
srvctl start scan_listener -i 3

adding service for  DR setup
-----------------------------------


srvctl add service -db ERPDBA -service ERPDBA_HA -role PRIMARY -preferred ERPDBA1,ERPDBA2

Disable/Enable Oracle Services

srvctl disable service -d ERPDBA -s ERPDBA_HA
srvctl enable service -d ERPDBA -s ERPDBA_HA
srvctl stop service -d ERPDBA -s ERPDBA_HA
srvctl start service -d ERPDBA -s ERPDBA_HA


--- ** SRVCTL - CLuster start/stop ** -----

srvctl status instance -d ERPDBA -i ERPDBA1

srvctl stop instance -d ERPDBA -i ERPDBA1
srvctl stop instance -d ERPDBA -i ERPDBA2
srvctl start instance -d ERPDBA -i ERPDBA1
srvctl start instance -d ERPDBA -i ERPDBA2

srvctl status instance -d ERPDBA -i ERPDBA1
srvctl stop instance -d ERPDBA -i ERPDBA1 -o immediate
srvctl stop instance -d ERPDBA -i ERPDBA2 -o immediate

appsdbahelp

17+ years of experience in Oracle Database, Oracle Cloud Infrastructure(OCI), Oracle EBS on Cloud, Oracle E-Business Suite, DevOps tools, Oracle WebLogic, Oracle Application Server, Oracle Access Manager and various Operating System flavors including Redhat Linux, UNIX (Solaris, HP-UX) and Windows. Expert in Oracle9i/10g/11g/12c/19c database administration, upgrade, configuration and tuning. Experience in Oracle E-Business Suite technological stack, including architecture, installation, configuration, maintenance, tuning, cloning and patching procedures. Expert in Oracle Cloud Infrastructure(OCI), Oracle EBS On Cloud and Oracle EBS Cloud Manager Experience with Oracle Cloud Solution and Expert of Oracle ERP/Oracle HCM Cloud deployment Experience in Terraform, JSON and chef cloud infrastructure automation framework Knowledge of ASM, Data Guard, Real Application Cluster, Exadata and Exalogic Knowledge of Oracle Enterprise Manager(OEM) Grid Control, Oracle WebLogic, Oracle Internet Directory, Oracle Access Manager and Apache Ability to analyze problem, develops solutions and bring program/project execution to completion.

Post a Comment

Previous Post Next Post