Solved

cloning of ASM database to ASM datbase in test

Posted on 2010-11-12
10
762 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 500 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Create Index on a Materialized View 5 59
Oracle Distributed Transaction Lock Error ORA-01591 8 88
oracle collections 2 41
oracle query 3 34
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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 how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

732 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