table SVERS does not exist

[Former Member]

Hi All,

I am attempting a re-install of SAP 4.6D kernel and Oracle 8.1.7 after tables were created under wrong schema. Now that, that is sorted out I am running into a few issues with DBPRELOAD_IND_ORA when creating the database using r3setup. It attempts to run the oradbuser.sql file and problems seem to start from there on.

oradbuser.sql runs here......

using following Parameters:

.

. Oracle SID: <SID>

. Oracle Version: 8.1.7.4.0

. Parametervalue os_authent_prefix: OPS$

. Database User (Schema): SAPR3

. SAP R/3 Administrator: OPS$<SID>ADM

.

Error accessing PRODUCT_USER_PROFILE

Warning: Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM

it then starts the oracle listener successfully...

tests the database connection...

gives the error message below

db_con_connect (con_name=R/3)

find_con found the following connection for reuse:

Thu Oct 18 16:07:10 2007

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

INFO 2007-10-18 16:07:10

Creating Data Dictionary Synonyms for R/3

with a return code of 1078, which is somthing to do with the init.ora file???

ERROR 2007-10-18 16:07:27 DBPRELOAD_IND_ORA InternalInstallationDo:0

SvrmgrDo: Phase failed.

ERROR 2007-10-18 16:07:27 DBPRELOAD_IND_ORA InternalInstallationDo:0

Startup Database with error: 1078.

ERROR 2007-10-18 16:07:27 DBPRELOAD_IND_ORA InstallationDo:0

Phase failed.

ERROR 2007-10-18 16:07:28 Main

Installation aborted.

your help is much appreciated

Mani

[Former Member · Accepted solution]

Mani,

What does your Oracle alert log tell you? (/oracle/SRD/saptrace/background -> alert_SID.log) Does it tell you which parameter is causing issues? Maybe a more usable ORA error code?

At a quick glance, it looks like it's not finding the SID of the system. What does your initSID.ora file look like? If this is UNIX, is it a permissions issue?

Cheers,

Tim