FAQ
A couple of things come to mind...

Set credentials for the node ORATEST, usually the user you installed
oracle with on the node.
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.
Ensure that the 'Logon as Batch Job' privilege is set for the Windows
user that you used in the preferred credentials for the node.
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 <>

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).

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 6 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 6, '02 at 3:04p
activeNov 6, '02 at 8:05p
posts6
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase