I have been working in the IT sector since 2002. Presently I’m working as a Senior Oracle Database Administrator for HP (hewlett packard) in Kingdom of Saudi Arabia, (Riyadh). I'm honored to receive an Oracle ACE Award. I have extensive experience with Oracle 8i, 9i, 10g & 11g, and Oracle E-Business Suite 11i, Specializing in Installation, Configuration and Administration of Oracle 8i, 9i, 10g, & 11g Oracle 10g/11g RAC, and Oracle E-Business Suite 11i on different UNIX and Linux OS including Solaris, HP-Unix, IBM AIX and Red Hat. Experience in Upgrading Oracle 8i, 9i, 10g, & 11g and Oracle E-Business Suite 11i. Good exposure in implementing of backup & recovery strategies, applications cloning & refreshing, applications patching, and performance tuning, Written and published a couple of articles on Oracle Metalink Customer Knowledge Exchange.

Twisted Metal 2 Download Free Full Game (known as Twisted Metal: World Tour in Europe and Twisted Metal EX in Japan) is the second and most successful game in. Twisted Metal 2 Free Download Free Download - Install the full version Twisted Metal 2 Free Download for free. Fast, working download for PC. Twisted Metal 2 Download game PC iso, Direct links game PC, Torrent game PC, Crack DLC game PC, Google Drive game PC, New game pc, Game VR PC. Download Twisted Metal 2 (Action game) - Great action racing game, it has all you need to have fun with friends or solo. Choose your car and shoot all you see! Twisted metal 2 free download.

Feb 06, 2008 setting env variable ORACLE_SID. Environment variable ORACLE_SID not defined. Please define it. The SID is a site identifier. It plus the Oracle_home are hashed together in Unix to create a unique key name for attaching an SGA. If your Oracle_sid or Oracle_home is not set correctly, you'll get 'oracle not available' since we cannot attach to a shared memory segment that is identified by magic key.

And also, I’m an Oracle Certified Professional (OCP) in 8i, 9i, 10g, & 11g, Oracle 11i Applications DBA Certified Professional, and Oracle Certified Expert in Oracle 10g RAC Administration as well.You can contact me at sabdar.syed @ gmail.com. Hello, When I check my blog hit counter statistics, my blog is being hit and searched by the blog users with the word “Oracle Home”, but, looks like they are not finding the required information on “Oracle Home” Environment variable. So, I wanted to explain about ORACLE_HOME in my simple terms which is helpful for novice. What is ORACLE_HOME used for? * The ORACLE_HOME is an environment variable which is used to set and define the path of Oracle Home (server) Directory. * The ORACLE_HOME directory will have the sub directories, binaries, executables, programs, scripts, etc.

For the Oracle Database. * This directory can be used by any user who wants to use the particular database. * If the ORACLE_HOME variable is defined as an environment variable, then during the installation process, the Oracle Home Path will be set to the directory defined as default. If the variable is not defined, then the Oracle will take its own default location. The ORACLE_HOME variable does not have to be preset as an environment variable, it can be set during the installation process. * Basically The ORACLE_HOME variable is in the following ORACLE_BASE directory: ORACLE_HOME=$ORACLE_BASE/product/10.2.0. What is ORACLE_BASE used for?

* The ORACLE_BASE is also an environment variable to define the base/root level directory where you will have the Oracle Database directory tree - ORACLE_HOME defined under the ORACLE_BASE directory. * Basically, The ORACLE_BASE directory is a higher-level directory, than ORACLE_HOME, that you can use to install the various Oracle Software Products and the same Oracle base directory can be used for more than one installation. Note: If you did not set the ORACLE_BASE environment variable before starting OUI, the Oracle home directory is created in an app/username/directory on the first existing and writable directory from /u01 through /u09 for UNIX and Linux systems, or on the disk drive with the most available space for Windows systems. If /u01 through /u09 does not exist on the UNIX or Linux system, then the default location is user_home_directory/app/username. How to check if ORACLE_HOME is set already? On Unix/Linux Systems: Basically, before or after the Oracle Database is installed, the oracle user profile, the environment variable file, is prepared where all the required environment variables for Oracle are set.

ORACLE_BASE, ORACLE_HOME, ORACLE_SID,PATH, LD_LIBRARY_PATH, NLS_LANG, etc. The user profile file can be.bash_profile – Bash Shell.profile – Bourne Shell or Korn shell.login­ – C Shell Note: This user profile file will be under user’s home directory i.e. $HOME/.bash_profile To check specific environment variable set: $ echo $ORACLE_HOME To check all the environment variables set: $ env On Windows Systems: To check specific environment variable set: C:>set ORACLE_HOME OR C: echo%ORACLE_HOME% To check all the environment variables set: C:>set Or C:>env Other way, to check the ORACLE_HOME, is as follows. Start >Run >Regedit (enter) >HKEY_LOCAL_MACHINE >SOFTWARE >ORACLE i.e. My Computer HKEY_LOCAL_MACHINE SOFTWARE ORACLE How to check using sqlplus command: How to set the ORACLE_HOME environment variable?