Hello all,
I am stuck with OMBPlus on a hard one.
Our script is intended to deploy our whole project, with users, mappings, workflows, etc.
We have to run some SQL scripts to perform various actions (grant roles, fill param tables, etc.)
I use the following syntax:
set ExecuteResult [exec sqlplus $user/$password@$tns @$sql_script_file]
where $user, $password, $tns and $sql_script_file are some params
This was working on my computer until yesterday evening. Since then, I get the following errors :
1) Error message from SQLPlus : "The procedure entry point snlinAddrLocalhost could not be located in the dynamic link library oranl10.dll"
2) ORA-12557: TNS:protocol adapter not loadable.
just like in post
513144
I have the following observations:
1) I have the same error when running from my computer or from the server, but not from a coleague's computer.
2) I have the same error with sqlplus and sqlplusw (GUIversion)
3) error also happens when I just launch OMBPlus, type exec sqlplusw, and enter the same connection information. SQLPlus still allows a new try, but this will lead to the same error with the same parameters, or even to crash SQLPlus if I try with other parameters (other database)
4) I have several Oracle Home, including one for the BI. The sqlplus launched by OMB+ is that of the BI.
5) all my TNSnames.ora are in synch across my various oracle homes.
6) the error happens with a tns entry, and also with a connect string:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=charon)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=bdexport)))
7) If I use sqlplus directly from windows, with or without the GUI, everything works fine and my script runs. This is true for any sqlplus I may launch (from any oracle home)
8) I didn't perform any significant settings change when it stopped working, only working on the script as far as I can remember...
I think this is related to local OMBPlus settings somehow, but I really don't see which ones... I even can't see where to change such settings...
Any help greatly apreciated!
Thank you in advance
Ced.