Monthly Archives: November 2012

Managing the Oracle DB 11g Scheduler Windows (DBMS_SCHEDULER)

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)

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

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

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

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

> 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

Alternative way to find files with specific extension in a folder on Linux

If you don’t like the “find” command, you can use the following one instead (I prefer it myself): ls -R | grep “\.xml” where “-R” lists all recursively grep is used to filter filename “\.xml” you must put the “\” … Continue reading

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