ORA-01017: invalid username/password after DB copy

[Former Member]

I am trying in my DR server. i am getting the following error ORA-01017: invalid username/password.

I have install SAP 4.7, windows 2000 adv , Oracle 9.2 (same as my Productin). then copied only the control files and the data files to the new location. both systems are the same the only diffreance is the production system is in domain and DR is not on the Domain

I cannot put the DR in domain as the name, SID, Noumber are the same as production. how can change this and get the DR server up and working ?

Is there a better way for this ?

[Former Member]

Hi Rehan,

If everything is identical on both servers, and the only difference is in the domain, then you are probably hitting an OPS$ issue.

The OPS$ usernames in the DB should look like

- In the primary host (included in the domain)

OPS$DOMAIN\<SID>ADM

OPS$DOMAIN\SAPSERVICE<SID>

- In the DR host (out of the domain)

OPS$<SID>ADM

OPS$SAPSERVICE<SID>

I assume the OS users (sidadm and sapservicesid) are also identical on both hosts.

Good luck

Alfonso

[Former Member]

When exactly do you get this error ? how did you perform system copy ?

What is the release of SAP ?

[Former Member]

Thank you for the support once again

I am getting the error in SAP MM (The Three Oracle services and Two SAP services are started in windows/services)

SAP 4.7 Oracle 9.2

[Former Member]

please refere to the homogenious system copy guides of your SAP release.

just copying the database is not always working and was never supported.

peter

[Former Member]

Rehan,

What ur trying in DR server?

When ur facing password user ?

u have installed SAP Win Orcale same as PROD means Same SID Right ?

Now u want to set up DR ? in Same server ? Some more info needed

Vinod