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.
Thanks,
7Souls
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.
Thanks,
7Souls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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,
7Souls