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 … Continue reading The Backdoor Entry to Oracle Database

Advertisements

DataGuard:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Please check service name and db_uniquie_name on the Production server. alter system set log_archive_dest_3='SERVICE=  < NAME >  VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) LGWR ASYNC DB_UNIQUE_NAME= <Name>' ;

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

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 … Continue reading Migration Error “sql error on script execution. try deleting repository before creating repository”

MySQL show current connection info Hostname and Port Number ?

If you want to know the port number of your local host on which Mysql is running you can use this query on MySQL Command line client SHOW VARIABLES WHERE Variable_name = 'port'; If you want to know the hostname of your Mysql you can use this query on MySQL Command line client SHOW VARIABLES … Continue reading MySQL show current connection info Hostname and Port Number ?

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" … Continue reading 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 … Continue reading ORA-38754: FLASHBACK DATABASE not started; required redo log is not available