?
Solved

cloning of ASM database to ASM datbase in test

Posted on 2010-11-12
10
Medium Priority
?
775 Views
Last Modified: 2012-06-27
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
Comment
Question by:ramavenkatesa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 

Author Comment

by:ramavenkatesa
ID: 34126149
metalink doc # is 340848.1
0
 
LVL 16

Accepted Solution

by:
Richard Olutola earned 2000 total points
ID: 34130476
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
 

Author Comment

by:ramavenkatesa
ID: 34131293
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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 16

Expert Comment

by:Richard Olutola
ID: 34131307
is sourcedb declared in your tnsnames.ora?

R.
0
 
LVL 16

Expert Comment

by:Richard Olutola
ID: 34131318
On both nodes, please type

lsnrctl services

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

R.
0
 

Author Comment

by:ramavenkatesa
ID: 34131324
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
 
LVL 16

Expert Comment

by:Richard Olutola
ID: 34131337
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
 

Author Comment

by:ramavenkatesa
ID: 34131362
can you please look into this one too?
http://www.experts-exchange.com/Database/Oracle/Q_26613841.html 
0
 
LVL 16

Expert Comment

by:Richard Olutola
ID: 34636132
Could you tell us what resolved this?
0
 

Author Comment

by:ramavenkatesa
ID: 34637999
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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question