Re: Listener Question

Sybrand Bakker wrote:

>On Tue, 30 Apr 2002 23:26:58 -0400, stinky
><stankonia_at_stunkitystunk.org> wrote:
>
>>Here's my LISTENER.ORA:
>>
>>LISTENER =
>> (DESCRIPTION_LIST =
>> (DESCRIPTION =
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = my.ip.add.ress)(PORT = 1521))
>> )
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
>> )
>> )
>> )
>>
>>SID_LIST_LISTENER =
>> (SID_LIST =
>> (SID_DESC =
>> (SID_NAME = PLSExtProc)
>> (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
>> (PROGRAM = extproc)
>> )
>> (SID_DESC =
>> (GLOBAL_DBNAME = stinky817.world)
>> (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
>> (SID_NAME = stinky817)
>> )
>> )
>>
>>
>>SQLNET.ORA
>>
>>NAMES.DIRECTORY_PATH= (TNSNAMES)
>>
>>
>>TNSNAMES.ORA (same in both cases....extraneous stuff excised)
>>
>>STINKY817 =
>> (DESCRIPTION =
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = my.ip.add.ress)(PORT = 1521))
>> )
>> (CONNECT_DATA =
>> (SERVICE_NAME = stinky817.world)
>> )
>> )
>>
>>
>>Thanks!
>>
>>P.S. I noticed in my $ORACLE_HOME/network/admin directory the following
>>files:
>>
>>listener02042811PM4228.bak
>>sqlnet02042811PM4228.bak
>>tnsnames02042811PM4228.bak
>>
>>There are several others. Are these files written there because I
>>connected to the database remotely from work? If so, is there anyway
>>I can route these to a different directory?
>>
>
>
>The *FULL* tnsnames.ora *PLEASE*.
>*WE* should determine what is *'EXTRANEOUS'*, not *YOU*
>as *ANY* syntax error in tnsnames.ora may result in 12514
>

I understand. I'm just a bit reluctant to copy stuff that pertains to work. I'll post them when I get home from work but I'll just modify the ip addresses and SID's.

>
>
>It strikes me you are using SID_NAME in listener.ora and SERVICE_NAME
>in tnsnames.ora. 12514 means 'The *SERVICE_NAME* in tnsnames.ora
>doesn't equate the *SERVICE_NAME* in *INIT*.ora (and the service_name
>in init.ora is db_name||'.||db_domain if db_domain is not null or
>db_name if db_domain is null.
>

db_name is stinky817 and db_domain is world in my initstinky817.ora

>
>It looks like you are not telling us everything.
>

I guess the only thing left is to show the full TNSNAMES.ORA files.  I'll do that when I get home tonight.

>
>The .bak files are a result of using the net8 assistant.
>

Ahhh. I was playing around with netca.

>
>
>Hth
>
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
>
Received on Wed May 01 2002 - 04:49:44 CDT