Content View Hits : 16815

Giriş Formu






Forgot your password?
Forgot your username?
No Account Yet? Create an account

Database Mail is stopped. Use sysmail_start_sp to start Database Mail. PDF Print E-mail
Written by Administrator   

This stored procedure starts the Database Mail queue that holds outgoing message requests and enables the Service Broker activation for the external program.

Solution :
USE msdb ;
GO

EXECUTE dbo.sysmail_start_sp ;
GO
Last Updated ( Monday, 05 July 2010 21:39 )
 
i can ping an ip adress but can't ping a computer name (domain name, host name etc.) PDF Print E-mail
Written by Administrator   

Ping uses name resolution to resolve a computer name into an IP address.

Therefore, if you successfully ping an IP address but you cannot ping a computer name, there is a problem with host name resolution, not with network connectivity.

  • Verify that DNS server addresses are configured for the computer, either manually in the properties of TCP/IP, or by automatic assignment. 
Try to ping the dns server addresses(DNS server addresses are listed when you type the ipconfig /all command) to make sure that they are accessible.
 if you cant ping you have to set right dns server adresses.
Last Updated ( Saturday, 03 July 2010 20:22 )
 
How to check Windows for 32-bit OS or 64-bit OS PDF Print E-mail
Written by Administrator   

to check Windows for 32-bit OS or 64-bit OS :

Start --> Run --> msinfo32.exe

 

System Type :

  • For 32-bit editions of Windows : x86-based PC.
  • For 64-bit editions of Windows : x64-based PC.

OS Name    Microsoft Windows XP Professional
Version    5.1.2600 Service Pack 3 Build 2600
OS Manufacturer   
System Name    
System Manufacturer    
System Model   
System Type    X86-based PC
Processor    x86 Family 6 Model 15 Stepping 13 GenuineIntel ~1994 Mhz
BIOS Version/Date    COMPAL 1.16, 12/31/2007
SMBIOS Version    2.4
Windows Directory    C:\WINDOWS
System Directory    C:\WINDOWS\system32
Boot Device    \Device\HarddiskVolume1
Locale    
Hardware Abstraction Layer    Version = "5.1.2600.5512 (xpsp.080413-2111)"
User Name    
Time Zone    GTB Daylight Time
Total Physical Memory    2,048.00 MB
Available Physical Memory    1.03 GB
Total Virtual Memory    2.00 GB
Available Virtual Memory    1.96 GB
Page File Space    3.84 GB
Page File    C:\pagefile.sys

 

Last Updated ( Tuesday, 13 April 2010 07:56 )
 
ORA-30926: unable to get a stable set of rows in the source tables PDF Print E-mail
Written by Administrator   

Cause

When you use merge statement

Action

 You have to check primary key constraint for two tables in merge statement.

 

 

 
redo blocks read, 55450 data blocks need recovery PDF Print E-mail
Written by Administrator   

oracle alert log

22344 redo blocks read, 55450 data blocks need recovery

there is no response in server 

 

you should :

startup mount;

recover database;

alter database open;

 

 

Last Updated ( Wednesday, 27 January 2010 12:17 )
 
More Articles...
« StartPrev12345678NextEnd »

Page 1 of 8