Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Symbolic Links on Sun Solaris 5.8/Oracle9.2

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

From: Janardhana Babu Donga <jbdonga_at_ucdavis.edu>
Date: Wed, 21 Apr 2004 09:52:26 -0700
Message-ID: <627D621CC38ED511AF8300B0D0D1A4EE04BEA0B8@matmail.ucdavis.edu>


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

-----Original Message-----

From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us] Sent: Wednesday, April 21, 2004 9:42 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Symbolic Links on Sun Solaris 5.8/Oracle9.2

I use symbolic links for a 9.2.0.3 and .4 database and it works fine. You sure you have the links set up correctly? Do they look like this:

mkdir -p /dba/U1009/ldwq
cd /dba/U1009/ldwq
mkdir -p /dba/ldwqdg/q14/ldwq/data

ln -s /dba/ldwqdg/q14/ldwq/data data

Personally, I *hate* soft links. I feel like I'm on an easter-egg hunt when I go looking for the files. But they are the standard here, so we use'em.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Janardhana Babu Donga [mailto:jbdonga_at_ucdavis.edu] Sent: Wednesday, April 21, 2004 12:21 PM To: 'oracle-l_at_freelists.org'
Subject: Symbolic Links on Sun Solaris 5.8/Oracle9.2

Dear List Members,  

Has anyone encountered the following problem on Sun Sparc Solaris 5.8?  

If I use symbolic links, create database stmt fails in oracle 9.2.0.1. If I

remove the soft links, create database stmt succeeds.  

I am forced to remove symbolic links and use direct path for Logfiles,

system file, tempfile and undofile etc. from the create database stmt. Does

it mean that the symbolic links are not permitted in Oracle 9.2.0.1 ? I

have several 8.1.7.4 databases that use symbolic links. Do I need to change

them before upgrading to 9.2.0.1? Am I obligated to follow OFA in 9.2 ??  

Please let me know if anyone has experienced the above problem.  

I am on Sun Sparc Solaris 5.8.  


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

-----------------------------------------------------------------
----------------------------------------------------------------
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

-----------------------------------------------------------------
----------------------------------------------------------------
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 - 11:49:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US