Agentry ConnectTest for Oracle backend

[CRVMANISH]

Hello Experts,

To test SAP backend we have connectTest.bat , is there anything to test Agentry connection to oracle backend database.

If no please suggest possible methods to test oracle backend database connectivity with Agentry.

Regards

Manish

[bill_froelich · Accepted solution]

Manish,

Oracle has it's own tnsping utility which will check if it can reach the backend system.  You can google for the specific syntax and options but a simple tnsping <entryname> should return something similar to the following.

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-MAR-2015 08:43:01

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:

D:\Oracle11g\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.server.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = maximo.0.0.1)))

OK (30 msec)

--Bill

[CRVMANISH · Accepted solution]

Its working.

How to authenticate Agentry client for oracle , is it through DB credentials or custom user table?

Regards

Manish

[Former Member · Accepted solution]

The Agentry Server will run a script called something like ValidateUsers.sql.  This is in the "SQL" folder.  By default it just does:

Select

'True' as valid

You will need change this script to meet your needs.

[CRVMANISH · Accepted solution]

Which users it will validate?

I am assuming database users.

Regards

Manish

[Former Member · Accepted solution]

It all depends on how to write the script.  You can have it check agaist a table, or the Oracle Database users.   It just like any other script, you will need to write what you want to check it against.