ABAP Import stuck for last two jobs

[Former Member]

Hi,

I am installing SAP IDES on Win Server 2003 with Oracle 10.2 and patch to h 10.2.0.4.

I am stuck at last two jobs in ABAP import step.

I have set 4 jobs to execute in parallel but in the end there was 1 running and 1 waiting for almost 6 hours and I kept monitoring disk size and found no difference. I have finally stopped the installation.

After restarting server I get error that SAP can't connect to Oracle, In short log appear as

<<

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

>>

Oracle listener is up and running and yes listener doesn't start automatically but needs manual start in from services

These last steps were running for long time and I suspect issue with oracle db space.

Can any one please guide how to proceed further?

Thanks,

Rahul.

[former_member182657 · Accepted solution]

Hi Rahul,

I have set 4 jobs to execute in parallel but in the end there was 1 running and 1 waiting for almost 6 hours and I kept monitoring disk size and found no difference. I have finally stopped the installation.

SAP means patience,before stopping you need to find out the exact issues & possible solutions for it.Anyways i would recommend first restart your complete system & then start it by listener services with database startup, as error 1034 generally comes when DB is not in functional states (In Down state).

After startup confirmation of DB try to restart the process again to complete the failure jobs in previous,if possible try to monitor sapinst_dev.log file & the process which would be under executions phase (last which failed or stopped by you ).

If still you experiences the issue you could share sapinst_dev.log ,failure job log ,trans.log file,which i don't think you'll need to share.

Hope this will help you.

Good luck !!

[Former Member · Accepted solution]

Hi Gaurav,

Appreciate your prompt response.

So PSAPSR3 tablespace is ok?

Rahul

[Former Member · Accepted solution]

Hello Rahul,

Is the issue resolved and also provide us wit the latest logs in the sapinst directory so that we can help you more on this.

regards,

Ram

[Former Member · Accepted solution]

Hi,

Not yet finished. Now I see duplicate task files which I will merge and restart the installation.

BR, Rahul

[former_member182657]

Have you tried the recommendations or steps suggested under previously shared SCN thread by me ? Could you share results after login with <sid>adm user at OS & then execution of command brtools from cmd ?

[Former Member]

Something is wrong with oracle.

It is not starting up even when all services are running up.

I tried many ways suggested in different threads to awake oracle but probably oracle doesn't want to.

unless oracle is up I can't perform the next steps.

[former_member182657]

Please share alert_<SID>.log file for analysis from the system.

[Former Member]

Hi Rahul,

What error it shows up when you do startup.

Let the beast of oracle be awaken .

Regards,

Ram

[former_member182657]

Hi Rahul,

You could refer SCN doc at

If possible could you share requested files specially the last process on which you stopped the process.

Regards,

[Former Member]

Hi,

This is on linux.

I need on windows.

Thanks,

Rahul.

[former_member182657]

Hi,

Follow SCN thread at

Regards,

[Former Member]

Hi Rahul,

The brtools will work for Linux as well so you need to follow up the same options as mentioned in the thread provided by Gaurav.

Select space management-->Extend Tablespace and the remaining options as mentioned.

Also you can try to use the oracle sql commands like below if required.

alter tablespace <name> add datafile '<location/name>' size 8G autoextend off;

Let us know if this worked for you.

Regards,

Ram

[Former Member]

Where I can get BR Tools / GUI on SAP SM.

Thanks,

Rahul.

[former_member207186]

Hi,

You can follow SAP Note 12741 - "Current versions of BR*Tools" to install/upgrade BR*Tools.

Regards,
Bíborka

[former_member182657]

Hi Rahul,

You should add more space to thelll system & extend the Table space PSAPS3 accordingly to avoid any space related issues during the proocess.

Gaurav

[Former Member]

Hello Gaurav,

Thanks again. But I don't know how I can do that at OS level.

Could you please provide some reference.

Also the log files you mentioned made me understand what was going wrong.

Thanks,

Rahul

[Former Member]

Some statistics

Tablespace                        Used MB    Free MB   Total MB  Pct. Free

------------------------------ ---------- ---------- ---------- ----------

SYSAUX                                 51        149        200         75

PSAPSR3                             60615       3385      64000          5

PSAPSR3USR                             29         11         40         28

PSAPUNDO                             4544       1056       5600         19

SYSTEM                                665        335       1000         34

PSAPSR3700                          53847      18153      72000         25

6 rows selected.