Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What is the default password for SYS?

884659Mar 12 2012 — edited Mar 12 2012
I'm trying to connect to an Oracle 11gR2 database on Linux using sqlplus.

The sys user password version is 10G and sys is one of the usersname returned by the view dba_users_with_defpwd.

Issuing sqlplus sys will get the prompt Enter Password: but I have no idea what password I should enter.

I kind of remember that the installation has a screen to enter password for SYS but I'm not sure what has been done on that screen since I didn't do the installation.

Thanks for any help.

Comments

horia berca
Hi,

If you set the environment variables ORACLE_HOME and ORACLE_SID and the user you are using on the Linux box is the one you used when installed the Oracle software (you own the files); you will be able to connect as sys internally without the need to supply the password:

abc@xyz:~ $ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 12 13:59:42 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options

SQL>


Regards,
Horia
kuljeet singh -
if you want to reset the password of sys. you can recreate the password file with below cmd.

$ orapwd
Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n> nosysdba=<y/n>

where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA,
force - whether to overwrite existing file (opt),
nosysdba - whether to shut out the SYSDBA logon (opt for Database Vault only).
There are no spaces around the equal-to (=) character.



--kuljeet Singh
813964
sys password would be configured while creating the database or via password file .


you can connect as below

$ sqlplus
$ / as sysdba

OS user shoud habe the privs to connect to the database as DBA .

FYI there is no default password for SYS (like scoot/tiger :) )
IronDrake
Hi There,

Actually, when you create a database without providing a SYS or SYSTEM password Oracle creates these user with the following credentials:

SYS: change_on_install
SYSTEM: manager

It's a good practice to change this passwords after the database creation (you can specify this passwords in the CREATE DATABASE command).

Regards!
2 people found this helpful
Hans Forbrich
SYS is a special user. Eventually you want to learn a bit about it's password requirements from http://docs.oracle.com/cd/E11882_01/server.112/e25494/dba007.htm#i1006789

If you log on to the operating system on which the database s/w is installed, in command line as the user who owns the Oracle software, you will be able to run the command 
sqlplus / as sysdba
to log in. The password is required when you log in across the network (and SQLNet has been setup correctly) or from an OS user that does not have 'DBA' privs.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 9 2012
Added on Mar 12 2012
#database-security, #database-security-general
5 comments
419,328 views