| Oracle Expert Error ... [message #67899] |
Tue, 02 July 2002 04:11  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
