| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 10g - ASM
Lisa,
From the 9.2 Database Reference guide about the LOCAL_LISTENER...
LOCAL_LISTENER
Parameter type string
Syntax LOCAL_LISTENER = network_name
Default value (ADDRESS = (PROTOCOL=TCP) (HOST=)
(PORT=1521))
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_at_Cendant-TRG.com 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.=20
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=3D (NTS)
NAMES.DIRECTORY_PATH=3D (TNSNAMES, ONAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN =3D ffci.com
Tnsnames reflects the ffci.com. I'd appreciate000 any suggestions you have. =20
Every time I see KG I think of Kevin Garnett... =20
-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal_at_yahoo.com]=20
Sent: Monday, May 10, 2004 5:22 PM
To: oracle-l_at_freelists.org
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
"The sender believes that this E-Mail and any attachments were free of
=
any virus, worm, Trojan horse, and/or malicious code when sent. This =
message and its attachments could have been infected during =
transmission. By reading the message and opening any attachments, the
=
recipient accepts full responsibility for taking proactive and remedial
=
action about viruses and other defects. The sender's business entity is
=
not liable for any loss or damage arising in any way from this message
=
or its attachments."
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |