Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01034: ORACLE not available while creating database
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
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
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