10g - ASM 2004-05-11 - By Ron Rogers
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@(protected) 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 (See ORA-00119.ora-code.com): invalid specification for system parameter LOCAL_LISTENER
ORA-00132 (See ORA-00132.ora-code.com): 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 (See ORA-00119.ora-code.com): invalid specification for system parameter LOCAL_LISTENER
ORA-00132 (See ORA-00132.ora-code.com): 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@(protected)]=20
Sent: Monday, May 10, 2004 5:22 PM
To: oracle-l@(protected)
Subject: Re: 10g - ASM
Lisa:
I think I can help you if you post the complete error stack.
If you are getting ORA-119 (See ORA-119.ora-code.com)/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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
"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. "
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
