Home » RDBMS Server » Server Administration » Oracle Database Server(2 Merged) (Oracle 10g)
Oracle Database Server(2 Merged) [message #516652] Tue, 19 July 2011 20:34 Go to next message
chintu00
Messages: 83
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 Go to previous message
BlackSwan
Messages: 22902
Registered: January 2009
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

Previous Topic: Grant SELECT through synonym
Next Topic: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST
Goto Forum:
  


Current Time: Wed Oct 22 10:47:57 CDT 2014

Total time taken to generate the page: 0.09052 seconds