FAQ
Hi,

We have a file in a database with two slashes in its name:
"/u03//oradbs/abcd/tool_abcd.dbf". I dont know how that file was created,
but I inherited that database. The tablespace is full now. I would like to
resize the file to a bigger size, but resize command fails with

"ORA-01516: nonexistent log file, datafile, or tempfile"

I can add a new file, but I prefer straightening out the name of this
file. Does anyone know how to rename this file properly with just one "/".

Oracle: 10.2 on Solaris 8

Ram.

Search Discussions

  • Saibabu Devabhaktuni at Jul 27, 2006 at 10:06 pm
    It works for me on 8i, if resize doesn't work on 10g,
    atleast rename should work.

    14:56:07 SQL> create tablespace test2 datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' size 100M;

    Tablespace created.

    14:56:37 SQL> select name from v$datafile where name
    like '%//%';

    NAME

    /oracle/TEST//data54/TEST/test2_01.dbf

    14:56:56 SQL> alter database datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' resize 200M;

    Database altered.

    14:57:11 SQL> alter tablespace test2 offline;

    Tablespace altered.

    14:57:21 SQL> alter database rename file
    '/oracle/TEST//data54/TEST/test2_01.dbf'
    14:57:38 2 to
    14:57:40 3 '/oracle/TEST/data54/TEST/test2_01.dbf';

    Database altered.

    Thanks,
    Sai
    http://sai-oracle.blogspot.com

    From: "Ram Raman"
    To: oracle-l_at_xxxxxxxxxxxxx
    Date: Thu, 27 Jul 2006 16:45:14 -0500

    Hi,

    We have a file in a database with two slashes in its
    name:
    "/u03//oradbs/abcd/tool_abcd.dbf". I dont know how
    that file was created,
    but I inherited that database. The tablespace is full
    now. I would like to
    resize the file to a bigger size, but resize command
    fails with

    "ORA-01516: nonexistent log file, datafile, or
    tempfile"

    I can add a new file, but I prefer straightening out
    the name of this
    file. Does anyone know how to rename this file
    properly with just one "/".

    Oracle: 10.2 on Solaris 8

    Ram.

    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com

    --
    http://www.freelists.org/webpage/oracle-l
  • Ram Raman at Jul 27, 2006 at 10:15 pm
    Thanks. It does not work for me:

    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf' to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist

    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf' to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist

    17:13:46 SQL> select FILE_NAME from dba_data_files
    17:13:54 2 where TABLESPACE_NAME = 'TOOLS';

    FILE_NAME

    /u03//oradbs/abcd/tool_abcd.dbf
    On 7/27/06, Saibabu Devabhaktuni wrote:

    It works for me on 8i, if resize doesn't work on 10g,
    atleast rename should work.

    14:56:07 SQL> create tablespace test2 datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' size 100M;

    Tablespace created.

    14:56:37 SQL> select name from v$datafile where name
    like '%//%';

    NAME
    ----------------------------------------------------------------------
    /oracle/TEST//data54/TEST/test2_01.dbf

    14:56:56 SQL> alter database datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' resize 200M;

    Database altered.

    14:57:11 SQL> alter tablespace test2 offline;

    Tablespace altered.

    14:57:21 SQL> alter database rename file
    '/oracle/TEST//data54/TEST/test2_01.dbf'
    14:57:38 2 to
    14:57:40 3 '/oracle/TEST/data54/TEST/test2_01.dbf';

    Database altered.

    Thanks,
    Sai
    http://sai-oracle.blogspot.com

    * From: "Ram Raman"
    * To: oracle-l_at_xxxxxxxxxxxxx
    * Date: Thu, 27 Jul 2006 16:45:14 -0500

    Hi,


    We have a file in a database with two slashes in its
    name:
    "/u03//oradbs/abcd/tool_abcd.dbf". I dont know how
    that file was created,
    but I inherited that database. The tablespace is full
    now. I would like to
    resize the file to a bigger size, but resize command
    fails with


    "ORA-01516: nonexistent log file, datafile, or
    tempfile"


    I can add a new file, but I prefer straightening out
    the name of this
    file. Does anyone know how to rename this file
    properly with just one "/".


    Oracle: 10.2 on Solaris 8


    Ram.


    __________________________________________________
    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com
    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l
  • Zhu,Chao at Jul 29, 2006 at 4:11 am
    use rman to switch name works for all cases. rman copy, offline datafile
    file#, swithc in rman. recover in rmn, online in rman.

    I hit that problem before, rename in sqlplus does not work for my case.
    On 7/28/06, Ram Raman wrote:

    Thanks. It does not work for me:

    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf'
    to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist


    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf'
    to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist





    17:13:46 SQL> select FILE_NAME from dba_data_files
    17:13:54 2 where TABLESPACE_NAME = 'TOOLS';

    FILE_NAME
    --------------------------------------------------------------------------------

    /u03//oradbs/abcd/tool_abcd.dbf


    ----------------------------------------------------


    --
    Regards
    Zhu Chao
    www.cnoug.org
    --
    http://www.freelists.org/webpage/oracle-l
  • Ram Raman at Jul 29, 2006 at 5:14 pm
    Thanks all who replied.

    I was able to increase the size of the file using Alex's approach, but I was
    not able to rename it. I can try Chao's method Monday.
    On 7/28/06, Zhu,Chao wrote:

    use rman to switch name works for all cases. rman copy, offline datafile
    file#, swithc in rman. recover in rmn, online in rman.

    I hit that problem before, rename in sqlplus does not work for my case.

    On 7/28/06, Ram Raman wrote:

    Thanks. It does not work for me:
    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf'
    to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist


    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf'
    to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist





    17:13:46 SQL> select FILE_NAME from dba_data_files
    17:13:54 2 where TABLESPACE_NAME = 'TOOLS';

    FILE_NAME
    --------------------------------------------------------------------------------

    /u03//oradbs/abcd/tool_abcd.dbf


    ----------------------------------------------------


    --
    Regards
    Zhu Chao
    www.cnoug.org

    --
    http://www.freelists.org/webpage/oracle-l
  • Alex Gorbachev at Jul 27, 2006 at 10:12 pm
    hm... perhaps, you can try to use file# instead of the name.

    What's error do you get when renaming a datafile?

    2006/7/27, Ram Raman :
    Hi,

    We have a file in a database with two slashes in its name:
    "/u03//oradbs/abcd/tool_abcd.dbf". I dont know how that
    file was created, but I inherited that database. The tablespace is full now.
    I would like to resize the file to a bigger size, but resize command fails
    with

    "ORA-01516: nonexistent log file, datafile, or tempfile"

    I can add a new file, but I prefer straightening out the name of this file.
    Does anyone know how to rename this file properly with just one "/".

    Oracle: 10.2 on Solaris 8


    Ram.
    --
    Best regards,
    Alex Gorbachev

    http://blog.oracloid.com
    --
    http://www.freelists.org/webpage/oracle-l
  • Saibabu Devabhaktuni at Jul 27, 2006 at 10:37 pm
    Are you sure that there are no hidden characters in
    that filename.

    you may want to run the following query:
    select ':'||file_name||':' from dba_data_files where
    tablespace_name='TOOLS';

    Thanks,
    Sai
    http://sai-oracle.blogspot.com

    From: "Ram Raman"
    To: saibabu_d_at_xxxxxxxxx
    Date: Thu, 27 Jul 2006 17:15:09 -0500

    Thanks. It does not work for me:

    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to
    be renamed does not
    exist

    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to
    be renamed does not
    exist

    17:13:46 SQL> select FILE_NAME from dba_data_files
    17:13:54 2 where TABLESPACE_NAME = 'TOOLS';

    FILE_NAME

    /u03//oradbs/abcd/tool_abcd.dbf

    On 7/27/06, Saibabu Devabhaktuni
    wrote:

    It works for me on 8i, if resize doesn't work on
    10g,

    atleast rename should work.

    14:56:07 SQL> create tablespace test2 datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' size
    100M;

    Tablespace created.

    14:56:37 SQL> select name from v$datafile where
    name

    like '%//%';

    NAME



    /oracle/TEST//data54/TEST/test2_01.dbf

    14:56:56 SQL> alter database datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' resize
    200M;

    Database altered.

    14:57:11 SQL> alter tablespace test2 offline;

    Tablespace altered.

    14:57:21 SQL> alter database rename file
    '/oracle/TEST//data54/TEST/test2_01.dbf'
    14:57:38 2 to
    14:57:40 3
    '/oracle/TEST/data54/TEST/test2_01.dbf';

    Database altered.

    Thanks,
    Sai
    http://sai-oracle.blogspot.com

    From: "Ram Raman"
    To: oracle-l_at_xxxxxxxxxxxxx
    Date: Thu, 27 Jul 2006 16:45:14 -0500

    Hi,

    We have a file in a database with two slashes in
    its

    name:
    "/u03//oradbs/abcd/tool_abcd.dbf". I dont know how
    that file was created,
    but I inherited that database. The tablespace is
    full

    now. I would like to
    resize the file to a bigger size, but resize
    command

    fails with

    "ORA-01516: nonexistent log file, datafile, or
    tempfile"

    I can add a new file, but I prefer straightening
    out

    the name of this
    file. Does anyone know how to rename this file
    properly with just one "/".

    Oracle: 10.2 on Solaris 8

    Ram.

    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam
    protection around

    http://mail.yahoo.com
    --
    http://www.freelists.org/webpage/oracle-l

    References:
    o Re: Resizing a file with two //
    + From: Saibabu Devabhaktuni

    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com

    --
    http://www.freelists.org/webpage/oracle-l
  • Steele, Theresa at Jul 27, 2006 at 11:05 pm
    While in mount mode, move the OS file to the newly name file. And then
    the rename command will work. The message is correct. Until renamed at
    OS level, the file does not exist.

    Theresa Corral-Steele
    Sr. Oracle DBA, MDS I.T. Services, Irvine, CA
    949-450-8345 ext. 415
    949-677-8925 (mobile)

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Saibabu Devabhaktuni
    Sent: Thursday, July 27, 2006 3:37 PM
    To: oracle-l_at_freelists.org
    Subject: Re: Resizing a file with two //

    Are you sure that there are no hidden characters in that filename.

    you may want to run the following query:
    select ':'||file_name||':' from dba_data_files where
    tablespace_name='TOOLS';

    Thanks,
    Sai
    http://sai-oracle.blogspot.com

    From: "Ram Raman"
    To: saibabu_d_at_xxxxxxxxx
    Date: Thu, 27 Jul 2006 17:15:09 -0500

    Thanks. It does not work for me:

    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist

    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist

    17:13:46 SQL> select FILE_NAME from dba_data_files
    17:13:54 2 where TABLESPACE_NAME = 'TOOLS';

    FILE_NAME

    /u03//oradbs/abcd/tool_abcd.dbf

    On 7/27/06, Saibabu Devabhaktuni
    wrote:

    It works for me on 8i, if resize doesn't work on 10g,
    atleast rename should work.

    14:56:07 SQL> create tablespace test2 datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' size 100M;

    Tablespace created.

    14:56:37 SQL> select name from v$datafile where name
    like '%//%';

    NAME



    /oracle/TEST//data54/TEST/test2_01.dbf

    14:56:56 SQL> alter database datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' resize 200M;

    Database altered.

    14:57:11 SQL> alter tablespace test2 offline;

    Tablespace altered.

    14:57:21 SQL> alter database rename file
    '/oracle/TEST//data54/TEST/test2_01.dbf'
    14:57:38 2 to
    14:57:40 3
    '/oracle/TEST/data54/TEST/test2_01.dbf';

    Database altered.

    Thanks,
    Sai
    http://sai-oracle.blogspot.com

    From: "Ram Raman"
    To: oracle-l_at_xxxxxxxxxxxxx
    Date: Thu, 27 Jul 2006 16:45:14 -0500

    Hi,

    We have a file in a database with two slashes in its
    name:
    "/u03//oradbs/abcd/tool_abcd.dbf". I dont know how
    that file was created,
    but I inherited that database. The tablespace is full
    now. I would like to
    resize the file to a bigger size, but resize command
    fails with

    "ORA-01516: nonexistent log file, datafile, or
    tempfile"

    I can add a new file, but I prefer straightening out
    the name of this
    file. Does anyone know how to rename this file
    properly with just one "/".

    Oracle: 10.2 on Solaris 8

    Ram.

    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com
    --
    http://www.freelists.org/webpage/oracle-l

    References:
    o Re: Resizing a file with two //
    + From: Saibabu Devabhaktuni

    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com

    --
    http://www.freelists.org/webpage/oracle-l

    This email and any files transmitted with it may contain privileged or confidential information and may be read or used only by the intended recipient. If you are not the intended recipient of the email or any of its attachments, please be advised that you have received this email in error and any use, dissemination, distribution, forwarding, printing or copying of this email or any attached files is strictly prohibited. If you have received this email in error, please immediately purge it and all attachments and notify the sender by reply email or contact the sender at the number listed.
    --
    http://www.freelists.org/webpage/oracle-l
  • Steele, Theresa at Jul 27, 2006 at 11:24 pm
    Before you do the rename command, do :

    1-shutdown immediate
    2-startup mount
    3-move the file at the OS level to what you want the new name to be <
    must be in mount mode>>
    4-then issue "alter database rename file "/u03//..." to "/u03/...";



    Theresa Corral-Steele
    Sr. Oracle DBA, MDS I.T. Services, Irvine, CA
    949-450-8345 ext. 415
    949-677-8925 (mobile)


    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Ram Raman
    Sent: Thursday, July 27, 2006 3:15 PM
    To: saibabu_d_at_yahoo.com
    Cc: oracle-l_at_freelists.org
    Subject: Re: Resizing a file with two //

    Thanks. It does not work for me:


    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf'
    to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist


    16:57:29 SQL> alter tablespace TOOLS rename datafile
    '/u03//oradbs/abcd/tool_abcd.dbf' to
    17:08:51 2 '/u03/oradbs/abcd/tool_abcd.dbf';
    alter tablespace TOOLS rename datafile '/u03//oradbs/abcd/tool_abcd.dbf'
    to
    *
    ERROR at line 1:
    ORA-01525: error in renaming data files
    ORA-01522: file '/u03//oradbs/abcd/tool_abcd.dbf' to be renamed does not
    exist





    17:13:46 SQL> select FILE_NAME from dba_data_files
    17:13:54 2 where TABLESPACE_NAME = 'TOOLS';

    FILE_NAME

    /u03//oradbs/abcd/tool_abcd.dbf





    On 7/27/06, Saibabu Devabhaktuni wrote:

    It works for me on 8i, if resize doesn't work on 10g,
    atleast rename should work.

    14:56:07 SQL> create tablespace test2 datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' size 100M;

    Tablespace created.

    14:56:37 SQL> select name from v$datafile where name
    like '%//%';

    NAME

    ----------------------------------------------------------------------
    /oracle/TEST//data54/TEST/test2_01.dbf

    14:56:56 SQL> alter database datafile
    '/oracle/TEST//data54/TEST/test2_01.dbf' resize 200M;

    Database altered.

    14:57:11 SQL> alter tablespace test2 offline;

    Tablespace altered.

    14:57:21 SQL> alter database rename file
    '/oracle/TEST//data54/TEST/test2_01.dbf'
    14:57:38 2 to
    14:57:40 3 '/oracle/TEST/data54/TEST/test2_01.dbf';

    Database altered.

    Thanks,
    Sai
    http://sai-oracle.blogspot.com

    * From: "Ram Raman"
    * To: oracle-l_at_xxxxxxxxxxxxx
    * Date: Thu, 27 Jul 2006 16:45:14 -0500

    Hi,

    We have a file in a database with two slashes in its
    name:
    "/u03//oradbs/abcd/tool_abcd.dbf". I dont know how
    that file was created,
    but I inherited that database. The tablespace is full
    now. I would like to
    resize the file to a bigger size, but resize command
    fails with

    "ORA-01516: nonexistent log file, datafile, or
    tempfile"

    I can add a new file, but I prefer straightening out
    the name of this
    file. Does anyone know how to rename this file
    properly with just one "/".

    Oracle: 10.2 on Solaris 8

    Ram.

    __________________________________________________
    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com
    --
    http://www.freelists.org/webpage/oracle-l

    This email and any files transmitted with it may contain privileged or confidential information and may be read or used only by the intended recipient. If you are not the intended recipient of the email or any of its attachments, please be advised that you have received this email in error and any use, dissemination, distribution, forwarding, printing or copying of this email or any attached files is strictly prohibited. If you have received this email in error, please immediately purge it and all attachments and notify the sender by reply email or contact the sender at the number listed.

    This email and any files transmitted with it may contain privileged or confidential information and may be read or used only by the intended recipient. If you are not the intended recipient of the email or any of its attachments, please be advised that you have received this email in error and any use, dissemination, distribution, forwarding, printing or copying of this email or any attached files is strictly prohibited. If you have received this email in error, please immediately purge it and all attachments and notify the sender by reply email or contact the sender at the number listed.

    --
    http://www.freelists.org/webpage/oracle-l
  • David Sharples at Jul 27, 2006 at 11:28 pm
    no need for steps 1 and 2 - just take the tablespace offline
    On 28/07/06, Steele, Theresa wrote:

    Before you do the rename command, do :
    1-shutdown immediate
    2-startup mount
    3-move the file at the OS level to what you want the new name to be < must be in mount mode>>
    4-then issue "alter database rename file "/u03//..." to "/u03/...";
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 27, '06 at 9:45p
activeJul 29, '06 at 5:14p
posts10
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase