Preview Tool

Cisco Bug: CSCuq86156 - Update oracleenv file when switchover occurs

Last Modified

Jun 23, 2020

Products (1)

  • Headend System Releases

Known Affected Releases


Description (partial)

Cannot access the Embedded Oracle DB on the Standby CMC HA node after a switchover.

The oracleenv environment variable file, ORACLE_SID is not updated to s_wcs when a switchover occurs.  It remains set to wcs indicating the Active node.  It should be changed to s_wcs on switchover.

Perform a switchover from Primary (Active HA) CMC to the Secondary (Standby HA) CMC node.

Steps to reproduce:

1.  Log into the Primary CMC (Standby HA) as root user.
2.  Change to oracle user.
3.  bash
4.  source /opt/oracle/oracleenv
5.  sqlplus wcsdba/wcs123

Produces a log in error.

SQL*Plus: Release Production on Mon Sep 15 08:45:01 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:
Bug details contain sensitive information and therefore require a account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.