Error 45 initializing SQL*Plus

My command : $nohup sqlplus "/ as sysdba" @script.sql & Error Messages : Error 45 initializing SQL*Plus Solutions: Go to end of the script, You have to add another line with a lone "/" after it, or you will get this error. Bug 3039738 - Error 45 Initializing Sql*Plus Running A Shell Script    

Advertisements

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 … Continue reading ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.

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 … Continue reading ERROR: ORA-00257: archiver error. Connect internal only, until freed.

ORA-01950: no privileges on tablespace ‘USERS’ [closed]

The problem was with quota on the USERS tablespace. Granting unlimited quota for the user on the USERS tablespace resolved the problem: You cannot insert data because you have a quota of 0 on the tablespace. To fix this, run ALTER USER <user> quota unlimited on <tablespace name>; or ALTER USER <user> quota 100M on … Continue reading ORA-01950: no privileges on tablespace ‘USERS’ [closed]

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 … Continue reading ORA-09925 Solution On Oracle Linux 6

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, … Continue reading ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

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 : … Continue reading Bash: sqlplus: command not found solution