How SharePlex reports out-of-sync conditions For all objects except those involved in transformation, SharePlex verifies that the source and target data in a given operation are synchronized before posting the…
Read MoreThe Idle Time Resource Usage setting limits the maximum idle time allowed in a session. Idle time is a continuous inactive period during a session, expressed in minutes. Long-running queries…
Read MoreEnable & Disable ADDM reports in Pluggable Database Oracle you can configure ADDM reports for Pluggable database(PDBs). By default it is disabled. You need to enable it manually by executing…
Read MoreRecover a dropped table in Oracle 11g Steps to recover a dropped table in Oracle 11g when flashback mode is off After dropping table and before restoring it from the…
Read MoreORA-00704 bootstrap process failure After Upgrading ORACLE_HOME (from 11.1.0.7.0 to 12.1.0.2.0), I was started my database by using startup command, then got below error. Connected to an idle instance. SQL>…
Read MoreADJRIINITPASSWD.sql Fails With An ORA-01031 Error: Error: Unable to execute statement < Begin ad_jar.get_jripasswords(:l_storepass, :l_keypass); End; > len = 63 AD Administration error: ORA-01031: insufficient privileges ORA-06512: at “SYS.DBMS_SESSION”, line…
Read MoreChange WEB Port on 12.2 The steps to change the webport to 8000. Step-1:Start only Weblogic admin using adadminsrvctl.sh start on run file system Login to Enterprise Manager(em) Console using below…
Read MoreORA-01017: invalid username/password; logon denied ERROR: ORA-01017: invalid username/password; logon denied First of all you need to edit your sqlnet.ora adding (or lowering) the parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER to…
Read MoreOracle Database 18c new features Versions 18.1.0 18.2.0 18.3.0 General Features in 18C we can configure ORACLE_HOME in read-only mode. we can CANCEL any database session SQL query (instead…
Read MoreData Guard New Features in Oracle 18c and 19c Data Guard Oracle Data Guard ensures high availability disaster recovery and data protection for enterprise data Data Guard maintains these standby…
Read More