Error rise TNSLSNR

[p43lo]

Personal,
I have a problem to raise the lsnrctl, follows below the error description will be that someone knows how to help me ..

Select all

[oracle@comodoro ~]$ lsnrctl start 
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 06-MAY-2013 13:18:29 
Copyright (c) 1991, 2010, Oracle.  All rights reserved. 
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... 
TNSLSNR for Linux: Version 10.2.0.5.0 - Production 
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log 
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) 
TNS-12542: TNS:address already in use 
 TNS-12560: TNS:protocol adapter error 
  TNS-00512: Address already in use 
   Linux Error: 98: Address already in use 
Listener failed to start. See the error message(s) above... 

[stcoutinho]

may already exist another service that is listening to port 1521. Verify that another listener already execution on this server or if another product is using port 1521 for your activities.

You can verify this in Linux through the netstat -a command

If port 1521 is being used by another listener or service, you can manually Edit the file " Listener.ora " from your instance and point to another port.

draws attention to the log message a little

Select all

Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

may be interesting to place HOST=<numero_ip_seu_servidor> and take the test again to see if the error repeats .

Hugs and good luck,

Sergio Coutinho

[p43lo]

He had no door in conflict but he had no listener. Then I tested it again and ran but still could not connect in the bank by the forms.
Logon error:

Select all

Problemas com a conexão. ORA-12505

Listener.ora

Select all

# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora 
# Generated by Oracle configuration tools. 
 
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0) 
      (PROGRAM = extproc) 
    ) 
  ) 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = TCP)[color=#BF4000](HOST = 10.0.76.132[/color])(PORT = 1521)) 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) 
    ) 
  ) 
~ 
~ 

tnsnames.ora

Select all

 
MVTRN = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)([color=#BF0040]HOST = 10.0.76.132[/color])(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = mvtrn) 
    ) 
  ) 
MVPROD = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = srvfis02)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = mvprod) 
    ) 
  ) 
 
~ 
~

[stcoutinho]

Hi,

Note that MVProd, registered as service_name in your TNSNAMES.ORA, is not in the SID relation of your listener.

You need to add the same in your Listener's SIDS list. Manually edit your listener file.

Hugs,

Sergio Coutinho

[p43lo]

Sorry for the TNS do not need MVProd. I did the inverse I removed it from the TNS (MVPROD)
turned as previously as below.

Select all

 
[oracle@comodoro ~]$ lsnrctl start 
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 07-MAY-2013 06:04:45 
Copyright (c) 1991, 2010, Oracle.  All rights reserved. 
TNS-01106: Listener using listener name LISTENER has already been started 
[oracle@comodoro ~]$ 

very strange face, I have DBAMV users, DBASGU among others ... in the bank only makes me select tables dbasug, I think it gave pit in the dump and still can not connect Forms.

[p43lo]

Sorry TNS I do not need MVProd. I did the inverse I removed it from the TNS (MVPROD)
turned as previously as below.

Select all

 
[oracle@comodoro ~]$ lsnrctl start 
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 07-MAY-2013 06:04:45 
Copyright (c) 1991, 2010, Oracle.  All rights reserved. 
TNS-01106: Listener using listener name LISTENER has already been started 
[oracle@comodoro ~]$ 

I still can not connect to the forms.

[stcoutinho]

Hi P43LO,

I think it would be interesting for you to register on Listener.ORa the instance SID in which you are trying to connect your forms.

Please take a look well at the end of the topic contained in this link: http://en.glufke.net/oracle/viewtopic.php?t=2439

If you continue in trouble, continue posting.

Hugs,

Sergio Coutinho

[p43lo]

Dude, I made everything I edited the TNS and nothing to run the connection, I analyzed all the content of the link you gave me but I still could not. Then came an idea of ??changing the name of the server puts in the fly the forms connected .. will know ..... follows below my modifications

I changed the hostname that was comodoro

Select all

hostname localhost

I changed the SYSCONFIG network

Select all

[root@comodoro ~]# vi /etc/sysconfig/network 
NETWORKING=yes 
NETWORKING_IPV6=no 
HOSTNAME=localhost

I confirmed the changes.

Select all

cat /proc/sys/kernel/hostname

I changed my tnsnames.ora

Select all

TRN_NOVO.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.76.132)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = mvtrn) 
    ) 
  ) 

Thank you very much for your help .... up to +