|
|
| Re: How to automate the export in OEM?? [message #58700 is a reply to message #58693] |
Fri, 26 September 2003 05:53   |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Sachin,
Whom are you logging in as into OEM console ? Try sysman.
Secondly, you will need to have set the Preferred credentials for the node,database for that database in OEM. You will need to choose a DBA user for the database and 'Oracle' (or the administrator user who owns the installation) for the node.
Third, You should have granted 'Logon as Batch job' privilege to the Windows account(eg ORACLE) and this user should preferably be a local account(ie domain accounts may be troublesome).
-Thiru
|
|
|
|
| Re: How to automate the export in OEM?? [message #58721 is a reply to message #58700] |
Fri, 26 September 2003 23:37 |
sachin kumar gupta
Messages: 157
Registered: March 2003
|
Senior Member |
|
|
Thanx Thiru!! But I have one more problem. Export job was done successfully on the server machine_(Oracle 9.0.1.1.1 on Windows 2000 Server), but when I am trying to export on my n/w account(used map network drive with full access), i m getting following error message:
Exp-00028: failed to open F:ExportExport.log for write.
Exp-00000: Export terminated unsuccessfully.
My target is to automate the exporting on local server as well as one of my remote account for safety.
TIA,
Sachin
|
|
|
|
| Re: How to automate the export in OEM?? [message #58728 is a reply to message #58721] |
Sat, 27 September 2003 08:33 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Where are you generating the export log file ? As the network account,can you write to F:Export ?
BTW,isnt it easier/more efficient to generate the export dumps locally and then copy the backup files to the network share , instead of doing the exports twice !?
-Thiru
|
|
|
|
| Re: How to automate the export in OEM?? [message #58729 is a reply to message #58728] |
Sat, 27 September 2003 12:00 |
sachin kumar gupta
Messages: 157
Registered: March 2003
|
Senior Member |
|
|
Hi Thiru,
I didn't set any export log file destination specifically, but I think automatically it is trying to generate the log file on F:Export...
Also I can copy/delete any .dmp file to my n/w account. But while exporting to the remote m/c only it is giving error.
I don't want to copy the exported file daily to remote m/c(very time comsuming). That's why I am exporting the db to remote m/c.
TIA,
Sachin
|
|
|
|
| Re: How to automate the export in OEM?? [message #58749 is a reply to message #58729] |
Mon, 29 September 2003 08:54 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Sachin,
I dont know about your environment, but if you are already making a local export dump, then copying that file to the network share is bound to be MUCH FASTER than doing the remote export all over again across the network.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
