Unable to login to Oracle Database from OSX -
i've downloaded , installed oracle instant client on mac sierra. have created tnsnames.ora files , exported path.
however, when try login remote oracle server, following error:
mridulas-macbook-pro:~ mridulaprabhu$ sqlplus demo$security/password@erponweb sql*plus: release 11.2.0.4.0 production on fri aug 18 16:37:03 2017 copyright (c) 1982, 2013, oracle. rights reserved. error: ora-01017: invalid username/password; logon denied
when colleague connects same server using same credentials on windows, can login.
someone told me because of characterset on mac. have set nls_lang american_america.us7ascii
still doesn't work.
how can fix this?
os x unix variant, , you're running shell. $
in username being interpreted environment variable.
if do:
echo demo$security/password@erponweb
you'll see shows demo/password@erponweb
- unless happen have envorinment variable called security
, in case substituted.
you can escape dollar symbol stop interpretation:
sqlplus demo\$security/password@erponweb
or enclose entire argument in single (not double) quotes:
sqlplus 'demo$security/password@erponweb'
Comments
Post a Comment