ORA-12154 error in target UE
- Article Type: General
- Product: MetaLib
- Product Version: 4
Description:
Receiving “Cannot connect to the data base: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach)” error in first step of target UE (upgrade express) after running MIK (Metalib Installation Kit).
Oracle10 and the meta4 database are already installed.
Resolution:
The m4_m tns name was not defined properly during the installation.
Therefore please change ORA_HOST to a fully qualified www.server.name when trying:
metalib@metalib4(m4_m):~/m4_m/metalib_conf>sqlplus $METALIB_ADMIN@$metalib_db
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 2 05:47:50 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining Scoring Engine options
metalib_admin@META4> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining Scoring Engine options
- Article last edited: 10/8/2013