SQL*Loader-500: Unable to open file
Ant13Mar 4 2013 — edited Mar 4 2013I 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