sqlplus: Command not found

[Former Member]

Hi All,

I am building a SAP System from a another system. Making an exact replica of an existing system but with different SID and hostname using Database Relinking procedure.

Relinking has been done and database is up and running. Listener is also running. OPS$ users are also created.

But R3trans -d is failing with the below error:

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 21 131.840608

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 16 131.840624

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 15 131.840639

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 63 131.840702

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 24 131.840726

4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#4 @ 433] 4880 131.845606

4 ETW000 [dblink ,00433] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#4 @ 433]

4 ETW000 26 131.845632

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SID'"

When I am trying to access sqlplus from <sid>adm its not working :-

qashub04:<sid>adm 21> sqlplus sapisu/vgy78uhb

sqlplus: Command not found.

From ora<sid> sqlplus is working :-

qashub04:ora<sid> 1> sqlplus sapisu/vgy78uhb

SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 28 23:37:24 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Kindly help in fixing the issue. Looking forward for your reply.

Regards,

Soumya

[Former Member]

Post restoration you have to set all env variables, user profiles and instance profiles according to new hostname/SID.

In this particular scenario.

Regards,

Nick Loy