From oracle-l-bounce@freelists.org Wed Apr 21 11:40:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3LGe5B21824 for ; Wed, 21 Apr 2004 11:40:05 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3LGe5621819 for ; Wed, 21 Apr 2004 11:40:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F32E172D748; Wed, 21 Apr 2004 11:32:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04632-24; Wed, 21 Apr 2004 11:32:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7FF7D72DF75; Wed, 21 Apr 2004 11:32:04 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 21 Apr 2004 11:30:47 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A8B1B72CD8B for ; Wed, 21 Apr 2004 11:30:46 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03044-91 for ; Wed, 21 Apr 2004 11:30:46 -0500 (EST) Received: from GAVHSEN0A1AD.HSEN (exchsen0a1ra.dfa.state.ny.us [198.22.236.246]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D300672D58D for ; Wed, 21 Apr 2004 11:30:45 -0500 (EST) Received: from snysdolmail1.labor.state.ny.us ([172.16.96.117]) by exchsen0a1ra.dfa.state.ny.us with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id HWBZ218C; Wed, 21 Apr 2004 12:42:21 -0400 Received: by snysdolmail1.labor.state.ny.us with Internet Mail Service (5.5.2650.21) id ; Wed, 21 Apr 2004 12:42:19 -0400 Message-ID: X-Sybari-Trust: 313f903f ba003653 a511a862 0000013d From: "Mercadante, Thomas F" To: "'oracle-l@freelists.org'" Subject: RE: Symbolic Links on Sun Solaris 5.8/Oracle9.2 Date: Wed, 21 Apr 2004 12:42:20 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3452 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@ucdavis.edu] Sent: Wednesday, April 21, 2004 12:21 PM To: 'oracle-l@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. -- Babu ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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@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 -----------------------------------------------------------------