Recent Articles
Perform the following setup instructions:
1. Follow instructions to enable verbosegc in WebSphere Application Server Read more...
Have you ever wondered what the codes listed at Apache acces_log mean
172.21.90.160 - - [05/Jan/2010:08:15:42 +0000] "GET HTTP/1.1" 200 554
172.21.90.160 - - [05/Jan/2010:08:15:42 +0000] "GET HTTP/1.1" 304 -
172.21.90.160 - - [05/Jan/2010:08:15:42 +0000] "GET HTTP/1.1" 304 –
I have more than 100 database servers. How can I report if my backup was successful?
Normally one can use shell scripts and grep rman log for errors but here is a better way
Read more...
- What is an "Application Server"? An application server is a server computer on a computer network dedicated to running certain software applications. Generally, an application server is a software engine that delivers applications to client computers.
After an install run config.bat to create default weblogic configuration Read more...
Plug-In Logs
WebServer http Plugin will create log, by default named as http-plugin.log, placed under PLUGIN_HOME/logs/
Plugin writes Error messages into this log. The attribute which deals with this is
< Log > in the plugin-cfg.xml
For Example
< Log LogLevel="Error" Name="/opt/IBM/WebSphere/Plugins/logs/http_plugin.log" / > Read more...
Hierarchy of directories of documents
In a Network Deployment environment, changes made to configuration documents in the cell repository, are automatically replicated to the same configuration documents that are stored on nodes throughout the cell. Read more...
Application server configuration files define the available application servers, their configurations, and their contents. Read more...
Check Server Status:
cd /opt/IBM/WebSphere/AppServer/profiles/Profile01/Node01/bin
serverStatus server1
serverStatus -all (returns status for all defined servers)
serverStatus -trace (produces the serverStatus.log file)
XDB enable use of FTP and HTML protocols to access and manage files located on ASM disksgroups. Files can be easily browse or moved in/out from ASM this way.
Attached script will create a spool file for user granted roles, object Privileges
My Statspack has following details.
Enqueue activity DB/Inst: Snaps: 1791-1808
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc
One of my 10.2.0.1 database was hanging despite allocating ample opf resources. The CPU, Memory,Disk accesses were normal but under heavy load server would freeze for no valid reason. I had to raise TAR with Oracle.
Example 1 : Running Execute immediate with an OUT parameter.
I wanted to output a count of tables to see if there is a data difference between Live/Test. I would have created a SQL script but it is hard to share with other developers so I found creating a procedure handy.
Step-1 Run the G:\obiee_windows_x86_101341\Windows\Server\Oracle_Business_Intelligence\setup.exe to display the welcome page.
Oracle 10g's DBMS_SCHEDULER provides significant improvements over DBMS_JOB for scheduling jobs and tasks. Let's take an overview of new functionalities that the Oracle Scheduler provides for DBAs.
The VMware Converter is amazing piece of software which will:
1) Import a Virtual Machine from a physical machine
2) Configure newly created Virtual Machine to make an existing image bootable
Below is a windows BATCH script used to Maintain RMAN catalogue. The script accepts 3 parameters Target SID, Target password and catalogue password.
Duplicate Database using rman
connect target rman/%password%@primary_server
connect auxiliary sys/%password%@standby_server
connect rcvcat rman/%password%@recovery_catalog
run {
set until time '27-JUL-2009 10:59:00';
allocate auxiliary channel tp1 type "sbt_tape";
allocate auxiliary channel tp2 type "sbt_tape";
If you have already uninstalled Oracle Clusterware using the Oracle Universal Installer - Please download attached file cleanup.zip that contains a copy of the logpartformat.exe and the guioracleobjmanage.exe (plus necessary dll).
How do I install CVU from OTN? Download From Here