Category Archives: Database

ORA Database Error Messages

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

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

ORA-00023: session references process private memory; cannot detach session
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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA Database Error Messages

ORA-00022: invalid session ID; access denied

ORA-00022: invalid session ID; access denied

ORA-00022: invalid session ID; access denied
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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA Database Error Messages

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

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

ORA-00021: session attached to some other process; cannot switch session
Cause: The user session is currently used by others.
Action: Do not switch to a session attached to some other process.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA Database Error Messages

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

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

ORA-00020: maximum number of processes (string) exceeded
Cause: All process state objects are in use.
Action: Increase the value of the PROCESSES initialization parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA Database Error Messages

ORA-00019: maximum number of session licenses exceeded

ORA-00019: maximum number of session licenses exceeded

ORA-00019: maximum number of session licenses exceeded
Cause: All licenses are in use.
Action: Increase the value of the LICENSE MAX SESSIONS initialization parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA Database Error Messages

ORA-00018: maximum number of sessions exceeded

ORA-00018: maximum number of sessions exceeded

ORA-00018: maximum number of sessions exceeded
Cause: All session state objects are in use.
Action: Increase the value of the SESSIONS initialization parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA Database Error Messages

ORA-00017: session requested to set trace event

ORA-00017: session requested to set trace event

ORA-00017: session requested to set trace event
Cause: The current session was requested to set a trace event by another session.
Action: This is used internally; no action is required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA Database Error Messages

ORA-00001: unique constraint (string.string) violated

ORA-00001: unique constraint (string.string) violated

ORA-00001: unique constraint (string.string) violated
Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.
Action: Either remove the unique restriction or do not insert the key.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA Database Error Messages

ORA-00000: normal, successful completion

ORA-00000: normal, successful completion

ORA-00000: normal, successful completion
Cause: Normal exit
Action: None

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

Database

I added a new datafile to the primary database, but not automatically added on standby

oracle

I added a new datafile to the primary database, but not automatically added on standby.

ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 129 is unknown – rename to correct file
ORA-01110: data file 129: ‘C:\ORACLE\ORA10G\DATABASE\UNNAMED00129’
ORA-01157: cannot identify/lock data file 129 – see DBWR trace file
ORA-01111: name for data file 129 is unknown – rename to correct file
ORA-01110: data file 129: ‘C:\ORACLE\ORA10G\DATABASE\UNNAMED00129’

Solution:

Note: It can run on umount state

1- Check the name of the datafile on standby database
SQL> select name from v$datafile; —- This command should show the datafile name as UNNAMEDxxxxx

2- On the standby database
SQL> alter system set standby_file_management=’manual’;

3- On the standby database rename the datafile
SQL> alter database create datafile ‘C:\ORACLE\ORA10G\DATABASE\UNNAMED00129’ as ‘C:\ORACLE\ORA10G\DATABASE\actual_dbfile_name.dbf’

4- On the standby database
SQL> alter system set standby_file_management=’auto’;

5- On the standby database
SQL> recover managed standby database disconnect;