Hi everyone,

I am having a weird Oracle problem. I used the command line tool dbca (database configuration Assistant) to create an Oracle database like so:

dbca dbca -silent -createDatabase -templateName Transaction_Processing.dbc
-gdbname TESTDB -sid TESTDB

The database was successfully created. It said that the initial sys password was change_on_install.

The problem is that I could log onto as sys using any password and even when I did ALTER USER sys IDENTIFIED by syspass, it did not change the password. It says that the user has been altered but I can still logon as sys with any password.

Am I missing something? Please help!

Thanks,

Pankaj

Hi Pankaj,

With what user you ran the ALTER USER command

Rgds
TheLion

This is probably a very normal situation.

In your sqlnet.ora file, if SQLNET.AUTHENTICATION_SERVICES is set to NTS, Oracle is allowed to use NT's authentication facilities rather than passwords to authenticate users. If your Windows user is a member of the ORA_DBA group, and you are connecting on the same machine that the database is running on, you can log in as sys without a password.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC