Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
10g - ASM

10g - ASM

2004-05-11       - By Ron Rogers

Reply:     <<     11     12     13     14     15     16     17     18     19     20     >>  

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