4.7 Enterprise install error in catproc.sql phase(RedHat5- Oracle 10.2.0.4)

[Former Member]

Hi,

I am installing SAP 4.7 Enterprise on Red Hat 5.3 and Oracle 10.2.0.4. When I install 4.7 Enterpirse I have an error in catproc.sql phase like below: -

---

ERROR 2009-06-02 18:42:34

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-955 for defaultdestSQL> Rem bnainani 11/29/00 - specify compatible=8.0 for create_queue_tableSQL> Rem liwong 10/20/00 - add def$_destination.flagSQL> Rem bnainani 11/15/00 - specify compatible=8.0 for queue tableSQL> Rem narora 09/13/00 - add comment on new def$_destination columnsSQL> Rem liwong 09/01/00 - add master w/o quiesce: fixesSQL> Rem liwong 07/12/00 - add total_prop_time_latSQL> Rem liwong 06/29/00 - add total_txn_count, total_prop_timeSQL> Rem liwong 05/17/00 - add_master_db w/o quiesceSQL> Rem jstamos 05/17/00 - add_master_db w/o quiesceSQL> Rem elu 01/24/00 - add column apply_init to def$_destinationSQL> Rem alakshmi 12/02/99 - Bug 979398: Before-row insert trigger onSQL> Rem def$_propagatorSQL> Rem wesmith 10/31/98 - change shape of table def$_pushed_transactionsSQL> Rem jnath 02/23/98 - bug 601972: split anonymous pl/sql blocksSQL> Rem wesmith 01/21/98 - create def$_pushed_transactions table forSQL> Rem server-side RepAPISQL> Rem nbhatt 07/27/97 - change create_queuetable -> create_queue_tableSQL> Rem nbhatt 04/21/97 - change 'TRACKING' in CREATE_QUEUE to 'DEPENDENCYSQL> Rem nbhatt 04/21/97 - change syntax of create_queueSQL> Rem liwong 04/16/97 - Alter view system.AQ$DEF$_AQ{CALL,ERROR}SQL> Rem liwong 04/11/97 - Fixing defaultdest_primary typoSQL> Rem jstamos 04/10/97 - remove unneeded indexesSQL> Rem nbhatt 04/08/97 - change create_qtable to create_queuetableSQL> Rem jstamos 04/04/97 - tighter AQ integrationSQL> Rem liwong 04/02/97 - Add schema_name, package_name in def$_calldestSQL> Rem ato 03/31/97 - create_qtable interface changeSQL> Rem liwong 03/25/97 - remove batch_no from def$_tranorderSQL> Rem liwong 02/24/97 - pctversion --> 0 for def$_aqcall, def$_aqerrorSQL> Rem liwong 02/22/97 - Remove dropping view aq$def$_aqcallSQL> Rem ademers 02/07/97 - Remove constraint def$_calldest_callSQL> Rem liwong 01/11/97 - drop and create aq$def$_aqcall (temporary)SQL> Rem liwong 01/10/97 - Alter view aq$def$_aqcallSQL> Rem liwong 01/07/97 - Alter default value for batch_noSQL> Rem jstamos 12/23/96 - change temp$nclob colSQL> Rem jstamos 11/21/96 - nchar supportSQL> Rem sjain 11/11/96 - Remove dummy buffer # commentSQL> Rem asgoel 11/05/96 - Disable misc_tracking in def$_aqerrorSQL> Rem sjain 11/06/96 - deferror changesSQL> Rem vkrishna 10/28/96 - change STORED IN to STORE AS for lobSQL> Rem sjain 10/02/96 - Aq conversionSQL> Rem sbalaram 09/24/96 - ARPC performance - add foreign key indexSQL> Rem jstamos 09/06/96 - rename temp$lob and temporarily change nclobSQL> Rem sjain 09/03/96 - AQ conversonSQL> Rem ademers 08/02/96 - queue_batch default in def_destinationSQL> Rem ademers 07/29/96 - queue_batch default in def_callSQL> Rem ademers 07/29/96 - queue_batch defaultSQL> Rem jstamos 07/24/96 - add system.temp$lobSQL> Rem sbalaram 07/22/96 - create def$_aqcall and def$_aqerror tablesSQL> Rem jstamos 06/12/96 - LOB support for deferred RPCsSQL> Rem ldoo 06/28/96 - Comment out queue_table from def_tranorderSQL> Rem ademers 05/30/96 - create def_originSQL> Rem ademers 05/28/96 - fix def_destination col namesSQL> Rem ldoo 05/09/96 - New security modelSQL> Rem sjain 05/01/96 - add seq col to def_destinationSQL> Rem ademers 04/29/96 - add batch_no, dep_scn to def_callSQL> Rem jstamos 12/04/95 - 324303: use index to avoid sorting the queueSQL> Rem jstamos 08/17/95 - code review changesSQL> Rem jstamos 08/16/95 - add comments to tablesSQL> Rem wmaimone 01/04/96 - 7.3 mergeSQL> Rem hasun 01/31/95 - Modify tables.<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

Also some error lines in ora_sql_results.log file like below:

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Disconnected

-

---

DOC> The following statement will cause an "ORA-01722: invalid number"

DOC> error and terminate the SQLPLUS session if the user is not SYS.

DOC> Disconnect and reconnect with AS SYSDBA.

-

---

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

-

---

ERROR at line 1:

ORA-00942: table or view does not exist

-

---

DOC> The following PL/SQL block will cause an ORA-20000 error and

DOC> terminate the current SQLPLUS session if the user is not SYS.

DOC> Disconnect and reconnect with AS SYSDBA.

-

---

ERROR at line 1:

ORA-01921: role name 'EXP_FULL_DATABASE' conflicts with another user or role

name

-

---

ERROR at line 1:

ORA-01434: private synonym to be dropped does not exist

-

---

ERROR at line 1:

ORA-04043: object DIANA does not exist

-

---

ERROR at line 1:

ORA-04043: object DIUTIL does not exist

-

---

ERROR at line 1:

ORA-04043: object DIUTIL does not exist

-

---

ERROR at line 1:

ORA-04043: object SUBPTXT2 does not exist

-

---

ERROR at line 1:

ORA-04043: object CREATE_TABLE_COST_COLUMNS does not exist

-

---

ERROR at line 1:

ORA-01434: private synonym to be dropped does not exist

-

---

########################################################################################

And ora_sql.log file is:

connect / as sysdba ;

SHUTDOWN ABORT;

exit;

Executed successfully.

connect / as sysdba ;

SHUTDOWN IMMEDIATE;

exit;

Executed with error.

connect / as sysdba ;

STARTUP NOMOUNT;

exit;

Executed successfully.

connect / as sysdba ;

CREATE DATABASE MDP CONTROLFILE REUSE MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE '/oracle/MDP/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '/oracle/MDP/sapdata1/temp_1/temp.data1' SIZE 1750M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/MDP/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE '/oracle/MDP/sapdata1/sysaux_1/sysaux.data1' SIZE 1000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

LOGFILE GROUP 1 ('/oracle/MDP/origlogA/log_g11m1.dbf',

'/oracle/MDP/mirrlogA/log_g11m2.dbf') SIZE 50M REUSE ,

GROUP 2 ('/oracle/MDP/origlogB/log_g12m1.dbf',

'/oracle/MDP/mirrlogB/log_g12m2.dbf') SIZE 50M REUSE ,

GROUP 3 ('/oracle/MDP/origlogA/log_g13m1.dbf',

'/oracle/MDP/mirrlogA/log_g13m2.dbf') SIZE 50M REUSE ,

GROUP 4 ('/oracle/MDP/origlogB/log_g14m1.dbf',

'/oracle/MDP/mirrlogB/log_g14m2.dbf') SIZE 50M REUSE

;

exit;

Executed successfully.

connect / as sysdba ;

set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Executed successfully.

connect / as sysdba ;

@@/oracle/MDP/102_64/rdbms/admin/catalog.sql

exit;

Executed successfully.

connect / as sysdba ;

set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Executed successfully.

connect / as sysdba ;

@@/oracle/MDP/102_64/rdbms/admin/catblock.sql

exit;

Executed successfully.

connect / as sysdba ;

set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Executed successfully.

connect / as sysdba ;

@@/oracle/MDP/102_64/rdbms/admin/catproc.sql

exit;

Executed with error.

connect / as sysdba ;

set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Executed successfully.

connect / as sysdba ;

@@/oracle/MDP/102_64/rdbms/admin/catproc.sql

exit;

Executed with error.

connect / as sysdba ;

set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Executed successfully.

connect / as sysdba ;

@@/oracle/MDP/102_64/rdbms/admin/catproc.sql

exit;

Executed with error.

connect / as sysdba ;

set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Executed successfully.

connect / as sysdba ;

@@/oracle/MDP/102_64/rdbms/admin/catproc.sql

exit;

Executed with error.

connect / as sysdba ;

set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Executed successfully.

connect / as sysdba ;

@@/oracle/MDP/102_64/rdbms/admin/catproc.sql

exit;

Executed with error.

#######################################################################################

The errors are like these. How can I correct these errors and continue to installation? Is the oracle version 10.2.0.4 not correct version to install 4.7 enterprise on Red Hat Linux 5.3?

Best regards,

[Former Member · Accepted solution]

Hi,

I found a sap note about these oracle errors (Sap Note: 582427). It says that if you have these oracle error you can ignore it. But I cannot continue to installation. How can I ignor these error and continue to installation?

Best regards,

[markus_doehr2 · Accepted solution]

If you use sapinst to install the 4.7 version you can try:

- close sapinst

- step to the installation directory

- open the file "keydb.xml" with an editor

- search for ERROR (in capitals)

- change the value to OK

- save and exit

- start sapinst and "continue with old installation"

Markus

[Former Member · Accepted solution]

Hi Markus,

I found 5 ERROR. There are different lines.

First one:

<fld name="STATUS">

<strval><![CDATA[ERROR]]>

Second one:

CASE (= 'AUTOALLOCATE') RETURN (' AUTOALLOCATE '),

CASE (DEFAULT) RETURN (' ERROR ' + (tTablespaces.extMgmtAllocMode

Third one:

CASE (= 'DICTIONARY') RETURN (' DICTIONARY '),

CASE (DEFAULT) RETURN (' ERROR ' + (tTablespaces.extMgmtMode

Fourth one:

CASE (= 'AUTOALLOCATE') RETURN (' AUTOALLOCATE '),

CASE (DEFAULT) RETURN (' ERROR ' + (tTablespaces.extMgmtAllocMode

Fifth one:

CASE (= 'DICTIONARY') RETURN (' DICTIONARY '),

CASE (DEFAULT) RETURN (' ERROR ' + (tTablespaces.extMgmtMode

Which one will I change to OK? Must all off them change to OK?

Also is this problem about only these oracle error in your oppinion? For example in first line of ora_sql_results.log I have an error like below:

CJS-00084 SQL statement or script failed

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

But ORACLE_HOME and ORACLE_SID environment variable are ok. Also I can connect and start and stop database manually. There is no problem about it.

I installed anly Oracle patch 10.2.0.4. I didn't install any oracle interim patch. Should I have install oracle interim patch for Oracle 10.2.0.4?

Best regards,

[markus_doehr2 · Accepted solution]

> <fld name="STATUS">

> <strval><![CDATA[ERROR]]>

This is the one you that should be changed. Leave all others since they are syntactical.

>

> Also is this problem about only these oracle error in your oppinion? For example in first line of ora_sql_results.log I have an error like below:

>

> CJS-00084 SQL statement or script failed

> Connected to an idle instance.

> ORA-01034: ORACLE not available

> ORA-27101: shared memory realm does not exist

This is normal since sapinst tries to stop/start the database at each step to find out if it's started.

> I installed anly Oracle patch 10.2.0.4. I didn't install any oracle interim patch. Should I have install oracle interim patch for Oracle 10.2.0.4?

Yes.

If you read the installation guide you will see that all interim patches should be installed before continuing with the installation.

Markus

[Former Member · Accepted solution]

Hi Markus,

I changed ERROR to OK and I am continueing to installation now. If I have any oracle database problem I will install all interim patches.

Thank you very much for your help again.

[Former Member]

Same error during System Copy - Target - DB Instance (R3 4.7 - Windows 2003 x64 Oracle - Non Unicode)

Markus' tip applied and sapinst "Create Database" phase passed Ok. Thank you.

Javier Gambino