-
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
-
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?
-
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$
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|