| Bishal |
Posted: Apr 30, 2008 07:05:36 AM |
Total Post: 196
Joined: Apr, 2008
|
When i connect with rman giving following command
rman> connect target/
connected to target databse bishal(DBID=....)
But when i give
rman> connect auxiliary sys/oracle/@dup(dup is the auxiliary database i am creating)
the output is:
Rman-4006: error from auxiliary database ORA-12154: TNS:coluld not resolve service name
Wat is the problem? what should be done? |
|
|
 Bishal |
| Posted: Apr 30, 2008 07:27:19 AM |  |
|
Total Post: 196
Joined: Apr, 2008
|
I think there is problem in tnsnames.ora file...
what should be done?
|
|
|
|
|
| GOPU |
| Posted: Apr 30, 2008 07:35:20 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
your Aux database is in which stage..i mena mount or nmount ?
|
|
|
|
|
| Bishal |
| Posted: Apr 30, 2008 07:42:23 AM | |
|
Total Post: 196
Joined: Apr, 2008
|
NOT IN ANY OF THEM... THE PROBLEM IS FOR DUPLICATION, ITS ASKING THE TARGET DATABASE MUST BE MOUNTED.. SO I STARTED INSTANCE BY MOUNTING TARGET DATABASE.. NOT AUXILIARY DATABASE
|
|
|
|
|
| Gitesh |
| Posted: Apr 30, 2008 08:00:20 AM | |
|
Total Post: 322
Joined: May, 2005
|
Dear....you are asking question and giving answer also.Great.
|
|
|
|
|
| Bishal |
| Posted: Apr 30, 2008 08:05:57 AM | |
|
Total Post: 196
Joined: Apr, 2008
|
but thats what i found out... now what can be the solution? how can i create auxiliary database?
|
|
|
|
|
| GOPU |
| Posted: Apr 30, 2008 08:18:26 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
Bishal,
do you checked this error..
ORA-12154: TNS:coluld not resolve service name
|
|
|
|
|
| arun |
| Posted: Apr 30, 2008 02:33:38 PM | |
|
Total Post: 28
Joined: Sep, 2007
|
If it is for duplication , you can connect to auxiliary database
from the database where it is available.
You cannot connect to auxiliary database from remote server or system.
Configure TNSnames.ora file for target database in auxliary database server,then connect target and auxiliary database.
It will work.
|
|
|
|
|
| Bishal |
| Posted: Apr 30, 2008 11:47:56 PM | |
|
Total Post: 196
Joined: Apr, 2008
|
No Gopu i could not resolve the error...
Arun, how to do whatever u mentioned?
|
|
|
|
|
| Mohammed Taj |
| Posted: May 01, 2008 02:00:06 AM | |
|
Total Post: 704
Joined: Jul, 2007
|
1. ORA-12154 : TNS:could not resolve the connect identifier specified
This error we received when we use “wrong” TNS_ENTRY” or “TNS_ENTRY” is not exist in TNSNAMES.ORA file
Just take above tnsnames.ora file there “tns_entry” is “TAJ” and service_name is “ORCL” now see…
SQL> conn scott/tiger@taj
Connected.
User is connected because TAJ is exist in tnsnames.ora file.
SQL> conn scott/tiger@orcl
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
User is not connected because ORCL is not a tns_entry.
|
|
|
|
|
| GOPU |
| Posted: May 01, 2008 11:19:59 PM | |
|
Total Post: 242
Joined: Apr, 2008
|
Hi,
check the error ORA-12154: TNS:coluld not resolve service name
i already mentioned to you that and TAJ demonstrated it in a good way.
hope you solved the issue
Regards
Gopu
|
|
|
|
|
| arun |
| Posted: May 02, 2008 06:30:31 AM | |
|
Total Post: 28
Joined: Sep, 2007
|
Primary Server - Target Server
Primary database Auxiliary database
( name : Test) (name : auxi)
Check the listener status ....... in Target Server
It shows status blocked
So you cannot connect the auxiliary database from Primary Server
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
Start Date 02-MAY-2008 12:47:16
Uptime 0 days 3 hr. 2 min. 45 sec
Trace Level admin
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora92\network\admin\listener.ora
Listener Log File C:\oracle\ora92\network\log\listener.log
Listener Trace File C:\oracle\ora92\network\trace\listener.trc
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=symantec)(PORT=1521)))
Services Summary...
Service "auxi" has 1 instance(s).
Instance "auxi", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
So try from target Server
It works.
Auxiliary database is in no mount mode.
C:\Documents and Settings\administrator>rman target sys/claw@test auxiliary sys/
oracle
recovery Manager: Release 9.2.0.1.0 - Production
copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: TEST (DBID=1951722569)
connected to auxiliary database: auxi (not mounted)
Arun
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
