Home » RDBMS Server » Backup & Recovery » ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #223291] Thu, 08 March 2007 05:44 Go to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member
Hi,

Here i have create duplicate database for testing purpose using

RMAN.

This is my old listener file :


## OLD LISTENER.ORA
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = adaptime75)(PORT = 1521))
)
)


## NEW LISTENER.ORA

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)

( SID_DESC =
(GLOBAL_DBNAME=babudb)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = babudb)
)

)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = adaptime75)(PORT = 1521))
)
)


I have run this cmd.


C:\Documents and Settings\Administrator>rman TARGET=sys/babu@orcl AUXILIARY=sys/oracle@babudb

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Mar 8 17:09:56 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1143536025)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

What's the problem ?

Babu B

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #223292 is a reply to message #223291] Thu, 08 March 2007 05:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Your new listener.ora contains entries only for babudb.
Nothing abuot ORCL.
If ORCL is a seperate database in a seperate home/machine, start the listener for ORCL and check your tnsnames.ora ( from whereever you are doing this)

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #223357 is a reply to message #223292] Thu, 08 March 2007 11:15 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

I have create duplicate database using rman. Here i'm add listener name in listener.ora file.

Just restart listener it's working well.

Babu B

Report message to a moderator

Previous Topic: Restore from previous version
Next Topic: Copy contents of oradata
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 19:09:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.