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_member204746]

can you find file "sqlplus" in /sapmnt/ISU/exe ?

[Former Member]

Hi All,

It was indeed a problem with environment variables.

The issue has been resolved. Thanks for the suggestions.

Regards,

Soumya

[Former Member]

This message was moderated.

[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

[Former Member]

Hi ,

You have raised 2 issues

LOG BY0=>ORA-01017: invalid username/password

This is surely OPS$ user issue only , just check SAP note regading this.You have to recreate user and also need to replicate table SAPUSER as well.

sqlplus from <sid>adm its not working

This is a issue with env variable run command

which sqlplus

if not showing any thing set environment variable for ORACLE_HOME and PATH as well.

Regards,