Problema al crear una BD con el dbca
Hola,
He instalado oracle 9.0.1 en una red hat 9. Pero cuando llega a la parte de crear la BD aparecen una serie de errores que impiden que se cree. En uno de ellos dice que la instancia de oracle no existe.
Q puede estar pasando??
Gracias.
He instalado oracle 9.0.1 en una red hat 9. Pero cuando llega a la parte de crear la BD aparecen una serie de errores que impiden que se cree. En uno de ellos dice que la instancia de oracle no existe.
Q puede estar pasando??
Gracias.
You are creating a database either through a create database script or manually from the command prompt and you receive the following error: ORA-1034: ORACLE not available Error: ORA 1034 Text: Oracle not available ------- ---------------------------------------------------------------------- Cause: Oracle was not started up. Possible causes include the following: The SGA requires more space than was allocated for it. The operating system variable pointing to the instance was improperly defined. Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. Retry after Oracle has been initialized. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform-specific Oracle documentation. Solution Description -------------------- Be sure you include the "startup nomount" command in your script or as one of your manual steps and that "startup nomount" appears just before the create database clause. Also, verify that the Oracle user has the necessary operating system permissions from the operating system AND as the Oracle user. Ensure that you are able to create a dummy file in the locations where you are creating the redo logs and the system datafile as listed in your create database statement. Also create a dummy file as an operating systems permissions test in the locations listed for the control files in your init<SID>.ora file. Explanation ----------- Without the "startup nomount" command Oracle will faile with an ORA-1034 error. Operating system permission problems can also cause the ORA-1034 error.
