problem with listener

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

Different port for imm1

Sameer

Quote:

---

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)
)
)

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

Quote:

---

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

Use different port as those genius said.

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

Code:

---

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

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

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

Sameer

Quote:

---

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

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

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

Code:

---

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

in the file initimm1.ora there are this parameter:
db_name = "imm1"

instance_name = imm1

service_names = imm1

the listener status is:
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srvimm)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc
tion
Start Date 05-NOV-2002 09:35:34
Uptime 0 days 4 hr. 57 min. 48 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora81\network\admin\listener.ora
Listener Log File C:\oracle\ora81\network\log\listener.log
Services Summary...
PLSExtProc has 1 service handler(s)
imm1 has 1 service handler(s)
imm1 has 2 service handler(s)
imm2 has 1 service handler(s)
imm2 has 3 service handler(s)
The command completed successfully

the services are:
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srvimm)(PORT=1521)))
Services Summary...
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
imm1 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
imm1 has 2 service handler(s)
DISPATCHER established:4 refused:0 current:12 max:16383 state:ready
D000
(ADDRESS=(PROTOCOL=tcp)(HOST=srvimm)(PORT=3251))
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
imm2 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
imm2 has 3 service handler(s)
DISPATCHER established:2 refused:0 current:1 max:1022 state:ready
D001
(ADDRESS=(PROTOCOL=tcp)(HOST=srvimm)(PORT=1040))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
D000
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srvimm)(PORT=1039))(PRESENTATION
=oracle.aurora.server.SGiopServer)(SESSION=RAW))
Presentation: oracle.aurora.server.SGiopServer
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
The command completed successfully

Are there errors??

regards
Raf

seems to be okay..

Did you try changing SERVICE_NAME to SID

Code:

---

(
  CONNECT_DATA=(SID=imm1)
 )

---

When you want to connect using svrmgrl try setting ORACLE_SID=imm1
as C:\set ORACLE_SID=imm1

Quote:

---

Originally posted by Sameer
seems to be okay..

Did you try changing SERVICE_NAME to SID

Code:

---

(
  CONNECT_DATA=(SID=imm1)
 )

---

When you want to connect using svrmgrl try setting ORACLE_SID=imm1
as C:\set ORACLE_SID=imm1

---

sorry,
I must change SERVICE_NAME to SID also in file initimm1.ora???

Thanks
Raf

Quote:

---

Originally posted by raf
sorry,
I must change SERVICE_NAME to SID also in file initimm1.ora???

Thanks
Raf

---

No.. Though we specify SERVICE_NAMES in init.ora, we won't use it..
SID is not a valid parameter in init.ora

Just change only in tnsnames.ora and as I said before svrmgrl set it on DOS prompt

Sameer

Quote:

---

Originally posted by raf
sorry,
I must change SERVICE_NAME to SID also in file initimm1.ora???

Thanks
Raf

---

I changed service_name to sid in tnsnames.ora but I get always the same error:
NO LISTENER

You think that I must drop the istance imm1??

raf

Now you are saying you get NO LISTENER error.. NO LISTENER and invalid SERVICE_NAME are different errors

stop all the instances, stop the listener, Try commenting INSTANCE_NAMES in both in init.ora.

And restart instance, listener

Quote:

---

Originally posted by Sameer
Now you are saying you get NO LISTENER error.. NO LISTENER and invalid SERVICE_NAME are different errors

stop all the instances, stop the listener, Try commenting INSTANCE_NAMES in both in init.ora.

And restart instance, listener

---

so,
I must shutdown oracle
stop listener in services of win2000
comment instance_name in intiimm1 and initimm2
startup oracle
start listener

is correct???

Raf

startup listener
startup database

I done shutdown abort and startup database
When I stop and restart listener, istance imm1 run correctly but when I connect to imm2 e after reconnect to imm1 I get error:
NO LISTENER
if I restart listener from services of control panel (win200) imm1 run correctly.

How can I resolve this strange problem??

thanks
regards
Raf