Home » SQL & PL/SQL » SQL & PL/SQL » ORCL 28009 (Oracle 10g)
ORCL 28009 [message #361340] Wed, 26 November 2008 00:33 Go to next message
vinothkp
Messages: 3
Registered: November 2008
Location: VA
Junior Member
I am getting an error ORCL 28009 User Sys has to connected as Sysdba. I just installed 10g and I am trying to get into SQL Plus to unlock other users, but it is not letting me login. What will be the username, password and hoststring?

I am using Sys as the username and CHANGE_ON_INSTALL as the password?

Any help is appreciated.

Thanks
Re: ORCL 28009 [message #361342 is a reply to message #361340] Wed, 26 November 2008 00:38 Go to previous messageGo to next message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
@vinothkp,


SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 26 12:07:34 2008

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

Enter user-name: sys as sysdba
Enter password:  <-- Enter your password here

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user;
USER is "SYS"
SQL>



Hope this helps.

Regards,
Jo

[Updated on: Wed, 26 November 2008 00:38]

Report message to a moderator

Re: ORCL 28009 [message #361343 is a reply to message #361340] Wed, 26 November 2008 00:38 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
> SQLPLUS sys/password@database AS SYSDBA
Re: ORCL 28009 [message #361344 is a reply to message #361340] Wed, 26 November 2008 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just have a look at Error Messages book or use "oerr" tool:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
 *Cause:    connect SYS/<password> is no longer a valid syntax
 *Action:   Try connect SYS/<password> as SYSDBA or
            connect SYS/<password> as SYSOPER

Regards
Michel
Re: ORCL 28009 [message #361500 is a reply to message #361344] Wed, 26 November 2008 12:13 Go to previous messageGo to next message
vinothkp
Messages: 3
Registered: November 2008
Location: VA
Junior Member
I tried this and the window automatically closed. (Please refer the attached gif image)
Please help me because this is the first time i m using SQL PLUS and am not able to get in and unlock other users like Scott, etc.


Thanks.
  • Attachment: sqlplus.gif
    (Size: 243.19KB, Downloaded 103 times)
Re: ORCL 28009 [message #361503 is a reply to message #361500] Wed, 26 November 2008 12:21 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
I never used a GUI tool to connect to a database, but why not just connect as SCOTT and then use the proper connect command that needs to be used to connect as a SYSDBA?
Re: ORCL 28009 [message #361504 is a reply to message #361500] Wed, 26 November 2008 12:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Littlefoot wrote on Wed, 26 November 2008 07:38
> SQLPLUS sys/password@database AS SYSDBA

Re: ORCL 28009 [message #361507 is a reply to message #361340] Wed, 26 November 2008 12:28 Go to previous message
vinothkp
Messages: 3
Registered: November 2008
Location: VA
Junior Member
I found a solution thanks to help from you guys. I used just the username in the login screen as attached in one of the previous posts i sent and did not have any password in the screen. I clicked OK and it asked for the password at the prompt:
I entered the password and it logged in
Enter password: *****************

Connected to:
Personal Oracle Database 10g Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show user
USER is "SYS"
SQL>


But, I am not sure why it would not log in if i gave the password in the login screen itself. Anyway, thanks all you guys.

Vinoth.
Previous Topic: Sum Field Based Off Distinct Other Field (2 cross-posts merged by bb)
Next Topic: MAX() Returning Wrong Values
Goto Forum:
  


Current Time: Sat Dec 10 07:10:17 CST 2016

Total time taken to generate the page: 0.09279 seconds