Mohammad Nazmul Huda
Search this site
About Me
Certifications
Employment History
Publications
Study Resources
Training
Technical Docs
Oracle
Managing Database
Backup and Recovery
Performance Tuning
ASM
Security
Replication
Database Change
Data Guard
Cloud Control
LISTENER
Parameters
SQL
SQL Functions
PL/SQL
ORA ERROR
12c Issues
Bugs
Scripts
Tools
OCM
Teradata
MySQL
SQL SERVER
Linux
AWS
Data Science
Other
Contact
ORA ERROR
ORA-00257: archiver error. Connect internal only, until freed
ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST
ORA-03297: file contains used data beyond requested RESIZE value
ORA-00031: session marked for kill
ORA-01017 : invalid username/password; logon denied (Using Database Link)
ORA-01017: invalid username/password; logon denied (Password expire)
ORA-39087: directory name DPUMP_DIR is invalid
ORA-16000: database open for read-only access
ORA-02067: transaction or savepoing rollback required
ORA-01873: the leading precision of the interval is too small
ORA-00932: inconsistent datatypes: expected - got LONG
ORA-20000: ORU-10027:buffer overflow, limit of 2000 bytes
ORA-12162: TNS:net service name is incorrectly specified
ORA-12505: TNS:listener does not currently known of SID given in connect descriptor
ORA-12514: TNS:listener does not currently known of service requested in connect descriptor
ORA-44416: Unresolved Principal
ORA-01436: CONNECT BY loop in user data
ORA-00922: missing or invalid option (log_archive_dest)
ORA-32021: parameter value longer than 255 characters (log_archive_dest)
ORA-16025: parameter LOG_ARCHIVE_DEST contains repeated or conflicting attributes
ORA-00600: internal error code, arguments: [kfnslnstanceReg00]
ORA-23419: regenerate replication support before resuming master activity
ORA-01450: maximum key length (3218) exceeded
ORA-01450: maximum key length (6318) exceeded
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DGMGRL)
TNS-12516 TNS:listener could not find instance with matching protocol stack
ORA-12516:TNS:listener could not find available handler with matching protocol stack
TNS-12519:TNS: no appropriate service handler found
ORA-12519:TNS: no appropriate service handler found
ORA-12520:TNS:listener could not find available handler for requested type of server
ORA-00054: resource busy and acquire with NOWAIT specified
ORA-20005: object statistics are locked (stattype = ALL)
ORA-38028: object statistics are locked
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
ORA-02298: cannot validate(%s.%s)-parent keys not found
ORA-01502:index <INDEX_NAME> or partition of such index is in unusable state
ORA-15260: permission denied on ASM disk group
ORA-06512: at "SYS.SCN_TO_TIMESTAMP"
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-12528: TNS:listener: all appropriate instances are blocking new connection during connection to ASM instance remotely
ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device
ORA 28 your session has been killed
ORA-04084: cannot change NEW values for this trigger type
ORA-39213: Metadata processing is not available
ORA-4088, ORA-6512 Using Triggers and RAISE_APPLICATION_ERROR
ORA-16057 DGID from server not in Data Guard configuration
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-01422: exact fetch returns more than requested number of rows (Error during Import)
ORA-01422: exact fetch returns more than requested number of rows
ORA-14141: ALTER INDEX VISIBLE|INVISIBLE may not be combined with other operations From Toad
ORA-30554: function-based index index_name is disabled
ORA-24247: network access denied by access control list (ACL)
ORA-30554: function-based index index_name is disabled
ORA-00955: name is already used by an existing object
ORA-09968, ORA-01102, ORA-10997 When Starting a Database
ORA-27154 on Database Startup After System Crash
ORA-01031: insufficient privileges while connecting to database as sysdba
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-16139: media recovery required
ORA-16826: apply service state is inconsistent with the DelayMins property
ORA-16766: Redo Apply is stopped (Error From Dataguard Broker)
ORA-01775: looping chain of synonyms in Toad
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file (After renaming database)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-23421: job number is not a job in the job queue
ORA-02082: a loopback database link must have a connection qualifier
ORA-02024: database link not found (Cannot drop a database link after changing the global_name)
ORA-12052: cannot fast refresh materialized view
ORA-23308: object %s.%s does not exist or is invalid
ORA-01102: cannot mount database in EXCLUSIVE mode (During database startup)
ORA-00845: MEMORY_TARGET not supported on this system (During Starting Instance )
ORA-28040: No matching authentication protocol (Using JDBC Connection to 12c Database )
ORA-20079: Full Resync from Primary Database Is Not Done (After new files are added to primary, rman fails at Standby)
ORA-15081: failed to submit an I/O operation to a disk
ORA-02275: such a referential constraint already exists in the table
ORA-600 [kccsbck_first] - What to Check
ORA-16014: log # sequence# ### not archived, no available destinations (Standby Database)
ORA-09925: Unable To Create Audit Trail File
ORA-4091: table <schema>.tablename is mutating, trigger/function may not see it
ORA-00060: deadlock detected while waiting for resource (Deadlock during delete from parent and insert on child)
ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index
ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-00922: missing or invalid option during create user or Change password
ORA-06553: PLS-306: wrong number or types of arguments in call to 'REPORT_SQL_MONITOR_LIST'
ORA-29285: file write error with utl_file.open
ORA-15149: another ASM instance found running on the host
ORA-04021: timeout occurred while waiting to lock object %s%s%s%s%s
ORA-17502: ksfdcre:4 Failed to create file +DATA during Physical Standby creation using RMAN
ORA-16014: log X sequence# XXX not archived, no available destinations (In Standby Database)
ORA-19511: Error received from media manager layer, error text: ANS1017E (RC-50) Session rejected: TCP/IP connection failure
crsctl Error: CLSU-00100 CLSU-00101 CLSU-00103 CLSU-00104 "cant open scr home dir scls_scr_getval" as Hostname was Changed
Background Media Recovery terminated with ORA-1274 after adding a Datafile
Oracle Restart: WARNING: unknown state for ASM password file location resource, Return Value: 3
Mount ASM disk group fails with: ORA-15186, ORA-15025
TNS-12547:TNS:lost contact, Linux Error:104: Connection reset by peer
TNS-12537:TNS:connection closed, Linux Error: 29: Illegal seek
TNS-12533: TNS:illegal ADDRESS parameters
TNS-12543: TNS:destination host unreachable
Message 1053 not found; No message file for product=network giving by lsnrctl status command
ERROR: Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name
ERROR: failed to establish dependency between database <database name> and diskgroup resource ora.<diskgroup name>.dg
IO exception: The Network Adapter could not establish the connection
SP2-0317 expected symbol name is missing
SP2-0717 Illegal SHUTDOWN option
WARNING: Limit of open file descriptors is found to be 1024
oracleasm >= 1.0.4 is needed by
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
RMAN
-
06429
: RCVCAT
database
is
not
compatible
with
this
version
of RMAN
RMAN
-
07539
: insufficient privileges
to
create
or
upgrade the catalog schema
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file during creation of physical standby using RMAN
RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause during creation of Physical Standby using RMAN
RMAN-08138: WARNING: archived log not deleted - must create more backups
RMAN fails with ORA-19502 and ORA-27072
After restart of database suddenly PLS-00553: character set name is not recognized are seen in the alert.log
PLS-00428: an INTO clause is expected in this SELECT statement
EM 12c Emctl Start Oms Fails with Error Oracle Management Server is Down
EM 12c: ORA-28001: the password has expired The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=<port>)))(CONNECT_DATA=(SID=<sid>)(SERVER=DEDICATED)))
Internal Error has occurred. Check the log file for details after login EM Cloud control 12c
ASMCMD-8102: no connection to ASM; command requires ASM to run
ASM Start Failing with ORA-29701 and ORA-01078
Oracleasm createdisk fails with selinux enabled
OCR create keys failed for root with OCR error 27
Execution failed: Can't locate Env.pm in @INC (Perl script (roothas.pl))
$GRID_HOME/bin/ocrconfig.bin: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
Oracleasm configure fails with selinux enable
Opatch fails with Error :"The relation between 2 composites[DB BP,DB PSU] are invalid."
Comments