Results 1 to 2 of 2

Thread: idle instance.

  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Exclamation Unanswered: idle instance.

    Hi
    When I login as oracle in Redhat9, I can give any connection string (e.g toto/tata as sysdba) to sqlplus to be connect to an idle instance and startup my Oracle instance. After open the database, I can do any thing (change password for any user, ...), still be connect with wrong user.
    In my init.ora file I have this
    "remote_login_passwordfile=EXCLUSIVE"
    I wanted only to connect with "sys/syspswd as sysdba" to start my instance.
    How could I do please?
    Thanks!

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    If you belong to the same group as the Oracle software owner and you log into the server and connect to the database as sysdba then the password file will be ignored since you have been authenticated at the O/S level. This only applies to users who belong to this group; other users connecting as sysdba will be authenticated using the password file.

Posting Permissions

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