Ask the Expert

Unable to connect to 7.3 database from 9.2 OEM

Can I use the Oracle Enterprise Manager Console utilities (e.g. performance manager, tuning pack, etc.) for a Oracle 7.3 database? I've installed the Oracle 9.2 client on my Oracle 7.3 database server to monitor performance -- and as per the help, I've created & assigned the select_catalog_role. There was no problem in installing 9.2 OEM, however I'm unable to connect to the database from this OEM. I get the required privileges missing message. Can you please help me?

    Requires Free Membership to View

The 'insufficient privileges' message usually indicates that you're connecting as a user who doesn't have the DBA role--is this the case? If so, try connecting as a DBA. I've never used OEM with an Oracle7 database, so I don't know if the combination is supported.

This was first published in May 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: