Home » RDBMS Server » Backup & Recovery » RMAN connection (Oracle 11g)
RMAN connection [message #663599] Sat, 10 June 2017 14:12 Go to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
When I tried for :

$ : rman target sys/oracle@trgt
$ : rman catalog rman/rman@catdb

doesnot work. Error is:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12523: TNS:listener could not find instance appropriate for the client connection

but when tried separately:

$. oraenv
$ :trgt
$ :rman target /
rman>exit
$ :. oraenv
$ :catdb
$ :rman catalog rman/rman

which works. But it is not useful for practicals with CATALOG, DUPLICATE etc..

Please reply..
Re: RMAN connection [message #663600 is a reply to message #663599] Sat, 10 June 2017 14:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

Copy and paste your RMAN session, the WHOLE session, like that:
>rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sam. Juin 10 21:16:21 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: MIKB2 (DBID=288523517)

RMAN> exit


Recovery Manager complete.

>rman catalog rman/rman@catdb

Recovery Manager: Release 11.2.0.4.0 - Production on Sam. Juin 10 21:16:45 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified
This will let no doubt about what you do and get.

[Updated on: Sat, 10 June 2017 14:18]

Report message to a moderator

Re: RMAN connection [message #663601 is a reply to message #663599] Sat, 10 June 2017 14:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Note that the 2 following are different:
rman target sys/oracle@trgt
rman target /
The later one locally connects when the former requires:
1/ a valid tnsnames.ora file
2/ a valid tnsnames.ora entry
3/ a remote listener matching the tnsnames.ora entry

Re: RMAN connection [message #663602 is a reply to message #663601] Sat, 10 June 2017 14:45 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
/forum/fa/13544/0/Here Are my settings:
  • Attachment: image(2).png
    (Size: 101.31KB, Downloaded 1846 times)

[Updated on: Sat, 10 June 2017 14:53]

Report message to a moderator

Re: RMAN connection [message #663603 is a reply to message #663602] Sat, 10 June 2017 15:01 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TRGT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc01.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = trgt)
)
)

CATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc01.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = catdb)
)
)

TRGT1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc01.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = trgt1)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc01.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = orcl)
)
)


Re: RMAN connection [message #663604 is a reply to message #663603] Sat, 10 June 2017 15:03 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
The question is to connect to two instances trgt and catdb together.
Re: RMAN connection [message #663605 is a reply to message #663604] Sat, 10 June 2017 15:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

3 posts and none contain what I asked.
And FORMAT your post.

Re: RMAN connection [message #663606 is a reply to message #663605] Sat, 10 June 2017 15:13 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
I have included tnsnames.ora file
and listener registration images copies.

Re: RMAN connection [message #663607 is a reply to message #663606] Sat, 10 June 2017 15:23 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
TNSNAMES.ORA entry:
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TRGT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc01.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = trgt)
)
)

CATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc01.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = catdb)
)
)

Re: RMAN connection [message #663608 is a reply to message #663607] Sat, 10 June 2017 15:39 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
Here is my listener registration:
  • Attachment: image3.png
    (Size: 392.18KB, Downloaded 1784 times)
Re: RMAN connection [message #663609 is a reply to message #663608] Sat, 10 June 2017 15:45 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
If you need any more details...I can post them.
Re: RMAN connection [message #663610 is a reply to message #663609] Sat, 10 June 2017 23:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sat, 10 June 2017 21:18

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

Copy and paste your RMAN session, the WHOLE session, like that:
>rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sam. Juin 10 21:16:21 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: MIKB2 (DBID=288523517)

RMAN> exit


Recovery Manager complete.

>rman catalog rman/rman@catdb

Recovery Manager: Release 11.2.0.4.0 - Production on Sam. Juin 10 21:16:45 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified
This will let no doubt about what you do and get.
Re: RMAN connection [message #663612 is a reply to message #663610] Sun, 11 June 2017 02:41 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
TNSNAMES.ORA entry:
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TRGT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc01.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = trgt)
)
)

CATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc01.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = catdb)
)
)
  • Attachment: image3.png
    (Size: 392.18KB, Downloaded 1889 times)
Re: RMAN connection [message #663613 is a reply to message #663612] Sun, 11 June 2017 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do you REALLY think this is what I asked?
Do you REALLY think there is a match between my post and yours?

Re: RMAN connection [message #663614 is a reply to message #663613] Sun, 11 June 2017 02:52 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
According to message, Re: RMAN connection [message #663601 is a reply to message #663599], This is what you have asked.
Re: RMAN connection [message #663616 is a reply to message #663614] Sun, 11 June 2017 03:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This message has NO question and just give information, in the opposite ALL other ones have (and repeated in red and bold).
I give up.

Re: RMAN connection [message #663619 is a reply to message #663616] Sun, 11 June 2017 06:50 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
Quote:
conclusion is to change the question..
Re: RMAN connection [message #663620 is a reply to message #663602] Sun, 11 June 2017 08:27 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Many company sites block attachments. Many people refuse to open them for the same reason others block them. To show us what the listener knows, what prevents you from simply issuing (at a command prompt) "lsnrctl status", then copying the entire command and entire result, and pasting the text into your message?
Re: RMAN connection [message #663621 is a reply to message #663620] Sun, 11 June 2017 10:09 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pc01.localdomain)(PORT=1521)))
Services Summary...
Service "CATDB" has 1 instance(s).
  Instance "CATDB", status UNKNOWN, has 1 handler(s) for this service...
Service "Oracle8" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Service "TRGT" has 1 instance(s).
  Instance "TRGT", status UNKNOWN, has 1 handler(s) for this service...
Service "TRGT1" has 1 instance(s).
  Instance "TRGT1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Re: RMAN connection [message #663624 is a reply to message #663621] Sun, 11 June 2017 12:29 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
It looks as though your catdb database is not dynamically registered with the listener. Is it actually started? On what machine? Can you connect to it with SQL*Plus?
Re: RMAN connection [message #663625 is a reply to message #663621] Sun, 11 June 2017 12:42 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
And another thing - why are you requesting a pooled connection rather than a dedicated connection? If you have not configured a database resident connection pool, it won't work.
Re: RMAN connection [message #663626 is a reply to message #663625] Sun, 11 June 2017 13:07 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
The server connection type:
1. Dedicated Server
2. Shared Server
3. Server Pool
which is the connection type in databse registration on netmgr.
Re: RMAN connection [message #663628 is a reply to message #663626] Sun, 11 June 2017 13:25 Go to previous messageGo to next message
prash2017
Messages: 14
Registered: June 2017
Junior Member
It worked when I changed connection type to Dedicated Server.
Re: RMAN connection [message #663630 is a reply to message #663628] Sun, 11 June 2017 19:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
prash2017 wrote on Sun, 11 June 2017 11:25
It worked when I changed connection type to Dedicated Server.
which filename was changed?
Re: RMAN connection [message #663643 is a reply to message #663621] Mon, 12 June 2017 07:32 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
prash2017 wrote on Sun, 11 June 2017 10:09
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pc01.localdomain)(PORT=1521)))
Services Summary...
Service "CATDB" has 1 instance(s).
  Instance "CATDB", status UNKNOWN, has 1 handler(s) for this service...
Service "Oracle8" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Service "TRGT" has 1 instance(s).
  Instance "TRGT", status UNKNOWN, has 1 handler(s) for this service...
Service "TRGT1" has 1 instance(s).
  Instance "TRGT1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
You seem to have difficulty following directions. I asked for "copying the entire command and entire result, and pasting the text into your message?" (emphasis mine, here). So why did you not do as asked? the part you left out could also contain useful information. This entire thread has been an exercise in near-futility with people asking you for very specific information, and you continually giving incomplete responses ...
Previous Topic: how to import full 10g dmp file in oracle 11g using imp
Next Topic: Tablespace point in time recovery
Goto Forum:
  


Current Time: Thu Mar 28 17:55:43 CDT 2024