Thursday, March 26, 2009, 02:43 PM - Oracle
Issue:
A backup with RMAN is after the actual backup is finished not responsive for a prolonged period of time.
Solution:
Probably the controlfile contains many unused delete object records:
Run a query "select count(*) from v$deleted_object". If this is as slow as the end of the RMAN session, you found the issue.
To solve this situation run:
SQL> execute dbms_backup_restore.resetcfilesection(19);
This effectively truncates v$deleted_object, resulting in fast backups again.
The issue should not occur anymore from Oracle 11.1.0.7 and higher.
| permalink |
Monday, March 2, 2009, 09:14 PM - Oracle, Oracle
Issue:
The Oracle Universal Installer (OUI) is not starting in Microsoft Windows. There is no error screen or anything relevant in the log files from the installer.
Solution:
The issue might be that the unzip action of the installer encounters a too long path, resulting in an error which is not logged. This is visible when trying to start the unzip step manually.
The solution is to place the installation software on a shorter path.
| permalink |
Wednesday, December 3, 2008, 10:38 PM - Microsoft SQL Server, Microsoft SQL Server
Issue:
You are expecting certain options in the maintenance cleanup plan (like option to select sub directory level for cleanup), and the option is just not there at one database, while it is present at another database.
Solution:
The problem is being caused be a mismatch in the SQL Server management Studio and the SQL server installation. Upgrade the SQL Server management studio to be at the same version of the SQL Server installation and the problem should disappear.
| permalink |
Wednesday, December 3, 2008, 10:34 PM - Oracle, Oracle
Issue:
You find an archiver hung error in log while Oracle is not in archive log mode (So archiver can not hang since it is not running....).
Solution:
Oracle is most likely connected with a database link to another database which is running in archive log mode. At that other database this exception occurred. The exception model of Oracle is such that the exception is communicate down to the requester of the action, which apparently requested some data coinciding with the occurance of the archive log error. This way the requesting database, which is not running in archive log mode is logging an archiver error from another database.
Solve the archiver error at the other database.
| permalink |
Friday, October 31, 2008, 08:36 AM - Oracle
Issue:
Oracle 10/11 chooses in the cost based optimizer for a full table scan instead of using the index. This is done when the cost of both options are equal according to Oracle.
Solution:
There are 2 possible solutions:
1. Use a hint: It garantees that the index will be used all the time;
2. Oracle chooses alphabetically when the cost is equal: Rename your index to a place earlier in the alphabet than your table: This lets Oracle keep its behaviour but still get the index when the cost is equal.
| permalink |
Friday, October 31, 2008, 08:20 AM - Oracle, Oracle
Issue:
Oracle 10.2.0.3 dataguard fails with a divide by zero exception crashing the memory recovery proces (MRP0).
Solution:
The solution is twofold:
1. Upgrade oracle to 10.2.0.4 (see metalink for details)
2. Just restart the process:
Login with sqlplus.
The database is still running, so just type:
RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Recovery should continu (archive logs will be applied).
| permalink | related link |
Tuesday, October 21, 2008, 08:23 PM - SuSE
Issue:
While running make to compile a program, it fails with stubs32.h not found.
Solution:
Create a symbolic link from stubs-64.h to stubs-32.h and run make again. The problem should be solved.
| permalink |
Wednesday, June 18, 2008, 08:03 PM - Joomla
Issue:
You are trying to load a template using the Joomla 1.5 MVC model, but you run into an error 500 - Layout "templatename" not found.
Solution:
Check for typos in the view name and template name. Use lowercase only.
Do not use the word "view" to start your view with. Joomla strips the word view of the template path only (I regard this as a bug, not a feature). It tolerates the word view when resolving the view.html.php file. So for example viewCustomer is not possible. This will resolve to customer for the template name. Try lookatcustomer instead (all lowercase).
| permalink |
Monday, June 9, 2008, 11:55 AM - Java
Issue:
Bea JRockit Mission Control does not want to connect to the Bea instance. It reports connection refused.
Solution:
A possible cause is that the -Xmanagement parameter is not in the correct location in the startup string. The startup string should look like:
${JAVA_HOME}/bin/java ${JAVA_VM} ${MEM_ARGS} ${JAVA_OPTIONS} -Dweblogic.Name=${SERVER_NAME} -Djava.security.policy=${WL_HOME}/server/lib/weblogic.policy ${PROXY_SETTINGS} -Xmanagement ${SERVER_CLASS} >"${WLS_REDIRECT_LOG}" 2>&1
With the -Xmanagement parameter just before the starting class.
| permalink |
Sunday, June 8, 2008, 01:34 PM - Joomla
Issue:
How to create a custom admin interface button in Joomla (1.5).
Solution:
The code to create the button should be as follows:
JToolBarHelper::custom("task","image1.png","image1Over.png","text for underneath the button",Check for list item (true/false),hide main menu after click (true/false));
| permalink |
Saturday, June 7, 2008, 11:30 AM - Joomla
Issue:
In Joomla 1.5 you try to create a new JTable object, but somehow it results in a blank screen. The apache log shows:
Call to a member function bind() on a non-object
Solution:
If it is a new JTable object from a self build component, the name and location of the object need to be in lowercase and as follows:
Location:
Use JTable::addIncludePath(JPATH_ADMINISTRATOR.DS.'components'.DS.'com_yourcomponent'.DS.'yourtablesubdirectory');
to add the path of your JTable objects to the search path of Joomla.
Use lowercase directory names and file names only.
Name the JTable class file name to the object you are trying to load:
$table = & JTable::getInstance('nameofobject','Table');.
The nameofobject has to become your file name: nameofobject.php in the locate indicated in the addIncludePath.
| permalink |
Friday, June 6, 2008, 07:41 PM - Joomla
Issue:
After adding a view to a component in Joonla 1.5 you get an error 500, view not found, on linux when trying to access this view.
Solution:
Use the view name in lowercase, and also the directory name of the view in lowercase. This (combined with typing the correct view name) should result in a different response (maybe good, maybe a different error 500).
| permalink |
Tuesday, June 3, 2008, 03:29 PM - Java
Issue:
While using a JMS configuration with multiple persistent stores in Bea WLS 9.2, there is an error stating the following:
<Warning> <Store> <managed server name 1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <> <BEA-280076> <Database table "weblogicWLStore" for store "PersistentStore-01" is currently owned by "[name={server=managed_03!host=x.y.x.a!domain=abc!store=PersistentStore-03!table=weblogicWLStore}]". Trying to wait for ownership.>
<Error> <Store> <managed server name 2> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <> <BEA-280077> <JDBC store "PersistentStore-01" in this server is not the owner of database table "weblogicWLStore". Unexpected current owner is "[name={server=managed_03!host=x.y.z.a!domain=abc!store=PersistentStore-03!table=weblogicWLStore}]", expected current owner is "[name={server=managed_01!host=x.y.z.a!domain=abc!store=PersistentStore-01!table=weblogicWLStore}]".>
<Error> <Store> <managed server name 2> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1212496576272> <BEA-280072> <JDBC store "PersistentStore-01" failed to open table "weblogicWLStore".
weblogic.store.io.jdbc.JDBCStoreException: [Store:280064]280077 (server="managed_01" store="PersistentStore-01" table="weblogicWLStore")
at weblogic.store.io.jdbc.JDBCStoreIO.checkTableOwnership(JDBCStoreIO.java:1991)
at weblogic.store.io.jdbc.JDBCStoreIO.getTableOwnershipLogical(JDBCStoreIO.java:2104)
at weblogic.store.io.jdbc.JDBCStoreIO.open(JDBCStoreIO.java:382)
at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:353)
at weblogic.store.admin.AdminHandler.activate(AdminHandler.java:135)
at weblogic.store.admin.JDBCAdminHandler.activate(JDBCAdminHandler.java:64)
at weblogic.management.utils.GenericManagedService.activateDeployment(GenericManagedService.java:237)
Solution:
The persistent store prefix (use the admin interface, edit persistent store) can be altered to have a table per persistent store. This way no table lock conflicts rise and all managed servers can start.
| permalink |
Tuesday, June 3, 2008, 11:58 AM - Java
Issue:
After an upgrade of the Bea Weblogic server, the environment does not want to start. The error from Bea is BEA-149610.
Solution:
Remove from servers your admin server and managed servers. They have something cached, which requires a rebuild from Bea, which fails because it is trying to start the admin server at the same time. After removal of the servers, the environment starts.
| permalink |
Tuesday, June 3, 2008, 10:03 AM - Java
Issue:
During the installation of Bea weblogic 10, the console mode installer reports to little disk space available:
Choose Product Installation Directories:
----------------------------------------
BEA Home Directory: [/opt/weblogic]
Product Installation Directories:
"Default Product Home" = [Enter new value or use default "/opt/weblogic/wlserver_10.0"]
** Insufficient disk space! The installer requires:
** 91MB for the BEA Home at /opt/weblogic,
** 362MB for the product at /opt/weblogic/wlserver_10.0 and
** 367MB temporary work space at /tmp/bea50538.tmp.
** There is only 375MB available at /tmp.
Note however that there is actually a larger number available on tmp in this case.
Solution:
Ignore the error, it is bogus.
| permalink |
Monday, June 2, 2008, 09:19 PM - Joomla
Issue:
Joomla 1.5 fails to install a component with the following error:
Component Install: SQL error or missing or unreadable SQL file. DB function reports no errors.
Solution:
The installer looks for the files within the admin files folder. This means that the files also have to be placed like standard files. Example xml config file:
<..>
<install>
<sql>
<file driver="mysql" charset="utf8">sql/install.mysql.sql</file>
</sql>
</install>
<..>
<administration>
<menu>Standard component name</menu>
<files folder="admin">
<filename>sql/install.mysql.sql</filename>
<..>
</administration>
<..>
| permalink |
Monday, June 2, 2008, 10:06 AM - Java
Issue:
The installation files as downloadable from Bea Weblogic are jar files instead of the executable files as mentioned in the installation manual.
Solution:
Use a different manual.
The important command is:
java -jar <jarfile> -mode=console
| permalink |
Friday, May 23, 2008, 09:17 AM - Java
Issue:
Bea Weblogic JMS information is not showing on any other machine in a cluster except the physical machine where the JMS is running.
Solution:
Bea implemented the JMS service standard as a high performance solution. To use this:
A JMS server has to be created per managed server (non-migratable);
The queues have to be created as (uniform) distributed queues with as target the cluster;
The connection factory also has to target the cluster.
| permalink |
Wednesday, April 16, 2008, 04:24 PM - General applicable solutions
Issue:
Unknown run time error in IE7 occurs while trying to put content in a div with javascript. No errors are to be seen in Firefox.
Solution:
Most likely a reserved keyword has been used as id for the div (like id=submit). Rename the div to another term, and the problem will most likely disappear.
| permalink |
Tuesday, April 8, 2008, 01:03 PM
Issue:
While using dbms_output.put_line no output shows up at the console using sqlplus.
Solution:
Set serveroutput to on:
set serveroutput on
Now output will be visible
| permalink | related link |
Next
