User login fails [message #524815] |
Tue, 27 September 2011 01:38 |
zabltn
Messages: 45 Registered: September 2011
|
Member |
|
|
I just create a user and tried to log in but it gives the following error, why?
pealse help.
SQL*Plus: Release 10.1.0.4.2 - Production on Tue Sep 27 10:57:55 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> create user user1 identified by user1;
User created.
SQL> conn user1
Enter password: *****
ERROR:
ORA-12560: TNS:protocol adapter error
Warning: You are no longer connected to ORACLE.
|
|
|
|
Re: User login fails [message #524828 is a reply to message #524817] |
Tue, 27 September 2011 02:34 |
zabltn
Messages: 45 Registered: September 2011
|
Member |
|
|
I am new to Oracle, Please if you could explain what are they, why to set them and how to set them, it will be my pleasure thanks.
|
|
|
|
|
|
|
Re: User login fails [message #524850 is a reply to message #524844] |
Tue, 27 September 2011 04:08 |
|
Michel Cadot
Messages: 68690 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
In DOS box, execute:
set ORACLE_SID=<your database sid>
set ORACLE_HOME=<your database home>
sqlplus user1/...
But there are several inconsistencies in your post:
1/
SQL*Plus: Release 10.1.0.4.2
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0
Have you 2 Oracle homes on your server?
2/
SQL> create user user1 identified by user1;
...
So your already connected to be able to create a user but as you can't connect locally with the new user this means you first connected through SQL*Net that is using an alias.
So you should be able to connect to the new user (after grant CREATE SESSION to it) with the same alias, that is in the same way you first connected.
Regards
Michel
[Updated on: Tue, 27 September 2011 04:09] Report message to a moderator
|
|
|
Re: User login fails [message #524884 is a reply to message #524850] |
Tue, 27 September 2011 05:15 |
zabltn
Messages: 45 Registered: September 2011
|
Member |
|
|
C:\>seT ORACLE_SID=XE
C:\>set ORACLE_HOME=E:\oraclexe\app\oracle\product\10.2.0\server
C:\>sqlplus user1/user1
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 27 14:33:20 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01045: user USER1 lacks CREATE SESSION privilege; logon denied
1/
i have installed the oracle 10g express edition database server and i have also installed oracle 10g developer suite.
2/
SQL> grant create session to user1;
Grant succeeded.
SQL> conn user1
Enter password: *****
ERROR:
ORA-12560: TNS:protocol adapter error
|
|
|
|
Re: User login fails [message #524894 is a reply to message #524891] |
Tue, 27 September 2011 05:36 |
zabltn
Messages: 45 Registered: September 2011
|
Member |
|
|
No i didnt hide anything, that user was the default SYSTEM user, and through that user i have created the user user1 so now the problem is that i am not able to connect with the user1.
|
|
|
|
Re: User login fails [message #524901 is a reply to message #524896] |
Tue, 27 September 2011 05:48 |
zabltn
Messages: 45 Registered: September 2011
|
Member |
|
|
Okay let me clear it.
i went to star menu on my windows7 >> Applicatoin Development>>sqlplus>> now it is promting me for a user and password, and i gave it <system> in the username box, <shaikh> for its password, and <myNSN> for the host string. Then it connect me to the Database through the <system> user now i have created another user and i cant login to that user.
|
|
|
|
|
|
|
|
Re: User login fails [message #526142 is a reply to message #526141] |
Sun, 09 October 2011 01:15 |
|
edris
Messages: 7 Registered: July 2011
|
Junior Member |
|
|
Yes, i can connect with the server through the SYSTEM user, and i am not able to connect through the SYS user because i dont know its password. And i think SYSTEM does not has the right to grant a user sysdba privilege.
[Updated on: Sun, 09 October 2011 01:19] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|