RE: 10g - ASM

Hi Ron,=20

Yes, there is a tnsnames.ora.  The fully qualified ADDRESS string you
show below fails with errors.=20

Thanks for your response
Lisa

-----Original Message-----
From: Ron Rogers [mailto:RROGERS@xxxxxxxxxxxxx]=20
Sent: Tuesday, May 11, 2004 12:02 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: 10g - ASM

Lisa,
 From the 9.2 Database Reference guide about the LOCAL_LISTENER...
LOCAL_LISTENER
       Parameter type     string
       Syntax                   LOCAL_LISTENER =3D network_name
       Default value         (ADDRESS =3D (PROTOCOL=3DTCP) (HOST=3D)
(PORT=3D1521))
       Parameter class      Dynamic:ALTER SYSTEM

       LOCAL_LISTENER specifies a network name that resolves to an
address or address list of Oracle Net local listeners (that is,
listeners that are running on the same machine as this instance). The
address or address list is specified in the TNSNAMES.ORA file or other
address respository as configured for your system.

Is there a local TNSNAMES.ORA on the server?
Just a thought.
Ron

>>> Lisa.Koivu@xxxxxxxxxxxxxxx 05/11/2004 11:27:25 AM >>>
Hi KG, here is what I get when I try to start the instance:

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER'
SQL>

Also doesn't work with the fully qualified name from tnsnames, like
Mladen suggested.=3D20

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name '+ASM.FFCI.COM'
SQL>

I added the following to sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES=3D3D (NTS)
NAMES.DIRECTORY_PATH=3D3D (TNSNAMES, ONAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN =3D3D ffci.com

Tnsnames reflects the ffci.com.  I'd appreciate000 any suggestions you
have. =3D20

Every time I see KG I think of Kevin Garnett... =3D20

-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal@xxxxxxxxx]=3D20=20
Sent: Monday, May 10, 2004 5:22 PM
To: oracle-l@xxxxxxxxxxxxx=20
Subject: Re: 10g - ASM

Lisa:

I think I can help you if you post the complete error stack.
If you are getting ORA-119/132, you can just add a TNS
entry for that crippling network name and start the ASM instance.

KG

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx=20
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/=20
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20
-----------------------------------------------------------------

"The sender believes that this E-Mail and any attachments were free of
=3D
any virus, worm, Trojan horse, and/or malicious code when sent. This =3D
message and its attachments could have been infected during =3D
transmission.  By reading the message and opening any attachments, the
=3D
recipient accepts full responsibility for taking proactive and remedial
=3D
action about viruses and other defects. The sender's business entity is
=3D
not liable for any loss or damage arising in any way from this message
=3D
or its attachments."

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx=20
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/=20
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: