EHP4 Error during DDIC_UPG phase.

[Former Member]

Hi Guys,

We are facing an issue while EHP4 upgrade in DDIC_UPG phase.

I have checked the logs.

i have error ;

DDIC IMPORT ERRORS AND RETURN CODE IN SAPH-70104INPIBASIS.PEP

2EETW169 NO COONECT POSSIBLE : "DBMS=ORACLE -

---

DBS_ORA_TNSNAME= PEP

1ETP111 EXIT CODE

I have checked sapsr3 user is OPEN in database.

The status of Listener is:

instance "PEP' , staus UNKNOWN.

ihave executed R3trans -d and r3trans -x with return code 0000.

and i am able to connect to database using sqlplus..

I have to mentioned we are running on HIGH availablity system on linux host.

Please advise how to proceed.

Regards

Abhishek

Edited by: abhishek sharma on Nov 3, 2011 8:32 AM

[former_member188883 · Accepted solution]

Hi,

As per the information provided by me, your number of oracle sessions might have exhausted. Hence the error no connect to database possible appeared.

You should look into alert_<SID>.log file for more details.

If oracle session issues appear in the log , increase the same and repeat the DDIC_UPG phase.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Abishek,

Can you paste the content of log SAPH-70104INPIBASIS.PEP?

Thanks,

Siva Kumar

[former_member227283]

Hi abhishek,

Your application server is running on the same host where DB instance is running ??

Thanks,

Anil Bhandary