Flashback Table
Flashback Table
Read MoreScript to check if sql connectivity hangs in RAC nodes due to different issues
### Schedule the script in crontab every 2 minutes based on need, to check if the sql connectivity is ### successful without hanging in each RAC node. mail_id=`cat /home/oracle/scripts/mail_members.txt`file=/home/oracle/scripts/logs/1.logif […
Read MoreHow to change Virtual IP and Scan IP in an existing RAC environment
Output of current Host file: =================== # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 #OLD…
Read MoreCalling Operating System Commands From PL/SQL Using External Procedures
Calling Operating System Commands From PL/SQL Using External Procedures (Doc ID 99136.1) Overview The ability to call operating system commands from PL/SQL is a feature that is easily implemented in…
Read MoreMinimal downtime rolling database upgrade to 12c Release 1
Minimal downtime rolling database upgrade to 12c Release 1 This note describes the procedure used to perform a rolling database upgrade from 11.2.0.3 to Oracle 12c Release 1 using a…
Read MoreOracle E-Business Suite Extensions for Oracle Endeca
Overview: Oracle Endeca Information Discovery (EID) is a sophisticated data discovery platform that searches for and filters data. It is based on a patented hybrid search-analytical database, and…
Read MoreRun SQL Tuning Advisor from SQL Prompt
Get SQL ID===========select distinct hash_value, sql_id, sql_textfrom v$sqlwhere sql_text like ‘%pktable_cat%’and sql_text not like ‘select distinct hash_value, sql_id%’;Create Tuning Task:===================DECLAREmy_task_name VARCHAR2(30);BEGINmy_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_id => ‘0j3dqg3a8aj8c’,scope => ‘COMPREHENSIVE’,time_limit => 3600, task_name =>…
Read MoreORA-01741: illegal zero-length identifier
Scenario: ======== While adding multiple schemas to a single workspace, we get the following error in Apex version 4.1 which is identified as a Bug in the version and it…
Read MoreError “ORA-0000: normal, successful completion” during Gather Schema Statistics for AP Schema
ISSUE:——— When attempting to run the concurrent program Gather Schema Statistics for AP schema the following error occurs. ERROR ———- ORA-0000: normal, successful completion +—————————————————————————+ Start of log messages from…
Read More