cannot call sqlplus from linux where password contains $ dollar sign

Question

I have spent hours trying various suggestions and combinations but for the life of me cannot get a call to sqlplus from direct linux command line or from a bash script to work with a password containing a $

I have tried these

sqlplus -S mylogin/'"my$password"'@My_DBName
sqlplus -S mylogin/'my$password'@My_DBName
sqlplus -S mylogin/"my$password"@My_DBName

I have tried the same as above but putting \ before the $, and various other attempts not shown...

Have tried using CONNECT instead both plain password, and with the various quotes and backslashes (only one example shown here)

sqlplus -S /nolog << EOF
CONNECT mylogin/my$password@My_DBName;    

sqlplus -S /nolog << EOF
CONNECT mylogin/'"my$password"'@My_DBName;

I do know that the general sqlplus commands as single command, or with CONNECT works for passwords that do NOT contain $.

Can someone tell me what I'm doing wrong and why? If so, I thank you profusely!

EDITED - MY BAD - ARGH!

Turns out someone changed the password. In fact it does work even the $ and specifying the single quotes like:

sqlplus -S mylogin/'my$password'@My_DBName

What is your 4 digits Oracle version ? What is the OS ? For example with Oracle 12.2.0.1 on Linux and bash putting the password between single quotes should work. — pifor
If you are not sure of what the shell is doing put your sqlplus command in a shell script and add in the script set -x to check the full sqlplus command that the shell is running. — pifor
I should have said !! ... "does work" means it can't login due to "ORA-01017: invalid username/password; logon denied". fyi linux 2.6.32-754.9.1.el6.x86_64 Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit — Rose

Bjarte Brandt Bjarte Brandt · Accepted Answer · 2020-06-11T11:29:32

Tested on my MacOS Catalina. Works with single-quotes.

Are you sure about your -S option ? Nothing is displayed after login.... (but you ARE logged in). You can still do select * from dual;

system@XEPDB1> create user mylogin identified by my$password;

User created.

Elapsed: 00:00:00.05
system@XEPDB1> grant create session to mylogin;

Grant succeeded.

Elapsed: 00:00:00.03
system@XEPDB1> exit

sqlplus mylogin/'my$password'@localhost/XEPDB1

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 11 13:17:35 2020
Version 19.3.0.0.0

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


Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

mylogin@XEPDB1>


-- change from my$password to $$$$password
mylogin@XEPDB1> passw
Changing password for MYLOGIN
Old password:
New password:
Retype new password:
Password changed
mylogin@XEPDB1> exit

sqlplus mylogin/'$$$$password'@localhost/XEPDB1

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 11 13:20:09 2020
Version 19.3.0.0.0

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

Last Successful login time: Thu Jun 11 2020 13:17:35 +02:00

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

mylogin@XEPDB1>

sqlplus -S mylogin/'$$$$password'@localhost/XEPDB1
select 'No errors - I am logged in!' from dual;

'NOERRORS-IAMLOGGEDIN!'
---------------------------
No errors - I am logged in!

Elapsed: 00:00:00.02

cannot call sqlplus from linux where password contains $ dollar sign

1 Answers