Release 8.0.4
A58312-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8 Error Messages Release 8.0.4 A58312-01 |
|
This section lists messages generated when resources within the Oracle Server are altered.
Cause: A resource that is not defined or that is specified twice appears in the CREATE or ALTER PROFILE statement.
Action: Define the resource before issuing a CREATE or ALTER PROFILE command. Also check the statement to see that each resource is listed only once.
Cause: An invalid resource limit of 0 was specified.
Action: Specify a resource limit greater than 0.
Cause: The same resource was specified twice in a CREATE or ALTER PROFILE statement.
Action: Issue the statement again, carefully checking that each resource is used only once.
Cause: An attempt was made to create a profile that already exists.
Action: Create the profile with a name not already used by another profile.
Cause: An attempt was made to assign a user to a non-existent profile.
Action: Assign the user to an existing profile.
Cause: An attempt was made to drop the PUBLIC_DEFAULT profile.
Action: The PUBLIC_DEFAULT profile cannot be dropped.
Cause: An attempt was made to drop a profile that had users assigned to it without using the CASCADE option of the DROP PROFILE statement. A profile that has users assigned to it cannot be dropped, unless the CASCADE option is specified. CASCADE reassigns users to the PUBLIC_DEFAULT profile before dropping the profile.
Action: To reassign all users to the PUBLIC_DEFAULT profile, issue the DROP PROFILE statement with the CASCADE option.
Cause: A negative value or UNLIMITED cost was specified for this resource in the ALTER RESOURCE COST statement.
Action: Only positive integer values can be specified for resources in the ALTER RESOURCE COST statement. Issue the statement again, using a positive integer value for each resource specified.
Cause: The COMPOSITE_LIMIT for the profile is exceeded. That is, the weighted sum of the connection time, logical reads per session, CPU usage per session, and private SGA space used during the session exceeded the limit set by the COMPOSITE_LIMIT clause set in the user profile.
Action: If this happens often, ask the database administrator to raise the COMPOSITE_LIMIT of the user profile, or determine which resource is used the most and raise the limit on that resource.
Cause: An attempt was made to exceed the maximum number of concurrent sessions allowed by the SESSIONS_PER_USER clause of the user profile.
Action: End one or more concurrent sessions or ask the database administrator to increase the SESSIONS_PER_USER limit of the user profile. For more information about SESSIONS_PER_USER and the database administrator's specific tasks of adjusting concurrent sessions, see the index entries on "SESSIONS_PER_USER of CREATE PROFILE" in Oracle8 Server SQL Reference and on "LICENSE_MAX_SESSIONS parameter" in the Oracle8 Server Administrator's Guide.
Cause: An attempt was made to exceed the maximum CPU usage allowed by the CPU_PER_SESSION clause of the user profile.
Action: If this happens often, ask the database administrator to increase the CPU_PER_SESSION limit of the user profile.
Cause: An attempt was made to exceed the maximum CPU time for a call, a parse, execute, or fetch, allowed by the CPU_PER_CALL clause of the user profile.
Action: If this happens often, ask the database administrator to increase the CPU_PER_CALL limit of the user profile.
Cause: An attempt was made to exceed the maximum I/O allowed by the LOGICAL_READS_PER_SESSION clause of the user profile.
Action: If this happens often, ask the database administrator to increase the LOGICAL_READS_PER_SESSION limit of the user profile.
Cause: An attempt was made to exceed the maximum I/O for a call, a parse, execute, or fetch, allowed by the LOGICAL_READS_PER_CALL clause of the user profile.
Action: If this happens often, ask the database administrator to increase the LOGICAL_READS_PER_CALL limit of the user profile.
Cause: A user has exceeded the maximum time allowed to remain idle.
Action: The user must reconnect to the database.
Cause: This error occurs only when using a multi-threaded server.
Action: Contact the database administrator to expand the PRIVATE_SGA limit.
Cause: Stored procedures used up too much space in the SYSTEM tablespace.
Action: Use fewer stored procedures or add an additional file to the system tablespace.
Cause: A user has exceeded the maximum time allowed to be connected to the database.
Action: The user must reconnect to the database.
