ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA while installing Demantra Patch

(Doc ID 1401744.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2014***

Symptoms

When attempting to install a Demantra point patch the following error was observed in the Install log under the  C:/tmp folder (note that this assumes the user has manually created the C:/tmp folder the install was attempted)

2012-01-25 11:46:47,518 [DEBUG] - SQL script to be executed: D:\Oracle Demantra Spectrum-DEV\Demand Planner\Database Objects\Oracle Server\UPGRADE_VERSION.sql
2012-01-25 11:46:47,533 [DEBUG] - Command String: cmd.exe /c D: & cd "D:\Oracle Demantra Spectrum-DEV\Demand Planner\Database Objects\Oracle Server" & "D:\oracle\product\11.2.0\client_1\bin\sqlplus.exe" -L msdem/*****@sxxxxdbd1-v @"D:\Oracle Demantra Spectrum-DEV\Demand Planner\Database Objects\Oracle Server\UPGRADE_VERSION.sql"
2012-01-25 11:46:48,174 [DEBUG] - STDOUT>
2012-01-25 11:46:48,174 [DEBUG] - STDOUT> SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 25 11:46:48 2012
2012-01-25 11:46:48,174 [DEBUG] - STDOUT>
2012-01-25 11:46:48,174 [DEBUG] - STDOUT> Copyright (c) 1982, 2010, Oracle.  All rights reserved.
2012-01-25 11:46:48,174 [DEBUG] - STDOUT>
2012-01-25 11:46:48,643 [DEBUG] - STDOUT> ERROR:
2012-01-25 11:46:48,643 [DEBUG] - STDOUT> ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
2012-01-25 11:46:48,643 [DEBUG] - STDOUT>
2012-01-25 11:46:48,643 [DEBUG] - STDOUT>
2012-01-25 11:46:48,643 [DEBUG] - STDOUT> SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms