Home » Archive

Articles in the Oracle Category

Oracle Error »

[22 Nov 2009 | No Comment | 142 views]

ORA-31409: one or more values for input parameters are incorrect
Cause: One or more of the inputs to the procedure had invalid values.
Action: Identify the bad parameter(s) and supply correct values to the procedure.

Oracle Code »

[22 Nov 2009 | No Comment | 309 views]

Enlarge a datafile

ALTER DATABASE datafile ‘/path/datafile.dbf’ resize 1024M;

Oracle Error »

[22 Nov 2009 | No Comment | 243 views]

ORA-31224: DBMS_LDAP: invalid LDAP session
Cause: An attempt was made by a PL/SQL module to use an LDAP session which is not valid and might have already been closed.
Action: Check the LDAP session handle in PL/SQL module involving DBMS_LDAP.

Oracle Error »

[22 Nov 2009 | No Comment | 111 views]

ORA-31229: DBMS_LDAP: invalid input parameter
Cause: An invalid argument has been passed by a PL/SQL module to a DBMS_LDAP subprogram
Action: Check the input argument to the DBMS_LDAP subprogram in PL/SQL module involving DBMS_LDAP.

Oracle Error »

[22 Nov 2009 | No Comment | 91 views]

ORA-31399: Cannot contact LDAP server string at port number
Cause: The LDAP server specified could not be contacted. This can happen if the server is down or inaccessible.
Action: Contact the administrator of the LDAP server ////////////////////////// End of DBMS_LDAP & OiD messages

Oracle Error »

[22 Nov 2009 | No Comment | 145 views]

ORA-31405: cannot make changes while change set string is advancing
Cause: The change set is currently advancing. Change sources related to an advancing change set cannot be altered. Change tables related to the advancing change set cannot be created, altered or dropped. Some or all the parameters of the change set cannot be altered while the set is advancing.
Action: Wait until the change set has finished advancing, then reissue the command. If altering the change set, only the advance_enable parameter can be altered during an advance.