Tuesday, June 9, 2009

Changing the ip address on Oracle server.

Recently my system's ip got changed and the after effect is when i tried to up my applications, it was unable to connect to the oracle database.

If your system's ip address have been changed then you got to test whether your oracle db is properly starting up or not and whether your applications which connect to Oracle are able to connect to oracle.
If you got a problem then you got to change the ip address of Oracle.

For changing the ip address on the oracle server, we need to change the following 2 files.
1. tnsnames.ora
2. listener.ora

You can find both the files in "oracle\product\10.2.0\db_1\NETWORK\ADMIN" path.
Replace the old ip address to new one.

Tuesday, June 2, 2009

URL Encoder.

Here is the perfect link which help you to find the encoding special characters which can exists in the url like a space,^,<,>, etc.

http://www.blooberry.com/indexdot/html/topics/urlencoding.htm

In this site, you got a live encoding converter too which tell whether the char is safe string or need to encode :)