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-00439: feature not enabled: Real Application Clusters – ORA-01078: failure in processing system parameters
Cause: I try to nomount the standby single instance database using primary RAC database pfile, i get the error due to RAC enabled cluster parameters. Workaround: Go to pfile Disable cluster parameters from pfile
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
ORA-19910: can not change recovery target incarnation in control file
Cause: I try to reset the incarnation to previous state without knowing that database is in open state. This error is because of consistency mismatch prevention when database is in open mode. Workaround: Bounce the database to mount state Reset the incarnation
ORA-16525: The Oracle Data Guard broker is not yet available.
Cause: If broker is not enabled , then you end up with this error Workaround: Enable broker
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.
