Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Oracle Password having special character

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Oracle Password having special character
# 1  
Old 04-01-2009
Oracle Password having special character
Hi
I am trying to connect to oracle using shell script with username/pwd@constring
The password is having special character . I have to ignore the special character else i am getting invalid username or password. How to achieve that
My password is having $ , but the password can have any special character at any place in the password

Thanks in advance
Suresh
# 2  
Old 04-01-2009
You have to escape the $ with a backslash
Code:
username/mypa\$\$wd@constring

In this case the pswd is mypa$$wd
# 3  
Old 04-01-2009
Thanks for your reply
This i tried but my question is that the password is in a variable and i dont know where is the special character
Thanks
Suresh
# 4  
Old 04-01-2009
You know - it is always better to present everything up front. Smilie

Use the ${ } construct:
Code:
pwd='mypa$$wd'
username/${pwd}@constring

# 5  
Old 04-01-2009
Thanks for your reply but sorry for bothering you again if the password contains other than $ then what to do because in future i may get this issue to me again i mean if it contains % or # or @ anything like that how to over come
# 6  
Old 04-01-2009
One more thing
username/${pwd}@constring is not working for me
Thanks
Suresh
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Special character $$

Hi, on ksh What does the following do? grep -v "toolbox" $home_oracle/.profile >$home_oracle/.profile.$$ Thanks. Please use CODE tags as required by forum rules! (3 Replies)
Discussion started by: big123456
3 Replies

2. UNIX for Beginners Questions & Answers

What is the meaning the $ special character?

Hello... and thank you in advanced for any help anyone can offer me I'm hoping someone can explain what the leading $ is/means (i.e. $PS1, $HOME, etc).... I was having a discussion with someone and was trying to explain it... Which I felt like I came up kind of short with how well I did it. ... (12 Replies)
Discussion started by: bodisha
12 Replies

3. Shell Programming and Scripting

A special character issue.

Hi Gurus, I have a file contains special character. when using: grep 'xxxxx' filename, it returns whole line. when using: grep -evt 'xxxxx' filename it returns whole line with special charactor. when running command: nl filename |grep 'xxxxxx' the line break by the special... (1 Reply)
Discussion started by: ken6503
1 Replies

4. Shell Programming and Scripting

Vi special character

When editing a file, vi displays a special character as ^L. Can you tell me the escaped character to be used in awk? And can that escaped character be used in a regexp in both sed and awk? (7 Replies)
Discussion started by: dmesserly
7 Replies

5. Shell Programming and Scripting

Deleteing one character after an special character

I have below line in a unix file, I want to delete one character after "Â". 20091020.Non-Agency CMO Daily Trade Recap Â~V Hybrids The result should be : 20091020.Non-Agency CMO Daily Trade Recap  Hybrids i dont want to use "~V" anywhere in the sed command or any other command, just remove... (1 Reply)
Discussion started by: mohsin.quazi
1 Replies

6. Shell Programming and Scripting

Special character \

Hi, In the shell script, i need to remove the special charater "\" with "\\". For example, i need to replace "D:\FXT\ABC.TXT" with "D:\\FXT\\ABC.TXT". However, when trying to do something like , i get the below error :- -->echo "D:\FXT\ABC.TXT" | sed -e 's#\#\\#g' sed: 0602-404 Function... (7 Replies)
Discussion started by: amit_arora
7 Replies

7. UNIX for Advanced & Expert Users

grep in special character

All, I am trying to grep "-----" from a test when i use this i am getting the below error. What is the reason for this ?????... How can i over come this ##) echo "----------------- test_sys_job -----------------" | grep "-----------------" grep: illegal option -- - grep: illegal... (6 Replies)
Discussion started by: arunkumar_mca
6 Replies

8. Shell Programming and Scripting

special character

Hi, I am trying to unload file from a database. Which contains few lines with the character below. Rest of the data was unloaded appropriately. a) What does this below character means? b) How can i remove it, I already have sed '/^$/d' c) Will this effect the file by any means... (4 Replies)
Discussion started by: tostay2003
4 Replies

9. Shell Programming and Scripting

convert special character like £

i had a shell script writing a xml file. I need to use "& # 163;" instead of "£", and replace others characters like: > to > , and so on.. Anyone know how to convert the character automatically? my script as below: do # GET FEED REC SQL2="SELECT A.*, B.subject FROM feed_details A,... (1 Reply)
Discussion started by: cynnie
1 Replies

10. Programming

special character ?

hey there im a bit stuck on executing commands that include the special character '?'. can someone recommend a way on how i would be able to execute it?? i thought the glob function could be useful (still mite be) but upon entering the command 'ls pars?' it listed all the files in the... (1 Reply)
Discussion started by: mile1982
1 Replies
Login or Register to Ask a Question