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>' ;

Advertisements

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

Speed of crsctl stop crs vs. crsctl stop cluster

a single step process  $ crsctl start crs Start it in a two-step process.  Here we start the HA service (HAS):  $ crsctl start has then, you start the clusterware stack by with crsctl start cluster:  $ crsctl start cluster -all