Skip to main content
Solved

How can i connect to oracle if my password contains @ symbol in it

f.kemminje
Contributor
Forum|alt.badge.img+11

Hi Team,

fme 2016

Both reading and writing to oracle spatial.

My customer has @ symbol in his oracle password string.

in my fmw file, oracle connection string is published parameter, and user has to pass the easy connect string to this parameter like

user1/x3#@rtye@mydb

now there are two @ symbols and fme treats rtye@mydb as dbname and fails to connect.

but thru oracle's sqlplus i can connect. not from fme.

and if i give these three parameter separately to sql executor it works good.

 

how can i connect with just one text string with @ symbol in password? please help.

there are lot of fmws developed and i exposed connection string as published parameter

 

Best answer by fmelizard

Hi @fkemminje, I'm pleased to let you know that the issue regarding connecting to Oracle with a string using a password containing an @ symbol has been fixed in our latest beta: FME 2018.0 Build 18162 which is now available for download.

View original
f.kemminje
Did this help you find an answer to your question?

14 replies

david_r
Celebrity
  • david_rCelebrity
  • July 25, 2017

I suspect that's not the fault of FME, but of the Oracle client libraries. Sqlplus is a different beast and I suspect it's a bit more intelligent about the @ symbol than the client libraries.

You may want to try quoting the password, e.g.

user1/\"x3#@rtye\"@mydb

See also: http://nadvi.blogspot.ch/2011/02/oracle-password-with-or-special.html

redgeographics
Celebrity
Forum|alt.badge.img+49

I did a bit of googling at it appears you can enclose the password between quotes (") if it contains a special character, like the @

There's also lots of articles specifically saying not to use @ in your Oracle password...

david_r
Celebrity
  • david_rCelebrity
  • July 25, 2017
redgeographics wrote:

I did a bit of googling at it appears you can enclose the password between quotes (") if it contains a special character, like the @

There's also lots of articles specifically saying not to use @ in your Oracle password...

Agree, I'm not sure I'd recommend using "special" characters in Oracle passwords e.g. backslash and whatnot. More info: http://www.oradba.ch/2014/06/oracle-passwords-and-special-characters/

 

f.kemminje
Contributor
Forum|alt.badge.img+11
  • f.kemminjeContributor
  • Author
  • Contributor
  • July 25, 2017
david_r wrote:

I suspect that's not the fault of FME, but of the Oracle client libraries. Sqlplus is a different beast and I suspect it's a bit more intelligent about the @ symbol than the client libraries.

You may want to try quoting the password, e.g.

user1/\"x3#@rtye\"@mydb

See also: http://nadvi.blogspot.ch/2011/02/oracle-password-with-or-special.html

@David, this does not work

 

 

f.kemminje
f.kemminje
Contributor
Forum|alt.badge.img+11
  • f.kemminjeContributor
  • Author
  • Contributor
  • July 25, 2017
redgeographics wrote:

I did a bit of googling at it appears you can enclose the password between quotes (") if it contains a special character, like the @

There's also lots of articles specifically saying not to use @ in your Oracle password...

@ redgeographics yes I know, but this is created by one of our customer. i cant ask them to change. Moreover oracle accepts @ symbol in password.
f.kemminje
david_r
Celebrity
  • david_rCelebrity
  • July 25, 2017
f.kemminje wrote:
@David, this does not work

 

 

Did you also try without the backslashes, as described in the blog?

 

user1/"x3#@rtye"@mydb
redgeographics
Celebrity
Forum|alt.badge.img+49
f.kemminje wrote:
@ redgeographics yes I know, but this is created by one of our customer. i cant ask them to change. Moreover oracle accepts @ symbol in password.
Actually, you can ask them to change...

 

steveatsafe
Safer
Forum|alt.badge.img+12

I tested creating a new database connection to Oracle 12c for a new user with a password of give@eight and it works if you (as @redgeographics indicates) wrap the password in quotes "give@eight".

 

NOTE I had to do the same in Oracle to set the password. Ex. I altered the users password with: alter user bobby identified by "give@eight"; If I didn't use the quotes, Oracle complained.
SteveatSafe
fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • July 26, 2017

Hi @fkemminje. I've asked our development team to investigate if there is a way to pass an easy connect string as a published parameter into FME successfully if the password contains "@". I'll provide more information here once I can.

f.kemminje
Contributor
Forum|alt.badge.img+11
  • f.kemminjeContributor
  • Author
  • Contributor
  • July 27, 2017
steveatsafe wrote:

I tested creating a new database connection to Oracle 12c for a new user with a password of give@eight and it works if you (as @redgeographics indicates) wrap the password in quotes "give@eight".

 

NOTE I had to do the same in Oracle to set the password. Ex. I altered the users password with: alter user bobby identified by "give@eight"; If I didn't use the quotes, Oracle complained.
Hi @SteveAtSafe You said it works.

 

Did you try it in FME ? or oracle (sqlplus or Toad)

 

even it is working working for me in sqlplus and Toad, But not in fme(oracle reader, sqlexecutor or joiner) even if I wrap the password in quotes

 

f.kemminje
f.kemminje
Contributor
Forum|alt.badge.img+11
  • f.kemminjeContributor
  • Author
  • Contributor
  • July 27, 2017
fmelizard wrote:

Hi @fkemminje. I've asked our development team to investigate if there is a way to pass an easy connect string as a published parameter into FME successfully if the password contains "@". I'll provide more information here once I can.

waiting for safe Answer.

 

Here My complaint is

 

if it is working in sqlplus or Toad for oracle then why dont in FME ?

 

FME passes the same string to Oracle right?

 

it has to work. or

 

 

Did fme splits the connection string at @ symbol before passing to Oracle?

 

 

f.kemminje
david_r
Celebrity
  • david_rCelebrity
  • August 3, 2017
david_r wrote:
Did you also try without the backslashes, as described in the blog?

 

user1/"x3#@rtye"@mydb
Did you try the above? Can you please post the relevant part of your log?
f.kemminje
Contributor
Forum|alt.badge.img+11
  • f.kemminjeContributor
  • Author
  • Contributor
  • September 1, 2017
fmelizard wrote:

Hi @fkemminje. I've asked our development team to investigate if there is a way to pass an easy connect string as a published parameter into FME successfully if the password contains "@". I'll provide more information here once I can.

Hello mam, reminding...

 

 

f.kemminje
fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • Best Answer
  • September 7, 2017

Hi @fkemminje, I'm pleased to let you know that the issue regarding connecting to Oracle with a string using a password containing an @ symbol has been fixed in our latest beta: FME 2018.0 Build 18162 which is now available for download.

Reply


Helpful Members This Week

Community Stats

31,140
Posts
118,062
Replies
38,759
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.