problem with listener

[raf]

hi,
I've installed oracle 8.1.7 server with two istance
IMM1
IMM2
IMM2 run correctly, but when I started IMM1 I get this error:
ORA-12541:TNS:NO LISTENER

the listener is up (status listener is OK)
this is the file listener.ora:
IMM2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imm2)
)
)

IMM1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imm1)
)
)

tnsping imm1 run correctly

How can I started imm1???

Thanks
Raf

[Sameer]

Different port for imm1

Sameer

[raf]

Originally posted by Sameer
Different port for imm1

Sameer

the port is same
This is the tnsnames.ora:
IMM2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imm2)
)
)

IMM1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imm1)
)
)

[jovery]

If the first file is your listener.ora you are trying to configure 2 listeners which is why Sameer suggested that you must have two different port numbers.

Are you trying to create two listeners? or do you want one listener for the two services?

Regards

[raf]

Originally posted by jovery
If the first file is your listener.ora you are trying to configure 2 listeners which is why Sameer suggested that you must have two different port numbers.

Are you trying to create two listeners? or do you want one listener for the two services?

Regards

Now I've just one listener for two istances.
must I create two listener necessarly??
how can I create a new listener for istance imm1?

Thanks
raf

[Calvin_Qiu]

Use different port as those genius said.

[jovery]

If you only want the one listener your listener.ora should look something like this

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )

Your services should auto register.

Regards

[Sameer]

I should have been more clear..forgot to write word "USE" two different ports

Use Net8 or you can manually edit listener.ora file to add settings for new listener and then start it using listener control

Sameer

[raf]

Originally posted by Sameer
I should have been more clear..forgot to write word "USE" two different ports

Use Net8 or you can manually edit listener.ora file to add settings for new listener and then start it using listener control

Sameer

sorry,
I've create a new listener (listener2) with net8 on port 1522
This is new listener.ora:
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1522))
)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = imm1)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = imm1)
)
(SID_DESC =
(GLOBAL_DBNAME = imm2)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = imm2)
)
)

after I've changed tnsnames.ora:
IMM2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imm2)
)
)

IMM1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = imm1)
)
)

but when I tried to connect I get this error:
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor

What I wrong??

Thanks
regards
Raf

[Sameer]

Check if the service_name parameter specified in listener.ora is same as that of in init.ora (parameter service_names)

If you haven't specified SERVICE_NAMES parameter in init.ora then change SERVICE_NAME of tnsnames.ora to SID

listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = stmn)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = /opt/oracle/product/8.1.6)
    )
  )

tnsnames.ora

ora4 = 
(DESCRIPTION =
 (ADDRESS_LIST =
   (ADDRESS =
      (COMMUNITY=TCP.world)
      (PROTOCOL=TCP)(Host=stmn)
      (Port=1521)
    )
 )
 (
  CONNECT_DATA=(SID=orcl)
 )
)

HTH

Sameer