What is the default password for SYS?

884659

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.

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:

[email protected]:~ $ 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!

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.