anyone here used OEM for export/import?

[Glen A Stromquist]

Just for a lark I thought I'd try it on a database that I needed to send
an export of to the application developers, rather than the usual
command line exp. All seemed to go well once I set up the preferred
credentials for the node as well as the db, I set up all the params
etc.. and chose to submit immediatly.

After that, it said it was succesfully submitted, and I could check the
status under the jobs menu in the console. I can see no such thing, and
the .dmp file I pointed it to does not exist on the local machine I am
running it from or the server itself (I wasnt sure which C: it meant)

so..., I'm running the plain old exp for now, but I'd like to know what
happened to the job I submitted as it seems to have vanished into the
void. Which process would this be? I assumed that it would simply run
exp.exe but neither process appears on either machine, other than the
command line one I'm currently running.

ideas?


TIA

[tojo]

In article <7%hac.32886$Ct5.2775@edtnps89>,
glen_stromquist@no_spam_yahoo.com says... Just for a lark I thought I'd try it on a database that I needed to send an export of to the application developers, rather than the usual command line exp. All seemed to go well once I set up the preferred credentials for the node as well as the db, I set up all the params etc.. and chose to submit immediatly. After that, it said it was succesfully submitted, and I could check the status under the jobs menu in the console. I can see no such thing, and the .dmp file I pointed it to does not exist on the local machine I am running it from or the server itself (I wasnt sure which C: it meant) so..., I'm running the plain old exp for now, but I'd like to know what happened to the job I submitted as it seems to have vanished into the void. Which process would this be? I assumed that it would simply run exp.exe but neither process appears on either machine, other than the command line one I'm currently running. ideas?
Could be the job failed immediately and was moved to job history. Did
you check there? There should be an error message. If you're using
Windows it's usually a problem with access rights.

-- Tom

[Guest]

Glen A Stromquist <glen_stromquist@no_spam_yahoo.com> wrote in message news:<7%hac.32886$Ct5.2775@edtnps89>... Just for a lark I thought I'd try it on a database that I needed to send an export of to the application developers, rather than the usual command line exp. All seemed to go well once I set up the preferred credentials for the node as well as the db, I set up all the params etc.. and chose to submit immediatly. After that, it said it was succesfully submitted, and I could check the status under the jobs menu in the console. I can see no such thing, and the .dmp file I pointed it to does not exist on the local machine I am running it from or the server itself (I wasnt sure which C: it meant) so..., I'm running the plain old exp for now, but I'd like to know what happened to the job I submitted as it seems to have vanished into the void. Which process would this be? I assumed that it would simply run exp.exe but neither process appears on either machine, other than the command line one I'm currently running. ideas? TIA


Anything submitted via OEM *always* end up on the server. If the
server doesn't have a mechanism to reach a PC, or your PC doesn't have
a mechanism to reach the server, you must ask whether you want to use
OEM to export. OEM export simply can't export to a local PC.
As far as I know, jobs don't 'disappear' and you should be capable to
use OEM's job history to see what has happened. Other than that
investigate the snmpd and snmpw log files on the server.
OEM runs a standard cooked tcl job to export. You can find them in
$ORACLE_HOME/network/agent/jobs

Sybrand Bakker
Senior Oracle DBA