During upgrade from 11.2.0.4 to 12.2.0.1 Grid infra we were facing below error at the time on running root upgrade 2017/11/28 19:48:28 CLSRSC-180: An error occurred while executing the command 'srvctl enable listener -listener -node node1' Died at /u02/app/12.2.0.1/grid/crs/install/orasrvm.pm line 1039. The command '/u02/app/12.2.0.1/grid/perl/bin/perl -I/u02/app/12.2.0.1/grid/perl/lib -I/u02/app/12.2.0.1/grid/crs/install /u02/app/12.2.0.1/grid/crs/install/rootcrs.pl -upgrade' execution failed to resolve it we fix … Continue reading CLSRSC-180: An error occurred while executing the command ‘srvctl enable listener -listener -node node1’
Downgrade from 12.2.0.1 to 11.2.0.4 Grid Infrastructure
Take output of below commands before starting downgrade /u02/app/12.2.0.1/grid/bin/ocrcheck /u02/app/12.2.0.1/grid/bin/crsctl status resource -t We have Three node of RAC 1. Delete the Oracle Grid Infrastructure 12c Release 2 (12.2) Management Database: /u02/app/12.2.0.1/grid/bin/dbca -silent -deleteDatabase -sourceDB -MGMTDB 2. as a root user You can run below commands in parallel on node 3 and node 2, but … Continue reading Downgrade from 12.2.0.1 to 11.2.0.4 Grid Infrastructure
Configure DNS on Solaris 11
We are creating DNS server to resolve our SCAN names. Our DNS server IP is 198.0.60.5 Domain name we are keeping as "testdomain dnshostname is hostname of DNS server On DNS ServerOn DNS Server Vi /etc/named.confVi /etc/named.conf options { directory "/etc/namedb/working"; pid-file "/var/run/namedb/pid"; dump-file "/var/dump/named_dump.db"; statistics-file "/var/stats/named.stats"; forwarders { 198.0.60.5; }; }; zone "testdomain" { … Continue reading Configure DNS on Solaris 11
How to add Local Listener in RAC
We can have more than 1 local listener in RAC. and each will have different port. srvctl add listener -l listener_01 -o /u01/app/11.2.0.4/grid -p 1901 srvctl add listener -l listener_02 -o /u01/app/11.2.0.4/grid -p 1902 srvctl start listener -l listener_01 srvctl start listener -l listener_02 srvctl status listener -l listener_01 srvctl status listener -l listener_02 … Continue reading How to add Local Listener in RAC
ORA-15025: could not open disk “/dev/oracleasm/disks/D1”
Getting below error in database alert logs when starting the database. database version is 11.2.0.4 NOTE: Loaded library: System ORA-15025: could not open disk "/dev/oracleasm/disks/D1" ORA-27041: unable to open file Linux-x86_64 Error: 13: Permission denied Additional information: 9 ORA-15025: could not open disk "/dev/oracleasm/disks/D2" ORA-27041: unable to open file SUCCESS: diskgroup DATA was dismounted … Continue reading ORA-15025: could not open disk “/dev/oracleasm/disks/D1”
Failed to start Oracle OHASD service
During the installation of 11gr2 RAC on RHEL 7, when running root.sh script getting error as Failed to start Oracle OHASD service when gone through the DOC came to know that its knows issue for 11gr2 with RHEL 7, This happens since RHEL 7 onwards, it uses systemd rather than initd for starting or restarting … Continue reading Failed to start Oracle OHASD service
CRS-0210: Could not find resource ‘ora.LISTENER.lsnr’
I was facing the issue when doing fresh installation of RAC on two node, at the time of running root.sh script getting below message in alert. 2017-02-21 16:58:21.949: [/grid/app/11.2.0/bin/oraagent.bin(57356)]CRS-5016:Process "/grid/app/11.2.0/opmn/bin/onsctli" spawned by agent "/grid/app/11.2.0/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/grid/app/11.2.0/log/node1/agent/crsd/oraagent_grid/oraagent_grid.log" 2017-02-21 16:58:22.054: [/grid/app/11.2.0/bin/oraagent.bin(57356)]CRS-5016:Process "/grid/app/11.2.0/opmn/bin/onsctli" spawned by agent "/grid/app/11.2.0/bin/oraagent.bin" for action "check" failed: … Continue reading CRS-0210: Could not find resource ‘ora.LISTENER.lsnr’
How to deinstall/deconfigure RAC.
sometimes we need to deconfigure the RAC when root.sh fails with some error or you want to do re-installation of RAC setup suppose you have Three node of RAC setup. Before deconfiguring a node, ensure it's not pinned, olsnodes -s -t If a node is pinned, unpin it first, i.e. as root user: crsctl unpin … Continue reading How to deinstall/deconfigure RAC.
CRS-2501: Resource is disabled
Today i was facing issue when starting 12C database using srvctl command. [grid@node1 ~]$ srvctl start database -db orcl12c PRCR-1079 : Failed to start resource ora.orcl12c.db CRS-2501: Resource 'ora.orcl12c.db' is disabled login through root srvctl enable database -db orcl12c then you can start the database.
how to change the default port of SCAN LISTENER
LISTENER and SCAN_LISTENER are running on port 1521. We are changing port from 1521 to 2088 LISTENER_SCAN3-1521 LISTENER-1521 LISTENER_1-2088 LISTENER_2-2089 LISTENER_3-2090 LISTENER_4-2091 LISTENER_5-2092 ps -ef | grep tns grid 46963 1 0 Jan 05 ? 4:37 /u01/app/11.2.0.4/grid/bin/tnslsnr LISTENER_1 -inherit grid 47103 1 0 Jan 05 ? 7:29 /u01/app/11.2.0.4/grid/bin/tnslsnr LISTENER_2 -inherit grid 47088 1 0 … Continue reading how to change the default port of SCAN LISTENER
Database Adminstration 