cloning of ASM database to ASM datbase in test

hi,
I was using cloning procedure mentioned in metalink doc #

I started the new database in nomount mode on auxiliary

when i am trying to sqlplus system/manager@auxiliary - - I am getting new connections not allowed error.

ORA-12528 (TNS-12528)
TNS:listener: all appropriate instances are blocking new connections

i have added UR=A for the tnsnames of primary, auxiliary tnsnames file.

I am able to tnsping from primary to auxilairy but not sqlplus -- can anybody please help me on this??
ramavenkatesaAsked:
Who is Participating?
 
Richard OlutolaConnect With a Mentor ConsultantCommented:
tnsping only tests that the listener is running and it knows of the name you've requested but it does not test that the instance is running.

Give us a fuller picture.
Which machine is the auxiliary host and which is the target host?
Auxialiary is the machine you're cloning to and target is the machine you're cloning.

Are you using RMAN?
If you are then you run rman from the auxiliary host

eg
[oracle@hotel]$rman target sys/pwd@pilot1 auxiliary /

hotel - auxiliary machine
pilot1 - alias defined in the tnsnames.ora on the auxiliary host

first set the ORACLE_SID on the auxiliary machine before running the above command.

R.
0
 
ramavenkatesaAuthor Commented:
metalink doc # is 340848.1
0
 
ramavenkatesaAuthor Commented:
i tried using rman command from auxiliary
rman target sys/manager@sourcedb auxiliary /

I am getting the same error.
ORA-12528 (TNS-12528)
TNS:listener: all appropriate instances are blocking new connections

listener is running fine and accepting new connections.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Richard OlutolaConsultantCommented:
is sourcedb declared in your tnsnames.ora?

R.
0
 
Richard OlutolaConsultantCommented:
On both nodes, please type

lsnrctl services

and post the output. Also, identify the hosts and services/instances

R.
0
 
ramavenkatesaAuthor Commented:
yes.

If I dont declare in the tnsnames.ora of auxialiary database, can I tnsping the target db?

Also, I want to say that the auxiliary database is a new build.
i installed software, upgraded to 10.2.0.3 and created a sample database with a name using dbca.
0
 
Richard OlutolaConsultantCommented:
You're right. You must have declared the name. I posted the comment before I realised my oversight.

Please send details of lsnrctl services from both nodes.

R.
0
 
ramavenkatesaAuthor Commented:
can you please look into this one too?
http://www.experts-exchange.com/Database/Oracle/Q_26613841.html 
0
 
Richard OlutolaConsultantCommented:
Could you tell us what resolved this?
0
 
ramavenkatesaAuthor Commented:
instead of doing connection to auxiliary from prod , i connected from auxiliary to prod

rman target sys/passwd@prod catalog a/a@catalog auxiliary /
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.