You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
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 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
Quote:
quote:Originally posted by Justin Cave
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?
[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