My Oracle Support Banner

After Upgrading Gsm From 12.1.0.2 To 12.2.0.1, Old OH Still Showed In Config Gsm Output. (Doc ID 2661281.1)

Last updated on MAY 19, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

Customer upgraded the gsm ORACLE_HOME from 12.1.0.2 to 12.2.0.1 by

- Install new $ORACLE_HOME with version 12.2.0.1.0
- Stop GSM using $ORACLE_HOME with version 12.1.0.2
- Copy all files from $ORACLE_HOME/network/admin with GSM version 12.1.0.2 to
$ORACLE_HOME/network/admin with version GSM version 12.2.0.1.0.

WALLET_LOCATION entry on gsm.ora (located at $ORACLE_HOME/network/admin with version 12.2.0.1.0) has been updated as
below to reflect the new 12.2.0.1.0 ORACLE_HOME location:

gsm.ora

==========

SQLNET.WALLET_OVERRIDE = TRUE

WALLET_LOCATION =
  (SOURCE =
  (METHOD = FILE)
  (METHOD_DATA =
  (DIRECTORY = /opt/app/oracle/product/gsm1531_12201/network/admin/gsmwallet)
  )
  )

<GSM name> =
  (configuration =
  (listener =
  (ADDRESS = (HOST =<gsm hostname>)(PORT = 1531)(PROTOCOL = tcp))
  )
  (cloud = db.att.com)
  )


- Start GSM using $ORACLE_HOME with version 12.2.0.1.0


GDSCTL>status gsm
Alias <gsm name>
Version 12.2.0.1.0
Start Date 23-JAN-2020 01:31:28
Trace Level off
Listener Log File
/opt/app/oracle/diag/gsm/<gsm hostname>/<gsm name>/alert/log.xml
Listener Trace File
/opt/app/oracle/diag/gsm/<gsm hostname>/<gsm name>/trace/ora_93824_140610251047296.trc
Endpoint summary
(ADDRESS=(HOST=<gsm hostname>)(PORT=1531)(PROTOCOL=tcp))
GSMOCI Version 2.2.1
Mastership N
Connected to GDS catalog Y
Process Id 93827
Number of reconnections 2
Pending tasks. Total 0
Tasks in process. Total 0
Regional Mastership FALSE
Total messages published 0
Time Zone -08:00
Orphaned Buddy Regions:
  None
GDS region region_est
Network metrics:
  Region: region_pst Network factor:0

However,

GDSCTL>config gsm -gsm <gsm name> 
Catalog connection is established
Name: <gsm name>
Endpoint 1: (ADDRESS=(HOST=<gsm hostname>)(PORT=1531)(PROTOCOL=tcp))
Local ONS port: 6123
Remote ONS port: 6234
ORACLE_HOME path: /opt/app/oracle/product/gsm1531_12102 <============= old gsm ORACLE_HOME for gsm 12.1.0.2
GSM Host name: <gsm hostname>
Region: region_est


$ env | grep -i gsm1531
LD_LIBRARY_PATH=/opt/app/oracle/product/<gsm name>/lib
OH=/opt/app/oracle/product/<gsm name>
ORACLE_DBUNAME=<gsm name>
ORACLE_HOME=/opt/app/oracle/product/gsm1531_12201 <============= correct gsm ORACLE_HOME for gsm 12.2.0.1
ORACLE_PROMPT=<gsm hostname>:<gsm name> 
ORACLE_RSID=gsm1531_zlxy24859
ORACLE_SID=gsm1531_zlxy24859
PATH=/bin:/usr/bin:/sbin:/usr/sbin:/usr/bin/X11:/usr/local/bin:...:/opt/app/oracle/product/gsm1531_12201/bin:...
SIDENV=/opt/app/x2cry1d7/oracle/local/gsm1531_zlxy24859.env
TNS_ADMIN=/opt/app/oracle/product/gsm1531_12201/network/admin
oh=/opt/app/oracle/product/gsm1531_12201



 all GSM processes are running from the correct ORACLE_HOME with GSM version 12.2.0.1

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.