We are migrating SM application from 9.30 to 9.70 on Linux machine.

Current application is hosted on physical machine. SM 9.30 and Oracle 11g are on the same machine.

Final Upgradation plan is to move SM application and Oracle to Virtual machine.

 Below are the migration and upgrade plan. Please let me know are we on the right path.

1. Exporting Oracle 11g database from physical machine and importing to new Oracle 11g on virtual machine
2. Installed SM 9.30 with RHEL 6.8 virtual machine. Install Oracle 12c client 32bit. Established connectivity with new Oracle 11g virtual machine.
3. Upgrade new Oracle 11g to Oracle 12c.
4. Upgrade SM 9.30 to 9.60. both RTE and Application version.
5. Install SM 9.60 on new RHEL 8.3 virtual machine. Established connectivity with Oracle 12c.
6. Upgrade Oracle 12c to 19c.
7. Upgrade SM 9.60 to 9.70. both RTE and Application version.

 Currently we are facing issue at point 3. After upgrading database from Oracle 11g to 12c we are getting TNS issue. We have done necessary environment variable entries and tnsnames.ora file update according to Oracle 12c database.

 Below logs for your reference. We found that the SM 9.60 able to connect with Oracle 12c database successfully. But failed to load dbdict table and searching for dbtype oracle11 and giving TNS service name mismatch. For SM 9.30 dbdict dbtype will be Oracle11 and for SM 9.60 dbdict dbtype is just oracle.

 One more thing with fresh db on Oracle 12c we are successfully able to load oob data and access SM 9.60 .

  7982( 7982) 09/07/2022 13:56:26 RTE I Creating 9973 mutexes for Cache Manager
7982( 7982) 09/07/2022 13:56:26 RTE I /opt/MicroFocus/ServiceManager9.60/Server/RUN/jre/lib/i386/server/libjvm.so is used.
7982( 7982) 09/07/2022 13:56:26 RTE I JVM successfully created
7982( 7982) 09/07/2022 13:56:26 JRTE I Java version: 1.7.0_80
7982( 8007) 09/07/2022 13:56:26 JRTE I Starting Memory Monitoring thread to check for memory every 15 seconds.
7982( 7982) 09/07/2022 13:56:28 StringEncrypter [ isUseEncryption = false] : One or any of configuration files is not provided ...
7982( 7982) 09/07/2022 13:56:28 Building of configuration completed in 185 milliseconds.
7982( 7982) 09/07/2022 13:56:28 RTE I Host network address: 10.0.xx.xxx
7982( 7982) 09/07/2022 13:56:28 RTE D sqociConnect: sqociConnect - OCIServerDetach()
7982( 7982) 09/07/2022 13:56:28 RTE D sql diff 0.000 total 0.000 call#:1 --> sqociConnect:sqociConnect - OCIServerDetach()
7982( 7982) 09/07/2022 13:56:28 RTE D sqociConnect: SERVER ATTACH
7982( 7982) 09/07/2022 13:56:28 RTE D sql diff 0.015 total 0.015 call#:2 --> sqociConnect:SERVER ATTACH
7982( 7982) 09/07/2022 13:56:28 RTE D sqociConnect: BEGIN SESSION
7982( 7982) 09/07/2022 13:56:28 RTE D sql diff 0.012 total 0.027 call#:3 --> sqociConnect:BEGIN SESSION
7982( 7982) 09/07/2022 13:56:28 RTE I Connection to dbtype 'oracle' Oracle server 'smdbxx' as user 'smadminxxx' successful
7982( 7982) 09/07/2022 13:56:28 RTE I Connected to Oracle Version 12.2.0.1.0
7982( 7982) 09/07/2022 13:56:28 RTE I Oracle Client version: 12.2.0.1.0
7982( 7982) 09/07/2022 13:56:28 RTE I Oracle server settings for language, territory and character set: AMERICAN_AMERICA.AL32UTF8 (AL16UTF16)
7982( 7982) 09/07/2022 13:56:28 RTE I OCI Client settings for language, territory and character set: AMERICAN_AMERICA.AL32UTF8 (UTF16)
7982( 7982) 09/07/2022 13:56:28 RTE W Oracle instance setting for NLS_SORT could not be determined. Default to BINARY
7982( 7982) 09/07/2022 13:56:28 RTE I Oracle instance setting for NLS_COMP is set to BINARY
7982( 7982) 09/07/2022 13:56:28 RTE I Oracle session is set up in BINARY mode
7982( 7982) 09/07/2022 13:56:28 RTE D sqociConnect: sqociConnect - OCIServerDetach()
7982( 7982) 09/07/2022 13:56:28 RTE D sql diff 0.000 total 0.059 call#:39 --> sqociConnect:sqociConnect - OCIServerDetach()
7982( 7982) 09/07/2022 13:56:28 RTE D sqociConnect: SERVER ATTACH
7982( 7982) 09/07/2022 13:56:28 RTE E Error: SQL code=12162 message=ORA-12162: TNS:net service name is incorrectly specified
7982( 7982) 09/07/2022 13:56:28 RTE E SQL code=12162 message=ORA-12162: TNS:net service name is incorrectly specified
7982( 7982) 09/07/2022 13:56:28 RTE E API=OCIServerAttach-Local [in sqociConnect]
7982( 7982) 09/07/2022 13:56:28 RTE E Additional errors have been written to the log. Contact your system administrator
7982( 7982) 09/07/2022 13:56:28 RTE D sql diff 0.000 total 0.059 call#:40 --> sqociConnect:SERVER ATTACH
7982( 7982) 09/07/2022 13:56:28 RTE E Failure connecting to dbtype [oracle11], using Oracle TNS '', user ''
7982( 7982) 09/07/2022 13:56:28 RTE I Going to sleep for 15 seconds and try again to connect
8098( 8098) 09/07/2022 13:56:31 RTE I Using "utalloc" memory manager, mode [0]
8098( 8098) 09/07/2022 13:56:31 RTE I Command line: /opt/MicroFocus/ServiceManager9.60/Server/RUN/smserver system.start
8098( 8098) 09/07/2022 13:56:31 RTE I Process sm 9.60.0025 () System: 13080 (0x784DFB00) on x86_64 running Linux (2.6.32-642.el6.x86_64) Timezone GMT+05:30 Locale en_US.UTF-8 from kseb-dc-sm-app-201.kseb.in
8098( 8098) 09/07/2022 13:56:31 RTE I Process attaching to resources with key 0x784DFB00
8098( 8098) 09/07/2022 13:56:31 RTE I /opt/MicroFocus/ServiceManager9.60/Server/RUN/jre/lib/i386/server/libjvm.so is used.
8098( 8098) 09/07/2022 13:56:31 RTE I JVM successfully created
8098( 8098) 09/07/2022 13:56:31 JRTE I Java version: 1.7.0_80
8098( 8123) 09/07/2022 13:56:31 JRTE I Starting Memory Monitoring thread to check for memory every 15 seconds.
8098( 8098) 09/07/2022 13:56:33 StringEncrypter [ isUseEncryption = false] : One or any of configuration files is not provided ...
8098( 8098) 09/07/2022 13:56:33 Building of configuration completed in 178 milliseconds.
8098( 8098) 09/07/2022 13:56:33 RTE I Host network address: 10.0.30.173
8098( 8098) 09/07/2022 13:56:33 RTE D sqociConnect: sqociConnect - OCIServerDetach()
8098( 8098) 09/07/2022 13:56:33 RTE D sql diff 0.000 total 0.000 call#:1 --> sqociConnect:sqociConnect - OCIServerDetach()
8098( 8098) 09/07/2022 13:56:33 RTE D sqociConnect: SERVER ATTACH
8098( 8098) 09/07/2022 13:56:33 RTE E Error: SQL code=12162 message=ORA-12162: TNS:net service name is incorrectly specified
8098( 8098) 09/07/2022 13:56:33 RTE E SQL code=12162 message=ORA-12162: TNS:net service name is incorrectly specified
8098( 8098) 09/07/2022 13:56:33 RTE E API=OCIServerAttach-Local [in sqociConnect]
8098( 8098) 09/07/2022 13:56:33 RTE E Additional errors have been written to the log. Contact your system administrator
8098( 8098) 09/07/2022 13:56:33 RTE D sql diff 0.000 total 0.000 call#:2 --> sqociConnect:SERVER ATTACH
8098( 8098) 09/07/2022 13:56:33 RTE E Failure connecting to dbtype [oracle11], using Oracle TNS '', user ''
8098( 8098) 09/07/2022 13:56:33 RTE I Going to sleep for 15 seconds and try again to connect
7982( 7982) 09/07/2022 13:56:43 RTE E Error: SQL code=12162 message=ORA-12162: TNS:net service name is incorrectly specified
7982( 7982) 09/07/2022 13:56:43 RTE E SQL code=12162 message=ORA-12162: TNS:net service name is incorrectly specified
7982( 7982) 09/07/2022 13:56:43 RTE E API=OCISessionEnd()
7982( 7982) 09/07/2022 13:56:43 RTE E Additional errors have been written to the log. Contact your system administrator