Manage HTTP Access in Application Express 3.0 After default installation of Oracle APEX 3.0, remote users are not allowed to access…
Installation of Oracle Application Intergration Architecture Foundation Pack (AIA) 11g including Oracle SOA Suite 11g with Oracle BAM 11g on Oracle…
This short demo demonstrates how to uninstall Oracle SOA Suite 11g including WebLogic platform and database schemas. Go to uninstall directory…
Automate Oracle Database startup shutdown script orarun – script automates database start, stop, status query tasks, also allows user to manage…
View Also: Oracle DBA Interview Questions Answered: Technical 1. Q: How do you automate starting and shutting down of databases in…
Scenario: To drop, truncate multiple or all tables from user’s schema. Let’s suppose we’ve got the following tables in user’s schema…
Scenario: UserX tries to run SQL Tuning Advisor on a long running SELECT query in the database. The SQL Tuning Advisor…
The Doordefender protects your cars doors against paint scratches, door dings and door dents when you park. With its patented magnetic…
Oracle Installer 11g doesn’t provide “uninstall database” option… In order to uninstall Oracle Database 11g go to “deinstall” directory in $ORACLE_HOME:…
CASE: Cannot change sga_max_size ORA–02095: specified initialization parameter cannot be modified (Cause: The specified initialization parameter is not modifiable) Simulation: SQL>…