Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 777
  • Last Modified:

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??
0
ramavenkatesa
Asked:
ramavenkatesa
  • 5
  • 5
1 Solution
 
ramavenkatesaAuthor Commented:
metalink doc # is 340848.1
0
 
Richard OlutolaConsultantCommented:
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:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now