Originally posted by mooks
Thanks! But I tried to login as sysdba in a script, i got the following error...

ERROR at line 1:
ORA-01034: ORACLE not available

My database is up and I have no problem connecting manually.
Check your environment variables, are you setting them in the script.

Check your connect string, which home are you picking your connect string from.

Try running sqlplus and try connecting and see are you connecting to the correct database.

Is the correct database up.