span8
span4
span8
span4
Hello,
I am trying to connect a Oracle DB to FME but even if I did everything fromthis linkit is not working.
Does anybody have any idea what could be the problem?
What version of FME and is it 32 or 64 bit?You need to match the Oracle Client as 32 or 64 bit.It is possible to have both.
One thing I like to do is to use SQLPlus to check the connection to Oracle - If SQLPlus can't connect FME probably can't.
Wondering also if the Service name allows an IP - Is you TNS Names configured correctly - the suggestion above will prove that.
Also when you click the Test button it should return an error - what does it say as the reason for failure?You can alsoShow Logwhich you can paste here.
Can I get any help please?
You're Oracle connection is missing an sid or servicename.This identifies the database instance that's is running on you're Oracle server.Out of the box Oracle uses orcl as the instance name.DBA's change this name to an name that's identifies the use of the database.On Oracle server can host multiple database connecting through different port numbers.Standard portnumber is 1521.
You're connection to oracle has only an IP address.That's not an valid connection.
When using TNSNames you give an Oracle connection an name (Alias).This cannot be an IP address.So I assume you are trying to connect to Oracle via an Easy Connect.
The richt syntax for Easy Connect is.
You can test if the Easy Connect is valid inside an command box (cmd.exe).
For example:
IP: 147.91.175.146
port: 1521
service_name: orcl
tnsping147.91.176.146:1521/orcl
I think the connection will be woring in FME when you are using the bold text as mentioned above after TNSPING.
P.S.
You should consider not to mention the server name of Ip address of your Oracle connection on any (web)site.I could reach your Oracle server (ping and tnsping) so I guess everyone in the world can reach you're server.This could be an security risk to you're data/organisation.
@mark_1spatial Where can You see that?Which client is not installed correctly?
OK I think the problem is in the Environment Variables.
The PATH variable needs the directory where the Oracle Client is installed.You do not need the InstantClient variable and certainly not pointing to oci.dll
Is my setting - yours will be in a different directory.
© 2019 亚搏在线Safe Software Inc |Legal