Post #210,939
6/11/05 1:12:41 PM
|
rm -r oracle
place tarfile of oracle that does the same job on a different machine with same hardware and disklayout on my now oracle free machine. Will report how it works out. thanx, bill
All tribal myths are true, for a given value of "true" Terry Pratchett [link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,943
6/11/05 1:38:39 PM
|
The tnsnames will be wrong
This file defines your sqlnet connections. You can accidently setup a local connection to access a remote machine. You THINK you are working on your local box, only to find you are accessing the other one.
Not fun after you've dropped a production table.
|
Post #210,947
6/11/05 2:23:48 PM
|
tnsnames on all boxes point to localhost
its cool. Just my own lab not production thanx, bill
All tribal myths are true, for a given value of "true" Terry Pratchett [link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #210,964
6/11/05 9:01:59 PM
|
OK
|
Post #210,965
6/11/05 9:08:30 PM
|
You might find this helpful
[link|http://www.ibiblio.org/pub/Linux/docs/HOWTO/other-formats/html_single/Oracle-9i-RH8-and-RH9-HOWTO.html|http://www.ibiblio.o...nd-RH9-HOWTO.html]
|
Post #210,970
6/11/05 10:18:28 PM
|
thanks! bookmarked
All tribal myths are true, for a given value of "true" Terry Pratchett [link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #211,178
6/14/05 10:30:21 AM
|
backup and running 4hrs to figure out
that oracle is fucking clueless about soft links. I mean if I link /export/home/oracle to /foo/oracle because I am too lazy to edit 5k path files and a user has $ORACLE_HOME=/foo/oracle I would reasonably expect sqlplus to connect me to the database. Nope gotta have $ORACLE_HOME=/export/home/oracle or it doesnt work.. grumble..... thanx. bill
All tribal myths are true, for a given value of "true" Terry Pratchett [link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #211,248
6/14/05 7:03:18 PM
|
Hmm
I've been using softlinks to Oracle home for years.
lrwxrwxrwx 1 root other 23 Feb 4 2001 u01 -> /xy/bfd/oracle_base/u01 lrwxrwxrwx 1 root other 23 Feb 4 2001 u02 -> /xy/bfd/oracle_base/u02 lrwxrwxrwx 1 root other 23 Feb 4 2001 u03 -> /xy/bfd/oracle_base/u03 lrwxrwxrwx 1 root other 23 Feb 4 2001 u04 -> /xy/bfd/oracle_base/u04 lrwxrwxrwx 1 root other 23 Feb 4 2001 u05 -> /xy/bfd/oracle_base/u05 lrwxrwxrwx 1 root other 24 Oct 31 2001 u06 -> /xy/bfd2/oracle_base/u06 lrwxrwxrwx 1 root other 24 Oct 31 2001 u07 -> /xy/bfd2/oracle_base/u07 lrwxrwxrwx 1 root other 24 Oct 31 2001 u08 -> /xy/bfd2/oracle_base/u08 lrwxrwxrwx 1 root other 21 Mar 24 2004 u09 -> /xy/H/oracle_base/u09 lrwxrwxrwx 1 root other 21 Mar 24 2004 u10 -> /xy/I/oracle_base/u10
$ echo $ORACLE_HOME /u01/app/oracle/product/8.1.7
|
Post #211,251
6/14/05 7:16:00 PM
|
yabut does your user $ORACLE_HOME
point at the same one that you use in the startupDB (startup script where you kick oracle awake and mount the database) mine was different startup script pointing to the link and user pointing at the real file. made them both the same and it worked. thanx, bill
All tribal myths are true, for a given value of "true" Terry Pratchett [link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #211,256
6/14/05 7:43:57 PM
|
Yup
Startup sets this, as well as it being sourced in to login scripts. ORACLE_BASE=/u01/app/oracle ORACLE_HOME=${ORACLE_BASE}/product/8.1.7
So it was really a matter of them being different, not that it was over a symbolic link for you.
|
Post #211,259
6/14/05 7:49:19 PM
|
but if oracle user uses
oracle_base=/export/home/oracle and user uses oracle_base-/foo/oracle and /foo/oracle is where /export/home/oracle really lives it should work. thanx, bill
All tribal myths are true, for a given value of "true" Terry Pratchett [link|http://boxleys.blogspot.com/|http://boxleys.blogspot.com/]
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
|
Post #211,262
6/14/05 8:12:56 PM
|
Maybe
Maybe not. Maybe it's checking for a different Oracle home and considering it an error.
|