Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Enterprise 10gR2 can't be installed on Windows XP/2003
Thomas wrote:
> Hi,
>
> i have solved the problem! You would never believe why the error
> occurs! The problem was a special character (@) or a number in my
> password and oracle doesn't seem to be able to transfere/decode/encode
> my password.
> I'm not sure why oracle can't use special characters. Could it be
> depends on the character set? (i used the default one WE8...)
>
> Thanks a lot and i hope my mistake helps others and helps to create a
> better version of the universal-installer.
> Thomas
>
Oracle can use special characters, but the '@' symbol has special meaning. If I want to sign on to a remote database, I use "@tns_entry" to connect to the remote db specified with the supplied TNS entry (in my tnsnames.ora config file). This notation is specified right after the password as follows:
connect username/password_at_tns_entry
So when SQL*Plus sees the '@' sign, it thinks what follows is a tns_entry and not part of your password.
If you do want an at-symbol in your password, then enclose the password in double quotes:
connect username/"pass_with_@_sym"
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown -- Posted via a free Usenet account from http://www.teranews.comReceived on Tue Aug 14 2007 - 12:48:15 CDT
![]() |
![]() |