This documentation is a start Oracle Applications automatically when the machine is rebooted.
Refer to Doc ID: Note: 61333.1 (Subject: AUTOMATIC STARTUP AND SHUTDOWN OF ORACLE DATABASE INSTANCES)
Can modify /etc/oratab script. This did not start database listener or application services.
Can also put startup script in /etc/rc.local. Must be edited as root user.
su applmgr -c /u2/oracle/scripts/startVIS2.sh su applmgr -c /u3/oracle/scripts/startVIS4.sh
This documentation covers a general backup strategy for the client.
Since a lot of work is being done on the Test instance, it is important that the server housing this instance be backed up on a regular basis.
There are several types of backup media available. For example, CD-ROMs, DVD-ROMs, secondary hard drives etc. CD-ROMs and DVD-ROMs do not possess the required capacity. Secondary hard drives are likely to fail. For example, if a power spike caused the server hard drives to fail, it may also cause the secondary hard drives to fail.
The best medium for backing up servers is tape media. The tape must be capable of backing up the database and related Oracle Application files, as well as the public folder. Storage requirements for these will grow as the project progresses, and this must be taken into consideration. A rough estimate of the tape capacity is about 200GB. This will easily back up the entire server.
Dell sells LTO tape drives (PowerVault 110T LTO Tape Drive) with some of their servers; perhaps this can be used as a starting point for research on tape drives.
There are several commercial backup and recovery solutions available, such as BrightStor ARCserve. ARCserve handles all aspects of job creation, scheduling and recovery from an intuitive GUI. In addition, ARCserve is certified by Microsoft on all of its server platforms.
Windows also comes with it’s own backup software, NT Backup. NT Backup provides much of the basic functionality as ARCserve. However, NT Backup is designed to be a more interactive solution, that is, an operator has to manually choose the files and directories to back up, and then start the backup.
Ideally, the backup should be automated so that an operator does not have to manually start the backup, and the backup can be scheduled in the middle of the night (say 10 o’clock).
NT Backup can be called from the command line with parameters, so the NT Backup command can be placed into a Windows Command Script (with a .cmd extension), which can then be scheduled. However, this method must be diligently tested to ensure that the scheduled backups are going through.
To view the syntax for NTBackup command line parameters, type ‘ntbackup /?’ at the command prompt:
C:> ntbackup /?
NT Backup loads, then the help file appears with the command-line reference.
To use NT Backup, a ‘selection’ of directories to back up has to be created and saved so that it can be referenced on the command line.
At the very least, the directories that should be backed up on oracleserver are
However, if all directories on all of the drives can be backed up, it would be even better.
Regardless of the backup software used, the backup made should be tested on a regular basis. There should be a separate machine, which can be used to test different disaster recovery scenarios.
Go to Control Panel > Administrative Tools > Computer Management.
Click Action, and then click New User.
Enter the new user and password.
Navigate to Control Panel > User Accounts to change the group membership.
Problem: The Customer Statements report prints a banner page.
Solution: On Vision, log on as user operations and access the Receivables, Vision responsibility. From the menu, access Print Documents > Statements.
Refer to Doc ID: Note:99687.1 (Subject: Printing Character Reports with Oracle Applications Release 11)
For the Printer Style MFGL_LANDSCAPE, enable the Suppress Header checkbox for the \oracleserverHPLaser printer.
From Concurrent Programs from the System Administrator responsibility, change the Print Statement program. Change Style to Landscape_mfgl and Printer to \oracleserverHPLaser.
Subject: FAQ (Application Reports)
Doc ID: Note:105105.1
Subject: Printing Character Reports with Oracle Applications Release 11
Doc ID: Note:99687.1
Subject: How to Remove The Banner Page From Printing On Reports
Doc ID: Note:163973.1
Subject: How to Suppress Banner Page when Printing Reports
Doc ID: Note:1038798.6 (No help)
Subject: How to Suppress the Header/Banner Page When Printing Report on AIX?
Doc ID: Note:302847.1 (No help)
This documentation shows the user how to load data for GL Interface.
Step 1: The data file provided by the analyst can either be a .CSV file or a .DAT file.
Step 2: Rename the data file to a name without spaces e.g. datafilename.dat.
Step 3: Copy the data file to the project folder, into folder GLDataLoadElvis.
Step 4: Load on to oracleserver (128.1.2.213) via VNC.
Step 5: Load Command Prompt.
Step 6: Change to D:PRODprodappl. Run APPSORA.cmd.
Step 7: Change to folder D:PROJECT FOLDERGLDataLoadElvis
Step 8: At the Command Prompt, run SQL Loader:
sqlldr80 apps/apps control=elvis.ctl data=datafilename.dat
Step 9: If only about 50-60 lines load, the data was incorrect (the load process fails after 50 lines have failed). Check the log file elvis.log for more information.
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.
Problem: When accessing any menu that launches core forms, get this error:
load: class oracle/apps/fnd/formsClient/FormsLauncher.class not found
Solution: Check the proxy server settings in the browser and ensure that addresses to bypass are correct.
Use the ‘hostname*’ format in the proxy server settings.
From Metalink article Doc ID: Note:291698 (Subject: FormsLauncher.class Not Found Error When Attempting to Access Forms in Applications)
Steps for resolution:
See also: Doc ID: Note:373736.1 (Subject: Load: Class Oracle/Apps/Fnd/ Formsclient/Formslauncher.Class Not Found)
Problem: In Oracle Applications Manager, in Applications Dashboard, on the database is appearing up. The remaining servers are shown as down.
Solution:
Executing service control script:
/emca/PROD/prodcomn/admin/scripts/PROD_linux-blade/adrepctl.sh stop
script returned:
**************************************************** You are running adrepctl.sh version 115.29 Reports Server for PROD is already stopped. adrepctl.sh: exiting with status 2 .end std out. .end err out. **************************************************** Executing service control script: /emca/PROD/prodcomn/admin/scripts/PROD_linux-blade/adfmcctl.sh stop script returned: **************************************************** You are running adfmcctl.sh version 115.16 forms load balancing client for PROD already stopped. adfmcctl.sh: exiting with status 2 .end std out. .end err out. **************************************************** Executing service control script: /emca/PROD/prodcomn/admin/scripts/PROD_linux-blade/adfmsctl.sh stop script returned: ****************************************************
Subject: Summary of Possible Reasons and Solutions for the Problem Where All Concurrent Requests Stuck in Pending Phase Doc ID: Note:182154.1
2. When shutting down the concurrent manager are there any FNDLIBR processes still running at the OS level? If so, do a kill -9 on them. Then restart the concurrent manager.
Tried this, but CM stopped successfully with no need to kill FNDLIBR.
3. Rebuild the concurrent manager views. As applmgr run the following from the OS:
This is non-destructive.
Concurrent Manager views can be rebuild by running the following command at the command line:
Ensure that concurrent manager is shutdown.
FNDLIBR FND FNDCPBWV apps/apps SYSADMIN 'System Administrator' SYSADMIN
Restart the concurrent manager.
Executed the above, but no change.
Executed the code:
update fnd_concurrent_queues set control_code = 'A' where concurrent_queue_name = 'FNDCRM'; commit; SQL> update fnd_concurrent_queues 2 set control_code = 'A' 3 where control_code = 'N' 4 / SQL> select control_code, target_node, concurrent_queue_name 2 from fnd_concurrent_queues 3 where control_code = 'N' 4 / C TARGET_NODE CONCURRENT_QUEUE_NAME - ------------------------------ ------------------------------ N FNDCRM N FNDSCH N STANDARD N PODAMGR N RCVOLTM N PASMGR N INVMGR N INVTMRPM N IEU_SH_CS N IEU_WL_CS N OAMCOLMGR C TARGET_NODE CONCURRENT_QUEUE_NAME - ------------------------------ ------------------------------ N OAMGCS_LINUX-BLADE
updated /etc/hosts file:
[applmgr@linux-blade etc]$ cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost 128.x.x.x linux-blade.domainname linux-blade SQL> create table fnd_concurrent_queues_vseeram 2 as select * from fnd_concurrent_queues;
In Oracle Applications 11.5.10, there is a security feature which prevents users from logging on to the database using SQL tools such as SQL*Plus or TOAD. Refer to Note: 291897.1 (11.5.10 New Features: Managed SQL*Net Access from Hosts) for information on resolving this problem.
To get information pertaining to the host, log on to Oracle Applications Manager, click on Site Map, Administration, and then Hosts. Click the Show link to see the host name, domain and IP address. To determine the port numbers associated with the instance, click View Configuration.
All information is available to place entries into the TNSNAMES.ORA.
NEWTEST = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESERVER.company.local)(PORT=1521)) (CONNECT_DATA=(SID=PROD)) ) FNDFS_ORACLESERVER= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESERVER.company.local)(PORT=1626)) (CONNECT_DATA= (SID=FNDFS) ) )
This documentation shows how to get the server ID string for the machine.
Navigate to the following directory:
%APPL_TOP%fnd11.5.0secure<SID>_<nodename>
e.g.
cd D:TESTTestapplfnd11.5.0secureTEST_oraclesrv
Open the <SID>.dbc (TEST.dbc) file using Notepad and you should see a line:
APPL_SERVER_ID=FE15648D7571C5C9E030005A1B00247727514667901730551185199646909747
Recent Comments