| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Symbolic Links on Sun Solaris 5.8/Oracle9.2
Babu,
This looks strange to me. I'm not saying it is wrong, but strange. I'm wondering if Oracle cannot deal with the softlink naming the explicit file name.
I softlink directories.
mkdir -p /dba/U1009/ldwq cd /dba/U1009/ldwq mkdir -p /dba/ldwqdg/q14/ldwq/data
and then within Oracle, I will create a file at the /dba/U1009/ldwq/data directory. So within Oracle, it looks like: /dba/U1009/ldwq/data/data_01.dbf
This places the file in the physical location of /dba/ldwqdg/q14/ldwq/data.
Why not try creating the softlink like this and see what happens?
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Janardhana Babu Donga [mailto:jbdonga_at_ucdavis.edu]
Sent: Wednesday, April 21, 2004 12:52 PM
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
-----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
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.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |