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
jifty::dbi::handle::oracle
Jifty::DBI::Handle::Oracle(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::Oracle(3pm)
NAME
Jifty::DBI::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of Jifty::DBI::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.
database_version
Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.
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.
build_dsn PARAMHASH
Takes a bunch of parameters:
Required: Driver, Database or Host/SID, Optional: Port and RequireSSL
Builds a dsn suitable for an Oracle DBI connection
blob_params column_NAME column_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).
apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
distinct_query STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle
perl v5.14.2 2011-04-26 Jifty::DBI::Handle::Oracle(3pm)