problem with listener

[raf]

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

[Sameer]

seems to be okay..

Did you try changing SERVICE_NAME to SID

(
  CONNECT_DATA=(SID=imm1)
 )

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

[raf]

Originally posted by Sameer
seems to be okay..

Did you try changing SERVICE_NAME to SID

(
  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

[Sameer]

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

[raf]

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

[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

[raf]

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

[Sameer]

startup listener
startup database

[raf]

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