OraFAQ Forum: Networking and Gateways » Regarding ORA-00119 error

Home » RDBMS Server » Networking and Gateways » Regarding ORA-00119 error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Regarding ORA-00119 error [message #267155]

Wed, 12 September 2007 10:45

rolex.mp
Messages: 161
Registered: February 2007

Senior Member

I am trying to install Oracle 11i Release 1 database(dbname : ADTASK) in my Unix machine .

After creating ORACLE_HOME i was trying with installing the database using DBCA . The unix machine already contains a few databases installed in them .

When I started with database creation it gave me the following error

ORA-00119 Invalid Specification for system parameter LOCAL_LISTENER
ORA-00132 : syntax error or unresolved network name 'LISTENER_ADTASK'
ORA-01078 : failure in processing system parameters

The listener.ora file is present at ORACLE_HOME/network/admin
but when i use lsnrctl to start the listener it checks the following directory for the listener.ora file

TNSLSNR for Linux: Version 11.1.0.3.0 - Beta
System parameter file is /etc/listener.ora

What should be done to resolve the same ?
How can i make it look for listener.ora file in the ORACLE_HOME/network/admin directory ?

Report message to a moderator

Re: Regarding ORA-00119 error [message #267172 is a reply to message #267155]

Wed, 12 September 2007 11:32

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-00119: invalid specification for system parameter %s
 *Cause: The syntax for the specified parameter is incorrect.
 *Action: Refer to the Oracle Reference Manual for the correct syntax.

ORA-00132: syntax error or unresolved network name '%s'
 *Cause:  Listener address has syntax error or cannot be resolved.
 *Action: If a network name is specified, check that it corresponds
          to an entry in TNSNAMES.ORA or other address repository
          as configured for your system. Make sure that the entry
          is syntactically correct.

Regards
Michel

Report message to a moderator

Re: Regarding ORA-00119 error [message #267315 is a reply to message #267172]

Thu, 13 September 2007 00:47

rolex.mp
Messages: 161
Registered: February 2007

Senior Member

The listener.ora file looks like this .
And when I am installing the database it is not pointing to this file instead it is looking for some other file which i did mention earlier.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /SLOTS/slot04/appmgr/pramohan/Ora11g_Home/product/11.1.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = ap6305rt.us.oracle.com)(PORT = 1522))
)
)

and the tnsnames.ora file has the following entry

LISTENER_ADTASK =
(ADDRESS = (PROTOCOL = TCP)(HOST = ap6305rt.us.oracle.com)(PORT = 1522))

adtask=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ap6305rt)(PORT=1522))(CONNECT_DATA=(SID=astask)))

Should i do any changes to the contents of these files ?
Since I am installing a server what is the use of checking tnsnames.ora and listener.ora during installation ? Since these two files will be needed only if i am collecting as client as far as i know ?
But i haven't done any installation , so I am not clear about what is going on

Report message to a moderator

Re: Regarding ORA-00119 error [message #267317 is a reply to message #267315]

Thu, 13 September 2007 00:52

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I suggest you to read Database Net Services Reference to know how to write the configuration files.
There are so many errors that I can't enumerate all.

Regards
Michel

Report message to a moderator

Re: Regarding ORA-00119 error [message #267472 is a reply to message #267315]

Thu, 13 September 2007 07:15

rolex.mp
Messages: 161
Registered: February 2007

Senior Member

I went through the document and made few changes to the tnsnames.ora file

Let me know where i went wrong or any more changes has to be done .

Still I'm facing the same error since as the DBCA runs the tnsnames.ora and init.ora file gets newly created , so may I know what has to be done .

tnsnames.ora looks like this after modification

LISTENER_ADTASK =
(ADDRESS = (PROTOCOL = TCP)(HOST = ap6305rt.us.oracle.com)(PORT = 1522))

ADTASK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ap6305rt.us.oracle.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = adtask)
)
)

Report message to a moderator

Re: Regarding ORA-00119 error [message #267475 is a reply to message #267472]

Thu, 13 September 2007 07:25

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Explain me what is the purpose of each bloc.
Do you make any change in listener.ora?

Regards
Michel

Report message to a moderator

Re: Regarding ORA-00119 error [message #267476 is a reply to message #267155]

Thu, 13 September 2007 07:34

rolex.mp
Messages: 161
Registered: February 2007

Senior Member

In the init.ora LOCAL_LISTENER is set to LISTENER_ADTASK ,
so it is described in the tnsnames.ora file

Address specifies the machine name and the port number used by the listener.
The address information of connect identifier contains the same information used for listener.
Since the server I am using is a dedicated one , I am mentioning it as dedicated.
Service name is the global database name.

No I didn't make any change to listener.ora

Let me know if my understanding is correct

Report message to a moderator

Previous Topic:	problems with listeners
Next Topic:	Error in listener.ora file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:10:25 CDT 2024