Welcome to Jiltin’s Blog

Read this and make a copy for your files in case you need to refer to it
someday. Maybe we should all take some of his advice! A corporate
attorney sent the following out to the employees in his company.

1. Do not sign the back of your credit cards. Instead, put ‘PHOTO ID
REQUIRED.’

2. When you are writing checks to pay on your credit card accounts, DO
NOT put the complete account number on the ‘For’ line. Instead, just put
the last four numbers. The credit card company knows the rest of the
number, and anyone who might be handling your check as it passes through
all the check processing channels won’t have access to it.

3. Put your work phone # on your checks instead of your home phone. If
you have a PO Box use that instead of your home address. If you do not have a PO Box, use your work address. Never have your SSN# printed on your checks. (DUH!) You can add it if it is necessary. But if you have It
printed, anyone can get it.

4. Place the contents of your wallet on a photocopy machine. Do both
sides of each license, credit card, etc. You will know what you had in
your wallet and all of the account numbers and phone numbers to call and
cancel. Keep the photocopy in a safe place. I also carry a photocopy of my
passport when I travel either here or abroad. We’ve all heard horror
stories about fraud that’s committed on us in stealing a Name, address,
Social Security number, credit cards.

Unfortunately,I,an attorney, have first hand knowledge because my
wallet was stolen last month. Within a week, the thieve(S) ordered an
expensive monthly cell phone package, applied for a VISA credit card, had a credit line approved to buy a Gateway computer, received a PIN number from DMV to change my driving record information on-line, and more.

But here’s some critical information to limit the damage in case this
happens to you or someone you know:

5. We have been told we should cancel our credit cards immediately. But
the key is having the toll free numbers and your card numbers handy so you
know whom to call. Keep those where you can find them.

6. File a police report immediately in the jurisdiction where your credit
cards, etc ., were stolen. This proves to credit provi ders you were
diligent, and this is a first step toward an investigation (if there ever
is one). But here’s what is perhaps most important of all: (I never even
thought to do this.)

7. Call the 3 national credit reporting organizations immediately to
place a fraud alert on your name and also call the Social Security fraud
line number. I had never heard of doing that until advised by a bank that
called to tell me an application for credit was made over the internet in
my name.

The alert means any company that checks your credit knows your information
was stolen, and they have to contact you by phone to authorize new credit.

By the time I was advised to do this, almost two weeks after the theft, all the damage had been done. There are records of all the credit checks initiated by the thieves’ purchases, none of which I knew about before placing the alert. Since then, no additional damage has been done,and the thieves threw my wallet away this weekend (someone turned it in). It seems to have stopped them dead in their tracks.

Now, here are the numbers you always need to contact about your wallet, if it has been stolen:

1.) Equifax: 1-800-525-6285

2.) Experian (formerly TRW): 1-888-397-3742

3.) Trans Union : 1-800-680 7289

4.) Social Security Administration (fraud line):
1-800-269-0271

We pass along jokes on the Internet; we pass along just about everything.

If you are willing to pass this information along, it could really
help someone that you care about

I had a chance to install/upgrade Equity Edge 6 and 7 version. You need licensing from Etrade. If your company has, and you are looking for strong candidates to maintain, feel free to update/comment here. I have few experts, in Bay Area, who can fix any issues in equity edge. I am one among them! Trust me, this is not a joke, but a fact. I have managed to install/upgrade around 30 times with my friend.

Jiltin

From:https://us.etrade.com/e/t/corporateservices/eedge

Equity Edge® is our advanced stock plan management and reporting software that gives you maximum control over your company’s equity compensation program. Equity Edge simplifies plan administration, providing the power and flexibility you need to manage stock options, restricted stock, stock valuation, insider reporting and stock purchase information more efficiently and effectively.

Powerful Software for Stock Plan Administrators

* New integrated support for Stock Appreciation Rights
* Integrated, multi-user database that minimizes data entry
* Multi-level access control for secure, multi-department usage
* Automated compliance assistance with IRS, SEC and FASB rules and regulations, including FAS 123 (R)
* Simplified data access to streamline annual report, proxy, Form 10-K, and Form 10-Q filings
* Multiple import/export methods for easy exchange of data with other software applications
* Powerful report processing, including access to nearly 200 customizable reports
* Section 16 reporting for corporate insiders
* Blackout functions and blocking by transaction type
* Global solution with foreign disbursements and foreign currencies for over 100 countries

End-to-End Integration and Automation

Equity Edge provides seamless integration with our easy-to-use employee stock plans service, letting your employees view and transact with their stock plan information. As the single-source provider of this comprehensive solution, we enable end-to-end processing without manual intervention.

Excerpts from OAUGNetDBA:

FYI, I have been able to get the forms to work from my Linux workstation.
After applying our 9iAS upgrade and 11.5.8 upgrade this spring, we found
new settings in the appsweb.cfg file (namely, an sunplugin entry). If you
have that set correctly, matching the version of the sun jdk plugin on
your workstation, the forms access DOES work on your Linux workstation 
It isn't supported, but then again, anyone who uses Linux at a workstation
is used to that!

This is the section that makes it work, although Oracle won't support it,
the code works when these are set, this is with the plugin version
1.4.1_01,it had 1.4.1 by default, you can change it to whatever version
you have installed and test it out:

; These parameters define the Sun's java plug-in to be used
sun_plugin_mimetype=application/x-java-applet;jpi-version=1.4.1_01
sun_plugin_classid=clsid:CAFEEFAC-0014-0001-0000-ABCDEFFEDCBA
sun_plugin_url=http://www.javasoft.com/
sun_plugin_version=1.4.1_01
sun_plugin_legacy_lifecycle=false

Check first which JDK version your form server is Using . On form server execute
env | grep FORMS60_WEB_CONFIG_FILE
depending on your apps version you will see file like appsweb_$CONTEXT_NAME.cfg or appsweb.cfg
Open this file & check for JDK version check for parameter sun_plugin_version If you see entry like sun_plugin_version=1.4.2_04, install this version of JDK from sun’s site java.sun.com to your linux client machine from where you want to access forms and create a symbolic link for the plugin in browser plugin directory usually in */usr/lib/mozilla/plugin* as in my case I am configuring mozilla on linux client.
Then change appsweb file defined by parameter FORMS60_WEB_CONFIG_FILE on forms tier plugin from jinit to jdk ; The following parameter specifies the type of plugin to be used.
; Following are the accepted values:
; jinit - use the JInitiator plugin (default)
; jdk - use the Sun’s JDK plugin
plugin=jdk
Try accessing Form server & check if you can access forms.

In Oracle Applications professional Users can access professional forms via Appletin web browser.  This Form Applet must run with in Java Virtual Machine (JVM) and Oracle bundles its own JVM as Oracle Jinitiator.  This Jinitiator is available only for Windows Client and for Unix/Linux you have to use Java Plug-In.
Till Oracle Apps 11i default JVM was Jinitiator but with Oracle Apps R12 default JVM under which form Applet run is J2SE Plug-In. If you are accessing Oracle Applications (11i/R12), Apps will automatically prompt you to install Jinitiator/J2SE Plug-in (If Jinitiator/J2SE is not installed in client machine) but if you are accessing same Oracle Applications from Linux/Unix it does not prompt to install plug-in and you can’t apps forms from Linux client.

How to access Oracle Apps 11i/R12 professional forms from Linux Client ?
In you to access forms from Linux client, Three steps are installed (You can skip first if Mozilla is installed on your Linux client) –

1. Install Mozilla Browser
2. Install JRE on client machine (JRE version to install will depend on Server configuration, for R 12.0.o you need JRE 5 update 10) .
3. Use JRE installed above on client machine in Browser (Mozilla) Plugin

1. Install FireFox Mozilla
–Download Mozilla for Linux from http://www.mozilla.com/en-US/firefox/all.html#en firefox-2.0.0.7.tar.gz
– “gunzip -d firefox-2.0.0.7.tar.gz” (You will get unzipped file with name as firefox-2.0.0.7.tar)
– Extract tar file as “tar -xvf  firefox-2.0.0.7.tar”
– This will create directory called “firefox” which is under you will see executable called “firefox“; Use this executable to start FireFox on Linux machine.

2. Install JRE on client machine
–Download JRE  5.0 Update 10   for Linux from http://java.sun.com/products/archive/j2se/5.0_10/index.html ”jre-1_5_0_10-linux-i586-rpm.bin”
–”chmod 755 jre-1_5_0_10-linux-i586-rpm.bin”
–./jre-1_5_0_10-linux-i586-rpm.bin  (You will be asked to accept license agreement , click enter and when prompted to accept license enter Yes)
–This will install jre 1.5.10 in linux machine under /usr/java and plugin is installed under /usr/java/jre1.5.0_10/plugin/i386/ns7/libjavaplugin_oji.so

Configure JRE Plug-in in browser
–Go to Mozilla FireFox plug-in directory which is $location_where_you_unziped_firefox_directory/plugins and create soft link like
–ln -s /usr/java/jre1.5.0_10/plugin/i386/ns7/libjavaplugin_oji.so ./libjavaplugin_oji.so

This is my trial to install Oracle applications 12 Release on Cent OS!

Visit Later with my details comments.

Jiltin

For 115.10i in Cent OS, export LD_ASSUME_KERNEL=2.4.19 gave me lot of troubles, which made me to reformat the installation again

The document is halfway through, imcomplete, but may help you and others.

Jiltin

This is posted by me at Oracle Forum:

http://forums.oracle.com/forums/thread.jspa?forumID=169&messageID=661976&threadID=198714

Short notes ( for those who are comfortable with linux/unix shell, patches)

(1 thro 7 & 9 as root)

1. check the fully qualified domain name

2. install jdk1.3.1_09 (sun jdk)

3. create group dba, added user applmgr & oracle

4. Include path, classpath in /etc/bashrc so that it
is common to both applmgr & oracle users. (not strictly required).

5. rename gcc to gcc323 and g++ to g++323. Linked old gcc296, g++296 in /usr/bin into /usr/bin/gcc & /usr/bin/g++

6. Apply patch 3006854 & rebooted the machine

7. Then start rapidwiz under x-windows mode

8. After 100% installed, stop all the serivices
and applied patches 3293983 & p3170128 as applmgr
login after setting oracle home to point 806 directory.

9. Log back to root, start all the process.
========================
Oracle update notes long notes (consult Oracle & metalink)
This is only a guide, oracle is the master document.
===================
Oracle® Applications Installation Update Notes Release 11i for Linux x86 (11.5.9)
Part No. B10849-02/December 2003

Operating System Requirements for Red Hat Enterprise Linux 3

Linux Kernel Version 2.4.21-4.EL

To determine what distribution and version of Linux is currently installed, enter the following command:

$ uname -r

Glibc Version 2.3.2-95.3

To determine if this is installed, enter the following command:

$ rpm -q glibc

Operating System Patches
The following patches must be installed on the system:

compat-db-4.0.14.5
compat-gcc-7.3-2.96.122
compat-gcc-c++-7.3-2.96.122
compat-libstdc++-7.3-2.96.122
compat-libstdc++-devel-7.3-2.96.122
openmotif21-2.1.30-8.i386.rpm
setarch-1.3-1

To determine if the operating system patches are installed on the system, enter the following command:

$ rpm -qa | grep <value>

For example:

rpm -qa | grep -i compat-db-4.0.14.5
rpm -qa | grep -i compat-gcc-7.3-2.96.122
rpm -qa | grep -i compat-gcc-c++-7.3-2.96.122
rpm -qa | grep -i compat-libstdc++-7.3-2.96.122
rpm -qa | grep -i compat-libstdc++-devel-7.3-2.96.122
rpm -qa | grep -i openmotif21-2.1.30-8.i386.rpm
rpm -qa | grep -i setarch-1.3-1

rpm –qa | grep –i jdk

Setting the Environment:
Perform the following tasks to set up the environment before you begin the installation:

1. Install the jdk131 from sun ( www.sun.com ). I have download jdk131_09 version
check whether the jdk is already installed. If not installed, install it now.

rpm –ivh jdk1.3.1_09.rpm

2. Rename the /usr/bin/gcc and /usr/bin/g++ directories, as follows:

mv /usr/bin/gcc /usr/bin/gcc323
mv /usr/bin/g++ /usr/bin/g++323

3. Enter the following commands to create symbolic links:

ln -s /usr/bin/gcc296 /usr/bin/gcc
ln -s /usr/bin/g++296 /usr/bin/g++

4. Verify that the host name setting is correct, as follows:

hostname

This command should return the fully qualified host name:

hostname.domainname

5. For hugemem kernel, install rpm setarch-1.0-2.i386.rpm or higher, as follows:
For up, smp and boot kernel this step is not required.

setarch i386

6. Set the LD_ASSUME_KERNEL environment variable to 2.4.19, as follows:
Note: You must have the LD_ASSUME_KERNEL environment variable set before you perform any operation.

For the Bourne, Bash, or Korn shell, enter:

export LD_ASSUME_KERNEL=2.4.19

For the C or tcsh shell, enter:

setenv LD_ASSUME_KERNEL 2.4.19

7. As a workaround to a bug in the rapidwiz utility, unset the LANG environment variable. To unset the LANG environment variable, enter the following command:
unset LANG

Additional Preinstallation Steps - Required Patch

To install Oracle Applications release 11.5.9 software, follow the instructions
in the Installation Guide. Before you begin the installation, perform the
following additional preinstallation steps :

1. Open a new terminal window.

2. Apply patch number 3006854.

This patch resolves a problem with the libcwait symbol. You can get the patch from OracleMetalink: http://metalink.oracle.com/

3. After you have applied the patch, reboot the system.

4. Start rapidwiz from the same terminal you used to set the environment and begin the installation.

Postinstallation Steps

After you have installed Oracle Applications release 11.5.9, perform the
following postinstallation steps:

1. Shut down all Oracle Applications processes. To shut down running
processes, use the following command:

# <COMMON_TOP>/admin/scripts/<TWO_TASK>_<machine_name>/adstpall.sh apps/<pwd>

2. Apply interoperablity patch 3293983. This patch fixes the stubs library and
modifies Developer 2000 6i and network makefiles.

3. Apply patch number 3170128. This patch fixes a Visibroker core dump
problem.

Then restart all the process.

Startall script shell (run as root): This starts all the process one by one

su - oracle -c “/opt/oracle/<dbname>db/9.2.0/appsutil/scripts/<DBNAME>_winxp-pc1/addbctl.sh start normal”
su - oracle -c “/opt/oracle/<dbname>db/9.2.0/appsutil/scripts/<DBNAME>_winxp-pc1/addlnctl.sh start <dbname>”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adrepctl.sh start”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adcmctl.sh start apps/apps”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adapcctl.sh start”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adfmcctl.sh start”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adfmsctl.sh start”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adfrmctl.sh start”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adtcfctl.sh start”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/addisctl.sh start”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adalnctl.sh start APPS_<dbname>”

Stopall script shell (run as root): This stops all the process one by one :

su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adcmctl.sh stop apps/apps”
su - oracle -c “/opt/oracle/<dbname>db/9.2.0/appsutil/scripts/<DBNAME>_winxp-pc1/addbctl.sh stop immediate”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adrepctl.sh stop”
su - oracle -c “/opt/oracle/<dbname>db/9.2.0/appsutil/scripts/<DBNAME>_winxp-pc1/addlnctl.sh stop <dbname>”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adalnctl.sh stop APPS_<dbname>”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adfmcctl.sh stop”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adfmsctl.sh stop”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adfrmctl.sh stop”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adtcfctl.sh stop”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/adapcctl.sh stop”
su - applmgr -c “/opt/oracle/<dbname>comn/admin/scripts/<DBNAME>_winxp-pc1/addisctl.sh stop”

if need be, do this (I did not do, it is working well)

4. Relink all Applications executables using “Relink Applications programs”
from “Generate Applications Files menu” of the adadmin utility.

5. Generate all of the .jar files with force option using “Generate product JAR
files” from “Generate Applications Files menu” of the adadmin utility.

6. Restart Oracle Applications processes using the following command:

# <COMMON_TOP>/admin/scripts/<TWO_TASK>_<machine_name>/adstrtal.sh apps/<pwd>

When I tried to install 11.5.9 on Redhat Linux Ent. 30 & AS 21 & RH9,
I find that read from config file does not work properly, that creates “unable to instantiate file” and “unable to create control file” issues.

Steps to recreate the issue.

start rapidwiz
When giving applusr and oracle user,
the default brings applEVAL, oraEVAL
supposing your instance is EVAL (oracle_sid)

change it to applmgr and oracle

save the config file

exit it ( do not run further )

Next start the rapidwiz

say read from config file

It reads the /tmp/config.txt and backs-up to /tmp/config.txt.bac

everything looks fine, but you will get

“unable to instantiate file” and “unable to create control file” errors

The reason is oracle changes some of the entries in
/tmp/config.txt while reading it.

half way through (you can find out at the end of the file)
it changes applmgr into applEVAL and oracle into oraEVAL

Hence, the user does not exists and unable to instantiate files.

The work around is do not read from config file

========================> .bashrc <==================

These error I have seen with RH9. I have not tested in RH9. However, here is addl data I have added to my /etc/bashrc (though you can do with local .bashrc too, I am lazy enough to modify each user!) The 2.4.19 is for RHEL 3.0, but 2.4.1 is for RH9.

export LD_ASSUME_KERNEL=2.4.19
export ORACLE_SID=<DBNAME>
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=${ORACLE_BASE}/<DBNAME>db/9.2.0
export CLASSPATH=.:/usr/java/jdk1.3.1_09/lib:/usr/java/jdk1.3.1_09/lib/tools.jar:/usr/java/jdk1.3.1_09/lib/rt.jar:$ORACLE_HOME/lib/servlet.jar:$ORACLE_HOME/jdbc/lib/classes12.zip
export PATH=.:${PATH}:/usr/java/jdk1.3.1_09/bin:${ORACLE_HOME}/bin:${ORACLE_HOME}/lib:${CLASSPATH}
export TNS_ADMIN=${ORACLE_HOME}/network/admin/<DBNAME>_<SERVER_NAME>
export LD_LIBRARY_PATH=${PATH}
export DISPLAY=${REMOTEHOST}:0.0
unset LANG

Good Luck

========================> .bashrc <==================

Source: http://michael.biven.org/2008/01/31/migrating-wordpress-to-a-different-domain-or-server/

All credit and copyright goes to the above site:

Two common questions I see both at work and from friends is how best to migrate a WordPress site from one server to another or how to go about changing the Domain Name. There are four different scenarios that will affect the changes you would be making:

Changing the Domain Name only or in combination with one of the scenarios below
Moving from one self-installed server to another self-installed server
Moving from a self-installed server to WordPress.com
Moving from WordPress.com to a self-installed server

Below are the steps that I suggest including backups, starting DNS changes, configuring the new server, database import and changes, verifying the new server, final DNS changes, 301 redirects and final verification. I will point out which applies to each of the different scenarios and also briefly go over a few tools that can help at the end of the guide. Remember though I don’t expect anything bad to happen this guide is completely use at your own risk and I do not take responsibility for anything resulting from following them.

Backup:

(applies to all four scenarios)

The very first thing to do is make a complete backup of the existing site for a few different reasons. First if you really do care about the work and effort you are putting into your site take the extra time to backup it up on some sort of regular schedule. Next is that we are about to make changes to the site and you will want a recent (as in the day your making the changes) backup to fall back on just in case something goes awry. And if you are moving from a self-installed copy of WordPress to another you will already have a copy of the plugins, themes and uploads to copy over to the new server. You do already have a current copy of WordPress and any plugins you have installed right?

So now on to backing up your site. I would suggest that you follow Lorelle’s guide to create a backup for WordPress and keep in mind the XML export would be needed if you are migrating from or to WordPress.com.

First set of DNS changes:

(applies to all four scenarios)

Try to make the following changes in DNS at least 24 hours before you plan to switch to the new domain name or server. Drop the Time To Live (TTL) for the A record that the blog uses down to something like 300 (make note of it’s original setting since you will need to change it back later). The TTL is in seconds so the 300 is equal to 5 minutes. During the migration to the new server you will be getting a new IP address, this way the TTL is dropped and since you made the change at least 24 hours before your migration you should only be looking at a 5 minute hiccup during the switch to the new server.

Configuring the new server:

(applies to all four scenarios)

Next on the new server go ahead and complete the basic install of WordPress. If you are moving to WordPress.com configure the new site, keep it set to private, but do not enable the domain alias at this point (under Options > Domains). For self-installed copies of WordPress depending on what type of access you have with the server you may need to edit your hosts file on your local computer to complete the install since you do not have DNS pointing to the new IP address, specifically when you run the file wp-admin/install.php.

Importing the data:

(applies to all four scenarios)

Now that we have the basic WordPress site completed it is time to import the data (posts, comments, pages) into the new server. Remember if you will be changing the Domain Name as well you will need to make the necessary changes in two tables in the database which I will go over at the end of this step.

If you are moving from one self-installed copy of WordPress to another use the backup of the database to create a new database on the new server. You will need to recreate the database user and edit the file wp-config.php to reflect any changes in the database name, user and password.

If you are moving to or from WordPress.com you will only be able to import the data to the new server from the XML export you created earlier. From the dashboard at the new WordPress.com site go to Manage > Import and then select WordPress. You will then be prompted to browse to the location of the XML from the previous export. Also when importing the file you will be asked if you want to change the author for the posts and drafts you are importing.

If you have changed the domain name used for the site and used the database backup to import your data you will need to make changes to two different tables. We need to change the Blog Address (URL), WordPress Address (URL) and the GUID for the posts. The Blog Address is listed as siteurl in the field option_name and the WordPress Address is home in the same field. You can use either phpMyAdmin or mysql if you have shell access, but the examples I give will be using phpMyAdmin.

The first two fields are located in the tables wp_options. After logging into phpMyAdmin click on the name of the database in the left hand side (you will need to select it form the drop down box if you have multiple databases) and then click on the SQL tab at the top of the page. In the “Run SQL query/queries” text box enter the following and press “Go” to change the Blog Address (URL):

UPDATE wp_options SET option_value =

replace(option_value, 'http://old.domain.com', 'http://new.domain.com')

WHERE option_name = 'home';

And to change the WordPress Address (URL):

(remember if you have your WordPress files in its own separate directory this URL will be different than the Blog Address)

UPDATE wp_options SET option_value =

replace(option_value, 'http://old.domain.com', 'http://new.domain.com')

WHERE option_name = 'siteurl';

To update the GUID with the new domain name enter:

UPDATE wp_posts SET guid = replace(guid, 'http://old.domain.com','http://new.domain.com');

And for any links to other pages or posts internally in your site with absolute URLs:

UPDATE wp_posts SET post_content =

replace(post_content, 'http://old.domain.com', 'http://new.domain.com');

Now that we have the data over get your theme and any plugins that you will be using configured on the new site.

Checking our work up to this point:

(applies to all four scenarios)

At this point you should have the new site up and running on the new server, but before we make it live by updating DNS with the new IP address or enabling the domain alias in WordPress.com you should take a moment to verify (thanks to the edit to the hosts file) that everything looks and behaves correctly. Consider viewing the site both while you are logged in as an admin and while logged out. You won’t be able to view a WordPress.com site while logged out unless you create a new user account and grant it permissions to access the site under Options > Privacy.

Final changes to DNS:

(applies to all scenarios)

After you are satisfied with the new install make the final change to DNS by either changing the A record or enabling the domain alias in WordPress.com. The changes for the A record includes updating it with the new IP address and changing the TTL back to it’s original setting.

301 redirects:

(applies to scenarios where the domain name changes)

So you just changed the domain name for the site and you might be asking yourself what about any links to the old domain name that are still getting spit out by search engines. You can take care of this with a simple .htaccess file in the root of your old domain names web server. Simply create or edit the file to include the following:

RedirectMatch permanent (.*) http://new-doamin.com$1

This will send any links to the old domain to their corresponding page at the new domain name as long as you do not make changes in the permalink structure. The longer you can leave this the better, but you should start seeing search engines updating with the new link, because we used a permanent redirect.

Final checks:

(applies to all scenarios)

It would be easy to think you’re done and stop right here, but I would suggest a couple more checks. Though you might have to wait a few hours or a day depending on how you made your DNS changes, take advantage of Google’s Webmaster tools, the Feed Validator, or Yahoo! Site Explorer to verify your sites robots.txt, sitemap, and any errors that they encounter with your site or feed. Also keep an eye on your bandwidth after the change just in case you have misconfigured something that is causing any problems with the site making calls to itself (ie using the RSS widget to load its own RSS feed) or anything else that we might not think of at the moment.

Closing and additional tools to help:

If you are planning on moving your site I hope you’ve found this guide useful, good luck and enjoy.

A few additional tips to help you check things as you go or troubleshoot (hopefully not) any problems.

Flush your local DNS cache:

In addition to making the changes in your local compuaters hosts file you may need to clear out your local DNS cache.

Mac OS 10.4 and older:

lookupd -flushcache

Mac OS 10.5:

dscacheutil -flushcache

Windows XP and newer (might work on Windows 2000):

ipconfig /flushdns

Query DNS servers with dig:

Being able to query the DNS server you are using or others is another handy skill to have when your mucking around in your sites DNS. On a Mac running OS X or Linux you can query your’s and other DNS server to see what they have listed for your domain using dig.

check your current DNS server for the A record

dig domain.com

check your current DNS server for the MX record

dig domain.com mx

check your current DNS server for the A record on a subdomain

dig sub.domain.com

check a different DNS server for the A record

dig @DNS.server.com domain.com

check a different DNS server for the MX record

dig @DNS.server.com domain.com mx

check a different DNS server for the A record on a subdomain

dig @DNS.server.com sub.domain.com

Setting the password:

1. From Unix:
shell> mysql -u username -h hostname -p password
mysql> SET PASSWORD FOR username@localhost=PASSWORD(’new_password’);

2. Directly manipulate the privilege tables:
shell> mysql -u username -h host -u username -p
mysql> UPDATE user SET Password=PASSWORD(’new_password’) WHERE user=’root’;
mysql> FLUSH PRIVILEGES;

3. Using the mysqladmin command:
shell> mysqladmin -u username password new_password

In our case we were able to change password specifying host name along with user name:
shell> bin/myslqadmin u username h localhost

MySQL Permissions & Grant Tables

In order to add a new user or update user’s privileges in mysql grant tables login to mysql as a root user.

There are two options: use GRANT/REVOKE command or manipulating the MySQL grant tables directly.
The preferred method is to use GRANT statements - more concise and less error-prone.

If you modify the grant tables manually (using INSERT, UPDATE, etc.), you should execute
a FLUSH PRIVILEGES statement to tell the server to reload the grant tables.

To remove user: mysql> delete from user where user=’username’;
mysql> FLUSH PRIVILEGES;

Examples adding a new user with different level of privileges:
dummy: A user who can connect without a password, but only from the local host.

mysql> GRANT USAGE ON *.* TO dummy@localhost;

myUser : A full superuser who can connect to the server from anywhere,
but who must use a password ‘pass’ to do so.
GRANT statements should be for both myUser@localhost and myUser@”%”.
to prevent the anonymous user entry for localhost take precedence.

mysql> GRANT ALL PRIVILEGES ON *.* TO myUser@localhost
IDENTIFIED BY ‘pass’ WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO myUser@”%”
IDENTIFIED BY ’some_pass’ WITH GRANT OPTION;

“%” - is a wildcard in mysql. If you are defining your DB table and in the ‘host’ field
enter ‘%’, that means that any host can access that database (Of course, that host
must also have a valid db user).

admin: A user who can connect from localhost without a password and who is granted
the RELOAD and PROCESS administrative privileges.
No database-related privileges are granted.

mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;

Add a user that has full rights to his database only but cannot see other database:
mysql> GRANT USAGE ON *.* TO ‘user’@'host’ GRANT Select, Insert, Update, Delete,
Create, Drop ON `database`.* TO ‘user’@'host’ FLUSH PRIVELEGS;

The FILE privelege and WITH GRANT OPTION may not be the best way to include, it is
only in case of creating another superuser with full set of privileges or
giving privileges to load data using mysql command INLOAD DATA.

GRANT TABLE FIELDS EXPLANATION:
TABLE USER: Everything after “password” is a privelege granted with values ‘Y’ or ‘N’.
This table controls individual user global access rights.

‘host’,'user’,'password’,’select’,'insert’,'update’,'delete’,'index’,'alter’
,’create’,'drop’,'grant’,'reload’,’shutdown’,'process’,'file’

TABLE DB: This controls access of USERS to databases.

‘host’,'db’,'user’,’select’,'insert’,'update’,'delete’,'index’,'alter’,
‘create’,'drop’,'grant’

TABLE HOST: This controls which HOSTS are allowed what global access rights.

‘host’,'db’,’select’,'insert’,'update’,'delete’,'index’,'alter’,
‘create’,'drop’,'grant’

HOST, USER, and DB table are very closely connected - if an authorized USER
attempts an SQL request from an unauthorized HOST, it is denied.
If a request from an authorized HOST is not an authorized USER, it is denied.
If a globally authorized USER does not have rights to a certain DB, it is denied.

Backups in MySQL

Full backup of MySql databases:
1. shell> mysqldump –tab=/path/to/some/dir –opt –full
OR
2. shell> mysqlhotcopy database /path/to/some/dir
OR
3. simply copy all table files (`*.frm’, `*.MYD’, and `*.MYI’ files)

For a SQL level backup of a table use SELECT INTO OUTFILE or BACKUP TABLE.

mysql> BACKUP TABLE tbl_name[,tbl_name…] TO ‘/path/to/backup/directory’
Copies to the backup directory the minimum number of table files needed to
restore the table, after flushing any buffered changes to disk.

RESTORE TABLE tbl_name[,tbl_name…] FROM ‘/path/to/backup/directory’
Restores the table(s) from the backup that was made with BACKUP TABLE.
Existing tables will not be overwritten; if you try to restore over an existing
table, you will get an error. Restoring will take longer than backing up due to
the need to rebuild the index. The more keys you have, the longer it will take.
Just as BACKUP TABLE, RESTORE TABLE currently works only for MyISAM tables.

Selective backups can be done with:
SELECT * INTO OUTFILE ‘file_name’ FROM tbl_name
and restore with:
LOAD DATA INFILE ‘file_name’ REPLACE …
To avoid duplicate records, you need a PRIMARY KEY or a UNIQUE key in the table.
The REPLACE keyword causes old records to be replaced with new ones when a new
record duplicates an old record on a unique key value.

Monitoring tools

The myisamchk utility is used to get information, check, repair or optimise mysql database tables:
shell> myisamchk [options] tbl_name

With no options, myisamchk simply checks the table.

Some useful Options for myisamchk utility:

1. Print informational statistics about the table that is checked: -i or –information
2. Check only tables that have changed since the last check: -C or –check-only-changed
3. The recommended way to quickly check all tables:
myisamchk –silent –fast /path/to/datadir/*/*.MYI

To Start the server automatically at system startup time

The mysql.server and safe_mysqld scripts can be used to start/stop the server automatically.
shell> mysql.server start
shell> mysql.server stop

See mysql.server in the `share/mysql’ directory or in the `support-files’ directory of the MySQL source tree.
The mysql.server script understands the following options: datadir, basedir, and pid-file.

If your system uses `/etc/rc.local’ to start external scripts, you should append the following to it:

/bin/sh -c ‘cd /usr/local/mysql ; ./bin/safe_mysqld –user=mysql &’

The mysql.server script understands the following options: datadir, basedir, and pid-file.

Mortgage Calculator
New Port Federal
Home Finance America
Fremont Bank
Downey Savings
Technology Credit Union
ING Direct

ARRAYIRR

Internal Rate of Return (IRR) for a stream of cash flows. Each cash flow value is assumed to be the cash flow at the end of the current period. If the cash flow contains multiple sequences of positive and negative cash flow values there may be multiple valid IRR results. In such cases the IRR closest to the specified guess is returned. If no guess is specified, a default of 0.2 is used.

ARRAYIRR (<cash_flow_array>)

ARRAYIRR (<cash_flow_array>, <guess>)

Example model equations:

V IRR Value = ARRAYIRR({ - 100,30,30,30,30,30})

Example result: 0.15

ARRAYMIRR

Modified Internal Rate of Return (MIRR) for a stream of cash flows. Each cash flow value is assumed to be the cash flow at the end of the current period. MIRR considers both the cost of investment and the interest received on reinvestment of cash.

ARRAYMIRR(<cash_flow_array>, <finance_rate>, <reinvestment_rate>)

Example model equations:

V MIRR Value = ARRAYMIRR({ - 100,30,30,30,30,30},10%,5%)

Example result: 0.11

ARRAYNPV

Net Present Value (NPV) for a stream of cash flow which is either income (positive amount) or payments (negative amount) at a given discount rate. Each cash flow value is assumed to be the cash flow at the end of the current period. The NPV is calculated for the given array of cash flow at each point in time.

ARRAYNPV (<cash_flow_array>, <rate>)

Example model equations:

V Net Present Value = ARRAYNPV({-100,30,30,30,30,30},10%)

Example result: 12.48

NPER

Number of periods to pay off an investment with a constant rate of <rate>, a payment of <pmt>, a present value of <pv> and a future value of <fv> (defaults to 0). If <type> is 0 (default) payment is at start of period, otherwise payment is at end of period.

NPER(<rate>, <pmt>, <pv>, <fv>, <type>)

NPER(<rate>, <pmt>, <pv>, <fv>)

NPER(<rate>, <pmt>, <pv>)

Example model equation:

V Payment Periods = NPER(10%,-200,-2000,5000,0)

Example result: 5.87

NPV

Net Present Value (NPV) for a stream of cash flow which is either income (positive amount) or payments (negative amount) at a given discount rate. Each cash flow value is assumed to be the cash flow at the end of the current period. As the cash flow is accumulated over time, the value given at the end of the simulation is actually the Net Present Value from the perspective of the simulation start time.

NPV (<rate>, <amount>)

NPV (<rate>, <amount>, <starttime>)

Example model equations:

V CashFlow = {-100,30,30,30,30,30}[simstep + 1]
V Net Present Value = NPV(10%, CashFlow, 0)

Example results:

PMT

Payment for an investment with a constant rate of <rate> over <nper> periods with a present value of <pv> and a future value of <fv> (defaults to 0). If <type> is 0 (default) payment is at start of period, otherwise payment is at end of period.

PMT(<rate>, <nper>, <pv>, <fv>, <type>)

PMT(<rate>, <nper>, <pv>, <fv>)

PMT(<rate>, <nper>, <pv>)

Example model equation:

V Payment = PMT (10%, 10, -2000, 1000, 0)

Example result: 262.75

PV

Present Value (PV) of an investment with a <rate> over <nper> periods, with a payment of <pmt>. and a future value of <fv> (defaults to 0). If <type> is 0 (default) payment is at start of period, otherwise payment is at end of period.

PV(<rate>, <nper>, <pmt>, <fv>, <type>)

PV(<rate>, <nper>, <pmt>, <fv>)

PV(<rate>, <nper>, <pmt>)

Example model equation:

V Present Value = PV(10%, 3, -1000, 100, 0)

Example result: 2,411.72

FV

Future Value (FV) of an investment with a <rate> over <nper> periods, with a payment of <pmt>. and a present value of <pv> (defaults to 0). If <type> is 0 (default) payment is at start of period, otherwise payment is at end of period.

FV(<rate>, <nper>, <pmt>, <pv>, <type>)

FV(<rate>, <nper>, <pmt>, <pv>)

FV(<rate>, <nper>, <pmt>)

Example model equation:

V Future Value = FV(10%, 3, -1000, 100, 0))

Example result: 3,176.90

We, team of oracle certified professionals, install 11i or 12i fresh application either at Linux or Windows with one month free support for a reasonable fee.  As an end-user, you need to have all the required licenses.  we can make the systems ready and up & running in three days! So far,  we have successfully installed 50+ systems in BayArea.

Minimum requirements:

Windows system:

OS:Windows 2000 server or Windows XP

Ram: 2 GB fine, we recommend 4 GB or More

HDD: 150 GB fine, we recommend 200 GB

Linux system:

OS: RHEL or Redhat 9 (not fedora!)

Ram: 2 GB fine, we recommend 4 GB or More

HDD: 150 GB fine, we recommend 200 GB

If you need to try our service, feel free to add a comment giving your contact emails or phone.

————————————————————————-
—     Author : Jayasankar Gopalakrishnan
————————————————————————-
SELECT
hr.name                                               operating_unit,
hr.organization_id                                    org_id,
le.name                                               legal_entity_name,
decode(ar.set_of_books_id,’-1′,’No’,NULL,’No’,'Yes’)  system_option_defined
FROM
hr_operating_units hr,
hr_all_organization_units_tl le,
ar_system_parameters_all ar
WHERE le.organization_id = to_number(hr.legal_entity_id)
AND   le.LANGUAGE = userenv(’LANG’)
AND   hr.organization_id = ar.org_id(+)
ORDER BY 2;

————————————————————————-
—     Author : Jayasankar Gopalakrishnan
————————————————————————-
select po.profile_option_name “NAME”,
po.USER_PROFILE_OPTION_NAME,
decode(to_char(pov.level_id),
‘10001′, ‘SITE’,
‘10002′, ‘APP’,
‘10003′, ‘RESP’,
‘10005′, ‘SERVER’,
‘10006′, ‘ORG’,
‘10004′, ‘USER’, ‘???’) “LEV”,
decode(to_char(pov.level_id),
‘10001′, ”,
‘10002′, app.application_short_name,
‘10003′, rsp.responsibility_key,
‘10005′, svr.node_name,
‘10006′, org.name,
‘10004′, usr.user_name,
‘???’) “CONTEXT”,
pov.profile_option_value “VALUE”
from   FND_PROFILE_OPTIONS_VL po,
FND_PROFILE_OPTION_VALUES pov,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where  po.USER_PROFILE_OPTION_NAME like ‘%SQL%Statement%’
and    pov.application_id = po.application_id
and    pov.profile_option_id = po.profile_option_id
and    usr.user_id (+) = pov.level_value
and    rsp.application_id (+) = pov.level_value_application_id
and    rsp.responsibility_id (+) = pov.level_value
and    app.application_id (+) = pov.level_value
and    svr.node_id (+) = pov.level_value
and    org.organization_id (+) = pov.level_value
order by “NAME”, pov.level_id, “VALUE”;

————————————————————————-
—     Author : Jayasankar Gopalakrishnan
————————————————————————-
select frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_id, furg.*
from
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
where fu.user_name =upper( ‘&username’)
and   fu.user_id = furg.user_id
and   furg.responsibility_id = fr.RESPONSIBILITY_ID
and   frt.responsibility_id = fr.RESPONSIBILITY_ID
order by 1

————————————————————————-
—    Author : Jayasankar Gopalakrishnan
————————————————————————-

SELECT          fr.responsibility_name RN ,fcpt.user_concurrent_program_name
FROM            fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
fnd_responsibility_vl fr
WHERE           frgu.request_unit_type = ‘P’
and             UPPER(fcpt.user_concurrent_program_name) = UPPER(’Journal Entries Report’)
AND             frgu.request_group_id = frg.request_group_id
AND             frgu.request_unit_id = fcp.concurrent_program_id
AND             fr.request_group_id = frg.request_group_id
AND             fcp.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID
ORDER BY        1

Just run this sample sql changing the patch number (3061831) in sqlplus or Toad.

select distinct rpad(a.bug_number,11)|| rpad(e.patch_name,11)||rpad(trunc(c.end_date),12) ||rpad(b.applied_flag,4)
from
ad_bugs a,
ad_patch_run_bugs b,
ad_patch_runs c,
ad_patch_drivers d,
ad_applied_patches e
where a.bug_id = b.bug_id
and b.patch_run_id = c.patch_run_id
and c.patch_driver_id = d.patch_driver_id
and d.applied_patch_id = e.applied_patch_id
and a.bug_number in (’3061831′)
order by 1 desc ;

ORACLE_HOME/appsutil/scripts
addbctl.sh - start or stop the database
addlnctl.sh - start or stop the database listener
COMMON_TOP/admin/scripts
adalnctl.sh - start or stop the APPS listener
adapcctl.sh - start or stop the Apache web listener
adcmctl.sh - start or stop the concurrent manager
adfmcctl.sh - start or stop Forms Metrics Server
adfmsctl.sh - start or stop Forms Metrics Server
adfrmctl.sh - start or stop the forms server
adrepctl.sh - start or stop the reports server
adtcfctl.sh - start, stop or check status of the TCF sockets

This starts all the server processes (database name=JTCA)

su - oracle -c “/jtca/oracle/jtcadb/9.2.0/appsutil/scripts/JTCA_rh9-pc1/addbctl.sh start normal”
su - oracle -c “/jtca/oracle/jtcadb/9.2.0/appsutil/scripts/JTCA_rh9-pc1/addlnctl.sh start jtca”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adrepctl.sh start”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adcmctl.sh start apps/apps”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adapcctl.sh start”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adfmcctl.sh start”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adfmsctl.sh start”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adfrmctl.sh start”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adtcfctl.sh start”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/addisctl.sh start”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adalnctl.sh start APPS_jtca”
This Stops all 11i applications processes.

su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adcmctl.sh stop apps/apps”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adrepctl.sh stop”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adalnctl.sh stop APPS_jtca”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adfmcctl.sh stop”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adfmsctl.sh stop”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adfrmctl.sh stop”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adtcfctl.sh stop”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/adapcctl.sh stop”
su - applmgr -c “/jtca/oracle/jtcacomn/admin/scripts/JTCA_rh9-pc1/addisctl.sh stop”
su - oracle -c “/jtca/oracle/jtcadb/9.2.0/appsutil/scripts/JTCA_rh9-pc1/addbctl.sh stop immediate”
su - oracle -c “/jtca/oracle/jtcadb/9.2.0/appsutil/scripts/JTCA_rh9-pc1/addlnctl.sh stop jtca”

–
– Set an OPERATING UNIT
–
begin
dbms_application_info.set_client_info(204);
end;

# Firewall configuration written by Jayasankar
# Manual customization of this file is not recommended.
# Note: ifup-post will punch the current nameservers through the
# firewall; such entries will *not* be listed here.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
:RH-Jayg-0-50-INPUT - [0:0]
-A INPUT -j RH-Jayg-0-50-INPUT
-A FORWARD -j RH-Jayg-0-50-INPUT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 22 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 25 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 80 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8080 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8081 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 6000:6010 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 7010 –syn -j ACCEPT
#
# TUFM starts
#
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 1521 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 1522 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 1526 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 1626 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 7000 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8000 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8100 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8200 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8800 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9000 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9100 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9200 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9300 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9800 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10000 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10100 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10200 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10300 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 16000:16009 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 17000:17009 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 18000:18019 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 19000:19009 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -i lo -j ACCEPT
-A RH-Jayg-0-50-INPUT -p udp -m udp -s 66.218.44.5 –sport 53 -d 0/0 -j ACCEPT
-A RH-Jayg-0-50-INPUT -p udp -m udp -s 66.51.205.100 –sport 53 -d 0/0 -j ACCEPT
#
# JPFM starts
#
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 1522 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 1627 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 7001 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8001 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8101 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8201 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8801 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9001 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9101 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9201 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9301 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9801 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10001 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10101 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10201 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10301 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 16010:16019 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 17010:17019 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 18020:18039 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 19010:19019 –syn -j ACCEPT
#
# JTCA starts
#
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 1523 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 1628 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 7003 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8003 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8103 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8203 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 8803 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9003 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9103 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9203 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9303 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 9803 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10003 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10103 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10203 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 10303 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 12348 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 16030:16039 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 17030:17039 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 18040:18059 –syn -j ACCEPT
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –dport 19030:19039 –syn -j ACCEPT
#
-A RH-Jayg-0-50-INPUT -p tcp -m tcp –syn -j REJECT
-A RH-Jayg-0-50-INPUT -p udp -m udp -j REJECT

COMMIT