local client copy error

[Former Member]

Dear Team,

When I am going local client copy .after some time its terminate and when I check in system log

it give below error

SQL error 3114 . Work processes in reconnect st

> Include ??? line 0000.

Run-time error "DBIF_REPO_SQL_ERROR" occurred

> Include ??? line 0000.

Run-time error "DBIF_REPO_SQL_ERROR" occurred

> Include ??? line 0000.

Run-time error "DBIF_REPO_SQL_ERROR" occurred

> Include ??? line 0000.

Run-time error "DBIF_REPO_SQL_ERROR" occurred

> Include ??? line 0000.

Run-time error "DBIF_REPO_SQL_ERROR" occurred

> Include ??? line 0000.

Run-time error "DBIF_REPO_SQL_ERROR" occurred

> Include ??? line 0000.

Run-time error "DBIF_REPO_SQL_ERROR" occurred

> Include ??? line 0000.

Operating system call recv failed (error no. 10054)

Database error 3108 at SEL access to table D342L

> ORA-03108: oranet: ORACLE does not support this interface

> version

Transaction Canceled 00 951 ( 3108 )

SQL error 3106 . Work processes in reconnect status

Start Workproc 1, Pid 6072

RSRZLLG0 canceled due to timeout

SQL error 3113 occurred (possible network problems?). Work process is stop

Database error 3113 at CON

> ORA-03113: end-of-file on communication channel

Initialization DB-Connect Failed, Return Code 000256

regard

[former_member189546 · Accepted solution]

Hello,

The note 871096 states that :

"Prerequisites for using Oracle Release 10.2 in the SAP

environment are:

- Oracle patch set 10.2.0.2

- Patches in accordance with this note"

Please check these pataches are applied

regards,

John Feely

[Former Member · Accepted solution]

Dear ,

when i upgrading Oracle patch from 10.1 to 10.2 .

After upgrading path , when i start oracle

SQL> startup

ORACLE instance started.

Total System Global Area 356515840 bytes

Fixed Size 1289448 bytes

Variable Size 188744472 bytes

Database Buffers 163577856 bytes

Redo Buffers 2904064 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

SQL>

How i start oracle now

[former_member204746 · Accepted solution]

read the upgrade guide, it will ask you to run a few SQL scripts to upgrade the database contents.

[Former Member · Accepted solution]

Dear

I Have upgrade sucessfull my Oracle patch 10.2.0.2 .

But when i run again SPAM . Its stuck in Imp all.

Then I check Action Log

It show yellow color.

Import phase 'CHECK_REQUIREMENTS' (14.06.2010, 16:01:36)

Interrupt the import due to an error situation (14.06.2010, 16:01:37)

The warning about open V3 update and data extraction requests was ignored

Now what-2 i should check and what activity i will do now

Regards

[former_member204746 · Accepted solution]

suniljoshi,

do these steps.

1. close this message here

2. open a brand new one with this newer info.

your last message has complete new problem. it should be on its own topic.

[Former Member]

What is your DB and OS and what version of SAP you are using. Its due to RSRZLLG0 report and its used for Load balancing. Pls try to re-build the stats for your table D342L.

Also, try to run in test-mode first and do it in real mode. Let me know if you face issue ..

[markus_doehr2]

> Run-time error "DBIF_REPO_SQL_ERROR" occurred

it seems your database crashed (or the shadow processes) .

Check the oracle alert_<SID>.log.

Markus

[Former Member]

I check my Alert log

I am using ECC 6.0 with Oracle 10

Successful open of redo thread 1

Mon Jun 14 14:50:01 2010

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Mon Jun 14 14:50:01 2010

ARC0: STARTING ARCH PROCESSES

Mon Jun 14 14:50:01 2010

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no SRL' ARCH

Mon Jun 14 14:50:01 2010

ARC2: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

ARC0: Becoming the heartbeat ARCH

ARC2 started with pid=16, OS id=2336

Mon Jun 14 14:50:02 2010

SMON: enabling cache recovery

Mon Jun 14 14:50:03 2010

Incremental checkpoint up to RBA [0x9c6.3.0], current log tail at RBA [0x9c6.3.0]

Mon Jun 14 14:50:04 2010

Successfully onlined Undo Tablespace 1.

Mon Jun 14 14:50:04 2010

SMON: enabling tx recovery

Mon Jun 14 14:50:04 2010

Database Characterset is UTF8

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=17, OS id=2340

Mon Jun 14 14:50:09 2010

Completed: ALTER DATABASE OPEN

Mon Jun 14 14:55:04 2010

Shutting down archive processes

Mon Jun 14 14:55:09 2010

ARCH shutting down

ARC2: Archival stopped

Mon Jun 14 15:20:49 2010

Incremental checkpoint up to RBA [0x9c6.a472.0], current log tail at RBA [0x9c6.a57c.0]

Mon Jun 14 15:50:55 2010

Incremental checkpoint up to RBA [0x9c6.10c90.0], current log tail at RBA [0x9c6.1156f.0]

Mon Jun 14 16:20:59 2010

Incremental checkpoint up to RBA [0x9c6.12a73.0], current log tail at RBA [0x9c6.12a9c.0]

Mon Jun 14 16:51:01 2010

Incremental checkpoint up to RBA [0x9c6.12c2d.0], current log tail at RBA [0x9c6.12c68.0]

Regards

[markus_doehr2]

> I check my Alert log

> Completed: ALTER DATABASE OPEN

Did you check immediately after that crash happened? Seems the database was restarted since that error happened.

Markus