Oracle-L: RE: 9i startup on Linux

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 03 Apr 2003 08:28:41 -0800
Message-ID: <F001.005796E0.20030403082841@fatcity.com>

Well, there is this little file called "/etc/oratab" and the dbca leaves a value of "N" in the last field.
The allowed values are "N" for No, "Y" for Yes and M for Maybe. The last field is there to determine
whether dbstart should start the oracle instance or not. The value of "M" is applicable only to
Win2k versions. If there is "N" in the /etc/oratab, dbstart will not start that database.

-----Original Message-----
Sent: Thursday, April 03, 2003 3:39 AM
To: Multiple recipients of list ORACLE-L

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: Gogala, Mladen
INET: MGogala_at_oxhp.com

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 - 10:28:41 CST