| Want to change sys password [message #429735] |
Thu, 05 November 2009 09:22  |
rhnilu Messages: 7 Registered: January 2009 Location: Bangladesh |
Junior Member |
|
|
|
I don't know sys password. But I need the password for DBA activities. How can I logon into sys user with sysdba or How can I change the old password to new password. Any one can help me plz..
|
|
|
|
| Re: Want to change sys password [message #429892 is a reply to message #429737] |
Fri, 06 November 2009 03:27   |
ramoradba Messages: 355 Registered: January 2009 Location: AP,Hyderabad |
Senior Member |
|
|
Z:\>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 6 14:54:24 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter user sys identified by tejajun20;
User altered.
SQL> conn sys/tejajun20 as sysdba
Connected.
SQL> alter user sys identified by password;
User altered.
SQL> conn sys/password as sysdba
Connected.
SQL> select name from v$database;
NAME
---------
SATYA
SQL> conn system/tejajun20
Connected.
SQL> select name from v$database;
NAME
---------
SATYA
SQL> alter user sys identified by sriram;
User altered.
SQL> conn sys/sriram as sysdba;
Connected.
SQL> select name from v$database;
NAME
---------
SATYA
SQL>
Sriram
|
|
|
| Re: Want to change sys password [message #429894 is a reply to message #429892] |
Fri, 06 November 2009 03:32  |
ramoradba Messages: 355 Registered: January 2009 Location: AP,Hyderabad |
Senior Member |
|
|
Quote:I don't know sys password. But I need the password for DBA activities
Ask your dba,for the required privileges.So that he can assign what ever required for you.
Never ever use sys user for regular tasks.Consult your DBA for your needs.
Sriram.
|
|
|