cannot connect dba account as sysdba from client sqlplus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: cannot connect dba account as sysdba from client sqlplus

  1. #1
    Join Date
    Jun 2003
    Posts
    22

    cannot connect dba account as sysdba from client sqlplus

    I have an account established with dba privileges (on 8.1.6) that can connect to the db with sysdba privileges using sqlplus command line from the linux prompt. This account cannot connect with sysdba privileges from a client (8.1.7) machine using SQL*Plus.

    My init.ora param os_authent_prefix = ""

    How can I get connect the dba account with sysdba privileges from the client machine?

    Thanks

  2. #2
    Join Date
    Jul 2003
    Posts
    59
    You need to set up a password file and add that user to it. See "Password File Authentication" in the Oracle Admin Guide.
    Tom Best

  3. #3
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    Use orapwd
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  4. #4
    Join Date
    Jun 2003
    Posts
    22
    Thanks Tom and Dilip got it working.

    These are the steps I took:
    1) revoke SYSDBA /SYSOPER privileges from the accounts
    2) shutdown databse
    3) use orapwd utility to create password file
    4) set init.ora param remote_login_passwordfile
    5) restart database

Posting Permissions

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



Click Here to Expand Forum to Full Width