Home » RDBMS Server » Server Administration » ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied (Oracle 10gr2-SUN OS 5.10)
icon14.gif  ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied [message #324765] Tue, 03 June 2008 23:44 Go to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
hi

Iam facing ann error ORA-01045

$ ./sqlplus start

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 4 10:09:59 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: system
Enter password:
ERROR:
ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied


And I know we have to grant CREATE SESSION privilages to user. but what are the steps to do that ? Any advice would be greatly appreciated.
Please do needful to avoid this.
Re: ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied [message #324768 is a reply to message #324765] Tue, 03 June 2008 23:54 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Please do needful to avoid this.
Please provide details how you found yourself in this position.

Use dbca to create new database & do not break it (again).
Re: ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied [message #324770 is a reply to message #324768] Tue, 03 June 2008 23:59 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
Hi

Iam unable to get into SQL prompt itself..

How can i login as sysdba...what is the command?
Re: ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied [message #324772 is a reply to message #324765] Wed, 04 June 2008 00:03 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Iam unable to get into SQL prompt itself..
>How can i login as sysdba...what is the command?
I suggest you stay far away from Oracle & stick with ACCESS.


http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above.
Re: ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied [message #324773 is a reply to message #324770] Wed, 04 June 2008 00:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
connect / as sysdba

Regards
Michel

[Updated on: Wed, 04 June 2008 00:03]

Report message to a moderator

Re: ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied [message #324778 is a reply to message #324773] Wed, 04 June 2008 00:10 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
Hi Michel,

iam not at all getting SQL promt ..where should i enter tis command..

Consider me as fresher to oracle and help..
Re: ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied [message #324781 is a reply to message #324778] Wed, 04 June 2008 00:16 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
ravindragdm wrote on Tue, 03 June 2008 22:10
Hi Michel,

iam not at all getting SQL promt ..where should i enter tis command..

Consider me as fresher to oracle and help..

Michel,

He is all yours!
I won't waste any more time on this thread.
Re: ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied [message #324788 is a reply to message #324778] Wed, 04 June 2008 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*PlusŪ User's Guide and Reference

Regards
Michel
Re: ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied [message #324806 is a reply to message #324788] Wed, 04 June 2008 02:48 Go to previous message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
thank you
Previous Topic: TEMPFILE cannot be dropped at this time
Next Topic: How to export a dump file of a database
Goto Forum:
  


Current Time: Sat Dec 10 22:50:05 CST 2016

Total time taken to generate the page: 0.08446 seconds