| anand |
Posted: Apr 28, 2008 08:53:54 AM |
Total Post: 8
Joined: Apr, 2008
|
Hi i am having listener problem.. The listeneer is running but its showing The listener supports no services.... and while going for rman m getting this error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Regards
Anand
|
|
|
 Murtuja |
| Posted: Apr 28, 2008 09:56:58 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
Execute below sql
alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip) (PORT = 1521))' scope=both sid='DBORCL1';
|
|
|
|
|
| anand |
| Posted: Apr 28, 2008 10:03:58 AM | |
|
Total Post: 8
Joined: Apr, 2008
|
But still i am getting the same error in rman... this is my listener.ora entry
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.122)(PORT = 1521))
)
)
SID_LIST_info =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = india)
)
)
|
|
|
|
|
| Murtuja |
| Posted: Apr 28, 2008 10:48:56 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
Read this two links,
http://forums.oracle.com/forums/thread.jspa?threadID=316611
http://www.dbmotive.com/oracle_error_codes.php?errcode=12514&type=ORA
|
|
|
|
|
| Gitesh |
| Posted: Apr 29, 2008 01:06:58 AM | |
|
Total Post: 322
Joined: May, 2005
|
what is the output of "tnsping" command?
|
|
|
|
|
| anand |
| Posted: May 01, 2008 03:13:52 AM | |
|
Total Post: 8
Joined: Apr, 2008
|
TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 01-MAY-2008 00:29:52
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = india)))
OK (0 msec)
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
