Home » RDBMS Server » Backup & Recovery » Unable to connect to the Target from catalog (oracle 10g, release 2 , Linux AS4)
Unable to connect to the Target from catalog [message #316658] Sun, 27 April 2008 03:52 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

I'm using oracle 10g, release 2 , Linux AS4 . I've started my listener and the tnsnames.
I've created a password file on the target and when I'm giving
rman catalog ruser/ruser target sys/sys@cat
at my catalog side , i'm getting error like

[oracle10g@localhost ~]$ rman catalog ruser/ruser target sys/sys@cat

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Apr 27 14:20:18 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-28547: connection to server failed, probable Oracle Net admin error

.
I tried to check the error code , but both listener and tnsnames are working fine .

Can somebody help me out .

Regards,
Raj

Re: Unable to connect to the Target from catalog [message #316659 is a reply to message #316658] Sun, 27 April 2008 04:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Post the contents of tnsnames.ora

And try to connect without catalog like,
rman target sys/sys@cat
Re: Unable to connect to the Target from catalog [message #316660 is a reply to message #316659] Sun, 27 April 2008 05:41 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
I tried to connect as you told but when I gave that

[oracle10g@localhost ~]$ rman target sys/sys@cat

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Apr 27 16:13:54 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-28547: connection to server failed, probable Oracle Net admin error



And this is my tnsnames.ora file

[oracle10g@localhost ~]$ cat tnsnames.ora
cat =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 5454))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)


Even now the listener and tnsnames are working , I mean they are pinging




[Updated on: Sun, 27 April 2008 05:45]

Report message to a moderator

Re: Unable to connect to the Target from catalog [message #316661 is a reply to message #316658] Sun, 27 April 2008 06:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Ok fine. Now in server paste the output of
lsnrctl status 
Re: Unable to connect to the Target from catalog [message #316662 is a reply to message #316661] Sun, 27 April 2008 06:11 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
[oracle10g@localhost ~]$ lsnrctl status tgt

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 27-APR-2008 16:40:08

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.2)(PORT=5454)))
STATUS of the LISTENER
------------------------
Alias tgt
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 27-APR-2008 16:06:06
Uptime 0 days 0 hr. 34 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oraeng/app/oracle/product/10.2.0/listener.ora
Listener Log File /oraeng/app/oracle/product/10.2.0/network/log/tgt.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=5454)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully




Re: Unable to connect to the Target from catalog [message #316664 is a reply to message #316658] Sun, 27 April 2008 06:36 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You have problem in your listener. Ok, issue

alter system set service_names=orcl;


in server machine and try to connect.
Re: Unable to connect to the Target from catalog [message #316666 is a reply to message #316662] Sun, 27 April 2008 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...Or use SID instead of SERVICE_NAME in your tnsnames.ora.

Regards
Michel
Re: Unable to connect to the Target from catalog [message #317418 is a reply to message #316666] Thu, 01 May 2008 02:52 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello,

I tried with the SID , instead of SERVICE_NAME ,

cat =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 5454))
)
(CONNECT_DATA =
(SID = orcl)
)
)
[oracle10g@localhost ~]$ tnsping cat

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-MAY-2008 13:20:14

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 5454))) (CONNECT_DATA = (SID = orcl)))
OK (10 msec)


But still unable to connect and getting the same error message
[oracle10g@localhost ~]$ sqlplus u1/u1@cat

SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 13:20:29 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error


Enter user-name:

Can you help me out please

Regards,
Raj

Re: Unable to connect to the Target from catalog [message #317432 is a reply to message #317418] Thu, 01 May 2008 03:46 Go to previous messageGo to next message
prashant.pawar
Messages: 6
Registered: May 2008
Junior Member
it seems that port 5454 is the issue.. if you are not using default port then you need to set local_listener parameter.
otherwise use default port 1521

-Prashant
Re: Unable to connect to the Target from catalog [message #317442 is a reply to message #317432] Thu, 01 May 2008 06:14 Go to previous message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Tried even with the default port number. Still getting the same.
Previous Topic: Standby in R/W mode with RMAN
Next Topic: problem in rename datafiles after migration from ASM to non-ASM
Goto Forum:
  


Current Time: Fri Dec 09 17:35:30 CST 2016

Total time taken to generate the page: 0.32184 seconds