Wednesday, July 6, 2011

ORACLE DATABASE “GENISYS” NOT CONNECTED FROM CLIENT MACHINE

It is also a possibility of not connecting oracle database "Genisys" from the Client machine that:

The Host address is not matching with the Server IP address / Name in "Listner.ora" file available in "Oracle\Ora92\network\admin"

LISTENER

The Oracle Database Listener is the database server software component that manages the network traffic between the Oracle Database and the client. The Oracle Database Listener listens on a specific network port (default 1521) and forwards network connections to the Database. The Listener is comprised of two binaries: (1) tnslsnr which is the Listener itself and (2) the Listener Control Utility (lsnrctl) which is used to administer the Listener on the server or remotely

The Listener can also be remotely managed by creating one or more alias entries in a listener.ora file. The Listener uses the TNS_ADMIN environmental variable to locate the listener.ora file, so multiple configuration files can be setup by setting TNS_ADMIN prior to executing lsnrctl. To set up a computer to remotely administer a Listener:

1. Install Oracle software that contains SQL*Net or Net8, which is usually the Oracle client. You may have to copy the lsnrctl (or lsnrctl.exe) executable from a server installation as it is not installed as part of the basic Oracle client software.

2. Configure the local listener.ora to resolve to the remote Listener.

The syntax is similar to a tnsnames.ora entry.

If the listener.ora does not exist, create and insert the entry.

Otherwise, add the entry to the listener.ora file.

A listener.ora file can contain multiple entries.

<alias> = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (Host = <host>) (Port = <port>)))

3. Start from the command line lsnrctl

4. Restart the Server and then try to connect the Oracle Genisys Database.

Nageswaran AG

Friday, July 1, 2011

How to create and restore System Restore point in Windows XP?

http://www.windowsfreetips.com/how-to-create-and-restore-system-restore-point-in-windows-xp.html

Thanks & Regards

Pravin K

How to Resize the Recycle Bin size in Windows XP?

Ten percent space on the hard drive is reserved for the Recycle bin in Windows XP according to default settings. You can resize the Recycle bin in Windows XP so that you are able to save space of about 3GB by setting it to take only one percent space on a hard drive of 40GB. It is up to you whether you want to resize the Recycle bin in Windows XP by resizing all of the drives combined or one drive at a time.

You can resize the Recycle bin in Windows XP by this method:

Empty the Recycle bin. (Make sure that you don't delete something you might need later.)
It is also recommended that you create a Restore Point before resizing the Recycle bin or applying any other system change.
Right-click on the icon for the Recycle Bin.
Choose and click Properties from the menu.
The Recycle Bin Properties window will appear. It is your choice whether you would like to configure the drives independently or all at once by selecting only one size for every drive. Drag the slider under the Global tab to alter the percentage of space taken by all the drives.

6. You will also have the option to remove all the deleted files right away without putting them in the Recycle bin. You can do this by checking the box.

This option is not recommended as you might need the deleted files later or if you delete a file by mistake.

As I have several drives of different sizes in my computer, I would prefer to configure the drives one by one instead of configuring all of them globally. Select the option "Configure Drives Independently".

Click on the tab for every drive and drag the slider to change the percentage of space you want it to utilize.

After you have changed the settings, click the Apply button.
Click the OK button.

You can resize the Recycle bin in Windows XP according to your own choice. You can turn it off entirely or even increase it to suit your requirements. Obviously, the good thing about not turning it off is that you can restore a deleted file if it is still in the Recycle bin.

Thanks & Regards

Pravin K

How to Repair Windows XP Without Formatting Your PC

If you suspect that there is a problem with your Windows system files you can simply try to repair it before resorting to formatting.

Here is the step by step instruction to repair your Windows XP installation without formatting your PC.

1. First, insert your bootable Windows XP in your CD/DVD drive.

2. Restart your computer

3. When it ask you to press any key to boot from CD, Press any key on your keyboard. Proceed to step 6.

4. If it doesn't ask you, then restart your computer again.

5. Go to the BIOS settings of your computer, usually by pressing the delete key or F1, F2, F10 function keys, varies from different computers. Once inside the bios, you need to change the boot options. Change the primary boot option to CDRom. Save and exit.

6. A Blue screen will appear… just like the one you see below.

7. Choose "To setup Windows XP now, press ENTER" Do not choose to Repair yet.

8. It will then display your existing Windows XP copy. Make sure that is selected like you see below

9. Choose to Repair the selected Windows XP installation by pressing the letter R key on your keyboard.

10. Your windows will run to it's usual installation process, however, it is a lot quicker this time. But don't panic it will not wipe your files, it will just repair your system.

11. At some point you will be ask to enter the serial number and restart the computer.

12. When it finishes the setup your files will still be there but the Windows errors you had will not.

Thanks & Regards

Pravin K

WHAT IS THE BEST WAY TO STORE BACKUP DVDs SO THAT ITS DATA REMAIN INTACT

IF WE START STORING BACKUP DATA IN DVDs , WHAT IS THE BEST PROCEDURE TO KEEP THESE DVDs ( I.E HOW TO STORE THE DVDs) , SO THAT NO MOISTURE COMES OR NO SCRATCH TAKE PLACE.

SANJEEV BHATEJA

WHICH MEDIA IS BEST FOR STORAGE OF DATA FOR 40-50 YEARS

WHICH SORT OF STORAGE MEDIA IS BEST FOR STORING OF DATA FOR RELATIVELY LONGER PERIOD OF SAY 40-50 YEARS, SO THAT TECHNOLOGY AT THAT TIME CAN READ TODAY'S STORAGE DEVICE.

SANJEEV BHATEJA

WHICH BRAND LED/LCD MONITOR IS BEST FOR HOME USE

IF I WANT TO BUY LED/LCD TO REPLACE MY EXISTING FLAT MONITOR AT HOME, FOR WHICH BRAND I SHOULD GO , WHICH IS EASILY REPAIRABLE AND WHOSE PARTS ARE EASILY AVAILABLE . LIFE WISE ALSO WHICH BRAND IS BEST. PL SUGGEST ANY BRAND IN WHICH PROBLEM RATE IS RARE.

SANJEEV BHATEJA

Hardware Queries

Respected Sir,

I had following Hardware Problems, kindly advise me in the matter:-

I had loaded two O.S in one PC for security purpose one is W.xp for normal user & another is Linux for me, are they make any problems to PC ?.

Can we install more than two O.S. software in one machine ? This is because Wxp rum media file very well but now W7 OS is running very good, so that whether it is safer or not? and also whether it will not affact the machin ?

Some of PCS make HCL make 2009 having Wxp automatically gets shut down, our PCS engg. check all the things, but he is is not able to solve the problem, kindly advise?

Whether it is possible to recover the data from damage &/or crack Hard Disck? if so what is the method?

Can we recover the Data from Hard Disk which has been Formatted for three to four times ? if yes then what is the procedure?

Can we repair LCD &/or LED monitor Screen, who is havig display problem ? ie. lines &/or dots.

Thanx & Regards,

Dinesh G. Khaire

CAN ANYBODY SUGGESTS THE BEST LAPTOP TO BUY FOR HOME USE

IF I WANT TO BUY A LAPTOP FOR HOME USE, WHICH BRAND IS BEST AND THE REASONS , WITHIN THE PRICE TAG OF 20000-28000

SANJEEV BHATEJA

How do I recover the files from formatted hard drives?

Another data recovery tool

http://www.easeus.com/datarecoverywizard/recover-formatted-partition.htm

Computer viruses: description, prevention, and recovery

If you are using Windows OS, no one else can protect your system better than Microsoft. Hence, in case of any doubt please use this

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

and don't fall in trap of those who are doing business of virus.

How to partition and format a hard disk by using Windows XP Setup program

Most authentic source of information

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

PRINTING TAKES MORE TIME TO PRINT GENISYS OUTPUTs

To find out the possibility & to rectify the Issues:

1. Temporary spool files to be removed from the

C:\System\Ins\<zero bytes files>

Keep Version.dat and dbnames.dat files and remove rest of the files lying the

C:\SYSTEM\INS folder

2, START --->SETTINGS --->PRINTERS and FAXES ---> SELECT THE PRINTER ICON AND RIGHT-CLICK AND GOTO PROPERTIES AND SELECT ADVANCED AND ACTIVATE THE BUTTON PRINT DIRECTLY TO THE PRINTERS

*** NOW SEE THAT YOUR PRINTOUTS GET VERY FAST ***

Nageswaran AG

What is difference between Virus, Bug, Worm ?

Karmvir Singh Kaintura

With Kind Regards

Karmvir Singh Kaintura

Treat yourself at a restaurant, spa, resort and much more with Rediff Deal ho jaye!

Can I start my computer by invertor in case of emergency ? or can I give line of my invertor to my mini UPS of 600 VA and then start the computer ? Is this safe for my computer ?

Can I convert my invertor in to UPS & how ?

With Kind Regards

Karmvir Singh Kaintura

Treat yourself at a restaurant, spa, resort and much more with Rediff Deal ho jaye!

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