RMAN-04004: error from recovery catalog database: ORA-12170: TNS:Connect timeout occurred

Hi experts,
Things were moving along just fine until I got the grandiose notion of creating a RMAN catalog on a new server that was designed to only hold the catalog. And the target Database is on another server a Windows 2003. I created a user for the target database and I went onto the remote server created an entry for the catalog in the tnsnames.ora file. Then I proceeded to 'Ping the Catalog server' no problems, then I tried to do a 'Tnsping on the Catalog dbname' then I got errors. Then I looked online and tried some of the suggestions like checking 'firewalls' and sqlnet.ora files once I got that straight. I tried to connect to the catalog from the remote target db server and I got this error 'RMAN-04004: error from recovery catalog database: ORA-12170: TNS:Connect timeout occurred' . The last thing that I haven't tried was putting a PWDfile on the remote target db server for the catalog, I thought that was alittle extreme because I can ping the server. Any Ideas.

7SoulsData Analyst/Database AdministratorAsked:
Who is Participating?
schwertnerConnect With a Mentor Commented:
This is a network problem.

1. Look for running firewalls between the two DBs.

2. Check how many NIC (network cards) have bot computers and if they are more then one check which one is mentioned in Listener.ora and if it is the correct one.

3. check tnsnames.ora if the entries are correct.

7SoulsData Analyst/Database AdministratorAuthor Commented:
Hi schwertner,

Thanks, for responding yes it was the firewalls. Our mean Sys Admin put the new server on a different sub-net where the Production and UAT servers resides. Even though you could ping the server from the development servers we noticed that you can only tnsping this new server where the new catalog resides behind the firewall of the Production and UAT servers. So our Sys Admin(s) the nice ones punched a hole or made some rules where this server can now connect to the development servers. Now I can start building my backups/recoveries through the catalog.

I'll let you know how it's going. BTW, I have a question that has been sitting in the queue for sometime waiting for some Perl experts to pick it up, are there any experts around? If you are able to find any can I share some of the points with you?

Thanks again and if I don't hear from you have a Happy Holiday,
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.