Hi.
How to connect the user sys as sysdba to a database Oracle?
The following sections of the Administrators Guide should provide all the information needed to get your Oracle server monitored with SAM.
Thank you, aLTeReGo.
But for some sql queries preferred credentials are required, ie the user must have a role sysdba.
I tried to change the Credentials, asking the user as sysdba:
connection worked, but the request was not working out due to lack of privileges.
I also tried to do it all just for Oracle Driver Type: microsoft. Net data provider, but have not tried ODP.NET.
Tomorrow will install ODP.NET and try to Credentials as sysdba.
With ODP.NET user sys similar to not connect as sysdba
It is not currently possible to use SAM's Oracle User Experience Monitor with "sqlplus <user>/<pw>@<DB>" like syntax. This is currently a feature request we're tracking internally under FB71852. A potential workaround may be to use the ODBC User Experience Monitor instead?
Updated links where you can learn more about the Oracle User Experience monitor include:
Grant the user sysdba permissions then put in the password field AS SYSDBA e.g. for user Solarwinds/SWPassWord. In the username field put 'Solarwinds' in the password field put 'SWPassWord as sysdba'. Without the speech marks
