Archive for June, 2007
Thursday, June 14th, 2007
Like the Nissan Pathfinder's ad: "not that you would, but you could". In certain performance test conditions, you may have to drop the current DB2 V8 instance, install V9.1, and re-create a instance. Here is a short list of helpful commands - run as root unless specifically sudo'ed:
1. Drop ...
Posted in db tuning, automation, system admin, aix, ibm db2 | No Comments »
Thursday, June 14th, 2007
This tip resolves Oracle client error: "ORA-12705: Cannot access NLS data files or invalid environment specified". According to Oracle documentation, "ORA-12705" can happen under the following conditions:
1. ORA-12705 with incorrect NLS_LANG parameter
2. ORA-12705 with incorrectly specified ORA_NLSx
3. ORA-12705 from incorrect Oracle install or configuration
4. ORA-12705 when using Special Character ...
Posted in oracle | No Comments »
Thursday, June 14th, 2007
Sometimes you want to preserve only a directory structure into a tar ball without having to archive the files themselves. This can happen if you want to backup a pre-defined directory structure, run some tests, and do not really care about the files created during the test. You ...
Posted in system admin, aix, linux | No Comments »
Tuesday, June 5th, 2007
Below shows simple steps in Oracle 9i and 10g to backup and restore Oracle databases; the goal is for the tasks to be called remotely so they can be automated as part of a performance test execution (i.e., always restores a known baseline before start a test!)1) Shuts down the ...
Posted in automation, backup and restore, windows, oracle | No Comments »
Sunday, June 3rd, 2007
Steps taken to to increase the storage for an existing logical volume. The following commands
are for AIX. The steps, however, are universal. You only need to substitute the commands for other platforms.
1) How big is the vg?
<Oracle 10.2.0.2 - ora10g>/home/oracle $ lsvg oradata_vg
VOLUME GROUP: ...
Posted in system admin, hardware setup | No Comments »