Re: listener won't start (TNS-12545 ) - how to shrink global dbname to 8 chars ?

pj,

Tracking down Net8 errors can be one of the most frustrating things a DBA ever has to encounter. When all the normal things have been tried (eg, tnsping), you have to resort to reading the cryptic trace files that Net8 generates. However, before you go down that path, let me copy something from Chap 11 of the O'Reilly book, Oracle Net8 Configuration and Troubleshooting (hope I'm not violating any copyright laws here):

[begin quote]
GLOBAL_DBNAME
Identifies a database by its global name. This is a combination of the DB_NAME and DB_DOMAIN parameters in the instance initialization parameter file (INIT.ORA). The global name must also be listed as one of the names in the SERVICE_NAMES parameter, which is also found in the instance parameter file.
...
In Oracle7, the SID_NAME parameter was the only means for identifying the database instances serviced by a listener. The GLOBAL_DBNAME parameter was introduced with the release of Oracle8. When Oracle8i was released, the need to have a SID_DESC entry for a database was eliminated. Instances now register themselves with the listener. However, for purposes of backward compatibility, Net8 still supports both SID_NAME and GLOBAL_DBNAME.
[end quote]

You cannot change the DB_NAME (at least not easily). Is your init.ora DB_DOMAIN set to "solaris" or is it null? One thing I've also noticed (at least on the configuration I have here) is that the listener's GLOBAL_DBNAME must match what you get when you type the 'hostname' command.

Also, since your error is something about not being able to find a message file, do you have the env var TNS_ADMIN set? The Net8 message files are located in $ORACLE_HOME/network/mesg by default. The listener log is in $ORACLE_HOME/network/log by default. You can turn on tracing (files in $ORACLE_HOME/network/trace by default) by placing a line like this in listener.ora:

trace_level_listener = { user | admin | support }

Let me know if you already knew all this and need any other help.

Roger Crowley - DBA - LearningFramework

pj wrote:
> The listener won't start after the machine was rebooted
> (dbstart went off ok, tho):
>
> bash$ .../bin/lsnrctl start
>
> LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 22-JUL-2002
> 11:30:05
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Message 1070 not found; No message file for product=network,
> facility=TNSTNS-12545: Messag
> e 12545 not found; No message file for product=network, facility=TNS
> TNS-12560: Message 12560 not found; No message file for
> product=network, facility=TNS
> TNS-00515: Message 515 not found; No message file for
> product=network, facility=TNS
> Solaris Error: 2: No such file or directory
>
>
>
>
> I've changed my hostname in my listener.ora to IP number, but no
> difference (I could already ping it, anyway).
>
> However, my GLOBAL_DBNAME is over 8 characters (blade.solaris), and
> I just found an article online stating that to be a major limitation
> (too bad the install didn't tell me!)
>
> Grepping through the oracle home, I see it in four places:
>
> in dbs/initblade.ora (service_names = blade.solaris)
> in network/admin/listener.ora (GLOBAL_DBNAME = blade.solaris)
> in network/admin/tnsnames.ora (SERVICE_NAME = blade.solaris)
> <ditto previous>
>
> So I'll try changing all those occurrences -- but directly after
> the installation, the database was running -- why wasn't
> this a problem then ?
>
> Since that time, we've had to switch the machine off (the video
> power-saving mode apparently locks the kernel ?), and now the
> listener won't start.
>
>
> (ps: I am not getting any logs in my orahome -- "find . -mtime 1
> -print"
> shows me that nothing is changing -- how do you get any helpful logs
> ?)
>
>
> **** listener.ora ****
>
> # LISTENER.ORA Network Configuration File:
> /extra/OraHome1/network/admin/listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /extra/OraHome1)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = blade.solaris)
> (ORACLE_HOME = /extra/OraHome1)
> (SID_NAME = blade)
> )
> )
Received on Mon Jul 22 2002 - 12:07:58 CDT