Solved

Setting Preferred Credentials in OEM

Posted on 2001-06-12
5
1,842 Views
Last Modified: 2013-12-03
I cannot perform an export or import after recently installing the OEM console.  

How do I set the Preferred Credentials? - the userid would be the Operating System userid?!  

I need a good explanation.

Any help would be greatly appreciated.

0
Comment
Question by:myramc
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:mathavra
ID: 6183505
This is a Oracle Note I received from Oracle a while ago. Hope this helps.

How to set Preferred Credentials for Enterprise Manager 2.x

The concept of "Preferred Credentials" allows DBAs to
store logon information used by EM Applications, Intelligent Agent and Data Gatherer. Logon information can be stored for any service type that is discovered by the Intelligent Agent.  For example: Database, Listener, Node (Host Server), Concurrent Managers, etc. If no preferred credentials are specified, logon errors like ORA-1017 will occur.


To set the credentials:

1. Logon to the EM 2.x Console as an EM Administrator.

2. Click on the main EM Console toolbar:

    System => Preferences => Preferred Credentials

3. All discovered and manually added services will display in the service list.

    Two options are available:
    --------------------------

a. Set the logon credentials in the "default" service for each service type.
 
    or

b. Highlight each service and provide a valid logon account for that service.

    Note:

    The "default" service credentials can be used if a generic account exists on all the services of that type.  For example, the database username / password can be set to system / manager. A Individual service logons takes
precedence over the "default" settings.

4.  Each EM 2.x Administrator should configure his/her own set of preferred credentials. A Repeat all three steps above for each EM 2.x Administrator including the default SYSMAN account.

Note:

    If the service is a database and SYSDBA or SYSOPER role is required, grant the role to the user and then select the option in the preferred credentials window.  If the option is selected and the role has not been granted, all logon attempts to that database will fail with an ORA-1017.

    If the host where the services are running is Windows NT, make sure the NT OS account has the LOGON AS A BATCH JOB privilege.
0
 

Author Comment

by:myramc
ID: 6183542
The login to specify is a database login, Not an Operating System login?  If this is so, why does the NT OS account have to have the 'logon as a batch job privilege'?
0
 
LVL 3

Accepted Solution

by:
mathavra earned 50 total points
ID: 6183752
If you would like to have the NT user account is configured for the Intelligent Agent (IA), you need to set that role for that account. The reason is that the Intelligent Agent attempts to establish a "new" Operating System (OS) logon session for each job that it receives. When it does that, the OS logon credentials are pulled from the Console's Preferred Credentials settings.
0
 

Author Comment

by:myramc
ID: 6187211
Thanks for the help.

I also created a new user for the console and gave it Super Administrator rights.  Before I have been using the default sysman user.
0
 
LVL 3

Expert Comment

by:mathavra
ID: 6187465
That is a good idea. We have it the same way. -Mathav
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle - Create Procedure with Paramater 16 56
Converting a row into a column 2 44
How to free up undo space? 3 29
push logos in footer up higher 5 10
Learn by example how to specify CSS selectors for Selenium WebDriver test automation software.
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now