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

From: pj <PeterJohannsen_at_hotmail.com>
Date: 22 Jul 2002 09:30:28 -0700
Message-ID: <4433d0a9.0207220830.92209cb@posting.google.com>

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 - 11:30:28 CDT