Here are some of the Top Oracle data guard queries/physical standby database queries for monitoring and troubleshooting How to check the archive log sequence on Primary Side SELECT THREAD# “Thread”,SEQUENCE# “Last Sequence Generated” FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#) ORDER BY 1; How to check the archive log […]
Top Oracle Data guard queries Read More »
Constraints are the ways to enforce data integrity rules in the Oracle database. If we dont require constraint at any point in time, we can drop constraint in Oracle using the alter table command. Let’s check with the addition of constraint and then drop them Oracle Table creation and Constraint creation SQL> CREATE TABLE “DEPT”
How to drop constraint in Oracle Read More »
In this post, we will discuss How to drop table in oracle,Drop table if exists in Oracle,How to drop multiple tables in oracle,drop table cascade Constraints, ORA-02449 How to drop table in oracle The DROP TABLE oracle command is used to remove a table from the database. The dropped table and its data remain no longer
How to drop table in oracle Read More »
We sometimes need to run Autoconfig on the Patch system in R12.2 in the current edition only. One case where this will be required is 19c Upgrade, we run FND conc clean as part of that and all entries are lost. But if you try to connect the Database from the patch filesystem, you will
How to run Autoconfig on Patch system in R12.2 Read More »
We may sometimes need to reset the MySQL root password on your Linux server. Here are the steps to do that We need the root user privilege to do this Step1 Login as root user and Stop the MySQL server /etc/init.d/mysql stoporservice mysql stop Step 2 Start MySQL in safe mode and skip the use
How to reset MySQL root password on your Linux server Read More »
We will go through the weblogic installation 10.3 .6 in the post. Similar will be the installation for Weblogic 12c Here are steps on How to perform weblogic Installation 1) Download the WebLogic software. The package WebLogic Server (10.3.6) generic installer for use with 64-bit JVMs should also be downloaded athttp://www.oracle.com/technetwork/middleware/weblogic/downloads. The filename is wls1036_generic.jar. 2)
How to perform weblogic Installation Read More »
