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.com