OraFAQ Forum: Backup & Recovery » RMAN connection

Home » RDBMS Server » Backup & Recovery » RMAN connection (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN connection [message #663599]

Sat, 10 June 2017 14:12

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..

Report message to a moderator

Re: RMAN connection [message #663600 is a reply to message #663599]

Sat, 10 June 2017 14:18

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: RMAN connection [message #663602 is a reply to message #663601]

Sat, 10 June 2017 14:45

prash2017
Messages: 14
Registered: June 2017

Junior Member

/forum/fa/13544/0/

Here Are my settings:

Attachment: image(2).png
(Size: 101.31KB, Downloaded 2343 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

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)
)
)

Report message to a moderator

Re: RMAN connection [message #663604 is a reply to message #663603]

Sat, 10 June 2017 15:03

prash2017
Messages: 14
Registered: June 2017

Junior Member

The question is to connect to two instances trgt and catdb together.

Report message to a moderator

Re: RMAN connection [message #663605 is a reply to message #663604]

Sat, 10 June 2017 15:06

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: RMAN connection [message #663606 is a reply to message #663605]

Sat, 10 June 2017 15:13

prash2017
Messages: 14
Registered: June 2017

Junior Member

I have included tnsnames.ora file
and listener registration images copies.

Report message to a moderator

Re: RMAN connection [message #663607 is a reply to message #663606]

Sat, 10 June 2017 15:23

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)
)
)

Report message to a moderator

Re: RMAN connection [message #663608 is a reply to message #663607]

Sat, 10 June 2017 15:39

prash2017
Messages: 14
Registered: June 2017

Junior Member

Here is my listener registration:

Attachment: image3.png
(Size: 392.18KB, Downloaded 2311 times)

Report message to a moderator

Re: RMAN connection [message #663609 is a reply to message #663608]

Sat, 10 June 2017 15:45

prash2017
Messages: 14
Registered: June 2017

Junior Member

If you need any more details...I can post them.

Report message to a moderator

Re: RMAN connection [message #663610 is a reply to message #663609]

Sat, 10 June 2017 23:46

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: RMAN connection [message #663612 is a reply to message #663610]

Sun, 11 June 2017 02:41

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 2409 times)

Report message to a moderator

Re: RMAN connection [message #663613 is a reply to message #663612]

Sun, 11 June 2017 02:45

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: RMAN connection [message #663614 is a reply to message #663613]

Sun, 11 June 2017 02:52

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.

Report message to a moderator

Re: RMAN connection [message #663616 is a reply to message #663614]

Sun, 11 June 2017 03:30

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: RMAN connection [message #663619 is a reply to message #663616]

Sun, 11 June 2017 06:50

prash2017
Messages: 14
Registered: June 2017

Junior Member

Quote:

conclusion is to change the question..

Report message to a moderator

Re: RMAN connection [message #663620 is a reply to message #663602]

Sun, 11 June 2017 08:27

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?

Report message to a moderator

Re: RMAN connection [message #663621 is a reply to message #663620]

Sun, 11 June 2017 10:09

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

Report message to a moderator

Re: RMAN connection [message #663624 is a reply to message #663621]

Sun, 11 June 2017 12:29

John Watson
Messages: 8963
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?

Report message to a moderator

Re: RMAN connection [message #663625 is a reply to message #663621]

Sun, 11 June 2017 12:42

John Watson
Messages: 8963
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.

Report message to a moderator

Re: RMAN connection [message #663626 is a reply to message #663625]

Sun, 11 June 2017 13:07

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.

Report message to a moderator

Re: RMAN connection [message #663628 is a reply to message #663626]

Sun, 11 June 2017 13:25

prash2017
Messages: 14
Registered: June 2017

Junior Member

It worked when I changed connection type to Dedicated Server.

Report message to a moderator

Re: RMAN connection [message #663630 is a reply to message #663628]

Sun, 11 June 2017 19:13

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?

Report message to a moderator

Re: RMAN connection [message #663643 is a reply to message #663621]

Mon, 12 June 2017 07:32

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 ...

Report message to a moderator

Previous Topic:	how to import full 10g dmp file in oracle 11g using imp
Next Topic:	Tablespace point in time recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 00:45:43 CST 2025