RE: 10g - ASM
- From: "Koivu, Lisa" <Lisa.Koivu@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 May 2004 13:02:52 -0400
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 //www.freelists.org/archives/oracle-l/=20
FAQ is at //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 //www.freelists.org/archives/oracle-l/=20
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
