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.
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.
sid exist in tnsnames.ora
sid is exist in tnsnames.ora file.
please be precise :
what do you type ?
what is the error message you get ?
warning message appears....
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 ?
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 ...
That normally means you entered an invalid SID
I am sending U the commands which I ran in sql plus.
I opened the sql plus and typed the following commands.
Enter user-name: emp
Enter password: ***
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
Ok, do you think you could of type the Password wrong?
Also in the username type
then type the password.
if you do sqlplus system/manager, does it work ??
the error means that your password is not valid, that's all ...
Click Here to Expand Forum to Full Width