SAPINST error

[Former Member]

Hi,

I am installing SAP Netweaver 2004 Support Release 1

in Sun Solaris 10 and Oracle 9.2.0.1.0.

Sapinst installed CI fine, without any issue at all.

While installing DB instance, it runs fine until error happens while creating the views in the DB. (SAPVIEW.TSK)

Everything goes smooth and installs the DB and starts the DB fine. After all the tablespace creation and at the end of the Oracle Load phase. At that phase, it gives the error while it is doing the SAPVIEW. SAPVIEW.TSK has the "err" for V_DD03 view creation. -

I traced the error and tried the command in the oracle sqlplus directly and find that it fails as well - it could most probably an error - in the syntax. (SAP failed for table not present - but I can see the table at the oracle level).

Just thought would bounce this in the forum and see if anyone has any suggestions?.

Of course, I tried this in few forums but could not find any solution yet.

SQL>

1 CREATE VIEW "/SAPTRX/V_DD03" ( "TRK_OBJ_TYPE" , "TABLEDEF" , "TABNAME"

2 , "FIELDNAME" , "AS4LOCAL" , "DDLANGUAGE" , "DDTEXT" )

3 AS SELECT T0004."TRK_OBJ_TYPE",

4 T0004."TABLEDEF", T0001."TABNAME", T0001."FIELDNAME", T0001."AS4LOCAL",

5 T0003."DDLANGUAGE", T0003."DDTEXT" FROM "DD03L" T0001, "DD04L" T0002, "DD04T"

6 T0003, "/SAPTRX/AOALLTAB" T0004

7 WHERE T0004."DDICDEF" = T0001."TABNAME" AND

8* T0002."ROLLNAME" = T0001."ROLLNAME" AND T0002."ROLLNAME" = T0003."ROLLNAME"

SQL> /

T0003, "/SAPTRX/AOALLTAB" T0004

*

ERROR at line 6:

ORA-00942: table or view does not exist

SQL>

-

---

To verify - I checked if the table exists - I ran this sqlplus command - here is the output.

SQL> select owner, table_name from all_tables

2 where table_name like '%AOALLTAB%';

OWNER TABLE_NAME

-

---

-

---

SAPBAC /SAPTRX/AOALLTAB

SQL>

Would appreciate any help!. Thanks a lot in advance.

Venkat V

[Former Member]

Hi,

I have the same problem

Could you correct it? How?

Many thanks!!!!!!

[Former Member]

Which platform you are installing this?,

During the db installation phase -

I hope you are installing the oracle using the SAP script (under the SAP directory) instead of the oracle's "runInstaller". Let me know.

thanks,

VenkatV

[Former Member]

Hi Venkat,

Kindly check Note 662644, if it helps.

Regards

Srikishan