DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: unix dba group logins fail

  1. #1
    Join Date
    Nov 2000
    Posts
    89
    Oracle People:

    I've got 5 oracle boxes and my scripts run great from crontab using:

    sqlplus -s / << eof_1 >> $LogFile

    before running the sql commands from the script. The script runs as oracle who is a member of the "dba" unix group who can just login direct using:

    sqlplus /

    HOWEVER ...
    One box gives the following error after the oracle user(member of dba group) runs the:
    sqlplus /

    ERROR: ORA-01017: invalid username/password; logon denied.

    This is very strange since all the boxes use the same unix oracle user: dba group system for logon. The initSID.ora is the same as the boxes that work !

    bad box:
    remote_os_authent = true
    os_authent_prefix = ""

    good box:
    remote_os_authent = true
    os_authent_prefix = ""

    Both of these machines are oracle 7.3.


    Thanx,
    Roger












  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    check for two task parameter on the bad box and see its pointing to that database or somewhere else ?

    There is something goofy goin on with your environment.

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