3 Replies Latest reply on Mar 4, 2013 8:24 AM by Chanchal Wankhade

    SQL*Loader-500: Unable to open file

      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 - 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
      Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
      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