SQL error 12154

[Former Member]

Hi,

We are trying to start SAP. While starting it gives SQL error 12154

We have checked thoroughly and we can see that in the env variable its mentioned AMERICAN.UTF8 code while in dev_w0 logs we can see its picking up AMERICAN.UTF16

Please help.

Thanks,

Santanu

[former_member226066]

Please backup your /sapmnt/<SID>/profile/oracle directory and copy sqlnet.ora, tnsnames.ora files from /oracle/<SID>/102_64/network/admin to /sapmnt/<SID>/profile/oracle

Or Refer Note 443867 - ORA-12154 Collective SAP note and correct your TNSNAME.ora and LISTENER.ORA entries

[Former Member]

My r3trans -d is returning 0000. So listener is working.

[Former Member]

It doesn't look like AMERICAN_AMERICA.UTF16 is the issue. Even our system also shows AMERICAN_AMERICA.UTF16 in dev_w0 and our system is running fine. Do you see any other error in dev_disp or dev_w0 ?

[Former Member]

We have restarted the listener and checked but facing the same issue.

[Former Member]

try Retrans -d and paste the log.

Did you try tnsping <SID> ?

[Former Member]

Santanu,

Looks like its Listener issue. Is Listener up and running ?

1) Make sure No or wrong entry tnsnames.ora (environment variable TNS_ADMIN or default location ORACLE_HOME/network/admin)

you can also try tnsping <SID> from command prompt.

Regards,

Arjun