Wednesday, August 10, 2011, 09:26 PM - Oracle
Issue:
Crosscheck is about 1 second (or more) per backup piece.
Solution:
It is possible that there are some full table scans in the query
SELECT NVL(MIN(SCN),POWER(2,64)-1)
FROM (
SELECT MIN(BRL.LOW_SCN) SCN
FROM BRL
WHERE BRL.DBINC_KEY = :B1 UNION
SELECT MIN(AL.LOW_SCN)
FROM AL
WHERE AL.DBINC_KEY = :B1 UNION
SELECT MIN(XAL.LOW_SCN)
FROM XAL
WHERE XAL.DBINC_KEY = :B1 UNION
SELECT MIN(BDF.CKP_SCN)
FROM BDF
WHERE BDF.DBINC_KEY = :B1 UNION
SELECT MIN(CDF.CKP_SCN)
FROM CDF
WHERE CDF.DBINC_KEY = :B1 UNION
SELECT MIN(XDF.CKP_SCN)
FROM XDF
WHERE XDF.DBINC_KEY = :B1 UNION
SELECT MIN(BCF.CKP_SCN)
FROM BCF
WHERE BCF.DBINC_KEY = :B1 UNION
SELECT MIN(CCF.CKP_SCN)
FROM CCF
WHERE CCF.DBINC_KEY = :B1 UNION
SELECT MIN(XCF.CKP_SCN)
FROM XCF
WHERE XCF.DBINC_KEY = :B1 );
This can be slightly improved by adding several indices:
create index idx_bcf_nn_1 on bcf(dbinc_key,ckp_scn);
create index idx_bdf_nn_1 on bdf(dbinc_key,ckp_scn);
create index idx_brl_nn_1 on brl(dbinc_key,low_scn);
If the indices are not helping, try altering db_file_multiblock_read_count to 0 (oracle 10/11 only). This can speed up the full table scans.
| permalink
Wednesday, April 6, 2011, 08:12 AM - Oracle
Issue:
There is a large back log in processing the XML uploaded by the agents. The AWR shows database related issues.
Solution:
There are several indexes which prevent some of the full table scans which speed up the processing speed considerably:
CREATE INDEX sysman.mgmt_current_metrics_idx1 ON sysman.mgmt_current_metrics (key_value,metrics_guid,target_guid);
and
CREATE INDEX sysman.mgmt_current_metrics_idx2 ON sysman.mgmt_current_metrics(target_guid, metric_guid, collection_timestamp);
Probably there are more (-:
| permalink
Tuesday, April 5, 2011, 03:36 PM - Linux
Issue:
Remove under unix gives an argument list too long.
Solution:
A possibility is to write a script:
TOBEREMOVED=start of file name to be removed
function larger_rm ()
{ while read line1; do
if [ $line1==$TOBEREMOVED* ]
then
if [ $line1 != $TOBEREMOVED ]
then
echo "removing "$line1
rm $line1
fi
fi
done
}
ls | larger_rm
This script removes all files except the file name itself (handy with historical files).
Warning: It is slow....
| permalink
Sunday, March 27, 2011, 06:06 PM - SuSE
Issue:
OpenSuse 11.4 Xen VM fails with ATA errors after upgrading to the desktop kernel version included in the distribution.
Solution:
Re-start the installation and install the default kernel instead of the Xen desktop kernels.
| permalink
Sunday, March 20, 2011, 09:23 AM - SuSE
Issue:
After a restart of the XEN kernel on OpenSuSE 11.4, DHCP of the bridged interface works, but a pint to the route returns with destination host unreachable.
Solution:
The eth interface used to communicate with the outside world is dropped out of the bridged configuration for unknown reasons. Use brctl add br0 eth0 to add the interface (and of course replace br0 and eth0 with your own values).
| permalink
Thursday, November 18, 2010, 10:54 AM - Oracle, Oracle
Issue:
Oracle Enterprise Manager has a large backlog of to be processed XML files.
Solution:
The problem can be that the stored procedure EMD_LOADER.UPDATE_CURRENT_METRICS is slow due to an not efficient index on the table SYSMAN.MGMT_CURRENT_METRICS. The index SYSMAN.MGMT_CURRENT_METRICS_PK is in the incorrect order to be efficient. Add the following index:
CREATE INDEX "SYSMAN"."MGMT_CURRENT_METRICS_IDX1_EFFICIENT" ON "SYSMAN"."MGMT_CURRENT_METRICS" ("KEY_VALUE", "METRIC_GUID", "TARGET_GUID");
| permalink
Sunday, September 12, 2010, 07:50 PM - General applicable solutions
Issue:
Your installed kvm virtual machine has run out of disk space and the volume created with qemu-img can not be formatted by Microsoft Windows (XP SP3).
Solution:
Create an image:
qemu-img create -f raw edrive.img 64G
Use fdisk (under linux) to create a disk header in the image:
fdisk /home/kvm/edrive.img
Press w
Add the image to your config:
qemu-kvm -cdrom /home/kvm/somecd.img -hda windowsxp_install.img -hdb edrive.img -m 1024 -net nic -net user &
Now the disk can be partitioned and formatted in Microsoft Windows (XP SP3)
| permalink
Thursday, June 24, 2010, 08:14 AM - Microsoft SQL Server, Microsoft SQL Server
Issue:
SQL Server Management Studio is slow while starting.
Solution:
The management studio can not find a certain URL. This can be fixed by adding the following line to the hosts file:
127.0.0.1 crl.microsoft.com
| permalink | related link
Wednesday, May 12, 2010, 02:48 PM - Oracle, Oracle
Issue:
Once in a while, depending on the installation size, the apache httpd access_log grows to 2GB on the Oracle Enterprise Manager Grid Control installation.
Solution:
There are two possible solutions:
A. Correct the log rotate setup;
B. Stop the logging.
This solution is the solution to stop the logging (since it is pretty much useless anyway).
Edit the sysman/config/httpd_em.conf file and hash out the following lines:
ErrorLog /oracle/product/oms10g/Apache/Apache/logs/error_log
TransferLog "/oracle/product/oms10g/Apache/Apache/logs/access_log"
to
# ErrorLog /oracle/product/oms10g/Apache/Apache/logs/error_log
# TransferLog "/oracle/product/oms10g/Apache/Apache/logs/access_log"
Delete the old log files from Apache/Apache/logs and restart grid control. The logging should be stopped.
| permalink
Tuesday, January 5, 2010, 10:22 AM - Microsoft SQL Server, Microsoft SQL Server
Issue:
The backup of the full database fails with error number -1073548784.
Solution:
Most likely the database requires a log file backup before a full backup is possible.
To see if the log file backup is required, select the following:
select log_reuse_wait_desc from sys.databases where name='your database name';
If this displays 'LOG_BACKUP', then first execute a transaction log backup. After the transaction log backup, the full backup should be possible again.
| permalink | related link
Tuesday, January 5, 2010, 07:39 AM - Microsoft SQL Server
Issue:
The disk containing the tempdb from SQL Server 2005 is near full.
Solution:
The tempdb can be moved by executing the following SQL and restarting the SQL Server instance:
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = '{location}tempdb.mdf');
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = '{location}templog.ldf');
GO
| permalink
Friday, December 25, 2009, 11:06 AM - Microsoft SQL Server
Issue:
You are trying to implement database mirroring with SQL Server 2005 instructions from http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx and fail at:
CREATE ENDPOINT [Mirroring]
AS TCP (LISTENER_PORT = 5022)
FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = ENABLED);
Solution:
The keyword ENCRYPTION=ENABLED should be ENCRYPTION=SUPPORTED
| permalink | related link
Monday, November 9, 2009, 10:21 PM - General applicable solutions
Issue:
Registration of tradebox fails due to badly written browser and java capability check.
Solution:
No claims due to any losses or mishaps when using this solution can be claimed. The solution is from the ABN Amro helpdesk:
Register using windows. At the end save the jnlp file. Copy the file to any system you want to start tradebox.
P.S. This is scary: The file contains the username/password combination in encrypted format. No user is requested anymore. Do not give to friends, keep in a save place. If lost: Block your accounts!
| permalink
Wednesday, November 4, 2009, 06:44 AM - Microsoft SQL Server
Issue:
A Microsoft SQL Server standby database needs to be brought online.
Solution:
Execute the command:
restore database [databasename] with recovery;
on the database server where the standby database is running.
| permalink
Monday, October 19, 2009, 10:26 AM - Microsoft SQL Server, Microsoft SQL Server
Issue:
The user rights assignment in SSIS is difficult to configure in such a way that a user does not require (local) administrator rights to be able to use SSIS.
Solution:
The following steps are required:
1. Add the user to the Distributed COM Users group using Administrative tools->Computer management->System tools->Local users and groups->groups->Distributed COM Users;
2. Open Control Panel, double-click Administrative Tools, and then double-click Component Services to start the Component Services MMC snap-in;
3. Expand the Component Services node in the left pane of the console. Expand the Computers node, expand My Computer, and then click the DCOM Config node;
4. Select the DCOM Config node, and then select MsDtsServer in the list of applications that can be configured;
5. Right-click on MsDtsServer and select Properties;
6. In the MsDtsServer Properties dialog box, select the Security tab.
7. Under Launch and Activation Permissions, select Customize, then click Edit to open the Launch Permission dialog box;
8. In the Launch Permission dialog box, add or delete users, and assign the appropriate permissions to the appropriate users and groups. The available permissions are Local Launch, Remote Launch, Local Activation, and Remote Activation. The Launch rights grant or deny permission to start and stop the service; the Activation rights grant or deny permission to connect to the service. Here select Local Activation only;
9. Click OK to close the dialog box;
10. Under Access Permissions, select Customize, and then click Edit;
11. In the Access Permission dialog box, add or delete users, and assign the appropriate permissions to the appropriate users and groups. Here select active Local & remote access;
12. Click OK to close the dialog box;
13. Close the MMC snap-in;
14. Restart the Integration Services service.
| permalink | related link
Wednesday, May 13, 2009, 11:27 AM - Oracle
Issue:
If Oracle dataguard stops receiving data due to full flash recovery area and init.ora shows standby_file_management=AUTO a fast way of recovery is required.
Solution:
Reset the dg_broker_start parameter on the primary database to false (alter system set dg_broker_start=false). DG broker stops. Then reset back to true.
Eventual gap can be resolved by copying the archivelogs to the dataguard and adding those archivelogs:
alter database register logfile 'fullpathtoarchivelog/logname';
| permalink
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
Next
