-
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
-
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
Vinit
-
sid exist in tnsnames.ora
hi vinit,
sid is exist in tnsnames.ora file.
thankx
mustak
-
please be precise :
what do you type ?
what is the error message you get ?
-
warning message appears....
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
-
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
-
help me..
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
-
Ok, do you think you could of type the Password wrong?
Also in the username type
emp@SID
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 ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|