Installing Oracle AIA 11g Foundation Pack on Linux 64bit
Installation of Oracle Application Intergration Architecture Foundation Pack (AIA) 11g including Oracle SOA Suite 11g with Oracle BAM 11g on Oracle…
How to uninstall Oracle SOA Suite 11g & WebLogic Server
This short demo demonstrates how to uninstall Oracle SOA Suite 11g including WebLogic platform and database schemas. Go to uninstall directory…
Oracle database startup shutdown script
Automate Oracle Database startup shutdown script orarun – script automates database start, stop, status query tasks, also allows user to manage…
Oracle DBA Interview Questions Answered: UNIX
View Also: Oracle DBA Interview Questions Answered: Technical 1. Q: How do you automate starting and shutting down of databases in…
Drop multiple tables from users schemas
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…
Problem when creating the SQL Profile
Scenario: UserX tries to run SQL Tuning Advisor on a long running SELECT query in the database. The SQL Tuning Advisor…
Doordefender is in Holland
The Doordefender protects your cars doors against paint scratches, door dings and door dents when you park. With its patented magnetic…
How to uninstall Oracle Database 11g
Oracle Installer 11g doesn’t provide “uninstall database” option… In order to uninstall Oracle Database 11g go to “deinstall” directory in $ORACLE_HOME:…
How to increase SGA_MAX_SIZE
CASE: Cannot change sga_max_size ORA–02095: specified initialization parameter cannot be modified (Cause: The specified initialization parameter is not modifiable) Simulation: SQL>…
Enter the Linux
Introduction to Linux Linux is the name usually given to any Unix-like computer operating system that uses the Linux kernel. Linux…