Oracle, Symbolic link pointing to Oracle Home

Symbolic link pointing to Oracle Home

Author	Message
Alle #1 / 5	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

Sybrand Bakke #2 / 5	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

Spence #3 / 5	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

Vincent Ventron #4 / 5	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

Spence #5 / 5	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

Page 1 of 1

[ 5 post ]