Symbolic link pointing to Oracle Home 
Author Message
 Symbolic link pointing to Oracle Home

Solaris 7..  I used to do this with Oracle 7, have a symbolic link
pointing to Oracle Home.  Is this still cool with 8i?  Any problems for
OEM or other Oracle tools?  Having a symlink sure makes it easier when I
upgrade versions to new directories.  I also like having symlinks pointing
to datafile locations, makes it easier to move them around if necessary.

thx.. Allen



Thu, 13 Nov 2003 13:55:59 GMT
 Symbolic link pointing to Oracle Home


Quote:

> Solaris 7..  I used to do this with Oracle 7, have a symbolic link
> pointing to Oracle Home.  Is this still cool with 8i?  Any problems for
> OEM or other Oracle tools?  Having a symlink sure makes it easier when I
> upgrade versions to new directories.  I also like having symlinks pointing
> to datafile locations, makes it easier to move them around if necessary.

> thx.. Allen

IMO it has never been cool, and it is for the lazy only.
It has resulted in problems at various sites I have been overseeing more
than once, because people beliieved Oracle was installed two times, and
there seemed to be lack of disk space. You can guess what happened.
I would avoid using links as much as possible, except for the init.ora (and
config.ora)

Hth,

Sybrand Bakker, Oracle DBA



Thu, 13 Nov 2003 15:14:28 GMT
 Symbolic link pointing to Oracle Home
we use symbolic links for the init.ora files (we relocate the init.ora
files from the default $ORACLE_HOME/dbs directory to the OFA
compliant location (.../admin/sid/pfile), but include the symbolic
link from the "default" location).

we also use symbolic links for all datafiles on raw partitions
(hp-ux logical volumes).

other than that, i have to agree with sybrand.  i cannot think of a
good reason to use a symbolic link as the oracle home directory.


Quote:



> > Solaris 7..  I used to do this with Oracle 7, have a symbolic link
> > pointing to Oracle Home.  Is this still cool with 8i?  Any problems for
> > OEM or other Oracle tools?  Having a symlink sure makes it easier when I
> > upgrade versions to new directories.  I also like having symlinks
pointing
> > to datafile locations, makes it easier to move them around if necessary.

> > thx.. Allen

> IMO it has never been cool, and it is for the lazy only.
> It has resulted in problems at various sites I have been overseeing more
> than once, because people beliieved Oracle was installed two times, and
> there seemed to be lack of disk space. You can guess what happened.
> I would avoid using links as much as possible, except for the init.ora
(and
> config.ora)

> Hth,

> Sybrand Bakker, Oracle DBA



Fri, 14 Nov 2003 05:46:32 GMT
 Symbolic link pointing to Oracle Home

Quote:
> > OEM or other Oracle tools?  Having a symlink sure makes it easier when I
> > upgrade versions to new directories.  I also like having symlinks
pointing
> > to datafile locations, makes it easier to move them around if necessary.

(snip)

Quote:
> IMO it has never been cool, and it is for the lazy only.
> It has resulted in problems at various sites I have been overseeing more
> than once, because people beliieved Oracle was installed two times, and

I wonder whether it would be OK if the ORACLE_HOME was on a network-attached
storage device (like Network Appliance)?  I have been considering doing so
that we only need to install/upgrade/patch a single copy of each Oracle
release which can then be shared to multiple machines (Solaris boxes in this
case) that are "attached" to the net appliance.  Each host would have a
symbolic link to the appropriate file system on the net appliance...


Sun, 16 Nov 2003 04:50:55 GMT
 Symbolic link pointing to Oracle Home

Quote:

> > > OEM or other Oracle tools?  Having a symlink sure makes it easier when
I
> > > upgrade versions to new directories.  I also like having symlinks
> pointing
> > > to datafile locations, makes it easier to move them around if
necessary.

> (snip)

> > IMO it has never been cool, and it is for the lazy only.
> > It has resulted in problems at various sites I have been overseeing more
> > than once, because people beliieved Oracle was installed two times, and

> I wonder whether it would be OK if the ORACLE_HOME was on a
network-attached
> storage device (like Network Appliance)?  I have been considering doing so
> that we only need to install/upgrade/patch a single copy of each Oracle
> release which can then be shared to multiple machines (Solaris boxes in
this
> case) that are "attached" to the net appliance.  Each host would have a
> symbolic link to the appropriate file system on the net appliance...

you would need to verify with network appliance that they actually
support "sharing" a single file system by more than one host, and
i'm not sure what kind of support a netapp filer would provide for
that type of configuration.

the network appliance website has several papers discussing
the placement of oracle datafiles on a netapp filer.  the emphasis
seems to be placed on the advantages of placing the database
datafiles on the netapp filer.



Sun, 16 Nov 2003 09:55:53 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. 29512-TN-Memphis-ORACLE-ORACLE Forms-ORACLE Tools-ORACLE HR-ORACLE Case Tools-CONSULTANTS

2. 20350-CO-Denver-ORACLE-ORACLE Case Tools-ORACLE Financials-ORACLE Forms-ORACLE H

3. 29512-TN-Memphis-ORACLE-ORACLE Forms-ORACLE Tools-ORACLE HR-ORACLE Case Tools-CONSULTANTS

4. 20350-CO-Denver-ORACLE-ORACLE Case Tools-ORACLE Financials-ORACLE Forms-ORACLE H

5. 20350-CO-Denver-ORACLE-ORACLE Case Tools-ORACLE Financials-ORACLE Forms-ORACLE H

6. Reliable link to Oracle server (linked, server, oracle)

7. 4720-FL-ORLANDO-ORACLE Case Tools-ORACLE Reports 2.X-ORACLE Tools-ORACLE Forms-S

8. 19894-VA-Herndon-ORACLE Financials-ORACLE Forms-ORACLE Reports 2.X-ORACLE-SQL-C-

9. 34744-Nationwide-ORACLE-ORACLE Financials-ORACLE Manufacturing-ORACLE HR-PeopleS

10. 4721-CO-COLORADO SPRGS-ORACLE Case Tools-ORACLE Forms-ORACLE Reports 2.X-ORACLE

11. 34744-Nationwide-ORACLE-ORACLE Financials-ORACLE Manufacturing-ORACLE HR-PeopleS


 
Powered by phpBB® Forum Software