Tag Archives: Oracle

How to get version of Redhat & Oracle Enterprise Linux

Posted on February 19, 2013 by Ahmed Tawfik

Oracle Enterprise Linux: more /etc/enterprise-release, example output: “Enterprise Linux Server release 5.5 (Carthage)” Redhat: more /etc/redhat-release

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

How to manually modify DB initialization parameters by creating pfile from spfile

Posted on January 19, 2013 by Ahmed Tawfik

pfile is the initialization parameters of DB in plain text, while spfile is the binary one, so to be able to change it, you have to: Extract the pfile from the spfile: “create pfile=’my_path/file_name.ora‘ from spfile;” Shutdown the DB: “shutdown … Continue reading →

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

How to start the X server at boot with Redhat or Oracle Linux

Posted on December 24, 2012 by Ahmed Tawfik

vi /etc/inittab Edit your /etc/inittab file by replacing the line: id:3:initdefault: With this one: id:5:initdefault: and reboot Enjoy! Source: http://www.redhat.com/support/resources/faqs/rhl_general_faq/s1-xwin-q.html

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

Managing the Oracle DB 11g Scheduler Windows (DBMS_SCHEDULER)

Posted on November 25, 2012 by Ahmed Tawfik

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

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