SQL * plus on Oracle 10G

[pc_delphi]

I have the Express version (free) and opened the command prompt, but I can not log in on it. How do I need to take a test with it, how do I log in 10g, via prompt?
My schema is: bank.global
My password is: 111111

[dr_gori]

Do you give any error message? If so, what?

[pc_delphi]

Not quite an error MSG, but like this:

Select all

Insufficient privileges

(this when I give the startup).

[pc_delphi]

If I do like this:

Select all

SQL> connect "Banco.Global"/111111

Dá a mensagem:

Select all

 invalid Username/password; logon denied

[schnu]

It may seem nonsense, but I had problems using password being the first digit number, when I changed the password by placing the first type a character worked !!!

If you can do this test there it would be interesting, because until I was surprised when I solved the way I wrote above.

[gokden]

Aham ... é that's right, look what happens here.

Select all

SQL> alter user teste identified by 1teste; 
alter user teste identified by 1teste 
                               * 
ERROR at line 1: 
ORA-00988: missing or invalid password(s)

= D

[ruevers]

If you want to put number ... put the password in quotation marks.

Thus:

Select all

alter user identified by "1teste";