ORA-01034: ORACLE not available while creating database

From: Terence Chang <peanutlen_at_yahoo.com>
Date: Sat, 21 Jul 2001 21:37:31 GMT
Message-ID: <d5b78107.0107131126.1c06e6f@posting.google.com>

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

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 Sat Jul 21 2001 - 16:37:31 CDT