-
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
-
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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
-
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
-
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
Last edited by Sameer; 11-05-2002 at 08:25 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|