My Oracle Support Banner

ECC - UpgradeSchema.sh Failed with the Error: ORA-12154: TNS:could not resolve the connect identifier specified (Doc ID 3001685.1)

Last updated on FEBRUARY 03, 2024

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.12 and later
Information in this document applies to any platform.

Symptoms


When attempting to upgrade ECC from V6 to V11, the following error occurs in the console where upgradeSchema.sh script is executed and the in the schemaUpgrade_%.log file:

Enter value for 1: Enter value for 2: Enter value for 3: SP2-0137: DEFINE requires a value following equal sign

Enter value for sid: ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified



The issue can be reproduced at will with the following steps:
1. Follow the steps #1 through #5 described in Doc ID 2495053.1 under " Appendix C: Upgrading Oracle Enterprise Command Center Framework to Release 12.2 V11"
2. Navigate to <STAGING_DIRECTORY>/Oracle/quickInstall and execute the upgrade command:
sh upgradeSchema.sh


Changes

 Upgrade ECC from V6 to V11

Cause

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
Symptoms
Changes
Cause
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.