db creation failed: unable to attach to default host
Date: 1996/04/02
Message-ID: <4jsdl1$ch4_at_elbereth.leftbank.com>
I'm attempting to install Oracle 7.2 on a SPARC5 running Solaris 2.4 (with patch 101945-36 installed, as recommended in the Oracle install documentation). It's a pretty minimal installation, as the only purpose is to load data and allow people to browse it using the Oracle Web Server. So, no SQL*Net or protocol adapters, no Parallel or Distributed; just the Oracle7 Server, SQL*Plus, PL/SQL, Installer & docs, and whatever else the installer decided was necessary.
I set all mandatory environment vars as per the installation docs, answered all the promts in the installer, and it ran for a while. About halfway through the installation, I got a dialog box saying:
- DB Failure -----------------------------+
| |
| Database creation appears to have failed. Select [Yes] if you |
| would like to continue with the installation (software only) for |
| the rest of the selected products. Select [No] to abort |
| instalation. |
| |
| (Yes) (No) |
| |
| (Help...) (Cancel) |
| |
+----------------------------------------------------------------------+
Choosing Help brings up this useful advice: "You can still proceed with the installation of the remaining products,but only their software will be installed. The database and the selected products' database objects will have to be created at a later time. Alternately,you can abort the entire installation and retry at a later time."
At the time of the error, these were the last few entries in install.log:
--------------[ rdbms.ins 1638 ]--------------------------------------------->>> Creating crdb2A.sql database catalog and file creation script
--------------[ rdbms.ins 1750 ]---------------------------------------------Action: Running crdbA.sql
Command: (/usr/oracle/bin/sqldba _at_/usr/oracle/dbs/crdbA.sql), Out=/usr/oracle/orainst/install.log, Err=/usr/oracle/orainst/install.log {
SQL*DBA: Release 7.2.2.3.0 - Production on Tue Apr 2 16:53:33 1996
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
DBA-00314: unable to attach to default host
}
Status: 0
--------------[ rdbms.ins 1760 ]--------------------------------------------- --------------[ rdbms.ins 1776 ]---------------------------------------------Action: Using egrep to search for 'Statement processed' in the file: /usr/oracle/dbs/crdbA.lst in order to determine if the 'CREATE DATABASE' statement succeeded for the A database. Command: (egrep "Statement processed" /usr/oracle/dbs/crdbA.lst), Out=/usr/oracle/orainst/install.log, Err=/usr/oracle/orainst/install.log {
egrep: can't open /usr/oracle/dbs/crdbA.lst }
Status: 2
(( OIERR-SYSTEM: egrep "Statement processed" /usr/oracle/dbs/crdbA.lst ))
--------------[ rdbms.ins 1786 ]--------------------------------------------->>> ERROR: The 'CREATE DATABASE' statement for the A database failed. egrep failed to find 'Statement processed' in the file: /usr/oracle/dbs/crdbA.lst
>>> db_up_normal: false
The help on error DBA-00314 isn't very helpful - it recommends that I use the "SET INSTANCE" command, but I can't run sqldba. If I try to run sqldba from the command line, I get exactly the same error as shown in the install.log fragment above. Also, although it doesn't tell me, it leaves a corefile in /usr/oracle/dbs. Completing the "software only" installation doesn't fix the problem - I still can't use sqldba so I can't run and of the .sql files to create the database.
I'm not familiar with the concept of a "default hostname", and I couldn't find any references to it in the indexes of the Oracle7 Server Administrator's Guide or Server Concepts Manual. However, I'm not using SQL*Net, there is supposed to be only one instance of one Oracle7 server running on this one host, and the only users would be running sqldba or sqlplus on this same host, using "connect internal".
I'm stuck. Where do I look next?
- Cos (Ofer Inbar) -- cos_at_leftbank.com cos_at_cs.brandeis.edu
- The Left Bank Operation -- lbo_at_leftbank.com http://www.leftbank.com "I'm addicted to stress that's the way that I get things done if I'm not under pressure then I sleep too long and I hang around like a bum I think I'm going nowhere and that makes me nervous..." -- Jim Infantino, "Stress"