Re: ORA-01034: ORACLE not available while creating database

Do you get any trace files at all?
Have you checked the create log?
Are there no errors in the alert file, (it looks as if you are looking in the $ORACLE_HOME/dbs/alert..., have you
checked for more log files)?
Try to let dbassist generate the script files for generating the database, and run them manually for
checking errors.

Terence Chang wrote:

> All:
>
> I have followed all posts here and on metalink, but still can not
> solve the problem when I create a new Oracle 8.1.7 database(12 times)
> by dbassist after install the database software(7 times). I always get
> ORA-01034: ORACLE not available error.
>
> I have a machine like this.
> SUN Blade 100 with 512MB membory, 12GB disk space for /export/home
> which is the place to install oracle software and data files.
>
> This is the /etc/system file setting which is from the Oracle
> Installation Guide.
>
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=200
> set shmsys:shminfo_shmseg=10
> set semsys:seminfo_semmni=100
> set semsys:seminfo_semmsl=100
> set semsys:seminfo_semmns=200
> set semsys:seminfo_semopm=100
> set semsys:seminfo_semvmx=32767
>
> I have .profile setup correctly for the oracle user. When I use the
> dbassist to create a new database with all default settings, it stops
> at the screen which shows the progress to create database component
> (time, jserver, SQL*Plus Help etc) with ORA-01034: Oracle Not
> Available error.
>
> It creates the folder and generates the initSUNORA01.ora under
> $ORACLE_HOME/admin/.pfile with this data without any control files and
> data files. This is the content of the initSUNORA01.ora.
>
> db_name = "SUNORA01"
> instance_name = SUNORA01
> service_names = SUNORA01
> control_files = ("/export/home/oracle/oradata/SUNORA01/control01.ctl",
> "/export/home/oracle/oradata/SUNORA01/control02.ctl",
> "/export/home/oracle/oradata/SUNORA01/control03.ctl")
> open_cursors = 300
> max_enabled_roles = 30
> db_block_buffers = 18500
> shared_pool_size = 50518835
> large_pool_size = 614400
> java_pool_size = 20971520
> log_checkpoint_interval = 10000
> log_checkpoint_timeout = 1800
> processes = 150
> log_buffer = 163840
>
> I can do svrmgrl internal. It says the following errors.
> SVRMGR> show sga
> ORA-01012: not logged on
> SVRMGR> connect internal
> Password: oracle
> Connected.
>
> I also try to see if LISTENER is started. It is.
>
> $ lsnrctl status LISTENER
>
> LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 13-JUL-2001
> 12:03:41
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=AZPHX01SV007)(PORT=1521)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Solaris: Version 8.1.7.0.0 -
> Production
> Start Date 12-JUL-2001 11:30:34
> Uptime 1 days 0 hr. 33 min. 6 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File
> /export/home/oracle/product/8.1.7/network/admin/listener.ora
> Listener Log File
> /export/home/oracle/product/8.1.7/network/log/listener.log
> Services Summary...
> PLSExtProc has 1 service handler(s)
> SUNORA01 has 1 service handler(s)
> The command completed successfully
>
> I also found the message in the alert_SUNORA01.log.
> Thu Jul 12 12:51:58 2001
> Starting ORACLE instance (normal)
> Thu Jul 12 13:03:19 2001
> Starting ORACLE instance (normal)
> Thu Jul 12 13:05:02 2001
> Starting ORACLE instance (normal)
> Thu Jul 12 21:41:46 2001
> Starting ORACLE instance (normal)
>
> and in crdb1.log
> Connected.
> ORA-03113: end-of-file on communication channel
> CREATE DATABASE "SUNORA01"
> *
> ORA-03114: not connected to ORACLE
> Disconnected.
>
> What did I do wrong? I have Oracle running on NT without any problem.
> I just move to UNIX and get no luck. I tried to install the whole
> Oracle 8.1.7 seven times. Created database 12 times. Sometimes it
> generate the initSID.ora files, soemtimes it doesn't. I am desperated
> on this. Please help.
>
> Thanks!
>
> peanutlen_at_yahoo.com
Received on Sun Jul 15 2001 - 13:12:08 CDT