3 Replies Latest reply: Mar 4, 2013 2:24 AM by Chanchal Wankhade RSS

    SQL*Loader-500: Unable to open file

    Ant13
      I have two un-related questions:

      (1) What should i do to get past this error message:

      Sample control file : oracle/home /directory

      load data
      infile '/home/employee.txt'
      into table employee
      fields terminated by "," optionally enclosed by '"'
      (id, name, dept, salary)

      [oracle@localhost oracle]$ sqlldr scott/tiger control =/oracle/home/example.ctl

      SQL*Loader: Release 11.2.0.1.0 - Production on Sun Mar 3 03:06:21 2013

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

      SQL*Loader-500: Unable to open file (/oracle/home/example.ctl)
      SQL*Loader-553: file not found
      SQL*Loader-509: System error: No such file or directory


      (2) How do I start enterprise manager from linux?
      I ran this command and attempted to view the log but to no avail, please help!

      oracle@localhost ~]$ cd /u01/app/oracle
      [oracle@localhost oracle]$ export ORACLE_BASE=/u01/app/oracle
      [oracle@localhost oracle]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
      [oracle@localhost oracle]$ export ORACLE_SID=OCA11G
      [oracle@localhost oracle]$ export PATH=$ORACLE_HOME/bin:$PATH
      [oracle@localhost oracle]$ export TNS_ADMIN=/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
      [oracle@localhost oracle]$ emctl start dbconsole
      Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
      Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
      https://localhost.localdomain:5500/em/console/aboutApplication
      Starting Oracle Enterprise Manager 11g Database Control ............. started.





      ------------------------------------------------------------------
      Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/localhost.localdomain_OCA11_G/sysman/log
      [oracle@localhost oracle]$ cd /sysman/log
      bash: cd: /sysman/log: No such file or directory

      Edited by: Ant13 on Mar 3, 2013 11:17 PM