Category Archives: Uncategorized

Limit a Local System User Access to a Certain Folder when using SFTP on Linux (and disable SSH for him as well)

Posted on November 21, 2012 by Ahmed Tawfik

This situation might face a lot of us, if you have a certain file you want to share on your system using SFTP, but you don’t want that user to be able to: login via SSH and run any commands … Continue reading →

Posted in Uncategorized | Tagged , , , , | Leave a comment

How to get CPU Info of a Linux Machine

Posted on November 17, 2012 by Ahmed Tawfik

This worked with me in Redhat and Ubuntu-based distros: “less /proc/cpuinfo” you can get the number of processors easily if you don’t want to read a lot of text: “less /proc/cpuinfo | grep processor”processor : 0processor : 1processor : 2processor : … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Two Simple Methods to Move/Rename Oracle DB Data Files

Posted on November 7, 2012 by Ahmed Tawfik

First Method (must be done as sysdba): 1. First, shut down the database: “shutdown immediate;” 2. Rename and/or move data files to new destination using OS commands (e.g. mv for linux) 3. Startup DB in mount mode: “startup mount;” 4. … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment

SQL Statement to get version of your Oracle DB

Posted on November 6, 2012 by Ahmed Tawfik

> sqlplus / as sysdba SQL> select * from v$version; BANNER ——————————————————————————– Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production PL/SQL Release 11.2.0.2.0 – Production CORE 11.2.0.2.0 Production TNS for Linux: Version 11.2.0.2.0 – Production NLSRTL Version 11.2.0.2.0 … Continue reading →

Posted in Uncategorized | Tagged , , , | Leave a comment

How to mount CD on Linux

Posted on October 31, 2012 by Ahmed Tawfik

mount -t iso9660 -o ro /dev/cdrom /mount_point

Posted in Uncategorized | Tagged , , | Leave a comment