Re: dbstart : errormessages...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 21 Oct 2001 22:26:07 +0200
Message-ID: <tt79rbfc2rkt6b_at_corp.supernews.com>


<Corleone_at_mail.com> wrote in message
news:3bd2cd89.252763594_at_news.xs4all.nl...
> Hi
> I'm pretty new to all this Oracle and even Solaris stuff, but I'm
> learning.
>
> When I try to start my database.
> it answers :
>
> oracle [/opt/oracle] > dbstart
>
> SQL*Plus: Release 9.0.1.0.0 - Production on Sun Oct 21
> 14:36:48 2001
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> SQL> ERROR:
> Error while trying to retrieve text for error ORA-24314
>
>
> SQL> Error while trying to retrieve text for error ORA-12154
> SQL>
> Database "phildb" warm started.
>
>
> So I think it is up and running.
>
>
> When I try to figure out what's wrong I type :
>
> oracle [/opt/oracle] > truss dbstart
> execve("/usr/bin/sh", 0xFFBEFA94, 0xFFBEFAA0) argc = 2
> mmap(0x00000000, 8192, PROT_READ|PROT_WRITE|PROT_EXEC,
> MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF3A0000
> stat("/usr/bin/sh", 0xFFBEF7D0) = 0
> open("/var/ld/ld.config", O_RDONLY) Err#2 ENOENT
>
> ... and a whole lot of other Err#.. messages. Where can I find more
> information on these error messages ? I must have messed it up, but
> I'm trying to find out what.
>
> Thanks
> Léon

dbstart is (korn) shell script. I don't think running truss on it is of much use, cat or page would be more like it.
The error messages can be looked up in the Oracle Server Messages manual. The associated error message ('Error while retrieving text') indicate you are missing either the NLS_LANG environment variable, or the ORA_NLS<xx>_DATA environment variable.
The Getting started Manual has a list of required environment variables.

12154 is the famous 'can not resolve service name' and points to an invalid tnsnames.ora

Generally, before you push that install button, read at least the getting started manual and follow it *closely*

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Sun Oct 21 2001 - 22:26:07 CEST

Original text of this message