Friday, September 30, 2011

ORA-01156 while issuing alter database add standby logfile

Problem Description
After creating physical standby database, whenever it was tried to add standby logfile while standby database is in recovery process it fails with error ORA-01156.

SQL> alter database add standby logfile thread 2;

ERROR at line 1:
ORA-01156: recovery in progress may need access to files

Cause of the Problem
The standby database is in managed standby mode and you cannot add standby redo log while the database is in managed recovery mode.

Solution of the Problem
In order to solve the problem in the standby database just follow simple three steps.

Step 01: Cancel managed recovery mode.
SQL> alter database recover managed standby database cancel;

Step 02: Add the Standby logfile.
SQL> alter database add standby logfile group {n} {filename} size {size};

Step 03: Reinstate Managed Recovery Mode.
SQL> alter database recover managed standby database disconnect from session;

Wednesday, September 28, 2011

In ActiveCollab Print preview layout as default layout in chrome

In ActiveCollab whenever any user use Google chrome and login as well as do any activities on Chrome browser always a banner appears across the pages saying "Print Preview" and close button. In Firefox and other browser, we don't see this issue.

The problem with alternate stylesheet is caused by the fact that the link tag doesn't have - a title! Chrome browser respects that and shows the Print Preview across pages.

In order to fix it quick just

1) open the file /activecollab_installation_dir/application/modules/system/layouts/wireframe.tpl in a text editor

2)Find the line 17, which should look something like this:

<link rel="alternate stylesheet" href="{$assets_url}/print_preview.php?theme_name={$theme_name}" type="text/css" media="screen" id="print_preview_css" disabled="true" />

3) Replace that line of code with this one:

<link rel="alternate stylesheet" href="{$assets_url}/print_preview.php?theme_name={$theme_name}" type="text/css" media="screen" id="print_preview_css" disabled="true" title="Print Preview" />

Save it, upload in server and reload page.