Wednesday, 4 November 2015

How to Install Oracle Application Server 10g on Windows Server 2008, 2012 64bit

Hi guys,

The installation of Oracle Application Server 10g on Windows Server 2008 and 2012 (64bit Operating Systems) is easy. The setup gives error when it is started. Here are the steps to skip the windows version check:-

1) Right Click on the setup.exe
2) Click Troubleshoot compatibility.
3) Choose "The program worked in earlier version of windows". Click Next.
4) Select old operating system like Windows XP or Windows Server 2003 from the list.
5) The setup will be started.

Friday, 26 June 2015

Virus Creating Shortcut in Computer, Can remove USB Shortcuts and Computer Virus

Often confront with the virus in computer that immediately creates shortcuts in usb or completely hide the files. So, you are in the right place to remove it.

No antivirus consider this as virus so once it comes into your pc, you have to manually dig it out. Actually it changes the file extensions to hidden and system files so you couldn't see them directly.

Short Term Solution:
If you want to immediately see what's present in the USB, then follow the following steps:

1. Press 'Windows+R', write 'cmd' and click enter to open command prompt.

2. Consider your USB drive is F, then write 'F:' in command prompt.

3. Enter the command, attrib -s -h -r /s /d f:\*.*, wait for some time and then you can see data in USB.

Permanent Solution:
If this type of virus is present in your computer and you want to permanently remove it then follow the following steps:

1. Go in the path, C:\Users\Administrator\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup, you will see the shortcuts in that folder.

2. Right click those files and click properties to see the target files that these shortcut opens.

3. The path generally is C:\Users\Administrator\AppData\Roaming\ some exe files with the name staring with ob or oh.

4. Those files are also made as system files so you will not see those files in that directory.

5. Go to that folder and click View>Options>View and uncheck the Hide Protected operatig system files (Recommended) and click ok.

6. Delete those files, and then return to original folder where shortcuts are present.

7. You will not be able to delete those files, so first go back and Right Click Startup folder, click properties and then click Security.

8. Click Edit and give Full Control to your account for that folder, then click Apply and ok.

9. Once again go into the folder and delete those shortcuts, now restart the computer and it will be all clear from virus.

Friday, 12 June 2015

C# Remove Duplicate Lines From Text File

There are various methods to remove duplicate lines from text file. Some of these are easier to implement than others. The approach to be taken can depend on the size of the text file and the expected number of matching lines. Here we focus on small size text files.


String[] TextFileLines = File.ReadAllLines("textFile.txt");
TextFileLines = TextFileLines.Distinct().ToArray() ;
File.WriteAllLines("textfile.txt", );
 
In the C# code above, first we read all text file lines and stored these lines into an array. Then we used Distinct() function, a built in function of C#, to remove duplicates. Finally we wrote these distinct lines back to the file.

Sunday, 24 May 2015

How to make Web Development fast??? (A trick to Quick Web Development)

Hi, Here I am going to give you a trick to quickly develop web pages. The trick is simple. This trick will be very useful and time saving when there is repetition of work. For example, making create, read, update, delete pages (CRUD operations) on a table in the database. If your application contains 25 or more tables in the database, and creating CRUD pages on a single table takes 2 hour, then it will take 50 hours to make CRUD pages for all the tables. You can reduce the time by making code generator for your web application.

Firstly create CRUD pages for a table. Then create an application whose inputs will be the table name and schema name. The application will automatically get the fields of the table and display it to you. You specify the appearence of the fields (like textbox, dropdownlist, checkbox etc). After submitting it will generate code for you by making replacements necessary in the code you created for one table.

Using Mail Merge in Microsoft Office Word

Anyone wanted to print same letter with different receiver name, or to send a single letter with different name to different email ids saved in Excel Sheet then Mail Merge is your solution.

Step 1:

Select the Mailings tab in Microsoft Word.

Step 2:

Click on the Start Mail Merge and Select Letters from the drop down list.

Step 3:

After that Click on the Select Recipients and select Use an Existing List, as you already have the Excel Sheet of the Recipients.



Step 4:

Find the Excel Sheet in your pc and double click the file.

Step 5:

A dialog box will open where the appropriate sheet containing data will be selected.

Step 6:

After that all the top buttons will become enabled, Select Insert Merge Field and Select the proper column number, your cursor on file should be placed where you want to print the names.

Step 7:

Now Click on Finish & Merge, and select print documents.

Step 8:

Select Range of the excel file, in this case All is selected to print letters for all names.

Step 9:

Select the printer that in this case is Foxit Phantom for pdf creation.


Step 10:

Select Save button and wait for some time, pdf file will be created and opened.

Now, in this procedure you had the excel file and created a single page in Word, After all this procedure you obtained number of pages equivalent to number of names in excel file.

Windows Server 2012 Installation



Follow the steps below to install Windows Server 2012 on your PC or Server.

Step 1 
Take the Windows Server 2012 DVD and insert it into the DVD ROM.
This will show the following message on the screen.
Press any key to start installation.


Step 2 
Now files will start loading from the Windows Server 2012 DVD.
Now wait till all necessary files are loaded.
Step 3 
Choose the language, time and keyboard setting and press the NEXT button. 

Step 4 
Click Install now button on the install screen.

Step 5 
Choose the second option; this will install Windows Server 2012 with GUI.
Step 6 
Go through the License Agreement, Check the option, “I accept the license terms,” and then click Next button.

Step 7 
Click on the option Custom: Install Windows only (Advanced).
Step 8 
Click drive options (advanced); then you can create custom partitions
Step 9 
Add a drive by clicking new.  Make new drives as per requirement. Then just click on the Drive 0. And click Next button.
Step 10  
It will then start copying files. This will take a while (could be 20 mins or so depending on hardware performance). It will reboot a couple times (automatically). After the first reboot, it will no longer be running off of the DVD.


Step 11 
In the Password box, enter a new password for this computer. It must meet complexity requirements e.g. windowsserver[2012] . Re-enter the password in the second password box, and then click Finish.

Step 12
Press Ctrl-Alt-Delete at the same time to get the login screen

Step 13 
Enter password and press enter.

The Desktop will be displayed and Server Manager will be opened automatically.

Wednesday, 18 March 2015

How to use barcode font in Oracle Report Builder 10g and Application Server 10g

Here I will show you how to use barcode fonts in Oracle Report builder 10g and Application Server 10g.
To use barcode font in Oracle Report builder 10g you have to simply install the barcode font on your development machine. But to apply barcode font in the Oracle Application server 10g (which will render your report) you have to install font as well as you have to do following steps:-

1. Get the genuine barcode font. It should be .ttf file. I am using IDAutomationHC39M.ttf barcode font. Install this font on your development as well as server machine where reports will run. You can install font by simply pasting the .ttf file in the C:\Windows\Fonts
2. Open C:\Oracle\FRHome_1\forms\server\default.env. Find CLASS_PATH located at the end of 'default.env'. Add 'C:\WINDOWS\Fonts' at the end of this variable. Their should be a semicolon (;) separating the paths except the end.
3. Open C:\Oracle\FRHome_1\tools\common\uifont.ali
In the [ PDF : Subset ] section add

IDAutomationHC39M = "IDAutomationHC39M.ttf"

4. Now you can use barcode font in the report builder by applying the barcode font to you text like you apply other fonts like Arial etc.
5. Restart the application server or the machine. Run the report and you will see you text in barcode.
Note: Remember the client (who is seeing the report) should also have the fonts installed on his/her machine.