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
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
2. UNIX for Dummies Questions & Answers
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
3. UNIX for Dummies Questions & Answers
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
4. Shell Programming and Scripting
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
5. UNIX and Linux Applications
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
6. Shell Programming and Scripting
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
7. IP Networking
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
8. AIX
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
9. Solaris
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
10. UNIX for Dummies Questions & Answers
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
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::oracle::wherejoins5.18
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)
NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you.
DESCRIPTION
This class implements Oracle's WhereJoin support. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the SQL query, it's already too late.
METHODS
See DBIx::Class::SQLMaker::OracleJoins for implementation details.
BUGS
Does not support full outer joins. Probably lots more.
SEE ALSO
DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
DBIx::Class::Storage::DBI::Oracle::Generic
DBIx::Class
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.18.2 2013-07-12 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)