Hi,
on 10g R2 on Win 2008 server DBSNMP can not login :
sqlplus dbsnmp@MYDB
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Aug 18 07:35:19 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter password:
ERROR:
ORA-04088: error during execution of trigger 'SYSTEM.SET_CURRENT_SCHEMA_PM'
ORA-01403: no data found
ORA-06512: at line 5
But I have :
SQL> select username from dba_users where username like '%DBSNMP%';
USERNAME
------------------------------
DBSNMP
SQL> grant connect to dbsnmp;
Grant succeeded.
What might be the problem ?
Thank you.