Listener does not initialize

[ErickSergi]

Environment information:
* Oracle version: Oracle 10g 10.2.0
* Operating system: Server 2008 Standard 64 Bits.

Good evening guys, I'm new here and I'm in need of your help.
I know the Basics of Oracle, install and mount banks, generate backup, things like.
I am in a company (customer) who uses Oracle, our dear IT friend changed the name of the network card together with the server name after the Oracle installation.
Only after the modifications carried out by the same, he restarted the machine and Listener no longer started. What do I do ? Can you see the name of the machine to return and the name of the network to return to what was before and try to make the listener boot?

[madmax]

Hello Erick.

You must go to the TNSNAMES.ORA and LISTENER.ORA files and change the name of the server, so i start the service afterwards.
EXAMPLE TNSNAMES
before my server called

Select all

ORALOCAL = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = madmax)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = ORALOCAL) 
    ) 
  )

after change

Select all

ORALOCAL = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = madmax_novo)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = ORALOCAL) 
    ) 
  ) 

The listener and the same

Select all

LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = MADMAX_NOVO)(PORT = 1521)) 
    ) 
  )

After altering goes in DOS and type:
lsnrctl stop -> To stop the service
Then type lsnrctl start -> Starts the service

and test the connection to the bank.


I hope I have helped.