Showing posts with label ora. Show all posts
Showing posts with label ora. Show all posts

Oracle error - ORA-01074: cannot shut down ORACLE; inside a login session - log off first

Oracle error
oracle, oracle error, oracle blog
ORA-01074: cannot shut down ORACLE; inside a login session - log off first


Cause: Obvious
Action: None



See more oracle error here.

Oracle error- ORA-01073: fatal connection error: unrecognized call type

Oracle error
oracle, oracle error, oracle blog
ORA-01073: fatal connection error: unrecognized call type


Cause: An illegal internal operation was attempted.
Action: Contact your customer support representative.



See more oracle error here.

Oracle error - ORA-01072: cannot stop ORACLE; ORACLE not running

Oracle error
oracle, oracle error, oracle blog
ORA-01072: cannot stop ORACLE; ORACLE not running


Cause: Obvious
Action: None

See more oracle error here.

Oracle error - ORA-01071: cannot perform operation without starting up ORACLE

Oracle error
oracle, oracle error, oracle blog


ORA-01071: cannot perform operation without starting up ORACLE
Cause: Obvious
Action: None




See more oracle error here.

Oracle error - ORA-01070: Using an old version of Oracle for the server

Oracle error
oracle, oracle error, oracle blog



ORA-01070: Using an old version of Oracle for the server
Cause: Using pre 7.0.10.1 version of oracle for server
Action: Upgrade server to post 7.0.10.1 version



See more oracle error here.

Oracle error- ORA-01062: unable to allocate memory for define buffer

Oracle error
oracle, oracle error, oracle blog


ORA-01062: unable to allocate memory for define buffer
Cause: Exceeded the maximum buffer size for current plaform
Action: Use piecewise fetch with a smaller buffer size



See more oracle error here.

Oracle error- ORA-01061: cannot start up a V8 server using a V7 client application

Oracle error
oracle, oracle error, oracle blog



ORA-01061: cannot start up a V8 server using a V7 client application
Cause: You are using an Oracle client application linked with version 7 (or lower) libraries and you attempted to start up a V8 (or higher) server.
Action: Use a client application linked with V8 (or higher) libraries.60







See more oracle error here.

Oracle error - ORA-01060: array binds or executes not allowed

Oracle error
oracle, oracle error, oracle blog



ORA-01060: array binds or executes not allowed
Cause: The client application attempted to bind an array of cursors or attempted to repeatedly execute against a PL/SQL block with a bind variable of type cursor.
Action: Bind a single cursor or execute the PL/SQL block once.







See more oracle error here.

Oracle error - ORA-01059: parse expected before a bind or execute

Oracle error
oracle, oracle error, oracle blog



ORA-01059: parse expected before a bind or execute
Cause: The client application attempted to bind a variable or execute a cursor opened in a PL/SQL block before the statement was parsed.
Action: Ensure the statement is parsed before a bind or execute.







See more oracle error here.

Oracle error - ORA-01058: internal New Upi interface error

Oracle error
oracle, oracle error, oracle blog


ORA-01058: internal New Upi interface error
Cause: Attempt to delete non existant hstdef extension.
Action: Report as a bug.




See more oracle error here.

Oracle error- ORA-01055: Object datatypes not supported for bind or define in this mode

Oracle error
oracle, oracle error, oracle blog
ORA-01055: Object datatypes not supported for bind or define in this mode


Cause: Bind or Define used for objects with an invalid mode
Action: Change the mode.



See more oracle error here.

oracle error- ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified

Oracle error
oracle, oracle error, oracle blog
ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified

Cause: A valid destination for parameter LOG_ARCHIVE_DUPLEX_DEST was not specified when parameter LOG_ARCHIVE_MIN_SUCCEED_DEST was set to two.
Action: Either specify a value for parameter LOG_ARCHIVE_DUPLEX_DEST, or reduce the value for parameter LOG_ARCHIVE_MIN_SUCCEED_DEST to one.


See more oracle error here.

oracle error- ORA-01037: maximum cursor memory exceeded

Oracle error
oracle, oracle error, oracle blog


ORA-01037: maximum cursor memory exceeded

Cause: Attempting to process a complex sql statement which consumed all available memory of the cursor.
Action: Simplify the complex sql statement.


See more oracle error here.

oracle error- ORA-01036: illegal variable name/number

Oracle error
oracle, oracle error, oracle blog



ORA-01036: illegal variable name/number
Cause: Unable to find bind context on user side
Action: Make sure that the variable being bound is in the sql statement.

See more oracle error here.

oracle error- ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Oracle error
oracle, oracle error, oracle blog


ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Cause: Logins are disallowed because an instance started in restricted mode. Only users with RESTRICTED SESSION system privilege can log on.
Action: Request that Oracle be restarted without the restricted option or obtain the RESTRICTED SESSION system privilege.



See more oracle error here.

oracle error- ORA-01034: ORACLE not available

Oracle error
oracle, oracle error, oracle blog


ORA-01034: ORACLE not available
Cause: Oracle was not started up. Possible causes include the following:- The SGA requires more space than was allocated for it. - The operating-system variable pointing to the instance is improperly defined.
Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.


See more oracle error here.

oracle error- ORA-01033: ORACLE initialization or shutdown in progress

Oracle error
oracle, oracle error, oracle blog
ORA-01033: ORACLE initialization or shutdown in progress


Cause: An attempt was made to log on while Oracle is being started up or shutdown.
Action: Wait a few minutes. Then retry the operation.



See more oracle error here.

oracle error- ORA-01032: no such userid

Oracle error
oracle, oracle error, oracle blog


ORA-01032: no such userid
Cause: This is an internal error message related to Export/Import.
Action: Contact customer support.



See more oracle error here.

oracle error- ORA-01031: insufficient privileges - error

Oracle error
oracle, oracle error, oracle blog
ORA-01031: insufficient privileges

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.


See more oracle error here.

oracle error- ORA-01030: SELECT ... INTO variable does not exist

Oracle error
oracle, oracle error, oracle blog


ORA-01030: SELECT ... INTO variable does not exist
Cause: The SELECT... INTO specified in the bind call does not correspond to a variable in the SQL statement.
Action: If it is not possible to correct the statement, call customer support.

See more oracle error here.