Tag Archives: hosts File

Cloning of Production Instance

Posted by on November 4, 2008 No comments

#

Step

Estimated duration
1. Prepare the test machine (echo) that shall be used as the new production machine for cloning:Remove any existing E-Business Suite instance on the machine. Ideally, reinstall the operating system, apply any required service packs, install the additional software such as JDK, Visual C++, MKS Toolkit etc. The software should be installed to the same directory paths as those on the production instance.If the test machine will not reinstalled, then remove the Oracle-related keys from the registry.

1 day
2. Carry out the pre-clone steps for the production instance (adpreclone.pl).

½ day
3. Shutdown the production E-Business Suite instance (application and database tier services) and copy the files from the production machine (delta) to the test machine (echo).

1 day
4. Disconnect the production server from the network. Change the name and IP address of the test machine (echo) to that of the production machine (delta). Update the ‘hosts’ file on the new production server, so that it now contains the new IP address and hostname.

1 hour
5. Clone the new production server. Run the clone scripts on the new production server (adcfgclone.pl).

½ day
6. Perform stress-testing of the new server to ensure that it responds suitably to the load.

1 day
7. Backup and test recovery of the instance on another server.

1 day

Please note:

1. Ensure that the Database processes are properly shut down before proceeding to copy the files; if files aren’t copied correctly, the cloning process would not be executed correctly.

2. Do not run the Gather Schema Statistics concurrent job on the new PROD instance.

Changing Domain Name in Oracle Applications 11i

Posted by on October 15, 2008 No comments

This documentation shows how to change the network domain name of the server that houses an Oracle Applications 11i instance (ebusiness).

  1. Log on to the ebusiness server (either on the console or using VNC or PuTTY). Run the network system settings tool (Red Hat menu > System Settings > Network).

Change the server name from ebusiness.support.com to ebusiness. illuminatnm.com. Save the settings. Do not attempt to restart the network services using this tool, since it will disconnect the remote connection tool.

  1. Edit the context file $APPL_TOP/admin/TEST_ebusiness.xml and replace ‘support.com’ with ‘illuminatnm.com’. With vi, use this command:
:%s/support.com/illuminatnm.com/g

Save the context file and exit the text editor.

  1. Stop the application tier services and then run AutoConfig on the database and application tiers:
cd /u0/oracle/testcomn/admin/scripts/TEST_ebusiness
./adstpall.sh

On the database tier:

cd /u0/oracle/testdb/9.2.0
. TEST_ebusiness.env
cd /u0/oracle/testdb/9.2.0/appsutil/scripts/TEST_ebusiness
./adautocfg.sh

On the application tier:

cd /u0/oracle/testappl
. APPSORA.env
cd /u0/oracle/testcomn/admin/scripts/TEST_ebusiness
./adautocfg.sh

Run the database tier and application tier AutoConfig processes in separate sessions (terminal windows).

  1. As the root user, update the hosts file on the server (/etc/hosts) to reflect the new host name:
x.x.x.x   ebusiness.illuminatnm.com   ebusiness
  1. As the root user, restart network services:
service network restart
  1. As the applmgr user, bounce the application tier services.
cd /u0/oracle/testcomn/admin/scripts/TEST_ebusiness
./adstpall.sh
(wait five minutes)
./adstrtal.sh
  1. Log on to the E-Business TEST application on the client machine using the new URL:
http://ebusiness.illuminatnm.com:8001

If E-Business Suite does not launch properly, reboot the server. After booting, start the application tier services. Then log on to the TEST instance.

Metalink References:

Note: 177311.1 – How to Change Domain Name in Oracle Applications 11i

Note: 342332.1 – Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+)

Installing Oracle Applications 11i Checklist

Posted by on March 7, 2008 No comments

This is a list of steps to check for when installing Oracle Applications.

Step 1:        Ensure that hostname and IP address are in hosts file. Under Windows, ensure that in the hosts file, the hostname is in the following order:

127.0.0.1                    localhost.localdomain                       localhost

xx.xx.xx.xx               hostname.domainname                   alias

Step 2:        Ping machine. It should return:

C:> ping alias

Pinging hostname.domainname [xx.xx.xx.xx] with 32 bytes of data:

Step 3:        Create domain user applmgr and ensure that it is assigned to the Administrators group of the local machine.

Step 4:        Install Visual C++ 6.0 to C:VC98 and apply service pack 4

Step 5:        Install Cygwin to C:cygwin (see Metalink document “Using Cygwin to Maintain Release 11i on Windows” Doc ID:302859.1 for packages to download).

Step 6:        To compile GNU Make, run VCVARS.bat from Visual C++ directory and in the gnumake-3.79.1 directory, run build_w32.bat twice. Copy gnumake.exe to c:cygwinbin (or C:mksntmksnt).

Step 7:        Install Microsoft XML Parser (MSXML) 3.0 Service Pack 4 or later SDK. Copy file from Microsoft XML Parserlib to C:VC98lib.( 11.5.9)

Step 8:        Install Java SDK 1.3.1_18 (11.5.9) (or 1.3.1_15?)

Step 9:        Install Perl (download ActivePerl from http://www.perl.com) (11.5.10)

Step 10:   Copy zip.exe and unzip.exe to C:mksntmksnt

Step 11:    Ensure that all files are on the path:

which gnumake

which perl

which zip

which cc

which link

Modify path if necessary to include: C:Perlbin; C:cygwinbin;C:VC98bin.

Step 12:   Ensure correct versions of Perl and Java installed:

Perl –version

ActivePerl version should be v5.8.8

On Linux, Perl should be 5.003 or later

Java –version

Should be 1.3.1_18

Step 13:   Set TEMP and TMP environment variables for user applmgr to C:TEMP.

Step 14:   Check manual on startCD for instructions on directory structure (11.5.9).

Step 15:   Set up staging area.

Setting Up Oracle Applications Desktop Integrator (ADI) 7.2

Posted by on June 6, 2007 No comments

This documentation covers locating the latest version of ADI on Metalink, downloading it, installing it on the client machine and configuring it to access an Oracle Applications instance.

Step 1:        Log on to Oracle Metalink using your logon information (email address and password).

Step 2:        Search for and read “Application Desktop Integrator (ADI) – FAQ” (Doc ID: Note:106667.1) to obtain instructions to download the latest version of ADI.

(Adapted from the FAQ):

QUESTION: Where can I download ADI from?

Download ADI from Metalink

Log on to http://metalink.oracle.com
Click the Patches & Updates tab.
On the Patches & Updates page, click Advanced Search.
Enter:
Product or Product Family: Click the Torchlight icon to search for Applications Desktop Integrator (adi).
Release: ADI 7.2
Platform or Language: Microsoft Windows (32-bit) Client
Patch Type: Any
Press Go and the 7.2 base release will be available for download.

Step 3:        The results of the search are returned at the bottom of the page.

Click the link ‘3966101’ to locate the patchset.

Step 4:        You may be required to enter a username and password to access the file. Enter the email address and password that you used to log onto Metalink.

Step 5:        Details about the patchset are displayed on screen.

Click Download to begin downloading the file. Note that the download size is 71MB.

Step 6:        Click Save in the File Download dialog box, and then choose a location to save the file.

Step 7:        After downloading, execute the patchset by double-clicking on it.

Step 8:        Enter a location to unzip the files to, and then click Unzip.

Step 9:        Ensure that all files were unzipped correctly (you should see ‘5179 file(s) unzipped successfully’), and then click Ok.

Then click Close to close the WinZip Self-Extractor program.

Step 10:   In the folder that ADI was unzipped to, read the README.TXT file. It points the user to the ADI Installation Guide (ADI.PDF), which should be read before proceeding.

Step 11:    After reading the installation guide, double-click Setupadi.exe to begin installation.

Caution: Remove headphones while installing this product since it uses a lot of extremely annoying sound effects.

Step 12:   The Oracle ADI Installer loads.

Click Oracle Applications Desktop Integrator for Excel 2000/XP/2003.

Step 13:   Click Yes to begin installation.

Step 14:   The Oracle Installer Settings form is displayed. In the Company Name field, enter the name of the company. Then click Ok.

Step 15:   The Software Asset Manager appears.

Install all of the products listed under Available Products. The products can be installed individually (one at a time), or all products can be selected and installed.

Note: The ADI Online Help will require you to choose a language to install.

Step 16:   After installing the products, click Exit to exit the installer. You will be required to reboot the machine after exiting the installer.

Step 17:   After the computer restarts, load Applications Desktop Integrator by clicking on the Start button, All Programs, Oracle ADI, and finally Applications Desktop Integrator.

Note: Let the client log on to the machine so that you can configure ADI under the user’s id. This is necessary since signon details are not shared between users.

Step 18:   When the application is first loaded, a message appears informing the user to select an Applications database.

Step 19:   After reading the message by the Office Assistant, click on the Signon button.

Step 20:   The Signon form appears. Since there are no predefined databases, click Define Databases to define a new Applications database.

Step 21:   The Select Database form appears. Click Add to add a database.

Step 22:   Fill out the fields in the Add Database Details form, and then click OK.

Copy sqlnet.ora and tnsnames.ora from the “806 NET80” directory in the Project Folder to c:orantnet80admin and c:orantnetworkadmin. Note that these files contain configuration information for the production instance only.

In addition, each instance has a unique server ID. To obtain the server ID for the production instance, navigate to the Project Folder, and then open the file “Server ID.txt”. Copy the hexadecimal string under MFGP and paste it into the Server ID field in the Add Database Details form.

Step 23:   After setting up the database details, save the information and log on to ADI using an Oracle Applications username:

After logging on, perform the following:

  • Choose a Responsibility (for example, GL Super User)
  • From the ADI Toolbar, click Submit Report
  • Click Financial Statement
  • Click in the Report Name, enter % as criteria, click OK and then select a report (for example, Unaudited Balance Sheet)
  • Choose Period (for example, APR-07)
  • Click the Publishing button
  • Select Spreadsheet
  • Click Submit

The job is submitted and completes within a few minutes. It will automatically open in Excel on completion.

Errors Encountered

Error Message: “No Listener”

Solution: Either instance on server does not exist or entry in TNSNAMES.ORA is incorrect. If TNS entry in the local TNSNAMES.ORA file is correct, then listener or database is not started on the server.

Error Message: “ORA-12571: TNS Packet Writer Failure”

Solution: Cannot send packets to the server. A firewall is blocking packets on the client machine.

Error Message: “ORA-12154: TNS: could not resolve service name”

Solution: Ensure that the service name is in c:orantnet80admintnsnames.ora

Check that c:orantnet80adminsqlnet.ora has names.default_domain and name.default_zone commented off.

Check %WINDIR%system32driversetchosts file has hostname and ip address.

Error Message: “An error occurred while attempting to establish an Applications File Server connection. There may be a network configuration problem, or the TNS listener may not be running. Nodename : ORACLESRV”

Solution: Incorrect FNDFS entry is in the TNSNAMES.ORA file. Recopy sqlnet.ora and tnsnames.ora from server onto client machine.

Metalink References

Subject: Tns Packet Writer Failure When Trying To Connect To ADI Ora-12571 (Doc ID: Note:264952.1)

Subject: Unable To Start ADI ORA-12571:TNS:Packet Writer Failure (Doc ID: Note:351088.1)

Subject: Troubleshooting the “Error Occurred While Attempting to Establish an Applications File Server Connection” (Doc ID:  Note:117012.1)

[amazon asin=0071779728&template=iframe image&chan=default]     [amazon asin=1849680620&template=iframe image&chan=default]     [amazon asin=0071622292&template=iframe image&chan=default]

Recreating DBC file

Posted by on November 22, 2006 No comments

Problem: While installing vision instance, the post-install check “JSP Check” fails with the message “DBC file may be invalid”.

Solution: Recreate DBC file.

Note: Run these commands from $FND_TOP/secure. Also, source environment file first.

To create a DBC file and server ID:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis ADD FNDNAM=apps GWYUID=applsyspub/pub TWO_TASK=vis SECURE_PATH=%FND_TOP%secure GUEST_USER_PWD=guest/guest APPS_JDBC_DRIVER_TYPE=THIN DB_HOST=eam.clientnetwork.com DB_PORT=1522

To check status:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis STATUS DB_HOST=eam.clientnetwork.com DB_PORT=1522

To delete DBC file:
java oracle.apps.fnd.security.AdminAppServer apps/apps@vis DELETE DB_HOST=eam.clientnetwork.com DB_PORT=1522

Also, you can run adgendbc.sh, located in $COMMON_TOP/admin/install/

For Database Connectivity problems, ensure that the hosts file is set up properly:

127.0.0.1 localhost.localdomain localhost
hostname.domainname hostname

On Windows, use java. On Linux/Unix, use JRE.

Reference:
Metalink Doc ID: 108865.1 (How To Create a Database Connection(DBC) File and Troubleshooting Common Problems)

No TNS Listener Installing Instance

Posted by on November 6, 2006 No comments

Problem: In step 5 of 5 during installation of Oracle Applications instance, TNS listener does not start.

Solution: hosts file configured incorrectly.

The correct format of the hosts file is:

Under Windows:


xx.xx.xx.xx hostname.domainname alias
127.0.0.1 localhost.localdomain localhost

Another symptom that the hosts file was not set up correctly: the StartCD did not stage properly.

Firewall Error Service Unavailable

Posted by on September 15, 2006 No comments

Problem: When access the production instance, a web page appears stating ‘Service Unavailable’.

Solution: In Internet Explorer, enter the instance’s host name in the list of hosts for the proxy server to bypass.

Troubleshooting Launching Oracle Applications

Posted by on August 10, 2006 No comments

Problem: Unable to get application to launch.

Solution: Try the following:

Step 1:        Check the hosts file (either /etc/hosts or C:WINDOWSSYSTEM32 DRIVERSETCHOSTS) and ensure that the IP address and host is in the file.

Step 2:        Ensure that the local addresses are bypassed in the browser.

Step 3:        Ensure that the instance is started on the server.