export parameter

Shell Programming and Scripting
1

Hi,
What all parameters need to set up for in shell script which includes export command.iam passing dbname and password to my shell script..now how to set the environment variables in the shell script..ignore the dump file name and log file name ..i will manage it
Thanks,
Shruti

2

Please post the code for which you are
having problems.
Also, post the OS ,version, shell etc. etc.

3

os i s unix..version of oracle is 9.2.0.5.iam nto facing any problems..but not able to login to database using the shell script .i think i need to set the orasid all those..iam not sure ..which are al needed.so pls tell me if any body is having idea about this..thank you

4

#!/bin/bash
#Set the environment variables for Oracle here
#e.g. export ORACLE_HOME="/u01/oracle9i"

sqlplus -s /nolog <<EOF
conn sys/your_sys_passwd as sysdba
startup
exit
EOF

Also, search for other posts in the forum on the same topic for any variants etc.

5

#Set the environment variables for Oracle here
#e.g. export ORACLE_HOME="/u01/oracle9i"

i want to know wat needs to be set here..i know environment variables comes here..but what are all needed...? :confused:

6

You may also need to set up your
ORACLE_SID=<your_oracle_sid>
Besides this make sure oracle is in your PATH.

Give this a try and if does'nt work post the error messages.