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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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,
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.