Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
What is the default password for SYS?

884659
Member Posts: 83
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.
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.
Answers
-
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 -
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 -
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)
-
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! -
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 commandsqlplus / 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.
This discussion has been closed.