Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

Re^3: Help with sql*loader

by Starky (Chaplain)
on May 15, 2008 at 14:36 UTC ( #686739=note: print w/replies, xml ) Need Help??

in reply to Re^2: Help with sql*loader
in thread Help with sql*loader

This looks suspiciously like a problem with environment variables to me as well. It's been a while since I've used Oracle, so forgive me if I'm a little fuzzy on details. But I'd suggest you check not only ORACLE_HOME, but (where appropriate)
  • TNS_ADMIN, which points to TNSNAMES.ORA (this one consistently gave me grief for some reason), and
Take a look at this page for summary information on other Oracle environment variables.

I'd also suggest double checking %ENV from within your code to be 100% sure you are setting the environment variables correctly and double checking that TNSNAMES.ORA, library files, and the other files the environment variables are targeting are where you expect them to be based on the environment variables.

Hope this helps :-)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://686739]
[Eily]: can't the nodelet be moved though? Maybe you could put one that doesn't change first ("Sections" or "Find Nodes" for example)
[Eily]: "Other Users" seems like a poor choice :P
[Eily]: nope, Nodelet Settings doesn't let you move the XP Nodelet, CSS might
[marinersk]: That would mitigate the distraction/jangle issue, but then the information wouldn't be easy to find when it is populated. Plus, I don't currently see a way to move it, but I'm not done poking around on that point yet.
[marinersk]: Ah, you beat me to it.

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (9)
As of 2017-05-29 14:09 GMT
Find Nodes?
    Voting Booth?