RE: Symbolic Links on Sun Solaris 5.8/Oracle9.2

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Wed, 21 Apr 2004 14:07:26 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E938B0@qtiexch2.qgraph.com>

Wouldn't you want to softlink the directory instead of the individual datafiles? Perhaps Oracle9i uses a Unix (or is it POSIX shell?) "-h" test in addition to a "-a" test for the file to see if it exists? The only softlinking we do with Oracle is on the init.ora (and some in /usr/lib for Oracle on HP-UX).

$ ln -s not_exist new_link
$ if [ -a new_link ]; then echo "Exists"; fi
$ if [ -h new_link ]; then echo "Exists"; fi

Exists
$ touch not_exist
$ if [ -a new_link ]; then echo "Exists"; fi Exists

Try changing your softlink from the file to the directory and see if it works. If you've mixed softlinks with actual files in that directory, you might want to prepare to rename some files.

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

> -----Original Message-----
> From: Janardhana Babu Donga [mailto:jbdonga_at_ucdavis.edu]
> Sent: Wednesday, April 21, 2004 11:52 AM
> To: 'oracle-l_at_freelists.org'
> Subject: RE: Symbolic Links on Sun Solaris 5.8/Oracle9.2
>
>
> Yes they look like the following.
>
> $ORACLE_BASE=/usr/local/oracle
> $ORACLE_HOME=/usr/local/oracle/9205
> cd /usr/local/oracle/data/orcl
> ln -s /u01/oracle/orcl/system01.dbf
> /usr/local/oracle/data/orcl/system01.dbf
>
> -- Babu

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Apr 21 2004 - 14:05:55 CDT