Muneer_Ali_8170

PCK.AUTOMIC_ORACLE_DB.PRV.JOB.EXEC_SQLPLUS@WINDOWS TNN ERROR

Discussion created by Muneer_Ali_8170 on Oct 9, 2016
Latest reply on Oct 12, 2016 by Tran-Hoang_Hau_348

Hi,

Trying to execute the  PCK.AUTOMIC_ORACLE_DB.PRV.JOB.EXEC_SQLPLUS action pack, which basically executes on windows and runs a query on an oracle server which is on AIX machine. I AM able to telnet over the port 1521 and also I am able to do tnsping to service which is defined and in TNSNAMES.ORA , also able to ping the DB server, moreover I able able to connect to the server using sqlplus through command line. what I am missing then , kindly advise.

 

 

"********************************"
"**      EXECUTION START       **"
"********************************"
""
"INFO: Connect with Username/Password at @datawarehouse:1521/******"

SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 9 20:59:04 2016

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

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


Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name: Program 'UC4 Job Messenger' version '11.2.2+build.622' started

Outcomes