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: 12
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: 26766
Registered: January 2009
Location: SoCal
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: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
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 messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
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.
Re: Want to change sys password [message #435222 is a reply to message #429735] Tue, 15 December 2009 04:52 Go to previous message
SreeQ8
Messages: 1
Registered: December 2009
Location: Kuwait
Junior Member
Windows follow step 1,2,4,5
Linux Users follow 3,4,5

1. Open Dos Prompt using CMD in windows ,(Click Start , Run Type CMD)
2. SET ORACLE_SID=(your database SID)
3. Type the following command on linux shell prompt
export ORACLE_SID=(your database SID)
4. Type sqlplus "/ as sysdba"
5. Type password

make sure the logged user has DBA_ROLE in windows.
and
Check you have the following line in your sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES = (NTS)


[Updated on: Tue, 15 December 2009 04:55]

Report message to a moderator

Previous Topic: Database Prod Sever Monitoring
Next Topic: Can be copy a file from ASM file system to Unix file system without using RMAN
Goto Forum:
  


Current Time: Mon Jul 01 00:42:55 CDT 2024