Login or Register to Ask a Question and Join Our Community


Solaris

New Oracle Home

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Solaris New Oracle Home
# 1  
Old 04-23-2014
New Oracle Home
How do I set ORACLE_HOME location?

When I type echo $$ORACLE_HOME it gives me
Code:
/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

Code:
/u01/app/oracle/product/11.2.0/dbhome_1

Any help from the community will be highly appreciated.
Last edited by Scott; 04-25-2014 at 12:38 PM.. Reason: Code tags
# 2  
Old 04-23-2014
Code:
set PATH="/u01/app/oracle/product/11.2.0/dbhome_1"

# 3  
Old 04-23-2014
If you have access, set it in /etc/profile
Else, set it in your .profile / .bashrc file
Code:
export ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1"

# 4  
Old 04-23-2014
Quote:
Originally Posted by Makarand Dodmis
Code:
set PATH="/u01/app/oracle/product/11.2.0/dbhome_1"

Well I did what I was told but same thing
echo $ORACLE_HOME gives me the same location.

---------- Post updated at 12:05 PM ---------- Previous update was at 12:03 PM ----------

Quote:
Originally Posted by SriniShoo
If you have access, set it in /etc/profile
Else, set it in your .profile / .bashrc file
Code:
export ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1"

I don't see much in my /etc/profile
and I don't know how to find .profile / .bashrc file.

FYI-I am very new to Solaris and I also have a root access.
# 5  
Old 04-23-2014
If you have a home directory on that server
Code:
cd ~
echo "export ORACLE_HOME=\"/u01/app/oracle/product/11.2.0/dbhome_1\"" >> .profile
. .profile
echo $ORACLE_HOME

# 6  
Old 04-23-2014
Thanks for your help but when I cd ~ it says "doesn't exist"
# 7  
Old 04-23-2014
Do you have a home directory on that server?
f so, go to that path, skip the 'cd ~' and run the rest of the commands
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract Oracle home from Oratab and compare values

Friends, I'm trying to do below in ksh script, while requesting user to provide src_db and dest_db values 1. Extract src_db and dest_db Oracle home from oratab file 2. Don't find db if it starts with comment (#) 3. Compare both values 4. Message success or exit with error if they don't... (0 Replies)
Discussion started by: homer4all
0 Replies

2. Solaris

Oracle Solaris 11 on home server

I am interested in learning oracle solais 11 but I can't seem to find a discounted version/free version with security updates for home use (I would like to set it up as I would a real server for practice so I would like to get security updates I understand that there is a trial version but you... (3 Replies)
Discussion started by: crookedmaze
3 Replies

3. 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

4. Shell Programming and Scripting

cp -p /home/* home/exp/*.date not working please help

:( ---------- Post updated at 01:51 AM ---------- Previous update was at 01:50 AM ---------- Not working ---------- Post updated at 02:04 AM ---------- Previous update was at 01:51 AM ---------- cp -p /home/* home/exp/*.`date` i am using this (4 Replies)
Discussion started by: rishiraaz
4 Replies

5. Solaris

Home Directory for oracle user

Hello all, I am Installing Oracle 11g on my Solaris OS. I created the below oracle user: # /usr/sbin/useradd -g oinstall -G dba oracle but when i am trying to to su - oracle it give me the below error No directory Do i have to setup a home directory for oracle user? and how can i do... (1 Reply)
Discussion started by: beayni33
1 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

$HOME Not Getting Set for Oracle Scheduler Script at Runtime

We are researching the possibility of using Oracle 10g Scheduler on Solaris 10 to launch scripts at our site, and the script that I am testing does not get $HOME (and other environment variables) set correctly. Here is the Korn shell script (show_info.ksh): #!/usr/bin/ksh id env | sort Here... (4 Replies)
Discussion started by: shew01
4 Replies

8. Shell Programming and Scripting

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... (3 Replies)
Discussion started by: DILEEP410
3 Replies

9. UNIX for Dummies Questions & Answers

Hardware dummy trying to set up Unix workstation for Oracle at home for practice!

I have been planning to set up a Unix workstation at home to host an Oracle database just for database admin. practice. But I don't know enough about hardware to know whether this can be done on a regular desktop and the required hardware config. If anyone could kindly guide me in this mission I... (4 Replies)
Discussion started by: tmanpakdee
4 Replies
Login or Register to Ask a Question