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

[akwete]

Hi Raf,


Make sure the tnsname.ora file is also under network/admin folder of the directory in which imm1 is located.

C. K.
AppsDBA 11i

[harsh77]

Is it OK to have same port no for two instances? From your listner.ora file HOST is same and even PORT no is also same.. Is it ok?? I think you need to change the port no and then try...

Cheers !!

Harshal

[stecal]

Well, for one, that is not your listener.ora file. What you pasted in was all or part of your tnsnames.ora file.

The listener.ora file looks like this:
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stecalpc)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = db00)
(ORACLE_HOME = d:\oracle\ora81)
(SID_NAME = db00)
)
(SID_DESC =
(GLOBAL_DBNAME = cendb)
(ORACLE_HOME = d:\oracle\ora81)
(SID_NAME = cendb)
)
)

Make sure your SID is listed in the listener.ora file. You can have a gazillion SIDs listed for the listener on port 1521. If your listener was okay, you would have seen both instances registered, so what did you mean by "the listener is up (status listener is OK)?"