Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Working, middle of night

RE: Working, middle of night

From: Gurgaon, DBA (CAP, GECSI, CONTRACTOR) <>
Date: Tue, 6 Jun 2000 15:49:19 +0530
Message-Id: <>

you can create soft link by executing this command

ln -s <actual file path> <path where you want the link>

Instead i recommend is to rename the datafile in your database.

svrmgr> startup mount
svrmgr> alter database rename file '/oradata/PETS/data1/system01.dbf' to '/opt/oracle/app/oracle/oradata/PETS/data/system01.dbf'; svrmgr>alter database open;


-----Original Message-----
From: Linda Hagedorn [] Sent: Tuesday, June 06, 2000 2:20 PM
To: Multiple recipients of list ORACLE-L Subject: Working, middle of night

Hope someone's around tonight...

I have some datasets in the 'wrong' place, and the database is failing to open with this error: Database mounted.
ORA-01157: cannot identify data file 1 - file not found ORA-01110: data file 1: '/oradata/PETS/data1/system01.dbf'

I want to create soft links from the recorded name: /oradata/PETS/data1/system01.dbf, to the location where the dataset actually resides: /opt/oracle/app/oracle/oradata/PETS/data/system01.dbf

I don't have root, and am reluctant to move the datasets around.

Does someone know the syntax to create a Unix soft-link?

Thanks very much. Linda

PS. The source of the problem is no mystery. In an effort to make space in an emergency, files were moved (not by me) to different directories. This has been done to a significant number of the files. While this is not production, it is QA/Dev, and I'm anxious to put the house back in order. This is a temporary situation, and meetings are underway to work out the space issues. In the mean time, I need to get this database back on-line, and the Unix soft-link is, I think, the least painful way to get the system up. I'm looking at 18 hours processing, so if you know the soft-link syntax, I'd appreciate knowing it. Thanks.

Author: Linda Hagedorn

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Jun 06 2000 - 05:19:19 CDT

Original text of this message