RE: Help required: Enterprise Manager Console -> Export/Import/Ba

A couple of things come to mind...

1. Set credentials for the node ORATEST, usually the user you installed oracle with on the node.
2. Set credentials for the database to be a user with DBA privileges, possibly even create a specific user to act as the primary user that you will do this and other jobs as.
3. Ensure that the 'Logon as Batch Job' privilege is set for the Windows user that you used in the preferred credentials for the node.
4. Connect to EM Repository as the SYSMAN user, this will enable you to test the functionality and you can use a specific user once the problems are worked out.

HTH... Phil Wilson (phil_wilson_at_smartforce.com) DBA, Operations Group
SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w)
506.447.0334(c)

-----Original Message-----
Sent: Wednesday, November 06, 2002 11:04 AM To: Multiple recipients of list ORACLE-L

Come on folks...Help me, I am stuck...

I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the export wizard through the Enterprise Manager Console by doing the following: Under Database folder, I right click the Global Name (say ORCL) -> Data Management -> Export ...
and it comes back with the error Either Preferred Credentials are not set or the username and/or password are invalid for this database and node. You must set the Preferred Credentials for the database and node in the Oracle Enterprise Manager Console <<OK>>

I have logged in to EM-Console with SYSMAN user. Under System -> Preferences
-> Preferred Credential, for ORCL, I have tried using SYSMAN, SYSTEM and SYS
with Role as NORMAL, SYSDBA & SYSOPER.

I have no credentials setup for the Node (say ORATEST).

I am pretty new to Oracle 8i and hence may not be taking the right steps required.

So, what Id should I log in to EM-Console with??? What ID should I put under preferred credential against ORCL database What permissions does this ID need to have (Can they be provided logging in to sql plus with System or Sys account)
What ID should I put under preferred credential against Node ORATEST (Does this ID need to have any prerequisites/permissions) Any other info. I need to provide???

Thanks
Arif

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arif Khan (GWL)
  INET: Arif.Khan_at_Weston.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Phil Wilson (DBA)
  INET: Phil_Wilson_at_smartforce.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).