LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

Hi,

I've a server, with oracle installed and I've created some table in an instance of that DB.
Now, I want to load some data from a LAE project, that I have on my laptop, to that DB on another server.

Is it possible, although the oracle is not installed on my laptop?
Is there any special configuration, while using the nodeDB Store?

Regards,

ZON

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

Hi Zon, you could either use a native OCI connector. Or use JDBC query. At least that's how I use it

Is your Lavastorm configuration on a local windows client or do you have the Enterprise Edition?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

Hi,

Is in a local windows client, not enterprise.
I'm using DB Store, with this config:
DbTable: RAVOIPCDR
Db User: mdara
DBPassword: ****** the password
DbService: DFASERVER (name of my Db)
DbInterface: oci

Am I doing it right?

Regards,
ZON

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

Typically you would need a client on your machine to talk to the host. You would have a TNS Names Configuration File.
http://www.oracle.com/technetwork/to...ft-085727.html

here is also a good install tutorial, http://docs.oracle.com/cd/E11882_01/...87/install.htm

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

I've changed the file TNSNAMES.ORA (was in folder C:\oracle\ora92\network\ADMIN) and added the configuration to the DB instance. This was what I added:

# Ambiente PRD RA MDA

EDFA1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = SVLFMCPDB01.corpdom.local)(PORT = 1522)
)
)
(CONNECT_DATA = (SID=EDFA1)
)


I've try to run the node again, but got the same error.
Why is that? Is there anything else that I must do, before I be able to load data into a table?

Thanks,
ZON

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

Hello,

Can anybody help me?
Still waiting for an answer.

Cheers,
ZON

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

What is the error message?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

Can you tnsping the EDFA1 Oracle Service? If not, then you probably do not have the service setup correctly.

You could try to use the host IP Address instead of the hostname. Sometimes there are DNS issues that will not allow connectivity.

Also, noticed you have the port set to 1522. Is this the actual port. The Oracle default port it 1521, unless it was changed on purpose.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

What do you mean by "tnsping"? How do I do that?
If you mean "ping" the ip, I did and it returns results.

Using SQL Developer app, I can connect to the database, using the HOSTNAME as 10.154.32.42, PORT 1522, and SID EDFA1.
Nevertheless, I added to the file TNSNAMES.ORA another line using the IP for the HOSTNAME.


EDFA1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = SVLFMCPDB01.corpdom.local)(PORT = 1522)
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.154.32.42)(PORT = 1522)
)
)
(CONNECT_DATA = (SID=EDFA1)
)

Still not working.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: spalluru

Hi Zon,

Please check post http://community.lavastorm.com/threa...r-with-DBquery , it is valid if your client windows is 7 and 64bit , ensure
you are installing Oracle Client in c: or D:. I also suggest to install Lavastorm in C: or D: instead in the default path it prompts.

-Sreekanth

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

Hi,

My windows is XP

I've LAE installed in C:\Program Files\Lavastorm, and oracle in a different machine, a server, on my network.

In the post you mention, its talking about "ensure that the location of the OCI dll files is included in your PATH environment variable".
What OCI dll files?

ZON

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: simon.wilby

Hi zon,

Apologies if you've already done this but here's how I generally use the oci option to connect to an oracle instance.

download the appropriate oracle instant client from here:
http://www.oracle.com/technetwork/da...ex-097480.html

save the zip file to somewhere like C:\Oracle
extract the files to the same location so that there's a new directory like C:\Oracle\instantclient_11_2 (for example)
Update the windows environment variables

in windows xp this is done by: right clicking My Computer and then clicking properties. click the Advanced tab.
click Environment variables. under system variables there'll be a variable called Path. select this and edit. add at the end the following:
;C:\Oracle\instantclient_11_2 (e.g the location you saved the extracted instant client to)
Ok each screen to close and save your changes.

For reference the oci.dll file talked about is included in the oracle download. So basically you've just installed the client and told your system to use that directory for dll's. LAE should then be able to use the oci option.

Hope that helps.

Simon

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

Hi Zon,

Did you ever get this working?

There is a utility that is installed with the Oracle client called "tnsping". You can use that utility to test connectivity to your Oracle service.

In the example from above you would type "tnsping EDFA1" at your command line on the machine where the Oracle client is installed.

-Larry

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

Hi,

I've tried what you said previously, but it didn't work.
But, is this different when Oracle is installed in another machine, not in my laptop?

I user LAE in my laptop, but oracle is installed in a different machine/server.

Cheers,
ZON

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

Hi,

I'm still waiting for your answer to my last reply.
Can you help me please?
My laptop is running out of space in disk.
I need to solve this please.

Regards,
ZON

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: simon.wilby

Hi ZON,

so have you tried the "tnsping" test? did that work for you?
In my experience the details I provided earlier should be all that you need from an LAE perspective.
It shouldn't matter where Oracle is installed as long as you have the oci.dll locally on your laptop.
So the first test I'd do is use a tool such as tnsping or sql developer to ensure you can connect to the remote/local oracle service.

regards
Simon

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

Hi Simon,

I have sql developer, and it works.
I can connect to the server, I even created the tables and so on.

So, I'm not getting why the connection doesn't work in DB node.
Do you want to have a look? Do you have Team Viewer, so you can see my desktop?

Regards,
ZON

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: simon.wilby

Hi Zon,

If you've completed all the steps noted previously then there's not much else I can add to it.
If you can reach out and contact our support organization in a way best suited for you, I think that is the most prudent course of action to help you resolve this issue in an expedient manner.

Regards

Simon

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: zon

Hi,

Due to some trouble times last year, I've not been able to get forward with this.
But I need to.

I checked that link, but those cases are not my case.

Just so we can be clear:
1 - I have MDA installed in my desktop machine (in a path with parenthesis);
2 - Oracle is installed on a different server;
3 - I need to connect to a VPN in order to get to that server;
4 - Once I connect to it, I test if my machine is reaching the server (using oracle sql developer)
5 - Then I tried to run the node to load data to one of the tables I've created in the DB
6 - Is not working

Install and uninstall LAE for me is not has easy as it looks like. Therefore I'm asking for your help, in order to fully understand where the error is.

Thanks for your help,
NOS

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: lnason

Hi Zon,

I had a look through this thread and I didn't see that you ever posted the error message that your are receiving when you try to execute the DB Store node. Could you please send along the error message?

One other question....are you able to run the Db Query node against the database you are using? If you haven't tried this, can you give it a try and send along the results? If it fails, please include the error message.

I think your best bet for getting this resolved quickly is to contact support as recommended by Simon above, but if we can have a look at the details of the error you are seeing then it might be possible to resolve the issue here.

Luke