Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

setting Oracle Home

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting setting Oracle Home
# 1  
Old 12-14-2006
setting Oracle Home
Hi,

if i set Oracle home in the command line as
export ORACLE_HOME=/usr/oracle/product/9.2.0; and then checking it by
typing echo $ORACLE_HOME,its getting the correct result.But if i try setting the ORACLE_HOME from a shell script by just including the same line as above,it was not working.Could anybody give me a tip regarding this?

With Regards
Dileep
# 2  
Old 12-14-2006
try

ORACLE_HOME=/usr/oracle/product/9.2.0

export ORACLE_HOME
# 3  
Old 12-14-2006
Quote:
Originally Posted by DILEEP410
Hi,

if i set Oracle home in the command line as
export ORACLE_HOME=/usr/oracle/product/9.2.0; and then checking it by
typing echo $ORACLE_HOME,its getting the correct result.But if i try setting the ORACLE_HOME from a shell script by just including the same line as above,it was not working.Could anybody give me a tip regarding this?

With Regards
Dileep
If you want to set the env variable from a shell script, then you need to source that file i.e.
Code:
source myscript.sh

# 4  
Old 12-14-2006
Quote:
Originally Posted by vino
If you want to set the env variable from a shell script, then you need to source that file i.e.
Code:
source myscript.sh

fine.This seems to be working.Thanks for your comment.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Setting up a home network for learning Linux

I am working on learning Linux, and somebody suggested setting up Linux on a separate computer, and searching for answers to whatever may be needed, on a different computer plugged in to the Internet. I have a Windows 7 PC, plugged in to a cable modem, and an old notebook, Compaq Presario R3000... (5 Replies)
Discussion started by: AdultFoundry
5 Replies

2. Solaris

New Oracle Home

How do I set ORACLE_HOME location? When I type echo $$ORACLE_HOME it gives me /u01/app/oracle//product/10.2.0/dbhome_1 which has been deleted. I just installed Oracle 11g and this is supposed to be a new oracle home /u01/app/oracle/product/11.2.0/dbhome_1 Any help from the community... (21 Replies)
Discussion started by: newborndba
21 Replies

3. AIX

Setting AIX box at home.

Hi guys... I have got a old Aix box i.e. 7043 - 150 for home experimenting purposes. I am having some issues to setup the tcpip on it correctly, so that i can access it within the network and also from outside i.e. work. My setup looks like this: Modem ----> Apple airport wireless router... (2 Replies)
Discussion started by: uzair_rock
2 Replies

4. IP Networking

Setting to SSH home-PC from Work

Hello, My question is very basic for the settings to SSH my home PC from work. Home network two PC: Internet comes into my house through ISP modem and then the two PCs are connected with the router (Trendnet). The IPs for my PCs are How to set other stuffs for me to access my home PC from... (5 Replies)
Discussion started by: yifangt
5 Replies

5. Shell Programming and Scripting

how to change ORACLE HOME?

All, I have to change my ORACLE_HOME in the prodution environment. I have chaged it in .profile file but when I am typing the command bash-2.05$ echo $ORACLE_HOME /apps/oracle/product/10.2.0.4.2011Q1 Instead of Q1 it should show Q3 bcoz I have changed it in .profile file. But at the same... (2 Replies)
Discussion started by: Oracle_User
2 Replies

6. UNIX and Linux Applications

Setting up Oracle RAC at home

Hello, I'm planning to set up Oracle 10g RAC at home. I was initaillay planning to get a windows desktop and install Cent OS after wiping out the existing windows OS. I have some questions with regards to this. 1) For setting up RAC, I would have to install an additional NIC besides the one... (2 Replies)
Discussion started by: luft
2 Replies

7. Shell Programming and Scripting

Setting path for a stand alone library in home directory

Hi all, This is probably a basic question. I had installed a stand-alone library called szip in my home directory, as I don't have the necessary root permission. I tried to set an environment for both include and lib files in my .cshrc script as setenv /home/szip/lib setenv... (3 Replies)
Discussion started by: alamcheril
3 Replies

8. UNIX for Dummies Questions & Answers

setting home as lin in user profile

Hi. I have a directory structure built with links. For example: /home/user1 is a link to /var/123/user1 can i set the home variable in the .profile of the user to use a link? or it has to be a "real" directory? tks (1 Reply)
Discussion started by: mrodrig
1 Replies

9. UNIX for Dummies Questions & Answers

Need help setting up a home solaris private network

Hi all, I just purchased 2 Ultra 10 servers and I want to practice with home networking. I want to create a private network where I can connect both boxes to the internet via broadband using my four port adsl modem/router. My ISP assigns me 192.168 addresses via DHCP and I use the ISP's DNS but... (1 Reply)
Discussion started by: Kongowea
1 Replies

10. UNIX for Advanced & Expert Users

setting up my HOME PC as server

Hi , i am having RedHat AS 4 in my home PC.now i want to access applications remotely i.e from office. how can i do that. in short i would like to make my PC as server for doing test's. while I am @ work. I am using static IP. leenus (1 Reply)
Discussion started by: rrs
1 Replies
Login or Register to Ask a Question