invalid username/password in sqlplus....

[Mustak]

Hi,

I have created one database (TestDB) and user also. I have given all the permissions to the user to access the full database. I am able to view the tables and data through wizard. But I am unable to access through sql plus. It says invalid username/password. I don't understand where I did the mistake. Could anybody help me. suggestions are appreciated.


thankx
mustak ahmed

[vinit]

Hi,
How are you connecting to your DB ? Can you give the syntax pls. Secondly hope you've added your sid in the tnsnames.ora file.

cheers

[Mustak]

hi vinit,

sid is exist in tnsnames.ora file.

thankx
mustak

[pipo]

please be precise :
what do you type ?
what is the error message you get ?

[Mustak]

Hi,

I tried to connect to database through sql plus. It shows the following warning..

You are no longer connected to ORACLE.

what does it mean ?


thankx
mustak

[pipo]

simply that you're not connected anymore, but if you don't answer the questions we ask you, there is no way to help you ...

[Zamial]

That normally means you entered an invalid SID

[Mustak]

hi,

I am sending U the commands which I ran in sql plus.


I opened the sql plus and typed the following commands.

SQL> connect
Enter user-name: emp
Enter password: ***
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL>


thankx
mustak

[Zamial]

Ok, do you think you could of type the Password wrong?

Also in the username type

emp@SID

then type the password.

[pipo]

if you do sqlplus system/manager, does it work ??
the error means that your password is not valid, that's all ...