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

Home -> Community -> Usenet -> c.d.o.server -> Re: listener won't start (TNS-12545 ) - how to shrink global dbname to 8 chars ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Jul 2002 19:43:19 +0200
Message-ID: <evgoju8282tch3slvmovmkk0v24ankvpt3@4ax.com>

On Mon, 22 Jul 2002 17:07:58 GMT, Enkidu Utnapishtim <utnapishtim43NOSPAM_at_hotmail.com> wrote:

>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.
>...

Also, the global name is in the control file. Changing it in listener.ora and init.ora only is not going to help. He needs to issue also
alter database rename global_name to <name without quotes>

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jul 22 2002 - 12:43:19 CDT