Problem migrating 7.2.3 to 7.3.3

Problem migrating 7.2.3 to 7.3.3

Post by Uwe Schneide » Sat, 31 Oct 1998 04:00:00



Hi experts,

I am experiencing a prblem while migrating from Oracle server
V 7.2.3 to 7.3.3 (AIX 4):

I have taken the following steps:

- shutdown the old database
- take a full tape backup
- deinstall old software
- install new software

After that I wanted to update the databse objects by invoking orainst
once again. After choosing Update database objects I was never asked
about the former version (which is mentioned in the documentation).
After leaving orainst I wanted to startup the new database server by
invoking svrmgrl (German texts translated):

Quote:> svrmgrl

Oracle Server Manager Release 2.3.3.0.0 - Production

Copyright (c) Oracle Corporation 1994, 1995, 1996. Alle Rechte
vorbehalten.

Oracle7 Server Release 7.3.3.0.0 - Production Release
With the parallel query option
PL/SQL Release 2.3.3.0.0 - Production

SVRMGR> connect internal
Connected to an idle instance.
SVRMGR> startup
ORACLE Instance wurde gestartet.
Total System Global Area      17981816 Byte
Fixed Size                       38988 Byte
Variable Size                 15657260 Byte
Database Buffers               2252800 Byte
Redo Buffers                     32768 Byte
ORA-00205: error in identifying control file
'/oracle/orahome.7.2.3.new/dbs/ctrl1i3v.ctl'
ORA-09782: sfifi: another instance has the same database mounted.
SVRMGR>

You see: I am unable to mount the control files, but I am absolutely
sure to have dismounted the old database.

Any help will be appriceated

Best regards

Uwe

 
 
 

Problem migrating 7.2.3 to 7.3.3

Post by Horace Cho » Sun, 01 Nov 1998 04:00:00


Uwe,

    Try it :

1. shutdown the database with abort option.
2. Go to $ORACLE_HOME/dbs to check whether there is any
'sgadef$ORACLE_SID*' file.  If you find one for your database, try to
remove it manually.
3. Reboot the machine if possible
4. Restart the database again.

    Hope this can help you.

Horace

 
 
 

Problem migrating 7.2.3 to 7.3.3

Post by Uwe Schneide » Sun, 01 Nov 1998 04:00:00



> Uwe,

>     Try it :

> 1. shutdown the database with abort option.
> 2. Go to $ORACLE_HOME/dbs to check whether there is any
> 'sgadef$ORACLE_SID*' file.  If you find one for your database, try to
> remove it manually.
> 3. Reboot the machine if possible
> 4. Restart the database again.

>     Hope this can help you.

> Horace

Hi Horace,

thank you for your aif, but it won't help:
There actually was a sgadef... file, which I removed.
Afterwards I rebooted the server.
But the results remain the same.

Question: What is the role of the "compatibility" variable in the
init...ora?

Deperately

Uwe

 
 
 

Problem migrating 7.2.3 to 7.3.3

Post by Horace Cho » Mon, 02 Nov 1998 04:00:00


Uwe,

    It is better to set the 'compatibility' to the same level of your
software (i.e. 7.3.3).

    Try to shutdown abort the database first (i.e. svrmgrl> shutdown
abort)

    I think there may have an 'rc' command which try to startup the
database when rebooting the system.  Go and check your 'oratab' file and
make sure that the last parameter is 'N'

e.g.

sid:/oracle/home:N

Check it to see whether it help you or not.

Horace

 
 
 

Problem migrating 7.2.3 to 7.3.3

Post by Uwe Schneide » Tue, 03 Nov 1998 04:00:00



> Uwe,

>     It is better to set the 'compatibility' to the same level of your
> software (i.e. 7.3.3).

>     Try to shutdown abort the database first (i.e. svrmgrl> shutdown
> abort)

>     I think there may have an 'rc' command which try to startup the
> database when rebooting the system.  Go and check your 'oratab' file
> and make sure that the last parameter is 'N'

> e.g.

> sid:/oracle/home:N

> Check it to see whether it help you or not.

> Horace

Hi,
in the meantime we have won: Only rebuilding the control files
really helped. Somethin in them must have been corrupt.

BTW: Have you known that byte # 4101 in each data file is the datafile
number under Oracle 7? :-) Try "cmp -l <file1> <file2> | less".

Uwe

--
Uwe Schneider       | Telefon +49 7251 / 82587

DE-76646 Bruchsal   |
Linux - OS al dente!