Oracle-L: 9i startup on Linux

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Thu, 03 Apr 2003 00:38:36 -0800
Message-ID: <F001.005790A1.20030403003836@fatcity.com>

Hi!

I am having problems getting 9.2.0.3 started on Red Hat Linux 8. I've done the standard linking in rc3.d and the like.

But when I reboot the machine, Oracle is not automatically started when using an SPFILE. If I dump the spfile to a text init.ora, the output is a follows:

[root_at_stan root]# /bin/su - $ORA_OWNER -c $ORA_HOME/bin/dbstart

SQL*Plus: Release 9.2.0.3.0 - Production on Thu Apr 3 08:25:26 2003

SQL> ERROR:
ORA-12162: TNS:service name is incorrectly specified

SQL> ORA-12162: TNS:service name is incorrectly specified SQL>
Database "" warm started.

SQL*Plus: Release 9.2.0.3.0 - Production on Thu Apr 3 08:25:27 2003

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area 105976704 bytes

Fixed Size                   451456 bytes
Variable Size              83886080 bytes
Database Buffers           20971520 bytes
Redo Buffers                 667648 bytes

Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production

Database "OLLIE" warm started.

Is there anything special about dbstart/dbshut in regard to 9i?

Thanks,
Helmut

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Daiminger, Helmut
INET: Helmut.Daiminger_at_KirchGruppe.de

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 03 2003 - 02:38:36 CST