Home » RDBMS Server » Server Utilities » ora-12514 error (Oracle 10g)
| ora-12514 error [message #574540] |
Fri, 11 January 2013 23:22  |
|
|
I am trying to upload a csv file into table using sqlloader on client computer, i am getting an error message while giving the ctl file , the error is ORA-12514 , can someone tell me where to store this ctl file and refer it as i am following the below steps.
1.Created the .csv file
2.copying it under home directory where oracle client is installed
3.created the ctl file from text editor and saved it under the name loader1.ctl.
contents of loader1.ctl is as below.
CREATE TABLE EMP_SETTLE (ID_NO VARCHAR2(12), SET_DT VARCHAR2(30));
LOAD DATA
INFILE 'c:/orant/emp_setle.csv'
INTO TABLE emp_settle
FIELDS TERMINATED BY ","
Sample .csv is attached.
|
|
|
|
|
|
| Re: ora-12514 error [message #574542 is a reply to message #574541] |
Fri, 11 January 2013 23:54  |
|
|
Thanks blackswan for the very prompt response and help,i had one database locally installed and it was on d drive and the one which i was referring to was on remote there was no link, i created one link and then now i am facing the problem like this below.i am also attaching the status files of lsnrctl status and lsnrctl service.If possible kindly tell me what are the exact steps to be followed for uploading the data from .csv to oracle , like where the loader.ctl file should reside.
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\arif>CD\
C:\>CD ORANT
C:\orant>SQLLDR RAKPAYLIVE/ORION@ORION
control = LOADER
SQL*Loader: Release 10.2.0.4.0 - Production on Sat Jan 12 09:26:25 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
C:\orant>lsnrctl status
LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 12-JAN-2013 09:26
:39
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER1
Version TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Produ
ction
Start Date 12-JAN-2013 07:25:42
Uptime 0 days 2 hr. 0 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener1.lo
g
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Arif.aicsteel.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "rakdb" has 1 instance(s).
Instance "rakdb", status READY, has 1 handler(s) for this service...
Service "rakdbXDB" has 1 instance(s).
Instance "rakdb", status READY, has 1 handler(s) for this service...
Service "rakdb_XPT" has 1 instance(s).
Instance "rakdb", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\orant>spool c:\status.txt
'spool' is not recognized as an internal or external command,
operable program or batch file.
C:\orant>spool c:\status
'spool' is not recognized as an internal or external command,
operable program or batch file.
C:\orant>lsnrctl service
LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 12-JAN-2013 09:27
:32
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "rakdb" has 1 instance(s).
Instance "rakdb", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:53 refused:0 state:ready
LOCAL SERVER
Service "rakdbXDB" has 1 instance(s).
Instance "rakdb", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: ARIF, pid: 2036>
(ADDRESS=(PROTOCOL=tcp)(HOST=Arif.aicsteel.com)(PORT=60266))
Service "rakdb_XPT" has 1 instance(s).
Instance "rakdb", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:53 refused:0 state:ready
LOCAL SERVER
The command completed successfully
C:\orant>set echo off
Environment variable echo off not defined
C:\orant>spool test.sql
'spool' is not recognized as an internal or external command,
operable program or batch file.
C:\orant>SQLLDR rakpaylive/orion@orion
control = loader1.ctl
SQL*Loader: Release 10.2.0.4.0 - Production on Sat Jan 12 09:41:43 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-500: Unable to open file (loader1.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
|
|
|
|
|
|
Goto Forum:
Current Time: Sat Apr 01 09:37:02 CDT 2023
|
] 
Search
Help
Members
Register
Login
Home
