ORA-02376: invalid or redundant resource
417430Dec 28 2009 — edited Mar 17 2010Hello,
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create profile test limit
2 composit_limit unlimited
3 session_per_user 2
4 cpu_per_session unlimited
5 cpu_per_call unlimited
6 logical_reads_per_session unlimited
7 logical_reads_per_call unlimited
8 idle_time unlimited
9 connect_time unlimited
10 private_sga unlimited
11 failed_login_attempts 10
12 password_life_time unlimited
13 password_reuse_time unlimited
14 password_reuse_max unlimited
15 password_lock_time unlimited
16 password_grace_time unlimited;
composit_limit unlimited
*
ERROR at line 2:
ORA-02376: invalid or redundant resource
SQL> CREATE PROFILE test LIMIT
2 SESSIONS_PER_USER 2
3 CPU_PER_SESSION UNLIMITED
4 CPU_PER_CALL UNLIMITED
5 CONNECT_TIME UNLIMITED
6 LOGICAL_READS_PER_SESSION DEFAULT
7 LOGICAL_READS_PER_CALL UNLIMITED
8 PRIVATE_SGA UNLIMITED
9 COMPOSITE_LIMIT UNLIMITED
10 idle_time unlimited
11 failed_login_attempts 10
12 password_life_time unlimited
13 password_reuse_time unlimited
14 password_reuse_max unlimited
15 password_lock_time unlimited
16 password_grace_time unlimited
17 /
Profile created.
What is wrong in my first command? Any help is highly appreciated...