Solved

cloning of ASM database to ASM datbase in test

Posted on 2010-11-12
10
752 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

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…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

808 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