Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35

    Exclamation Unanswered: weird Oracle problem

    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 <i>ALTER USER sys IDENTIFIED by syspass</i>, 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

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I suspect that the two following items are true.
    1) You are logged onto the computer as the user which owns the Oracle s/w installation directory tree.
    2) OS Authentication is enabled for this instance
    If/when both of these two are true then you don't need to supply any password to get logged into the Oracle DB.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35

    OS authentication

    Hi,

    Thanks for the reply. How can I disable OS authentication. I could not find any parameter in the dbca command line tool that could specify what kind of authentication to perform.

    The thing is that I need to create the database in a command line script and need to use a tool like dbca.

    Thanks,

    Pankaj

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    go to http://asktom.oracle.com & do a keyword search on "OS authentication"

    RTFM - http://download-west.oracle.com/docs...a96524/toc.htm
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •