The Backdoor Entry to Oracle Database

The backdoor entry of the Oracle database! You can enter to the database through the back door using SQL * Plus tool with “Prelim” parameter  Prelim, directly connects to the SGA but it does not open a session. You can connect to the database with Prelim as following. [oracle@maxerman bin]$ sqlplus /nolog SQL*Plus: Release 12.1.0.2.0 […]

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 […]

Migration Error "sql error on script execution. try deleting repository before creating repository"

I got this message when try to associate migration repository. I created a user for the migration repository CREATE USER yatt IDENTIFIED BY yatt; user created. DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP; Grant succeeded. Installing Repository: Error Messages: I had the same problem, this was solved changing the GRANT statement with… GRANT ALL PRIVILEGES to {migration-name} identified […]

jTDS – SQL Server and Sybase JDBC driver

Description Open source JDBC 3.0 type 4 driver for Microsoft SQL Server (6.5 up to 2012) and Sybase ASE. jTDS is a complete implementation of the JDBC 3.0 spec and the fastest JDBC driver for MS SQL Server. For more information see http://jtds.sourceforge.net/ Setup Download the latest “jTDS – SQL Server and Sybase JDBC driver” […]

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available Cause Oracle needs to have the required archive logs in the archive destination at the time of flashback. Solution Use rman to restore the missing archive logs. The sequence and thread numbers are in the error message. rman target / run{ allocate channel t1 […]