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
sql::reservedwords::oracle
SQL::ReservedWords::Oracle(3pm) User Contributed Perl Documentation SQL::ReservedWords::Oracle(3pm)
NAME
SQL::ReservedWords::Oracle - Reserved SQL words by Oracle
SYNOPSIS
if ( SQL::ReservedWords::Oracle->is_reserved( $word ) ) {
print "$word is a reserved Oracle word!";
}
DESCRIPTION
Determine if words are reserved by Oracle Database.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either Oracle7, Oracle8i, Oracle9i or Oracle10g.
is_reserved_by_oracle7( $word )
Returns a boolean indicating if $word is reserved by Oracle7.
is_reserved_by_oracle8( $word )
Returns a boolean indicating if $word is reserved by Oracle8i.
is_reserved_by_oracle9( $word )
Returns a boolean indicating if $word is reserved by Oracle9i.
is_reserved_by_oracle10( $word )
Returns a boolean indicating if $word is reserved by Oracle10g.
reserved_by( $word )
Returns a list with Oracle versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_oracle7
is_reserved_by_oracle8
is_reserved_by_oracle9
is_reserved_by_oracle10
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://www.oracle.com/technology/documentation/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::Oracle(3pm)