06-03-2005
oracle on solaris
Hi Friends ,
I need to connect to Oracle using sqlplus and it says that sqlplus is not found . I need to check if Oracle is running or not .is there any command to check if oracle is running ?
Please help
Thanks in advance
Veera
6 More Discussions You Might Find Interesting
1. UNIX Desktop Questions & Answers
Good afternoon Unix folks,
I have been asked to find out if there is an ideal way to setup oracle on sun solaris. Right now, I have 2 36gig drives mirrored for my root volume.
I have 4 more raid 5 for my datavolume. For io purposes, I need to break up these drives to prove that io is the... (2 Replies)
Discussion started by: niasdad
2 Replies
2. Solaris
Hi friends,
i am given a new login id on a solaris system.And i have the basic .profile for that.Once i log in to that system how can i check if there is oracle installed on that solaris system ?
I would want to set the path and other variables if i find that oracle is installed on it.
Please... (6 Replies)
Discussion started by: sveera
6 Replies
3. Shell Programming and Scripting
Please is there a way and how can I check is my oracle database OK on my solaris I did not istall that database but on processes I can see there are lot of oracle processes running ..also I would like to use that database..
That was my first q and second: I can telnet that machine from my local... (1 Reply)
Discussion started by: amon
1 Replies
4. Solaris
Hi,
what are all best performance practices we can set in solaris box for oracle database 10.2.0.2
Thanks. (3 Replies)
Discussion started by: rags_s11
3 Replies
5. Solaris
What is the minimum amount of RAM a db could be made to run on solaris OS .. i just need to test high availability failover of oracle db on a VM so want to make the db as thin as possible and to make it run on least amount on memory. (1 Reply)
Discussion started by: fugitive
1 Replies
6. Solaris
Hello Friends
I was running Solaris 10 on SunFire X2200 M2, with 40 Sunray 270 units, and would like to advance to a higher version of Solaris,
Can anybody with experience on this help how to go about it, or if there is any other open source os to go with the hardware advice
Thanks in... (1 Reply)
Discussion started by: daviey.daviey
1 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::oracle::wherejoins
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)