RE: Oracle and SUN config question...
Title: RE: Oracle and SUN config question... I guess I wasn't very clear in the initial posting. Hangovers can be a dreadful thing.. Let's assume that I have 16 Databases on a SUN enterprise server. The architecture is to install Oracle and it's associated components all in one container. And within this container; I'll have an $ORACLE_HOME, a database,et,etc. And each container is owned by a different account(oradb1, oradb2,oradb3,etc,etc). Think of a container as an OS domain. Yet without the overhead of the OS.. Sure, there is some differences of opinion on why to do this,etc. Not wanting to get into those discussion of merit right now. But I'm looking to find out how to isolate the oraInst.loc file for each individual container. The idea in our environment is to be able to lift and drop that container to another enterprise server for one reason or the other. We select a database-and move the container to a different box. If everything is within the container; there really isn't any configuration changes to worry about because I moved a database from box A to box B. The underlying architecture at the OS level allows us to do this (storage is on the SAN, mucho brocade switches and HBA cards,etc). Now if I want to move database JOSE on server TEQUILA to server PORCELINETHRONE-I would like to have the oraInst.loc and oratab within that container. And at one time-I thought that on SUN there was an environment variable/install option that would allow one to position those files accordingly. So the oratab file can be handled via environment variables. No sweat there, got that one covered..But what about the oraInst.loc? thank greg -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 26, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle and SUN config question... The quick and dirty way would be to use soft links. Or you can change the oracle startup scripts (I think). Might there be a line like: ORATAB=/your/favorite/spot in the startup/shutdown scripts?? -Original Message- I have a quick question.. In a SUN environment, how would one place the oratab and oraInst.loc files within a directory that would be self-contained within the $ORACLE_BASE directory tree instead of /var/opt/oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle and SUN config question...
As far as I know, the oratab is only used by the startup and shutdown scripts (and any homebrew scripts you might write). If you wanted different oratabs in different locations, then you won't be able to have a single oracle startup / shutdown script in init.d. I think you need to edit one for each container, then give each startup/shutdown script a unique name. So instead of having something like S99oracle and K##oracle, you might have S99oracle1, S99oracle2, etc. with each coded to read a different oratab. This means that if you move a container from one box to another, you will have to pick up the corresponding startup / shutdown script(s) too. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle and SUN config question...
I have a quick question.. In a SUN environment, how would one place the oratab and oraInst.loc files within a directory that would be self-contained within the $ORACLE_BASE directory tree instead of /var/opt/oracle I seem to remember a method on making that happen...But I have either encountered a Senior moment or I have destroyed that brain cell from last nites opportunity to talk with my friend, Jose, and his partner "the worm".. (not to mention the possibility of talking to Jose's friend - Earl) Thanks in advance! Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)
RE: Oracle and SUN config question...
The quick and dirty way would be to use soft links. Or you can change the oracle startup scripts (I think). Might there be a line like: ORATAB=/your/favorite/spot in the startup/shutdown scripts?? -Original Message- I have a quick question.. In a SUN environment, how would one place the oratab and oraInst.loc files within a directory that would be self-contained within the $ORACLE_BASE directory tree instead of /var/opt/oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle and SUN config question...
- Original Message - From: Loughmiller, Greg To: Multiple recipients of list ORACLE-L Sent: Thursday, February 27, 2003 7:00 AM Subject: Oracle and SUN config question... I have a quick question.. In a SUN environment, how would one place the oratab and oraInst.loc files within a directory that would be self-contained within the $ORACLE_BASE directory tree instead of /var/opt/oracle Ferenc : Soft links will do this. Put a soft link in /var/opt/oratab to the file in $ORACLE_BASE. If you have multiple oracle homes, this might not be such a good idea.