The system don't goes up after Upgrade to 10g

[Former Member]

Hello friends. After a Oracle upgrade of 9i to 10g (Windows 2003 / Basis Release 46D). The system SAP R/3 4.6C don't goes up. A follow message is the error in file "dev_w0":

Now I'm connected to ORACLE

C Database instance prd is running on SAPUPG with ORACLE version 10.2.0.2.0 since 20070612

B Connection 0 opened

B Wp Hdl ConName ConCnt ConState TX PRM RCT Date Time

B 000 000 R/3 000000 ACTIVE NO YES NO 20070613 100955

B ***LOG BZA=> table SVERS doesn't exist on database [dblink 2056 ]

To understand the problem I run the follow command into "sqlplus":

SQL> select * from svers;

select * from svers

*

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> select * from sapr3.svers;

VERSION

-

---

46C

Please take special attention to this point: When the execution it's was made indicating a DBSCHEMA plus table (sapr3.svers) the command it's succesfull, otherwise fail's. If I logon with user: "SYSTEM" it's the same result.

Thank's to everyone for help me and understand my very bad english.

Best regards.

Xavier Pol

[Former Member]

Was upgrade completely successful?

Check this note - Note 830576 - Parameter recommendations for Oracle 10g

[Former Member]

I have seen this one time before.

Just ensure that.

1. Oracle 9.2 is not longer part of the environment variable path

2. you have updated the Oracle instance client to the newest version available on SMP (10.2.0.2.5). See note 998004 for details

3. shutdown your database, restart the Windows Service OracleServiceUPG

4. try it again

regards

Peter

[Former Member]

now I remember back the details.

can you please post the result of

select * from V$nls_parameters;

regards

Peter

[Former Member]

Hi Peter,

I am getting the table SVERS is not in the database. I have made a system copy from BOS to WS1 sid. Now in WS1, there is no schema( I have checked through the EM). I tried lots of checks, no use.

I have then check the command

select * from SAPBOS.SVERS and it worked. As I have copied the database ( OS files ) from BOS server. Now I want it to be WS1. How it is possible

The table owner( note 400241) shows me SAPBOS. I want it to be SAPWS1?

How is it posssible, because of that I cannot login through SAP. Oracle is up.

Please suggest..

[fidel_vales]

Hi,

It looks like you have some "wrong" concepts.

First you say that:

<b>Now in WS1, there is no schema</b>

later on you are telling

<b>have then check the command

select * from SAPBOS.SVERS and it worked.</b>

So, do you have a schema or don't you?

Let me try to understand what you have done, for your description

1) you have a system called BOS. On this system you have a schema called SAPBOS.

2) you did a system copy from BOS to W1S. Guessing -> You did a restore from a BOS

Now your SAPW1S has "dissapeared"

am I understandin it properly?

If so, you should think a little.

You have restored a backup from BOS ( DB name BOS, SCHEMA BOS, tablespace names PSAPBOS ) into W1S

Restoring a backup will not change the schema name ( AFAIK, there is no simple way of doing so )

Restoring a backup will not change the tablespaces names ( in Oracle 10g you can do this, but has to be done manually )

Restoring the backup will not change the DB name. The System copy procedure ask you to create a script that will perform this last change.

So, at the end of the process you have a DB called W1S, with a schema called SAPBOS and tablespaces called PSAPBOS.

As mentioned before there is no simple way of changing the schema name.

If you <b>need/want/desire</b> to do so then you cannot use BACKUP/RESTORE for system copies. You must use the R3Load method ( take all data out of the DB and then take all the data in on the new system )

[Former Member]

Hi Xavier,

can you post the result of "R3trans -d" (file trans.log) and "set", both started as <sid>adm?

Best regards,

Elmar.