| kirru |
Posted: Jan 18, 2008 06:42:11 AM |
Total Post: 4
Joined: Jan, 2008
|
Hi
I have installed Oracle10g on Red hat enterpirse edition. I have created database and all its working fine. But iam suffering with oracle below network error when i am saying like "lsnrctl start list4".
TNS-01150: The address of the specified listener name is incorrect
But when i am saying like "lsnrctl start" it is taking default port number and default listener.
Pls find my listener content also.
list4 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 160.6.210.225)(PORT = 4569))
)
)
)
SID_LIST_list4 =
(SID_LIST =
(SID_DESC =
(SID_NAME = FUTURE)
(ORACLE_HOME = /oraeng/app/oracle/product/10.2.0)
)
)
|
|
|
 Murtuja |
| Posted: Jan 18, 2008 07:37:25 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
For changing port ...
You need to edit both listener.ora and tnsnames.ora file then restart listener.
|
|
|
|
|
| kirru |
| Posted: Jan 18, 2008 08:17:52 AM | |
|
Total Post: 4
Joined: Jan, 2008
|
Murthuja
Thanks for u r reply. I configured parameters in the tnsnames.ora file.Still i am getting the same error.
1)TNS-01150: The address of the specified listener name is incorrect.
Pls find My tnsnames.ora contents also.
list4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 160.6.210.225)(PORT = 4569))
)
(CONNECT_DATA =
(SID_NAME = FUTURE)
)
)
|
|
|
|
|
| Murtuja |
| Posted: Jan 18, 2008 10:43:00 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
The Listener syntax is very sensitive.
So I will suggest you to create new listener using netca
Before this backup the old listener.ora for comparison.
|
|
|
|
|
| kirru |
| Posted: Jan 20, 2008 11:49:55 AM | |
|
Total Post: 4
Joined: Jan, 2008
|
Hi murtuja
I tried with the netca command to create listener.ora. It is showing some error like "Could not create listener" while creating listener.ora through oracle net configuration assistant.
|
|
|
|
|
| kirru |
| Posted: Jan 20, 2008 12:17:45 PM | |
|
Total Post: 4
Joined: Jan, 2008
|
Hi
My hostname, ipaddress pinging successfully without no issues. The ip address pinging from other computer also.
1)when i am try with this "tnsping list4" It is showing below error
Used parameter files:
/oraeng/app/oracle/product/10.2.0/sqlnet.ora
TNS-03505: Failed to resolve name.
2)When i am try with this option "lsnrctl stat list4" it is showing below error.
TNS-01150: The address of the specified listener name is incorrect
3)Pls find my listener.ora contents also
list4 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 160.6.210.225)(PORT = 6588))
)
)
)
SID_LIST_list4 =
(SID_LIST =
(SID_DESC =
(SID_NAME = FUTURE)
(ORACLE_HOME = /oraeng/app/oracle/product/10.2.0)
)
)
4) Pls find my tnsnames.ora contents also
list4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 160.6.210.225)(PORT = 6588))
)
(CONNECT_DATA =
(SID_NAME = FUTURE)
)
)
5)After that i tried to create new listener file using netca command. While creating through netca it showing below error.
"Could not create listener"
6)I installed oracle10g on redhat but where is the problem coming i dont know pls help me
I tried with the hostname, ip address no use.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
