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

Thanks for the info. The directory softlinks work, however, I am planning to
remove all the symlinks and use direct path to the datafiles as in Optimal
Flexible Architecture (OFA) compliant database. 
I used symbolic links for all 8174 databases, actual datafiles are located
in different partitions such as /u01...,/u02... etc.  
If I use softlinks for directories, I may need to create many directories,
one for each /U.. partition. I thought I can use the same softlinks and
upgrade the databases to 9205. oracle 9205 is not even letting me create a
new database if I use softlinks. I think it is an undocumented restriction
in 9205, I am not sure if it is documented else where.

How do you guys use while creating the database? Do you specify direct path
as in OFA (/mountpoint/oradata/sid/data01.dbf) or use directory soft links
for all the datafiles? What procedures do you follow for medium to large
databases?

Appreciate a reply.


-- Babu

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse@xxxxxxxxxxxxxxxxx] 
Sent: Wednesday, April 21, 2004 12:07 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Symbolic Links on Sun Solaris 5.8/Oracle9.2

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@xxxxxxxxxxxxxxxxx      QuadTech, Sussex, WI USA


> -----Original Message-----
> From: Janardhana Babu Donga [mailto:jbdonga@xxxxxxxxxxx]
> Sent: Wednesday, April 21, 2004 11:52 AM
> To: 'oracle-l@xxxxxxxxxxxxx'
> 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: