Printable View
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
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 ?
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
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 ...
Hi,
thankx zamial.
I am able to login to database. But I want to know why should I type emp@sid at user-name. Could U please let me know.
where as for other users I need not to type like this.please help me.
thankx
mustak ahmed
You have to say to wich database you want to connect. Because sqlplus is not asking for a db-name you have to add it behind the username.
That is when your Oracle environment has not been set.
If you export $ORACLE_SID=[sid] on a Unix OS before you start sqlplus you don't have to fill in the sid any more.
So some unix users have added the export $ORACLE_SID=[sid] in there .profile. So that can explain why some of your users don't have to add the @sid...
Yep, environment variables.
If you leave out the SID, it uses the SID set in your "ORACLE_SID" environment variable on UNIX and there is a similiar parameter on NT.
If you don't have this set you msut specify the SID.
In your case it may also be set to a different SID as you have multiple databases. Specifying the SID is a reasonable method of guaranteing you connect to the correct database.
On UNIX type ' env|sort ' and look at what your ORACLE_SID variable is set to.