Archive

Archive for the ‘Uncategorized’ Category

Funny Oracle FAQ’s

May 17th, 2009 sam No comments
Categories: General, Uncategorized Tags: ,

Unix Alias for Oracle Database

April 26th, 2009 sam No comments

alias abort=’echo shutdown abort|sqlplus -L -s / as sysdba’

alias alertvi=’vi $ORACLE_HOME/admin/ ORACLE_SID/bdump/alert_ORACLE_SID.log’

alias nomount=’echo startup nomount quiet|sqlplus -L -s / as sysdba’

alias ora=’cd $ORACLE_HOME’

alias pmon=’ps -ef | grep [p]mon’

alias startup=’echo startup quiet|sqlplus -L -s / as sysdba’

alias sysdba=’sqlplus -L / as sysdba’

alias tns=’cd $ORACLE_HOME/network/admin’

alias alert=’tail -100 $ORACLE_LOG/alert_$ORACLE_SID.log|more’

alias blog=’tail -130 /backup/dbbackup.log’

alias bdump=’cd $ORACLE_HOME/admin/sunmoto/bdump’

alias udump=’cd $ORACLE_HOME/admin/sunmoto/udump’

Categories: Uncategorized, UNIX Tags:

Places where trojans hide in ur system

March 11th, 2009 sam No comments

///THE FOLLOWING REGISTRY FILES R USED BY TROJANS FOR HIDIN IN UR SYSTEMS ND D COUNTERMEASURE IZ 2 CREATE BACKUP n DELETE D FOLLOWING REG FILES/////////


Registry is often used in various auto-starting methods. Here are some known ways:

[HKEY_LOCAL_MACHINESoftwareMicrosoftW
indowsCurrentVersionRun]

“Info”=”c:directoryTrojan.exe”

[HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionRunOnce]

“Info”=”c:directoryTrojan.exe”

[HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionRunServices]

“Info”=”c:directoryTrojan.exe”

[HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionRunServicesOnce]

“Info=”c: directoryTrojan.exe”

[HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionRun]

“Info”=”c:directoryTrojan.exe”

[HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionRunOnce]

“Info”=”c:directoryTrojan.exe”

Registry Shell Open methods

[HKEY_CLASSES_ROOTexefileshellopencommand]

[HKEY_LOCAL_MACHINESOFTWAREClassesexefileshellopencommand]

A key with the value “%1 %*” should be placed there and if there is some executable file placed there, it will be executed each time a binary file is opened. It is used like this: trojan.exe “%1 %*”; this would restart the Trojan.

ICQ Net Detect Method

[HKEY_CURRENT_USERSoftwareMirabilisICQAgentApps]

This key includes all the files that will be executed if ICQ detects Internet connection. This feature of ICQ is frequently abused by attackers as well.

ActiveX Component method

[HKEY_LOCAL_MACHINESoftwareMicrosoftActiveSetupInstalledComponentsKeyName] StubPath=C: directoryTrojan.exe

These are the most common Auto-Starting methods using Windows system files, and the Windows registry

Categories: Softwares, Uncategorized Tags:

Oracle RMAN – Restore from any Disk Location

February 24th, 2009 sam No comments

Oracle RMAN – Restore from any Disk Location

RMAN looks for the backupfiles to restore within its catalog and therefore there is no RESTORE DATABASE FROM <Disk-Location> command. You can circumvent this constraint using the RMAN command CATALOG START WITH <Disk-Location>. The following example shows how to restore an Oracle database from any disk location.

ora_rman_catalog_start_with.gif

1. Copy the Backup Set Files to any Disk Location

cp <backupset> /tmp/backup

2. Mount the Database

sqlplus / as sysdba
startup mount;

3. Cleanup RMAN Catalog

rman target /

crosscheck backup;
delete noprompt expired backup of database;
delete noprompt expired backup of controlfile;
delete noprompt expired backup of archivelog all;
list backup;

At this point no backup should be available !

4. Make new Backup Location visible to RMAN Catalog

catalog start with ‘/tmp/backup’;

searching for all files that match the pattern
/tmp/backup

List of Files Unknown to the Database
=====================================
File Name: /tmp/backup/PROD_datafile_14_1.bak
File Name: /tmp/backup/PROD_controlfile_17.bak
File Name: /tmp/backup/PROD_archivelog_16_1.bak
File Name: /tmp/backup/PROD_datafile_15_1.bak

Do you really want to catalog the above files
(enter YES or NO)?
yes

List of Cataloged Files
=======================
File Name: /tmp/backup/PROD_datafile_14_1.bak
File Name: /tmp/backup/PROD_controlfile_17.bak
File Name: /tmp/backup/PROD_archivelog_16_1.bak
File Name: /tmp/backup/PROD_datafile_15_1.bak

list backup;

At this point the backup must be available !

5. Restore and Recover the Database

restore database;
recover database;
alter database open;

Categories: Uncategorized Tags:

APP-FND-01630: Cannot open file D:\oracle\prodcomn\temp\OF4981.tmp

February 15th, 2009 sam No comments

My Friend call me and told me he is getting following errors when he runs the report.

Cause: The program terminated, returning status code 3.
Action: Check your installation manual for the meaning of this code on this operating system.
APP-FND-01630: Cannot open file D:\oracle\prodcomn\temp\OF4981.tmp for reading
Cause: USDINS encountered an error when attempting to open file D:\oracle\prodcomn\temp\OF4981.tmp for reading.
Action: Verify that the filename is correct and that the environment variables controlling that filename are correct.
Action: If the file is opened in read mode, check that the file exists. Check that you have privileges to read the file in the file directory. Contact your system administrator to obtain read privileges.
Action: If the file is opened in write or append mode, check that you have privileges to create and write files in the file directory. Contact your system administrator to obtain create and write privileges.
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 440550.
Review your concurrent request log and/or report output file for more detailed information.

I had searched the metalink and i got the solution for this

To implement the solution, please execute the following steps:

1. Rename the temp directory.

2. Create new temp directory.

3. Run cmclean.sql

Note 134007.1 CMCLEAN.SQL Non Destructive Script to Clean Concurrent Manager Tables

4. Bounce the applications services.

Categories: Uncategorized Tags:

Sending an e-mail via Telnet

February 12th, 2009 sam No comments

Sending an e-mail via Telnet


In this document, we:

  • shall use Telnet to connect to the SMTP server.
  • shall give commands to the server, then type our e-mail, and finally tell the server, ‘Okay, the e-mail is done. Send it.
  • can then send more mails, or disconnect from the server.

The steps are quite similar to what you do when you send an e-mail from – for instance – Outlook Express. We are going to use the SMTP server of monitortools.com with the ID ‘webmaster’.



Step 1

Connect to the Internet in case you are a dial-up user. Open an MS-DOS prompt, and enter this command:

    C:\WINDOWS>telnet mail.monitortools.com 25

This will open a Telnet window, and within a short time, you will be connected to the SMTP server, and the server says:

    220 PROTAGONISTNT Mailmax version 4. 8. 3. 0 ESMTP Mail Server Ready

This varies, but you should definitely see the ’220′ part. It is an indication that the server is ready to service your request.



Step 2

Now the server expects you to identify yourself. If you are a dial-up user, you can enter the name of your computer (the one Windows asks you when you intall Windows) or anything else you want. If you have a domain-name, then you should enter the domain-name here. My computer’s name is dell01, so I say:

    helo dell01

Note that it is ‘helo’ and not ‘hello’. The commands are not case-sensitive, so you can also say HeLo or HELO or hELo. The server replies:

    250 HELO 217.120.215.201, How can I help you?

This is like a shake-hand. You tell the server your name, and it says its name! Computers are quite friendly, you see!



Step 3

Next give the server your e-mail address. Note that most SMTP servers require that your e-mail address belong to the same domain as the server. For example, if you send mail from Yahoo! SMTP server, you should have a Yahoo! address. You cannot use it if you give it a Hotmail address. Let me give the SMTP server some e-mail address:

    mail from: webmaster@monitortools.com

‘mail from:’ is a SMTP command. Note that there is a space between ‘mail’ and ‘from’, followed by a colon (:). The server says:

    250 Ok


Step 4

Tell the server who you want to send the e-mail to. Let me send a mail to info@activexperts:

    rcpt to: info@activexperts.com

There are no restrictions here. You can enter any e-mail address. If there is some problem with the recipient-address, your mail will bounce, but for now, the server doesn’t complain. It will say:

    250 Ok


Step 5

You have told the server your e-mail address, and the recipient’s e-mail address, so now you can go ahead and type the e-mail. You have to do that with the data command:

    data

The server asks you to go ahead with your e-mail:

    354 End data with .

Don’t worry with the thing. It’ll be explained later.



Step 6

Now type in your e-mail, like this:

    This is a test e-mail.
    Remember to type it all right. Backspace key doesn't work in Windows
    Telnet, though it does in Linux. If you make a mistake, try pressing
    CTRL-h. If it works, well and good.
    .

When you finish your e-mail, press [ENTER], then a ‘.’, and again an [ENTER]. This tells the server that you have finished the e-mail, and it can send it. It will say:

    250 Ok: queued as 6AB5150038

Your mail was sent!



Step 7

Now you can either send another mail, or disconnect from the server. If you want to send another mail, you should repeat the ‘rcpt to:’ and ‘data’ commands. There is no need for ‘helo’ and ‘mail from:’, because the server already knows who you are. If you want to disconnect, just say ‘quit’:

    quit

The server will reply:

    221 Bye
Categories: Uncategorized Tags:

Online Convert Any format to PDF

February 9th, 2009 sam No comments

Convert commonly used files (Microsoft Office, Open Office, graphic images, vector graphic and other formats) to PDF. This interactive PDF converter and document creator is quick and reliable. Try it for yourself.

Example: you need to convert a Power Point (PPT) file into PDF. Use the “Browse” button to locate the source file on your local PC, select it and click the “Convert” button. Done!

http://www.freepdfconvert.com/

Categories: Uncategorized Tags:

Shortcut Bar for Windows sTabLauncher

February 4th, 2009 sam No comments

This tool helps finding and launching your favorite programs,web pages, folders, or any type of files in a fast and easyway. Taking up fewer resources as possible, and allowing you to personalize the appearance in many ways, by changing colors, images, transparency, animations, and many other options to make it blend in with your desktop.

You can download from this site http://stablauncher.com/

Categories: Uncategorized Tags:

Good Tool for copying files

February 4th, 2009 sam No comments

While browsing i had find a good tool to copy the files in windows

The follow are the features of tere copy

TeraCopy is a compact program designed to copy and move files at the maximum possible speed, providing the user a lot of features:

  • Copy files faster. TeraCopy uses dynamically adjusted buffers to reduce seek times. Asynchronous copy speeds up file transfer between two physical hard drives.
  • Pause and resume file transfers. Pause copy process at any time to free up system resources and continue with a single click.
  • Error recovery. In case of copy error, TeraCopy will try several times and in the worse case just skips the file, not terminating the entire transfer.
  • Interactive file list. TeraCopy shows failed file transfers and lets you fix the problem and recopy only problem files.
  • Shell integration. TeraCopy can completely replace Explorer copy and move functions, allowing you work with files as usual.
  • Full Unicode support.

http://www.codesector.com/download.php

Categories: Uncategorized Tags:

Study Engineering Classes online.

January 19th, 2009 sam No comments

While i was Surfing the internet i had found a good site. I had recalled my Enigneering days where i used to study the subject.

What is NPTEL?

http://nptel.iitm.ac.in/

NPTEL is an acronym for National Programme on Technology Enhanced Learning which is an initiative by seven Indian Institutes of Technology (IIT Bombay, Delhi, Guwahati, Kanpur, Kharagpur, Madras and Roorkee) and Indian Institute of Science (IISc) for creating course contents in engineering and science.

NPTEL as a project originated from many deliberations between IITs, Indian Institutes of Management (IIMs) and Carnegie Mellon University (CMU) during the years 1999-2003. A proposal was jointly put forward by five IITs (Bombay, Delhi, Kanpur, Kharagpur and Madras) and IISc for creating contents for 100 courses as web based supplements and 100 complete video courses, for forty hours of duration per course. Web supplements were expected to cover materials that could be delivered in approximately forty hours. Five engineering branches (Civil, Computer Science, Electrical, Electronics and Communication and Mechanical) and core science programmes that all engineering students are required to take in their undergraduate engineering programme in India were chosen initially. Contents for the above courses were based on the model curriculum suggested by All India Council for Technical Education (AICTE) and the syllabi of major affiliating Universities in India.

Objective

The main objective of NPTEL program is to enhance the quality of engineering education in the country by developing curriculum based video and web courses. This is being carried out by seven IITs and IISc Bangalore as a collaborative project. In the first phase of the project, supplementary content for 129 web courses in engineering/science and humanities have been developed. Each course contains materials that can be covered in depth in 40 or more lecture hours. In addition, 110 courses have been developed in video format, with each course comprising of approximately 40 or more one-hour lectures. In the next phase other premier institutions are also likely to participate in content creation.

http://nptel.iitm.ac.in/

Categories: Uncategorized Tags: