on 07-09-2014 7:58 AM
Dear Expert,
I wanted to restore our ehp7 oracle 11g data to on other server with different SID and different drive letter.For oracle 10g I was creating ops$ user.I wans not able to find oracle control file from trace folder.?How i can perform with oracle 11g.
Regards,
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Krishna,
Process of restoration in Oracle 11g and 10g remains the same.
Only location for trace files is changed in oracle 11g. you can check under ORACLE_HOME/diag/rdbms/<database>/trace
Deepak Kori
Thanks Deepak,
What abt ops$ user alternative.
Process for creating OPS$ remains the same like Oracle 10g. Drop old OPS$ users and re-create newones.
Hi,
Check SAP Note 50088 for OPS$ user Id creation process.
Nick Loy
Dear Nick Loy
Ops$ mechanism exist on 11g ?
As of SAP Kernel 740 only secure connection using SSFS is supported for Oracle
Refer SAP note for more details on configuration
1622837 - Secure connection of AS ABAP to Oracle via SSFS
As your system is NW 7.40 based you should be using SSFS based connection. OPS$ mechanism may not work here.
Hope this helps.
Deepak kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.