Home » RDBMS Server » Server Administration » Want to change sys password
Want to change sys password [message #429735] Thu, 05 November 2009 09:22 Go to next message
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 #429737 is a reply to message #429735] Thu, 05 November 2009 09:24 Go to previous messageGo to next message
BlackSwan
Messages: 3352
Registered: January 2009
Senior Member
log onto DB server as user oracle or owner of Oracle software

sqlplus
/ as sysdba
alter user sys identified by newpassword;
exit
Re: Want to change sys password [message #429892 is a reply to message #429737] Fri, 06 November 2009 03:27 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic:error ORA-01555 in Oracle 10g
Next Topic:9i to 10g upgrade - Materialized views
Goto Forum:
  


Current Time: Mon Nov 30 11:11:03 CST 2009

Total time taken to generate the page: 0.01060 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.