Mariano
03 de Marzo del 2005

Hola. He instalado ORACLE 9i (release 1) en Red Hat 9. He conseguido finalizar la instalación sin que aparecieran errores, pero al ejecutar la herramienta de configuracion de la base de datos, empieza a dar distintos errores como:
- ORA-01092: ORACLE instance terminated.Disconnection forced.
- ORA-01034: ORACLE not available.

Y cuando hago:
sqlplus /nolog
connect / as sysdba
startup

el sistema se cuelga, no responde.

¿Alguien me puede ayudar?

Gracias.

sandra
03 de Marzo del 2005

Hola Soy de QRO., y estoy en la especialidad de BD, el problema que tienes es que la instasncia con la que estas conectado no es la correcta, entra con el usuario del dba para que veas cual es el usuario. Voy entrando, es el 01034.
El otro error tal vez sea por que han tirado base de datos, tienes que levantarla. Tal vez te sirva de algo, no soy muy experta en esto!!!

Adrian
03 de Marzo del 2005

Mira en el alert_log, ahí aparecerá la causa del ORA-01092

Saludos

jaoga
03 de Marzo del 2005

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.

oscar
03 de Marzo del 2005

en veces es falla de oracle

debes revisar en inicio/programas/herramientas administrativas/servicios que tods los oracle esten iniciados