asked on
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??
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??
Oracle Database
Last Comment
ramavenkatesa
ASKER
metalink doc # is 340848.1
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
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.
is sourcedb declared in your tnsnames.ora?
R.
R.
On both nodes, please type
lsnrctl services
and post the output. Also, identify the hosts and services/instances
R.
lsnrctl services
and post the output. Also, identify the hosts and services/instances
R.
ASKER
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.
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.
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.
Please send details of lsnrctl services from both nodes.
R.
ASKER
can you please look into this one too?
https://www.experts-exchange.com/questions/26613841/moving-oracle-home-to-new-home-for-1-database.html
https://www.experts-exchange.com/questions/26613841/moving-oracle-home-to-new-home-for-1-database.html
Could you tell us what resolved this?
ASKER
instead of doing connection to auxiliary from prod , i connected from auxiliary to prod
rman target sys/passwd@prod catalog a/a@catalog auxiliary /
rman target sys/passwd@prod catalog a/a@catalog auxiliary /