ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.

Problem : ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired. Solutions : + (Check the datafile size) Show Oracle Session; SELECT O.OBJECT_NAME, S.SID, S.SERIAL#, P.SPID, S.PROGRAM, SQ.SQL_FULLTEXT, S.LOGON_TIME FROM V$LOCKED_OBJECT L, DBA_OBJECTS O, V$SESSION S, V$PROCESS P, V$SQL SQ WHERE L.OBJECT_ID = O.OBJECT_ID AND L.SESSION_ID = S.SID AND […]

ERROR: ORA-00257: archiver error. Connect internal only, until freed.

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 27 08:31:46 2017 Copyright (c) 1982, 2013, Oracle.  All rights reserved. ERROR: ORA-00257: archiver error. Connect internal only, until freed. Fast solution is to simply increase the value for db_recovery_file_dest_size. Steps: SQL> sho parameter db_recovery_file NAME TYPE VALUE ———————————— ———– —————————— db_recovery_file_dest string /recoveryarea db_recovery_file_dest_size big integer 200G […]

ORA-09925 Solution On Oracle Linux 6

Error : [oracle@ErmanTestSTDBY ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 15 15:42:42 2017 Copyright (c) 1982, 2014, Oracle.  All rights reserved. ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 13: Permission denied Additional information: 9925 ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 13: Permission denied Additional […]

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

OS: Oracle Linux 6.8 Oracle Database: 12c Problem Description: SQL> startup ORACLE instance started. Total System Global Area 1644167168 bytes Fixed Size     2925024 bytes Variable Size 1056968224 bytes Database Buffers   570425344 bytes Redo Buffers   13848576 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open  In this case, […]

Bash: sqlplus: command not found solution

Error   Messages: [oracle@ermankara ~]$ sqplus / as sysdba -bash: sqplus: command not found Environment variable has been with a good, but still error: [oracle@ermankara ~]$ cat .bash_profile # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=ermankara.localdomain export ORACLE_UNQNAME=db12cc export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.2/db export ORACLE_SID=db12cc export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib Solution : […]