ORA-Fehler
ORA-01792 „maximum number of columns in a table or view is 1000“
a) Texte aus oerr unter Linux01792, 00000, „maximum number of columns in a table or view is 1000“// *Cause: An attempt was made to create a table or view with more than 1000// columns, or to add more columns to a table or view which pushes// it over...
ORA-02142 „missing or invalid ALTER TABLESPACE option“
a) Texte aus oerr unter Linux02142, 00000, „missing or invalid ALTER TABLESPACE option“// *Cause: A valid option was not present.// *Action: Use one of the valid options: add, rename, default, online,// offline, read only, read write, begin, end, no,...
ORA-02143 „invalid STORAGE option“
a) Texte aus oerr unter Linux02143, 00000, „invalid STORAGE option“// *Cause: An option other than INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, or// PCTINCREASE was specified in the STORAGE clause.// *Action: Specify only valid options. b) ErklärungDieser Fehler tritt auf,...
ORA-02154 „a tablespace with the name ‚%s‘ is found“
a) Texte aus oerr unter Linux02154, 00000, „a tablespace with the name ‚%s‘ is found“// *Cause: An attempt to rename a tablespace to a new name failed because// the new name is already used by some other tablespace.// *Action: Retry with a different...
ORA-12701 „CREATE DATABASE character set is not known“
a) Texte aus oerr unter Linux12701, 00000, „CREATE DATABASE character set is not known“// *Cause: The character set specified when creating the database is unknown.// *Action: b) ErklärungDieser Fehler tritt auf, wenn beim Create Database kein gültiger...
ORA-01033 ORACLE initialization or shutdown in progress
1.) Texte aus oerr unter Linux 01033, 00000, „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. 2.) Erklärung Eine...
ORA-01089 – immediate shutdown in progress – no operations are permitted
1.) Texte aus oerr unter Linux 01089, 00000, „immediate shutdown in progress – no operations are permitted“ // *Cause: The SHUTDOWN IMMEDIATE command was used to shut down // a running ORACLE instance, so your operations have been // terminated. //...
ORA-01654 – unable to extend index %s.%s by %s in tablespace %s
1.) Texte aus oerr unter Linux 01654, 00000, „unable to extend index %s.%s by %s in tablespace %s“ // *Cause: Failed to allocate an extent of the required number of blocks for // an index segment in the tablespace indicated. // *Action: Use ALTER TABLESPACE...
ORA-00054 – resource busy and acquire with NOWAIT specified or timeout expired
1.) Texte aus oerr unter Linux 00054, 00000, „resource busy and acquire with NOWAIT specified or timeout expired“ // *Cause: Interested resource is busy. // *Action: Retry if necessary or increase timeout. 2.) Erklärung Diese Fehlermeldung tritt auf, wenn die...
ORA-12719 operation requires database is in RESTRICTED mod
1.) Texte aus oerr unter Linux // *Cause: This command can only be run when the database is in RESTRICTED mode// *Action: Ensure that the system is in RESTRICTED mode 2.) Erklärung Der Fehler ORA-12719 tritt bei einem „DROP DATABASE“ auf, wenn die Datenbank nicht im...
ORA-12570 – TNS:packet reader failure
1.) Texte aus oerr unter Linux 12570, 00000, „TNS:packet reader failure“ // *Cause: An error occurred during a data receive. // *Action: Not normally visible to the user. For further details, turn // on tracing and reexecute the operation. If error persists, contact...
ORA-17627: ORA-01017: invalid username/password; logon denied
Lösung: bei bestehender Anpassung von Listener.ora und tnsnames.ora – wird eine Passwortdatei auf der auxiliary benötigt