Re: Oracle for OS/2

In <3uitdp$5qq_at_gryphon.phoenix.net>, chacon_at_houvmscc.lsis.loral.com (Raul R. Chacon) writes:
>I recently posted an append asking for help on changing the directory
>references for all *.ORA files. I received plenty of help and answers to
>which I am very thankful. One of the answers stated the following procedure:
>
>SQLDBA> connect internal
>SQLDBA> startup mount exclusive
>SQLDBA> alter database rename file 'd:\oraos2\....' to 'e:\oraos2\.....';
>SQLDBA> shutdown
>SQLDBA> exit
>
>I attempted to do just that, except the ALTER DATABASE... command gave me the
>following errors:
>
>
>>alter database rename file 'd:\oraos2\rdbms70\control1.ora' to
>'e:\oraos2\rdbms70\control1.ora';
>DBA-00342: unable to complete internal login
>ORA-00600: internal error code, arguments: [901], [138], [6], [1], [], [], []
>
>I then shutdown the SQLDBA app and restarted it to which I received the
>following (different) error:
>
>>alter database rename file 'd:\oraos2\rdbms70\control1.ora' to
>'e:\oraos2\rdbms70\control1.ora';
>ORA-01511: error in renaming log/data files
>ORA-01516: nonexistent log/data file 'd:\oraos2\rdbms70\control1.ora'
>
>I performed a directory search and this is what I found:
>
>[D:\oraos2\rdbms70]dir *.ora
>
>The volume label in drive D is WORKGROUPI.
>The Volume Serial Number is E698:5C14.
>Directory of D:\oraos2\rdbms70
>
> 7-17-95 2:13p 159232 0 CONTROL1.ORA
> 2-26-93 12:09p 256 0 DBAINI.ORA
> 7-17-95 2:13p 8389120 0 DBS1.ORA
> 6-01-93 10:50a 1743 35 INIT.ORA
> 7-17-95 2:12p 205312 0 LOG1.ORA
> 7-17-95 2:12p 205312 0 LOG2.ORA
> 6 file(s) 8960975 bytes used
> 277078528 bytes free
>
>[D:\oraos2\rdbms70]
>
>From this, I can see that CONTROL1.ORA and the rest of the *.ORA files DO
>exist. So, what else could be causing these error messages. I am performing
>this commands at the server console, not remotely.
>
>Thanks,
>
>Raul
>

Oooops... my mistake... I forgot 1 important piece of info...

You don't have to rename the control file [CONTROL1.ORA]. Just copy the

   control file to the new location.

Then, if you use sql*dba to startup the database normally, all should be fine   since the default location for the control file is %RDBMS70%\control1.ora,   where RDBMS70=xxxxx in \oraos2\xbin\config.ora. If you are using Database Manager to startup the database, you should again be   OK as long as control1.ora is in the default place [%RDBMS70%\control1.ora].

For your reference, if control1.ora isn't in the default place you can point   to it from SQL*DBA by adding "control_files = (e:\oraos2\....\control1.ora)"   to \oraos2\rdbms70\init.ora.
In Database Manager, you go into Parameters -> Advanced, and change   CONTROL_FILES to point to your control file.

So, point all config.ora entries to e:, copy all the files to   e:\oraos2\rdbms70, then do 'alter database...' only on dbs1.ora, log1.ora,   and log2.ora. Don't do init.ora or dbaini.ora, since they aren't datafiles   or logfiles.

Sorry for the confusion.

Dave Colello
dcolello_at_oracle.com

The views expressed here are my own and not my employer's. Received on Thu Jul 20 1995 - 00:00:00 CEST