Teckstack

ALPHAGEEK369

CHANGE BACKGROUND AND FONT COLOUR OF PUTTY SCREEN

In putty , you can configure the putty background and font with multiple colours Load the connection details from session field and then point to colours option Uncheck the “Use system colours” checkbox and click “Default background” and click modify option to choose a background colour for your putty screen Likewise click on “Default Foreground” … Continue reading “CHANGE BACKGROUND AND FONT COLOUR OF PUTTY SCREEN”

[INS-00001] Unknown irrecoverable error

Cause: This error occurred for me due to improper settings of environment variables Below error is thrown during invoke of dbca Workaround: Ensure that proper environment variables are set

DIFFERENCE BETWEEN ARCHIVE LOG CURRENT AND SWITCH LOGFILE ORACLE

ARCHIVE LOG CURRENT: Syntactically different Specifically used in RAC Slow Synchronous IO Can be used for log switch of individual RAC instance or all instances of RAC Waits for ARCH process to archive the current log Logfile: SWITCH LOGFILE: Fast log switch Checkpoint will be incomplete Asynchronous IO Used for both single instance and RAC … Continue reading “DIFFERENCE BETWEEN ARCHIVE LOG CURRENT AND SWITCH LOGFILE ORACLE”

RMAN-05535: WARNING: All redo log files were not defined properly.

Cause: This error is triggered due to primary database as RAC and standby database as single instance Workaround: Ignore the warning because while perform of rman duplication to create standby database, due to dual thread in RAC as primary database but in standby database there is only one thread

ORA-01516: nonexistent log file, data file, or temporary file

Cause: I drop a datafile and run into the below error. I crosschecked syntax and it is correct. Workaround: Issue can be reproduced by creating a datafile and check to see what is the behaviour. This may happen in a RAC database with an active passive cluster with switchover operation performed

INSTALL SWINGBENCH IN LINUX

Download swingbench from the link http://www.dominicgiles.com/downloads.html Copy the file using winscp to linux from windows Unzip the file Locate to the swingbench directory Invoke oewizard script from the installation bin directory in swingbench Click on next Check the recommended version of swingbench Create the OE schema with its metadata objects Give the connection details of … Continue reading “INSTALL SWINGBENCH IN LINUX”

SWITCHOVER USING DGMGRL BROKER IN ORACLE DATAGUARD

Switchover is an activity which acts as a role reversal with guaranteed protection to data. Here primary database acts as a standby and standby database acts as a primary!! We can perform switchover in situations like maintenance of primary database like patching,migration of a database from one server to another etc.. Switchover using broker is … Continue reading “SWITCHOVER USING DGMGRL BROKER IN ORACLE DATAGUARD”

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow My Blog

Get new content delivered directly to your inbox.