AutoMate Discussion Forums - oracle database trigger

AutoMate Discussion

help : faq : home
Latest News: NA.com -> HS.com	latest topics : statistics

AutoMate Discussion » AUTOMATE » AutoMate 10 » oracle database trigger - listener error

Hide

Categories

	BETA
·	AutoMate 10 & AutoMate BPA Server 10 - Public Beta
	AUTOMATE
·	Automate 11
·	AutoMate 10
·	AutoMate 9
·	AutoMate 8
·	AutoMate 7
·	AutoMate 6
·	AutoMate 5
	AUTOMATE BPA SERVER & AUTOMATE ENTERPRISE
·	Automate Enterprise 11
·	AutoMate BPA Server 10
·	AutoMate BPA Server 9
·	AutoMate BPA Server 8
·	AutoMate BPA Server 7
	GENERAL
·	General Discussion
·	Sample Tasks
·	Suggestions
·	Lounge
	KNOWLEDGE BASE
·	KB Articles
·	AutoMate / Automate
·	AutoMate BPA Server / Automate Enterprise
·	Triggers / Conditions
·	Actions / Activities
·	Task Builder

Search the Forums

advanced search

AUTOMATE

Automate
AM11	11.0.6.11

AutoMate
AM10	10.7.0.3
AM9	9.0.5.4
AM8	8.0.9.0
AM7	7.1.3.0
AM6	6.2.8.0
AM5	5.5.5.1

AUTOMATE ENTERPRISE

Automate Enterprise
AME11	11.0.6.11

AutoMate BPA Server
BPA10	10.7.0.3
BPA9	9.0.5.4
BPA8	8.0.9.0
BPA7	7.1.3.0

INSITE

Insite
2.2

Topic Title: oracle database trigger - listener error
Topic Summary:
Created On: 01/10/2018 05:50 AM
Status: Read Only

Linear : Threading : Single : Branch

Search Topic

Topic Tools

	View similar topics
	Print this topic.

01/10/2018 05:50 AM

HarleyEllenberger
Student (5-19 posts)

Posts: 18
Joined: 09/09/2005

Trying to set up an AutoMate database trigger that monitors an Oracle database that is hosted on another server.

I'm getting this error...

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Any suggestions on how to resolve this?

Category Survey

AutoMate 10 version: 10.3.0

Windows version: Windows Server 2008 R2

Top : Bottom

01/10/2018 08:16 AM

Leonard Amabile
HelpSystems

Posts: 5454
Joined: 05/15/2007

Hi Harley,

Did you grant permission to the user using the following statement: GRANT CHANGE NOTIFICATION TO user name? Are the proper Oracle ODP and connector drivers installed on the agent machine that is monitoring Oracle?

Category Survey

-------------------------

Top : Bottom

AutoMate Discussion » AUTOMATE » AutoMate 10 » oracle database trigger - listener error

Topic Tools

Statistics

18258 users are registered to the AutoMate Discussion forum.

There are currently 0 users logged in.

The most users ever online was 6686 on 11/01/2020 at 01:24 AM.

There are currently 3453 guests browsing this forum, which makes a total of 3453 users using this forum.