Unable to find error file (orapwd)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Unable to find error file (orapwd)

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Location
    Stockholm, Sweden
    Posts
    33
    I've made a shellscript which I run as root...

    Everything works BUT i receive theese 2 error messages
    when running orawpd command to create a passwordfile.


    In the script I su to user oracle and then execute orapwd..

    ------------------------------------------------------------------
    Scenario one:

    su oracle -c "$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwSID password=***** "

    Error message:
    Unable to find error file

    ------------------------------------------------------------------
    Scenario two:

    su - oracle -c "$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwSID password=***** "

    Sun Microsystems Inc. SunOS 5.8 Generic February 2000
    stty: : Inappropriate ioctl for device
    ------------------------------------------------------------------

    Any clues??

    Anyhow my script creates a working password file...


  2. #2
    Join Date
    Mar 2001
    Posts
    314
    In scenario one: the oracle environment will not be set up properly - the oracle user will inherit the root environment - so variables like ORACLE_HOME will be undefined.

    In the second scenario, your command will be executed properly. The reason you are getting the message, I believe, is that you have a "stty" command in the oracle ".cshrc" file - move this command to the oracle user ".login" file and the error message should go away.

    Hope this helps - let me know the result please!

    -amar

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