| Oracle Database Server(2 Merged) [message #516652] |
Tue, 19 July 2011 20:34  |
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
|
Member |
|
|
I am connected as System. It was the only user I set-up a password when installed the database on personal computer. Can someone explain why is this happening ?
SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Warning: You are no longer connected to ORACLE.
SQL> connect sysdba/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied
|
|
|
|
| Re: Oracle Database Server [message #516654 is a reply to message #516652] |
Tue, 19 July 2011 20:47  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
>Can someone explain why is this happening ?
You don't know what you are doing & would rather ask for answers here instead of Reading The Fine Manual for documented answers.
SQL> alter user sys identified by mypass007;
User altered.
SQL> connect sys/mypass007 as sysdba
Connected.
SQL> connect sys/foobar as sysdba
Connected.
SQL> connect sys/ID10T as sysdba
Connected.
SQL>
both your post behavior & this post behavior are documented in the Fine Manual
[Updated on: Tue, 19 July 2011 20:51] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
