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

Advertisements

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