Monthly Archives: November 2012

Managing the Oracle DB 11g Scheduler Windows (DBMS_SCHEDULER)

Posted on November 25, 2012 by SoCRaT

To display existing scheduler windows, you should query the “dba_scheduler_windows” table: e.g. SELECT WINDOW_NAME,REPEAT_INTERVAL,DURATION,ENABLED FROM dba_scheduler_windows In my case, I needed to disable a window, so that it doesn’t run any scheduled jobs, so I had to run the following: … Continue reading →

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

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 SoCRaT

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 SoCRaT

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

Mount NTFS manually on Ubuntu Linux Server

Posted on November 11, 2012 by SoCRaT

First, list all the ntfs drives you have: “fdisk -l | grep NTFS”, example output: /dev/sda1 * 2048 206847 102400 7 HPFS/NTFS/exFAT /dev/sda2 206848 409599999 204696576 7 HPFS/NTFS/exFAT /dev/sda3 409600000 976957421 283678711 7 HPFS/NTFS/exFA Second, create a folder to mount … Continue reading →

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

Two Simple Methods to Move/Rename Oracle DB Data Files

Posted on November 7, 2012 by SoCRaT

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