After entering my username and password, while accessing Sql/plus, I get the error code "Ora-01034" and message "Oracle Not Available"

This happens about 95% of the time I try to signon. I am running Oracle 81 and Developer 9I.

Here is one discussion on resolving the ORA-01034 error on 8i. Most likely, either your ORACLE_SID or ORACLE_HOME environment variable is set improperly. What are these environment variables set to on your system?



Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

This error means that SGA parameters in your database need more space than it allocated.
Thank you and with best regards

Waheed rashwan

Justin thanks for responding to my problem. I am somewhat new to Oracle and could not locate the Oracle_Sid or Oracle_Home to check what they are set at. If you could point in the right direction, it would be appreciated

[Thank you Waheed. I am new to Oracle. Could you give me some directions on where to locate the SGA parameters. Thank you again]Originally posted by wahras
 This error means that SGA parameters in your database need more space than it allocated.
Thank you and with best regards

Waheed rashwan
[/quote]

Thanks for assisting me in solving this problem. I increased the SGA and the problem is now gone.