IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New 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]
New 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.
New 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]
New OK
New 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]
New 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]
New 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]
New 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
New 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]
New 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.
New 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]
New Maybe
Maybe not.
Maybe it's checking for a different Oracle home and considering it an error.
     anyone with oracle know what these are? - (boxley) - (26)
         You need em. - (folkert) - (1)
             lab box, my care and feeding only - (boxley)
         If memory serves me correct. - (ChrisR) - (8)
             ICLRPD (new thread) - (drewk)
             well I guess I know what Ill be doing the rest of the day - (boxley) - (6)
                 Live and learn. - (ChrisR) - (1)
                     no problem, I needed to knock it down any way - (boxley)
                 My rule on unknown files - (SpiceWare) - (3)
                     disk at 100% ripem out then learn something -NT - (boxley) - (2)
                         Compress elsewhere, then learn later. -NT - (ben_tilly) - (1)
                             *GRIN* -NT - (imric)
         Yes - (broomberg) - (14)
             nope only one :-) - (boxley) - (13)
                 You CANNOT use one from a different box - (broomberg) - (12)
                     rm -r oracle - (boxley) - (11)
                         The tnsnames will be wrong - (broomberg) - (10)
                             tnsnames on all boxes point to localhost - (boxley) - (9)
                                 OK -NT - (broomberg)
                                 You might find this helpful - (broomberg) - (7)
                                     thanks! bookmarked -NT - (boxley)
                                     backup and running 4hrs to figure out - (boxley) - (5)
                                         Hmm - (broomberg) - (4)
                                             yabut does your user $ORACLE_HOME - (boxley) - (3)
                                                 Yup - (broomberg) - (2)
                                                     but if oracle user uses - (boxley) - (1)
                                                         Maybe - (broomberg)

Somewhat classier digs than the last version.
74 ms