Hardware and Networking Tips: June 2011

Thursday, June 30, 2011

PROBLEM IN ACCESSING CD DRIVE OF SERVER IN CLIENT MACHINES

We have noticed at some places that ever after sharing the cd drive of the server and keeping the workgroup of server and client same, the drive is not accessible from client machine and it gives message that drive is not accessible. However it works fine on server. We have opened both the server and client by administrator password also.

kindly suggest solution

SANJEEV BHATEJA

SQL QUERY TO FIND OUT THE STATUS OF GENISYS PATCH LOADING IN THE DATABASE

We can find out what are the Genisys Patches / Versions loaded in the Genisys Database by executing below mentioned SQL query.

START ---> RUN ---> CMD

C:\>SET ORACLE_SID = INS

C:\>sqlplus "/as sysdba"

This command will successful, if the entry

"SQLNET.AUTHENTICATION_SERVICES=NTS" in

E:\Oracle\Ora92\Network\Admin\sqlnet.ora"

SQL>

SQL>SELECT * FROM GEN_PARAM_TABLE WHERE LOWER(TXT_PARAM_CODE) LIKE '%GLOBAL%';

***THIS SQL QUERY WILL HELP THE ADMINISTRATOR TO KNOW THE STATUS OF PATCHES LOADED TILL DATE***

Nageswaran AG

PROBLEM IN NETWORK CONNECTIVITY BETWEEN SERVER AND CLIENT MACHINE

The above tips posted by

Nageswaran AG

PROBLEM IN NETWORK CONNECTIVITY BETWEEN SERVER AND CLIENT MACHINE

CLIENT MACHINES NOT CONNECTED WITH SERVER, RESULTING WHICH GENISYS USERS NOT ABLE TO LOGIN TO DATABASE

ERROR MESSAGE " DATABASE NOT CONNECTED "

THE FOLLOWING STEPS MAY HELPFUL TO IDENTIFY / RECTIFY THE PROBLEMS:

CLIENT MACHINE:

START ----> RUN ----> ping <Server IPaddress> -t

** if you get the result as "TIMED OUT", then there is a problem

** Check the "LAN-CARD" cable is plugged correctly, if not fix it up properly
and then check the connectivity.

** Eventhen Network connection is not establieshed.

SERVER:

** Check the "LAN-CARD" cable is fixed correctly with Server and Router, if not
plugged it up properly and then check the connectivity.

** Eventhen Network connection is not established.

** START ---> SETTINGS ---> NETWORK CONNECTIONS ----> OPEN ---->

** if "LOCAL AREA CONNECTIONS" is having "RED-CROSS SIGN and NOTCONNECTED"

** RIGHT-CLICK "LOCAL AREA CONNECTIONS" and change the
ENABLE button to DISABLE

The RED-CROSS SIGN will disappear and connection will be established.

CLIENT MACHINE:

*** NOW USERS WILL BE ABLE TO LOGIN TO GENISYS DATABASE ***

EXPECTATIONS FROM DATA RECOVERY SESSION TO BE HELD ON 02.07.2011 10AM TO 11.30 AM

Kindly accept our heartiest thanks for designing the program on Basic Hardware Maintainance and Effective Utilisation ( June 27 to July 2, 2011) in a very nice way . Faculty too is the best one.

Sir, we would like to bring to your kind notice that most of the officers in our batch are from DOs or ROs only. I am also working in I.T. Deptt at regional office. Our region is having approx 100 offices/servers alongwith approx 10 clients in each office. So, we are dealing with thousand of machines.

In routine we are formatting 7-8 servers in a week ( Mostly due to virus issue). We generally copy last 2-3 backups and then format the server. After restoration, sometimes, we come to know that all 2-3 backups were infected with virus. If we would have taken the backup files of last week or last month, it would have been restored properly. So, in data recovery session we would expect that following topics must be covered:

1. Data recovery from formatted hard disks.

2. Data recovery from physically damaged hard disks ( Because sometimes HDD gets damaged as they are coming from the long distances )

So that we can physically open the hard disks and replace the physically damaged part or burnt part or we can recover the data with the help of some softwares.

Such kind of session will save lot of money, which we are forced to pay to the data recovery engineers, who asks for thousands of rupees to recover the data.

Pl try to cover this topic . We shall be very grateful to you

Thanks and Regards

SANJEEV BHATEJA
ASST MANAGER

SQL QUERY - TO CREATE ORACLESERVICEINS

SQL Query to create Oracle_Services_INS for Genisys Database

ORADIM -NEW -SID INS -INTPWD ORACLE -STARTMODE AUTO -PFILE E:\ORACLE\ADMIN\INS\PFILE\INITINS.ORA

Nageswaran AG

Fw: Shortcut to Install D2K in Client Machine

--- On Wed, 6/29/11, Nageswaran AG <nageshag@yahoo.com> wrote:

From: Nageswaran AG <nageshag@yahoo.com>
Subject: Shortcut to Install D2K in Client Machine
To: girijesh.niahardware2011@blogger.com
Cc: "nagesh" <nageswaranag1@gmail.com>
Date: Wednesday, June 29, 2011, 6:35 PM

It is an alternative method to install D2K in Client machine where D2K software CD not available.

The follwing steps to be followed :

1. Copy the folders from the working client machine

     C:\Orawin95 or Orant

    C:\System

     C:\Windows\msvcrt2x.dll

     C:\Windows\mfcans32.dll
     C:\Windows\oc30.dll

2. Extract the registry files from the working client machine

     Start-->Run-->Regedit-->Export

     Create a file and copy to the Client machine where stop-1 done, in Desktop.

3. Double click the copied file.

Now this Client machine is installed D2K software without CD.

Nageswaran AG

What is bad sector and How can we repair it ?

Bad sectors are little clusters of data on your hard disk that cannot be read. More than that, though, they are the potential to cause real damage to your hard drive (catastrophic failure) if they build up over time, stressing your read arm. Bad sectors are fairly common with normal computer use and the imperfections of the world we live in; however, there are several simple steps you can take to prevent HDD bad sectors and to repair any that you do have. Here is a step-by-step guide.

What is a sector, and how are HDD bad sectors created?

A sector is simply a unit of information stored on your hard disk. Rather than being a soupy mass of fluid information, your hard disk stores things neatly into "sectors". The standard sector size is 512 bytes.

There are various problems that can cause HDD bad sectors:

Improper shutdown of Windows;
Defects of the hard disk, including general surface wear, pollution of the air inside the unit, or the head touching the surface of the disk;
Other poor quality or aging hardware, including a bad processor fan, dodgy data cables, an overheated hard drive;
Malware.

Hard and soft bad sectors

There are two types of bad sectors – hard and soft.

Hard bad sectors are the ones that are physically damaged (that can happen because of a head crash), or in a fixed magnetic state. If your computer is bumped while the hard disk is writing data, is exposed to extreme heat, or simply has a faulty mechanical part that is allowing the head to contact the disk surface, a "hard bad sector" might be created. Hard bad sectors cannot be repaired, but they can be prevented.

Soft bad sectors occur when an error correction code (ECC) found in the sector does not match the content of the sector. A soft bad sector is sometimes explained as the "hard drive formatting wearing out" - they are logical errors, not the physical ones. These are repairable by overwriting everything on the disk with zeros.

How to repair bad sectors

Windows has inbuilt check disk tool, called "Chkdsk". It is recommended to run this tool from time to time. It will scan the disk for errors, fix logical errors, detect and mark bad sectors, so that Windows will no longer try to use them. This way it can prevent your computer from becoming unstable.

There is a slight disadvantage, though – Check Disk may require a lot of time to perform its task. It depends on many things, like overall PC speed, number of files and folders on the disk, amount of RAM, and disk size. So it's best to run Check Disk only if you don't need to use the computer for some time.

Also Windows Chkdsk wants exclusive access to the computer. In most cases it will ask for a reboot and will run right after the reboot, so you won't have access to your PC. Of course, you can always interrupt the process, but it's not a good idea.

To run Check Disk do this:

Find the My Computer icon on your desktop and double-click it;
Find the disk you want to check, right-click it and go to Properties;
In the Properties dialog box go to Tools;
Click Check now;
A new dialog box will appear, check both options and click Start;
Most likely you will get a message that Check Disk wants exclusive access to the disk and wants to start right after your reboot. Click OK;
Restart your computer.

Preventing bad sectors

You can help prevent bad sectors (always better than trying to repair them!) by paying attention to both the hardware and the software on your computer.

Preventing bad sectors caused by hardware

Make sure your computer is kept cool and dust free;
Make sure you buy good quality hardware from respected brands;
Always move your computer carefully;
Keep your data cables as short as possible;
Always shut down your computer correctly - use an uninterrupted power supply if your house is prone to blackouts.

Thanks

Pravin K

Wednesday, June 29, 2011

How to Format the C Drive on a Windows XP SP2

Sir,

The following link provides easy steps to install Windows-XP-SP2 in C Drive.You can provide it in your blog

http://www.wikihow.com/Format-the-C-Drive-on-a-Windows-XP-SP2

Thanks,

Swapnil Gondane.

Disk Cleanup for Windows XP Users

Windows XP users

Click Start, point to All Programs, point to Accessories, point to System Tools, and then click Disk Cleanup. If several drives are available, you might be prompted to specify which drive you want to clean.
In the Disk Cleanup for dialog box, scroll through the content of the Files to delete list.
Clear the check boxes for files that you don't want to delete, and then click OK.
When prompted to confirm that you want to delete the specified files, click Yes.

After a few minutes, the process completes and the Disk Cleanup dialog box closes, leaving your computer cleaner and potentially performing better.

Thanks & Regards

Pravin K
Administrative Officer (IT Specialist)
United India Insurance Company

Chennai

How to Perform Scandisk in Windows

Below link is from Microsoft Support. Simple and easy to follow. It may be helpful to explore few more pages on the same site.

http://support.microsoft.com/kb/156571

Data Recovery

Below link talks about a data recovery software. It also gives good idea about what can reduce the chance of data recovery.

http://www.quetek.com/maximize_disk_recovery.htm#data