How to manually delete oracle background processes? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: How to manually delete oracle background processes?

  1. #11
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I suspect your environment is not setup correctly. You can set an ORACLE_SID that doesn't exist and then shutdown abort and it looks just like a successful shutdown.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  2. #12
    Join Date
    Feb 2006
    Posts
    12
    I have set ORACLE_BASE and ORACLE_HOME in my script and everytime i run the sqlplus function, i set ORACLE_SID, as shown below....

    # VARIABLES
    ORACLE_BASE="/u01/app/oracle"
    ORACLE_HOME="$ORACLE_BASE/product/10.2.0"

    echo "`export ORACLE_SID=${orcl_sid}`"
    run_sql "startup nomount pfile='$pfile';"

    Since this doesnt work, any suggestions on how to set up my environment correctly in my script?

  3. #13
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Perhaps I'm missing something here, but are you sure you're setting your ORACLE_SID correctly:

    Code:
    austin$ echo $SHELL
    /bin/bash
    austin$ unset ORACLE_SID
    austin$ echo $ORACLE_SID
    
    austin$ echo "`export ORACLE_SID=TESTDB`"
    
    austin$ echo $ORACLE_SID
    
    austin$ export ORACLE_SID=TESTDB
    austin$ echo $ORACLE_SID
    TESTDB
    austin$

  4. #14
    Join Date
    Feb 2006
    Posts
    12
    I guess I was doing it the wrong way all this time. I tried it the way you showed me, and it seems to work fine now.
    Thank you for your help and also thanks to the others who helped me solve my errors

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