| SQL LOADER does not start? [message #171182] |
Mon, 08 May 2006 21:58  |
dkarvel
Messages: 5
Registered: May 2006
Location: SYDNEY
|
Junior Member |
|
|
Hi I recently installed Oracle 9 on a Windows 2000 Pro PC.
The installation was successfully finished and succesfully created a database on the server.
I am trying to execute the sqlldr.exe from command prompt and nothing happens.
If I try to execute sqlplus.exe the utility starts fine.
If I double click the sqlldr.exe from the oracle/.../bin folder same thing happens... It "thinks" for 1 sec and then nothing happens.
Any help will be much appreciated.
Thank you in advance.
|
|
|
|
|
|
| Re: SQL LOADER does not start? [message #171304 is a reply to message #171182] |
Tue, 09 May 2006 06:27  |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
As Mahesh noted, SQL*Loader is a command line utility. If you have a command prompt up, enter PATH and make sure your ORACLE_HOME is set. If not enter:
set path=e:\oracle\product\9.2
Replace the path above with your own corresponding ORACLE_HOME path. Then try to run sqlldr again from the command prompt.
[Updated on: Tue, 09 May 2006 06:42] Report message to a moderator |
|
|
|
| Re: SQL LOADER does not start? [message #171388 is a reply to message #171182] |
Tue, 09 May 2006 12:02 |
sauami
Messages: 54
Registered: October 2005
Location: india
|
Member |
|
|
Go to the command prompt by sql.
when you login in your schema the give command host
SQL> host
go the where you have save your .ctl(control) file and execute it
c:\xx>sqlldr control=xx.ctl log=data.err
try this.
Thanks,
Saurabh
|
|
|
|
| Re: SQL LOADER does not start? [message #171418 is a reply to message #171388] |
Tue, 09 May 2006 20:06 |
dkarvel
Messages: 5
Registered: May 2006
Location: SYDNEY
|
Junior Member |
|
|
Thank you,
As I mentioned on my previous post I am trying through the command line (command prompt): See below:
***********************************************
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\>sqlldr
C:\>
***********************************************
As you can see I get no "unknown file" errors or invalid parameters... which means that it starts(?) loading the utility but fails(?)
Also, I am almost certain that the ORACLE_HOME path is ALREADY SET correctly as:
1) all other utilities (e.g sqlplus or imp) run perfectly fine, See below:
************************************************
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\>sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 10 11:07:28 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name:
************************************************
and 2) I manually checked all the system variables e.g PATH and also Windows registry which specifies clearly ORACLE_HOME=C:\ORACLE\ora92
So the problem looks like is that the utility loads for less than 1 second and then it dies (nothing happens)
|
|
|
|
| Re: SQL LOADER does not start? [message #171420 is a reply to message #171388] |
Tue, 09 May 2006 20:22 |
dkarvel
Messages: 5
Registered: May 2006
Location: SYDNEY
|
Junior Member |
|
|
Thanks Saurabh,
I did type host on the SQL> prompt and it succesfully brought up the command prompt (cmd.exe).
*****************************************************
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\oracle\ora92\BIN>sqlldr
C:\oracle\ora92\BIN>
*****************************************************
I then typed the sqlldr as mentioned and unfortunately it behaved the same way:
*****************************************************
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\oracle\ora92\BIN>sqlldr
C:\oracle\ora92\BIN>
******************************************************
Is there any way I can find separetely the sqlldr.exe utility and its dependancies and install them manually?
Same or different versions of 9.2.0.1 that I have installed in my system.
Thank you for your time so far,
DK
[Updated on: Tue, 09 May 2006 20:23] Report message to a moderator |
|
|
|
|
|
| Re: SQL LOADER does not start? [message #171647 is a reply to message #171541] |
Wed, 10 May 2006 18:28 |
dkarvel
Messages: 5
Registered: May 2006
Location: SYDNEY
|
Junior Member |
|
|
Thank you Mahesh,
There is definately no offence. No worries...
Regarding if I have read/try it I have to tell you that I know every single switch of this utility.
I have read and printed almost everything I need to work with the utility AS LONG AS IT STARTS.
I have created control files and also tried with different login/password (in fact I tried with SYSDBA as well).
The reason I listed the command sqlldr by itself without the parameters is for simplicity purpose.
Reading O'Reilly's Oracle SQL*Loader: The Definitive Guide it clearly states that:
**********************************************
SQL*Loader can be invoked in one of three ways:
sqlldr
sqlldr keyword=value [keyword=value ...]
sqlldr value [value ...]
Issuing the sqlldr command by itself results in a list of valid command-line parameters being displayed. Command-line parameters are usually keyword/value pairs, and may be any combination of the following:
USERID={username[/password][@net_service_name]|/}
CONTROL=control_file_name
LOG=path_file_name
BAD=path_file_name
DATA=path_file_name
DISCARD=path_file_name
DISCARDMAX=logical_record_count
SKIP=logical_record_count
SKIP_INDEX_MAINTENANCE={TRUE | FALSE}
SKIP_UNUSABLE_INDEXES={TRUE | FALSE}
LOAD=logical_record_count
ERRORS=insert_error_count
ROWS=rows_in_bind_array
BINDSIZE=bytes_in_bind_array
SILENT=[(]keyword[,keyword...][)]
DIRECT={TRUE | FALSE}
PARFILE=path_file_name
PARALLEL={TRUE | FALSE}
READSIZE=bytes_in_read_buffer
FILE=database_datafile_name
So, I think that I don't need to specify parameters in order to start the utility.
However, I have already tried all the possible combinations of systax but the strange thing is that it does not start... I wish I got an error back from the utility to tell me why it does not start. It simply dies after 1 second.
Thank you for your reply anyway...
The next think I will try is to install Oracle in a solaris environment and attempt to start the utility from there.
If you have any more suggestions are very welcome.
DK
|
|
|
|
|
|
| Re: SQL LOADER does not start? [message #171651 is a reply to message #171182] |
Wed, 10 May 2006 18:42 |
dkarvel
Messages: 5
Registered: May 2006
Location: SYDNEY
|
Junior Member |
|
|
Thank you Mahesh,
>Just re-install your client ( along with sqlldr / utilities) >and try again
I should do this...
BTW: Do you know where I can get a copy of this utility and its dependants separetely without having to download the Disk1 (500MB) of another version?
DK.
|
|
|
|
| Re: SQL LOADER does not start? [message #171654 is a reply to message #171651] |
Wed, 10 May 2006 20:54 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
You can download the client from OTN.
>> utility and its dependants separetely
I have not tried it. In Unix, this would be compilation.
In windows, since it is just an exe, you ***may*** copy it from a similiar installation (OS,Version ). I doubt whether it will work. I have not tried it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
