1 2 3 Previous Next 37 Replies Latest reply on Jan 24, 2017 11:01 AM by 3373013

    SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]

    3373013

      Hi All,

       

      I have an Oracle DB 12c installed on my laptop. I am able to database objects in the HR schema. And have a SYS and PDB as well.

       

      When running a SQLLOADER from the command prompt, I am getting the below error:

       

      Microsoft Windows [Version 10.0.14393]
      (c) 2016 Microsoft Corporation. All rights reserved.

      C:\WINDOWS\system32>cd\

      C:\>cd C:\app\sunita\product\12.1.0\dbhome_1\BIN

      C:\app\sunita\product\12.1.0\dbhome_1\BIN>sqlldr userid=sys/Password@xe control=FixedDataControlFile.ctl

      SQL*Loader: Release 12.1.0.2.0 - Production on Mon Jan 23 20:50:49 2017

      Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

      SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
      ORA-12154: TNS:could not resolve the connect identifier specified

       

      Kindly advise.

       

      Note: FixedDataControlFile.ctl is kept in C:\app\sunita\product\12.1.0\dbhome_1\BIN.

       

      Thank you.

       

       

        1 2 3 Previous Next