Thank you @rahmansunbeam, Actually, the difficulties appear when upgrading the SDE 9.2 schema to SDE 10.2, they are completely not compatible with each other (ArcSDE 10.2 can not read SDE 9.2 schema).
So, I tried to setup a transition stage through ArcSDE 10.0.
ie: SDE 9.2/Ora 10g ---> SDE 10.0/Ora 10g ---> SDE 10.2/Ora 11g r2
I'm facing a lot of troubles related to versions compatibility between ArcSDE, Oracle DB, Oracle client, Windows 32 bit, Windows 64 bit.
I need some guidance.