Home » RDBMS Server » Enterprise Manager » Oracle Expert Error ...
Oracle Expert Error ... [message #67899] Tue, 02 July 2002 04:11 Go to next message
Hitesh Shenoy
Messages: 11
Registered: January 2002
Junior Member
I have configured OEM 9.0.1 on my clients database. I am using Oracle Expert to view performance of my database. When I try to collect info for my Tuning Session I get the following error :

XP-21161: Database connection attempt has failed
ORA-28009: connection to sys should be as sysdba or sysoper

Cause: Expert was unable to establish the requested
database connection.

Action: Check the accompanying Oracle Server message for
a full description of the connection problem.

It is possible that the service specification
used in the connection attempt is not correct.
Expert accepts 3 types of service information:

o A database alias as defined in the
TNSNAMES.ORA file

o A Net8 descriptor block

o A network port specification using:

<host-name>:<database-port>:<database-sid>

But I have connected to my database in OEM with “sys as sysdba”. Also I have configured the Preferred Credentials in Preferences to connect “sys as sysdba”.

Please advise.

Regards,
Hitesh Shenoy
Re: Oracle Expert Error ... [message #67900 is a reply to message #67899] Tue, 02 July 2002 05:06 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Set
o7_dictionary_accessibility=true in init<SID>.ora
(By default this is set to 'false' for Oracle Server 9i)and restart the database server.
Previous Topic: Oracle SQL statement 00900 error
Next Topic: 9iR2 OEM discover nodes doesn't discover W2K 8.1.7 agent
Goto Forum:
  


Current Time: Thu Mar 28 05:02:38 CDT 2024