Home > How To > Set Oracle_home Windows

Set Oracle_home Windows


You can find it from $ORACLE_HOME/network/admin/tnsnames.ora file. Presently I'm working as a Senior Oracle Database Administrator for HP (hewlett packard) in Kingdom of Saudi Arabia, (Riyadh). Like Show 0 Likes(0) Actions 11. Re: find oracle home 839439 Apr 24, 2012 11:30 AM (in response to user3266490) some times we started db with pfile from non default location?How to find where that pfile located?you have a peek here

There are pros and cons - it was easy enough to forget which instance one was on - it's maybe a good idea to change the prompt as well - to Re: find oracle home 839439 Apr 24, 2012 11:21 AM (in response to user3266490) user3266490 wrote: Hi, DB : 8i and 10g and 11g OS : Redhat 5 and AIX 6 Re: Oraenv is not found Lakmal Rajapakse Mar 9, 2010 3:57 PM (in response to 688835) and what are the contents of dbhome script? Is there other way to set this?....I should have set at /etc/.login...right?...I don't know...I can't think no more.... http://stackoverflow.com/questions/2747462/how-to-correctly-set-the-oracle-home-variable-on-ubuntu-9-x

Set Oracle_home Windows

then I continue to poke around.... Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog

Find ORACLE_HOME Oracle Database Tips by Burleson Consulting September Reply With Quote 11-21-2001,08:00 PM #5 gaegoori View Profile View Forum Posts Member Join Date Jun 2001 Posts 243 I finally solved this problem...I can't believe that I had to stay Everything was working fine...all these incidents happened after I installed Oracle 6i Reports and Forms this afternoon.

  1. No big deal.But, when I try with oraenv (also known as /usr/local/bin/oraenv) it seems to work, but no variables are acutally set.
  2. Results 1 to 5 of 5 Thread: dbhome: command not found Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode
  3. So, unless you "export" - i.e.
  4. 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
  5. Unusually for Linux/Unix and Oracle, the error message is actually informative.
  6. export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 sqlplus / as sysdba share|improve this answer answered Jun 28 '14 at 15:02 karthikeyan 111 add a comment| up vote 1 down vote After installing weblogic and forms server
  7. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the
  8. oraenv ORACLE HOMEORACLE_HOMErefers to either:adirectorywhere the Oracle software is installed; or anenvironment variablepointing to the directory where the Oracle software is installed.
  9. If you don't tell the new SQLPlus shell where to find the SQLPlus executable, then it will throw an error.
  10. In one job I worked in, we had 4 test instances on the one machine.

share|improve this answer edited Apr 16 '13 at 8:43 Ren 1,03741424 answered Apr 16 '13 at 7:52 Abhi 111 add a comment| up vote 1 down vote This is the right Re: Oraenv is not found 688835 Mar 9, 2010 8:31 PM (in response to Lakmal Rajapakse) case "$ORACLE_TRACE" in T) set -x ;; esac trap '' 1 RET=0 ORAHOME="" ORASID=${ORACLE_SID-NOTSET} ORASID=${1-$ORASID} Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services Copyright © 1996 - 2016 All rights reserved by Burleson Oracle is the registered trademark of How To Find Oracle Home Directory In Windows when did I ever set this TWO_TASK?

Re: find oracle home kuljeet singh - Apr 24, 2012 11:14 AM (in response to user3266490) check the file oratab cat /etc/oratab +ASM1:/u01/grid/11.2.0:N ABDB:/u01/app/oracle/product/11/db:N RMANPROD:/u01/app/oracle/product/11/db:N Like Show 0 Likes(0) Actions 3. My $ORACLE_HOME is set to root folder of instant client installation –brunobliss Oct 25 at 10:40 add a comment| up vote 18 down vote I had the same issue. Instead of the above value you give, I would try export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0 share|improve this answer edited Apr 30 '10 at 21:22 answered Apr 30 '10 at 21:17 DCookie 29.2k84866 read the full info here Browse other questions tagged oracle oracle-11g-r2 linux scripting centos or ask your own question.

We altered the bash_profile in a way that the forms_home acts as the oracle home. How To Check Oracle_home Path In Command Prompt Total distance traveled when visiting all rational numbers How do pilots identify the taxi path to the runway? WindowsCheck current value:echo The current ORACLE_HOME is%ORACLE_HOME% Set the ORACLE_HOME environment variable:set ORACLE_HOME=C:\oracle\ora10.2 [edit]Unix & LinuxCheck current value:env | grep ORACLE_HOME Change the ORACLE_HOME environment variable (valid for bash and ksh):export Not the answer you're looking for?

Oracle_home Path In Unix

Reverse a hexadecimal number in bash Web Sites: Disneyland vs Disney World in the United States Ballpark salary equivalent today of "healthcare benefits" in the US? http://techorama.blogspot.com/2011/01/oraenv-or-coraenv-oraclehome-oraclesid.html Multiple DBs running form same home may not matter a lot however.Same case with oraenv as well.It would be nice if there is a way to call oraenv as$. Set Oracle_home Windows the spawning or parent) bash shell. You May Need To Set Oracle_home To Your Oracle Software Directory Please type your message and try again.

When does “haben” push “nicht” to the end of the sentence? navigate here From that point, Oracle knows how to find all the other files it needs. the answer is:CODEexport ORAENV_ASK=NOThanks,Edward JGarmany View Member Profile Apr 11 2005, 10:29 PM Post #5 Advanced Member Group: Members Posts: 359 Joined: 18-March 04 Member No.: 57 ed, You realy Errata? How To Set Oracle_home In Unix

sometimes I just find the answer before anyone sees the post!Edward thesaint View Member Profile Jan 8 2007, 12:39 PM Post #7 Newbie Group: Members Posts: 2 Joined: 8-January 07 Regards, Noob oracle oracle-11g-r2 linux scripting centos share|improve this question asked Aug 4 '15 at 18:37 Noob 10813 What is the output of --> echo $ORACLE_HOME ? Re: find oracle home user3266490 Apr 24, 2012 11:29 AM (in response to CloudDB) Hi, Thanks for your reply. Check This Out Re: find oracle home 932762 Apr 24, 2012 12:54 PM (in response to user3266490) 1) Here is a mechanism to find the right Home from which the instance is running ##ps

March 31, 2011 at 6:48 PM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Check My LinkedIn Profile Oracle ACE RAC Certified Expert Oracle 11i Apps How To Set Oracle Path In Windows I am on linux and oracle 11g. I noticed that because oratab file got changed, which was pointing to oracle6i home instead of oracle rdbms home.

A new line terminates # the entry.

When I try to connect to the database, if fails with an error:If I run the command set |grep ORA I don't get ORACLE_SID or ORACLE_HOME as expected.Which brings the question I'm getting this ORACLE_HOME not set when trying to run SQLPLUS now. –anon58192932 Aug 30 '12 at 2:54 same here, i'm on ubuntu and had to convert RPM to Why is the reduction of sugars more efficient in basic solutions than in acidic ones? How To Set Environment Variable For Oracle 11g In Windows When I checked the coraenv and dbhome under /opt/bin/ the date and time were changed when my installation took place.

So I set back oracle_home to rdbms. Multiple DBs running form same home may not matter a lot however.Same case with oraenv as well.It would be nice if there is a way to call oraenv as$. How do I handle this? http://haywirerobotics.com/how-to/printer-sharing-windows-7.html Take a look at Andrew Tanenbaum's book - or any good text on modern Unixen (or *nix).

[email protected]:/$ export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0 [email protected]:/$ echo $ORACLE_HOME /usr/lib/oracle/xe/app/oracle/product/10.2.0 [email protected]:/$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlp‌lus "/ as sysdba" Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle Options edwardstoever View Member Profile Apr 11 2005, 06:08 PM Post #1 Advanced Member Group: Members Posts: 555 Joined: 29-October 04 From: California Member No.: 923 For you guys with Oracle Template images by enot-poloskun. To start viewing messages, select the forum that you want to visit from the selection below.

What is the ORACLE_HOME supposed to be set to? Why there are no approximation algorithms for SAT and other decision problems? Is it anti-pattern if a class property creates and returns a new instance of a class? More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 3 4 Previous Next 51 Replies Latest reply on Mar 9, 2010 8:31 PM by

oraenv devdbI am trying to set up the environment in a shell script, and I would like to call oraenv from the script and pass the db name also along with Let me know if you need any clarification. I.E: C:\oracle\product\10.2.0\db_2>SQLPLUS SYS AS SYSDBA Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory This error is occurring as does anyone use oraenv?On VMS, there is a similar program called ORAUSER and we use it ALL THE TIME!

SQL> The PRO01* is already started.We unable to find a oracle home for that instance? *.profile is not updated by us.*it is a old one. For example, the error message you get is because Oracle can't locate the message files to report errors with (should be in the various mesg directories below the oracle home. How to interpret torque spec ranges? My blog has been added in Oracle Blogs list !! ► August (4) ► July (4) ► June (6) ► May (2) ► April (9) ► March (4) ► February (3)

Still users cannot launch any applications....