RE: 9i startup on Linux

[Gogala, Mladen]

Title: 9i startup on Linux

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-----
From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 3:39 AM
To: Multiple recipients of list ORACLE-L
Subject: 9i startup on Linux

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:

[EMAIL PROTECTED] 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

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

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

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

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