Tuesday 17 November 2009

How to do ftp the files between 2 servers.

For eg. We have to ftp a file abc.dmp
Source Server A : /dev1/mydump/abc.dmp
Target Server B : /dev1/urdump/


Putting files from Source Server to Target Server.
1. Telnet and login into the Source Server A
2. CD to source directory
cd /dev1/mydump
Use the below commands to ftp the files
3. ftp targetservername
4. Enter the login details for the target server
5. After successful login enter the below commands on ftp prompt
bin (Press Enter)
hash (Press Enter)
prompt (Press Enter)
6. CD to target directory
cd /dev1/urdump
7. mput abc.dmp
Ftp will start and progress will be shown by display of hashes

If we need to get a file "cde.dmp"from target server, use the following command
mget cde.dmp

8. To leave to ftp session, enter the below command
bye

Wednesday 11 November 2009

ORA : 12541 No listener error while logging in Application Designer

When trying to connect to Server from Client machine using Application Designer, No listener error was faced.
Tried the Following:
  • tnsping to the DB was working fine
  • Able to login in the Sql tool
  • Able to login into the Data Mover
  • Uninstalled the workstation and reinstalled it.
  • Cleared Cache of Application Designer
  • Found no specific error message in the Trace logs
  • Tried Creating a new profile and checked the path for Oracle Binaries

Solution:
Generally this error is faced when Listener is not running on the DB server. But since tnsping and data mover login are working fine, so there is no issue with listener.
After doing lot of debugging ,this issue was resolved after disabling the firewall of the client system. Firewall was blocking the Application Desinger connectivity of the client machine
with the DB Ser ver.

Get our exclusive subscription-only PeopleSoft tips once per month!

How was the blog? Help us in getting better