10-10-2007
By binaries do you mean the binary database image or the executables?
I would recommend that you have the executables on local disk but have the database on the san.
Also, Oracle is a complex product and has to be tuned with the operating system. I would do a separate install of oracle on the 5.9 box, and ensure that only have one oracle has the database open at a time.
You would need to check with the Oracle documentation to see if you need to migrate the database itself, but I am assuming the version of Oracle is not changing.
As always, ensure adequate backup prior to any activity like this.
7 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. UNIX for Advanced & Expert Users
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 (2 Replies)
Discussion started by: sveera
2 Replies
4. 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
5. Red Hat
Hi,
I have to move user account from solaris to Linux environment because I don't want user to create password again in Linux environment, so could somebody confirm me how to do it, I know there are files /etc/groups, /etc/passwd and /etc/shadows need to copy but somebody confirm me what is the... (2 Replies)
Discussion started by: mnaumanca
2 Replies
6. UNIX Desktop Questions & Answers
Hello,
Do you guys by any chance know what is the best (if any ) way to move CDE configuration from a SOLARIS 10 machine to HP-UX?
Just the config (actions, text files etc).
Thanks in advance! (0 Replies)
Discussion started by: binary0x01
0 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I have to backup users from one server and put them on another server. I have tried cp -pr, copied over the passwd, group, shadow and appended the users from the old server to the new servers files, rebooted and still can't login. The server accepts that new accounts are there but not... (2 Replies)
Discussion started by: hs3082
2 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::oracle
DBIx::SearchBuilder::Handle::Oracle(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::Oracle(3pm)
NAME
DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
Connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
BuildDSN
Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method.
Takes additional argument SID. Database argument used unless SID provided. Two forms of DSN are generated depending on whether Host
defined or not:
dbi:Oracle:sid=<SID>;host=...[;port=...]
dbi:Oracle:<SID>
Read details in documentation for DBD::Oracle module.
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
InsertFromSelect
Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle.
Unlike other DBs Oracle needs:
o id generated from sequences for every new record.
o query wrapping in parens.
NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the
following query would generate "ORA-00918: column ambiguously defined" error:
SELECT g.id, u.id FROM ...
Solve with aliases:
SELECT g.id AS group_id, u.id AS user_id FROM ...
KnowsBLOBs
Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database must be informed of BLOBs
for inserts.
BLOBParams FIELD_NAME FIELD_TYPE
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
DistinctQuery STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
BinarySafeBLOBs
Return undef, as Oracle doesn't support binary-safe CLOBS
DatabaseVersion
Returns value of ORA_OCI constant, see "Constants" in DBI.
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT tzname FROM v$timezone_names;
Read Oracle's docs about timezone files:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
perl(1), DBIx::SearchBuilder
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::Oracle(3pm)