9 Replies Latest reply: Dec 10, 2012 8:36 AM by marlborocat RSS

    why all users can not login to database?

    marlborocat
      I have to grant DBA to the user??


      SQL> create user test_1 identified by test123;

      User created.

      SQL> grant create session to test_1;

      Grant succeeded.

      SQL> exit

      :->sqlplus test_1/test123

      SQL*Plus: Release 10.2.0.3.0 - Production on Fri Dec 7 15:24:06 2012

      Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

      ERROR:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-30511: invalid DDL operation in system triggers
      ORA-06512: at "SYS.LOAD_SESSION_MONITOR", line 13
      ORA-06512: at line 2


      Enter user-name: ^C
      (hqw0cdt1sora02.dev.pbgc.gov-oracle-pmtgen1) /orabin/rdbms/1020g/dbs
      :->sqlplus / as sysdba

      SQL*Plus: Release 10.2.0.3.0 - Production on Fri Dec 7 15:24:08 2012

      Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options

      SQL> grant dba to test_1
      2 ;

      Grant succeeded.

      SQL> exit
      Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options
      (hqw0cdt1sora02.dev.pbgc.gov-oracle-pmtgen1) /orabin/rdbms/1020g/dbs
      :->sqlplus test_1/test123

      SQL*Plus: Release 10.2.0.3.0 - Production on Fri Dec 7 15:24:17 2012

      Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options

      SQL>