Oracle - Errores y soluciones

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01031: insufficient privilegesbases_datos_2

 


 

Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.

 

Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00020: maximum number of processes (string) exceededbases_datos_2

 


 

Cause: All process state objects are in use.

 

Action: Increase the value of the PROCESSES initialization parameter.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00021: session attached to some other process; cannot switch sessionbases_datos_2

 


 

 

Cause: The user session is currently used by others.

 

Action: Do not switch to a session attached to some other process.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00022: invalid session ID; access deniedbases_datos_2

 


 

 

Cause: Either the session specified does not exist or the caller does not have the privilege to access it.

 

Action: Specify a valid session ID that you have privilege to access, that is either you own it or you have the CHANGE_USER privilege.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00023: session references process private memory; cannot detach sessionbases_datos_2

 


 

Cause: An attempt was made to detach the current session when it contains references to process private memory.

Action: A session may contain references to process memory (PGA) if it has an open network connection, a very large context area, or operating system privileges. To allow the detach, it may be necessary to close the session's database links and/or cursors. Detaching a session with operating system privileges is always disallowed.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00024: logins from more than one process not allowed in single-process modebases_datos_2

 


 

Cause: Trying to login more than once from different processes for ORACLE started in single-process mode.

 

Action: Logoff from the other process.

Oracle

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-00025: failed to allocate stringbases_datos_2

 


 

Cause: Out of memory.

 

Action: Restart with larger sga heap.