The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com



Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Install Guide: Oracle Database 11g Release 1 on Oracle Enterprise Linux 5 iBot Oracle Updates (RSS) 0 04-06-2008 06:10 AM
Integrating the Oracle Designer Legacy Table API with Oracle JDeveloper 11g ADF Busin iBot Oracle Updates (RSS) 0 04-06-2008 06:10 AM
Build a Rapid Web Development Environment for Python Server Pages and Oracle iBot Oracle Updates (RSS) 0 04-06-2008 06:10 AM
Oracle and Symantec Certify Veritas Data Center Solutions on Oracle - WebWire (press iBot UNIX and Linux RSS News 0 07-17-2007 09:30 AM
How can i load or insert a table in oracle from c language thru unix environment rramprasad High Level Programming 6 07-09-2002 01:17 AM

 
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1 (permalink)  
Old 04-05-2006
castlerock castlerock is offline
Registered User
  
 

Join Date: Mar 2006
Posts: 9
Help to set the oracle environment????

Hi,
I am trying to set the environment for my oracle database. I have 5 database in an unix box. My idea is to create 5 files for each database with the following script on it.

After logging into the unix box ...just by typing the database name....the enviornment for the database will be set.

not able to set the environment by calling the file name which is sadev(same as database name)

1. Created a file with name sadev

2. contents in sadev file

export ORACLE_SID=SADEV
echo $ORACLE_SID

3. running the file

eg: deveopmentbox# sadev
sadev
# echo $ORACLE_SID
sademo


I am not able to set the environment the ORACLE_SID=sadev. The "sademo" is set in the .profile of the user.

when i execute the commands inside the file i am able to set the environment for any database instance.

Is there anything wrong in the above steps???


Many Thanks,
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -4. The time now is 07:06 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0