3

From the thread What is the difference between sys and system accounts in Oracle databases?, I understand that sys schema is supposed to be used only by the database.

But still an administrator can change the password for the schema.

Can the database connect without the password? If not, how does it connect even after the password is changed?

Community
  • 1
Lazer
  • 3,361
  • 15
  • 43
  • 53

3 Answers3

9

The database doesn't bother authenticating itself to itself.

As the database does not use the password identification strategy when performing operations, changing the SYS password only impacts how humans can use the account.

Brian Ballsun-Stanton
  • 4,731
  • 2
  • 30
  • 36
4

At the shell prompt, on the machine your database runs on, as the Unix user your Oracle runs as, try:

$ sqlplus / as sysdba

No password is necessary. What is actually happening is that your session attaches directly to the shared memory that is your instance relying only on Unix permissions - there is actually no way for Oracle (or any process) to stop you doing this type of operation, so rather than fight it, they made it a feature.

Gaius
  • 11,238
  • 3
  • 32
  • 64
-1

yeah , you can conncet to database with no passwprd when you conncet as admin on serever :

$ sqlplus
username : sys as sysdba
password : (empty)

then the database open with idle . you can work with idle instance for some of activities

saeed.sh
  • 216
  • 2
  • 6
  • 17