Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01034: ORACLE not available while creating database
It sounds like the database is not getting created. Make sure that the ORACLE UNIX user is in the DBA group. You may also want to remove the password file in $ORACLE_HOME/dbs it is usually called orapwdSID.ora. It may be causing you to be prompted for a password when a connect internal is issued.
8.1.7 will work on Solaris. I installed one a couple of months back.
Stephen C. Ashmore
Brainbench MVP for Oracle Administration
http://www.brainbench.com
"Terence Chang" <peanutlen_at_yahoo.com> wrote in message
news:d5b78107.0107131126.1c06e6f_at_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
>
> (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 Sat Jul 14 2001 - 04:17:19 CDT