Troubleshooting issues in Oracle, RedHat Linux, Windows and lot more!.

Linux Equivalents Of  Dos Commands Are you a Dos command pro but finding it a little difficult to settle down with Linux command lines? Here's some help! Linux command line is the most powerful tool of Linux, that can help you do almost every thing right from the shell. And if you are aware of the Dos commands, learning Linux command line becomes a lot more easier. Below is a list of Linux equivalents 36 Dos commands to help you out. You can also read and more Linux commands in this list of  83 Linux Commands For Beginners . DOS commands Linux command Function assign ln Create a file or directory link /? man Help about the command break on trap Trap ctrl-break / Trap signals cd cd Change directory chdir pwd Display directory location cls clear Clear screen copy cp Copy a file date date Displays or sets the date del rm Deletes one or more files dir ls Displays a list of files and subdirectories in a directory doskey /h history history List command history e...

Below are the some of the sql queries which helps to find the log directories in oracle database server. select * from v$logfile; select * from v$log_history; show parameter debug; select * from dba_profiles; select profile,resource_name,resource_type,limit from dba_profiles; select window_name, repeat_interval, duration from dba_scheduler_windows where window_name like 'WEEK%';

You can drop a tablespace and its contents (the segments contained in the tablespace) from the database if the tablespace and its contents are no longer required. You must have the DROP TABLESPACE system privilege to drop a tablespace. Caution: Once a tablespace has been dropped, the data in the tablespace is not recoverable. Therefore, make sure that all data contained in a tablespace to be dropped will not be required in the future. Also, immediately before and after dropping a tablespace from a database, back up the database completely. This is strongly recommended so that you can recover the database if you mistakenly drop a tablespace, or if the database experiences a problem in the future after the tablespace has been dropped. When you drop a tablespace, the file pointers in the control file of the associated database are removed. You can optionally direct Oracle Database to delete the operating system files (datafiles) that constituted the dropped tablespace. If you ...

SQL Queries to drop oracle tablespace, -- drop tablespace: syntax: DROP TABLESPACE <tablespace_name>; eg: DROP TABLESPACE tspace; -- drop tablespace including contents: syntax: DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS; eg: DROP TABLESPACE tspace INCLUDING CONTENTS; -- drop tablespace including contents & datafiles:     syntax: DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS AND DATAFILES; eg: DROP TABLESPACE tspace INCLUDING CONTENTS AND DATAFILES; -- drop tablespace including contents & datafiles -- where referential constraints exist:     syntax: DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; DROP TABLESPACE tspace INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; -- drop tablespace after datafile was accidentally dropped: conn / AS sysdba CREATE TABLESPACE testbed DATAFILE 'c:\temp\testbed.dbf' SIZE 10M BLOCKSIZE 4096 EXTENT MANAGEMENT LOCAL UNIFOR...

If you are tired of using the Windows Classic theme on your Server 2008, you can install Desktop Experience so that you can enjoy the eye candy goodness of the Vista theme. Desktop Experience will also install Windows Media Player, Windows Sidebar and photo gallery. Follow these steps to install Desktop Experience and liven up your server: The Desktop Experience installs a variety of features, including Windows Media Player. It is required for the proper operation of Moxie Studio and Player on Windows Server 2008 and Windows Server 2008 R2. 1. Click Start and select Server Manager 2. When the Server Manager window appears, go to the left pane and select  Features . 3. On the right, click the  Add Features  link. 4. Check the  Desktop Experience  checkbox 5. Click Next. 6. Click Install 7. When the installation is complete, Windows will notify you that you must restart your server to complete the process. After you have rebooted...

Example syntax for Secure Copy ( scp ) What is Secure Copy? scp  allows files to be copied to, from, or between different hosts. It uses  ssh  for data transfer and provides the same authentication and same level of security as  ssh . Examples Copy the file "foobar.txt" from a remote host to the local host $ scp your_username@remotehost.edu:foobar.txt /some/local/directory Copy the file "foobar.txt" from the local host to a remote host $ scp foobar.txt your_username@remotehost.edu:/some/remote/directory Copy the directory "foo" from the local host to a remote host's directory "bar" $ scp -r foo your_username@remotehost.edu:/some/remote/directory/bar Copy the file "foobar.txt" from remote host "rh1.edu" to remote host "rh2.edu" $ scp your_username@rh1.edu:/some/remote/directory/foobar.txt \ your_username@rh2.edu:/some/remote/directory/ Copying the files "foo.txt" and ...

Updated: April 7, 2010 Applies To: Windows Server 2008 R2 This document outlines supported and unsupported upgrade paths for editions of the Windows Server® 2008 R2 operating system. Unsupported Upgrade Scenarios Upgrades to Windows Server 2008 R2 from the following operating systems are not supported: Windows® 95, Windows 98, Windows Millennium Edition, Windows XP, Windows Vista®, Windows Vista Starter, or Windows 7 Windows NT® Server 4.0, Windows 2000 Server, Windows Server 2003 RTM, Windows Server 2003 with SP1, Windows Server 2003 Web, Windows Server 2008 R2 M3, or Windows Server 2008 R2 Beta Windows Server 2003 for Itanium-based Systems, Windows Server 2008 for Itanium-based Systems, Windows Server 2008 R2 for Itanium-based Systems Cross-architecture in-place upgrades (for example, x86 to x64) are not supported. Cross-language in-place upgrades (fo...