This content has been marked as final. Show 13 replies
Check if you are able to connect using sqlplus to sys/oracle@teststand
If not then have some basic checks to resolve it as below
1. Verify if you have compatible client version with RDBMS db version
2. Client Server has only single oracle client binary installed
3. tnsnames.ora file contains proper TNS Entry formatting
4. Host which you are trying to connect is pingable & added in /etc/hosts
5. telnet Host Port is working
6. DB service/Listener you are trying to connect is up & running on hosted db server
7. tnsping <TNS_Alias> is working from client
8. sqlplus <user>@<TNS_Alias>/<password> is working
9. troubleshoot using below
I am using same windows7 system for DR testing I mean Test and Teststand both Db are on same machine.
tnsping/Sqlplus connectivity to both DB is successful.
Any other clue please.
Hi ,1 person found this helpful
Do you have password file created for teststand ?
Can you try with system .. Also can u paste sqlplus system@testand/<pwd> op here
Below is ouput .
SQL> startup nomount
ORACLE instance started.
Total System Global Area 150667264 bytes
Fixed Size 1373152 bytes
Variable Size 92277792 bytes
Database Buffers 50331648 bytes
Redo Buffers 6684672 bytes
Disconnected from Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - Pr
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL*Plus: Release 18.104.22.168.0 Production on Tue Apr 16 17:32:51 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ORA-12514: TNS:listener does not currently know of service requested in connect
And output of lsnrctl>status is as follows.
Service "test" has 1 instance(s).
Instance "teststand", status BLOCKED, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "ihistest", status READY, has 1 handler(s) for this service...
The command completed successfully
DB in nomount will not allow to connect , put it in mount stage & re-try
Also try with system or sys/<pwd> as sysdba
Check1 person found this helpful
RMAN-04006 And ORA-12514 During RMAN Duplicate [ID 883490.1]
it may be listener problem.refer below link.
post your listener entries.plz
Edited by: KR10822864 on Apr 16, 2013 5:31 AM
when i try to connect traget from auxillary it works for me without any error but otherway round is not working so was not sure whether to initiate rman duplicate from auxillary or not but will try .
when i try to connect traget from auxillary it works for me without any error but otherway round is not workingIt is because you do not have a static registration of the standby database with the listener on the standby server.
Add a static entry to the listener on the standby server.
Reload the listener and you should be able to connect the standby database from the primary database server.
SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME= <STANDBY SID>) (ORACLE_HOME=<ORACLE HOME path>) ) )
After changing Oracle_home also still same problem but when i try to connect from auxiliary DB to target DB it is working .
I want to copy test(target) to testsand(auxiliary) DB
Test DB is active open mode and teststand is in nomount state.
I tried following commands.
rman target / nocatalog sys/****@test
Now to duplicate can i try below command
duplicate auxiliary DB to target ;
Refer this on the listener setup for the creation of standby database.
Issue is Resolved using MOS Doc [ID 1075908.1] and also there was problem in listener.ora it was not closed properly (Closing Bracket missing).