| Ext file being created is '0' bytes.... [message #456091] |
Fri, 14 May 2010 09:35  |
shajju
Messages: 29
Registered: August 2009
|
Junior Member |
|
|
Hi guys
Hoping to get some help here. I have a 9i db. The problems I'm currently facing is pretty much summed up in the Title.
Yesterday, the database server was moved to a new physical location and given a new IP address. Since then, after powering the server back up, when the loader runs as scheduled in the cron and tries to load data into the database, for some reason the external file created is '0' bytes although the file being loaded has data in it.
However, if I run the ETL loader manually, the ext file is not empty and data gets loaded into the db.
Everything was working fine before the servers were re-located but I can't relate the server activity with a '0' bytes ext file.
Any ideas?
Regards
Shajju
|
|
|
|
|
|
| Re: Ext file being created is '0' bytes.... [message #456145 is a reply to message #456092] |
Sat, 15 May 2010 03:00  |
shajju
Messages: 29
Registered: August 2009
|
Junior Member |
|
|
The database is installed on a HPUX machine.
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for HPUX: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production
I'm using a third party application to load data into the database which was working fine (scheduled in cron) since a couple of days ago after the IP addresses of the servers were changed. One HPUX box has two partitions and hence two IP addresses making them two servers. One server has oracle 9i installed on it. And one server has the files that need to be loaded into the db. The Oracle server can be TNSPinged from the Mediation server. The external dir on the database server is mounted on the mediation server so any file created/copied into the ext dir on the mediation server can be seen in the ext dir on the db server.
Now when I run the loader, I can see that the ext file created in the ext dir on the mediation server is '0' bytes and also correspondingly on the db server and the log says, there are no files to process. The path to the location where the files to be loaded exist in defined in the ini file used with the loader and is a valid path.
I've checked all permissions to the respective folders. Just cannot figure out why the ext file created is zero bytes.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
