Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2001
    Location
    The Netherlands
    Posts
    38

    Unanswered: Logon as sysdba from script

    I'm trying to logon to sqlplus as sysdba from a unix script:

    sqlplus /nolog << _eof
    connect system/pwd@dbtest as sysdba
    ...
    _eof

    This result in an 'insufficient privileges' error.
    If I run the command interactively I get the same result unless I leave out the password:

    $sqlplus /nolog
    connect system@dbtest as sysdba
    password: pwd

    ok

    Is there a way I can do this from a script?

  2. #2
    Join Date
    Apr 2002
    Posts
    31
    Check following:
    connect / as sysdba

    Get more info about password file

    HTH,
    OBRP

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    You have to do some changes on the remote database. The procedure was explained in details Here


    Check the latest Oracle DBA forums at:
    http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi


    Hope that helps,


Posting Permissions

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