Oracle-L: Re: Help required: Enterprise Manager Console -> Export/Import/Backup

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 06 Nov 2002 07:56:40 -0800
Message-ID: <F001.004FCC0A.20021106075640@fatcity.com>

Sysman is not a user on the database. Set preferered credentials to someone who has sysdba privs or export full database, import full database privs.

Ruth

Original Message ----- From: Arif Khan (GWL) To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 06, 2002 10:04 AM Subject: Help required: Enterprise Manager Console -> Export/Import/Backup

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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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

Received on Wed Nov 06 2002 - 09:56:40 CST