ora-apps-dba

Re: Out of Topic - Facing error during RHEL 4 AS 3 Installation ( Hangs at Uncompressing Linux... Ok, booting the kernel) (Shastry(DBA))

Hi Mikey,Howard and Karl, Thanks alot for your help. I could fix the issue with the below addition(append) in grub: *pci=nommconf all-generic-ide noapic nolapic* and it look like below *Kernel /boot/vmlinuz-2.6.9-42.0.3.ELsmp ro root=LABEL=/ rhgb quiet **pci=nommconf all-generic-ide noapic nolap**ic* ...

(no subject) (Virendra Patel)

hi guys, i am trying to run adpreclone.pl and i am getting the below mentioned error [oravis@vapsoft VIS]$ perl adpreclone.pl dbTier ERROR: Could not find java under /u01/app/oravis/visdb/10.2.0/oui21/jre/1.3.1/bin or /u01/app/oravis/visdb/10.2.0/appsoui/jre/1.3.1/bin Please make sure that you applied the prerequisite oui patch to the RDBMS ORACLE_HOME. ...

Re: Shared APPL_TOP filesystem question (Chuck Edwards)

Agreed - with some serious scripting, use of VIPs, and general clustering experience you can go quite a ways with a commodity NFS setup; the more time and expertise you put into it, the higher the brain cost. To be sure, commercial NFS is going to add a lot of features (OpenFiler may indeed replicate some of these - excellent point) but unless there is a larger need for HA NFS in the enterprise, I might want to point my $$ at the skilled OS person vs the commercial filer; ...

Re: Shared APPL_TOP filesystem question (Luis Freitas)

Chuck, I don't agree that this setup can't deliver automated NFS failover. It should be possible to set these boxes with a shared device, DRDB, OCSF2, whatever, and use Oracle CRS to manage the NFS server and virtual IP. The Linux NFS server already has some provisions to allow for a high availability deployment. There are some parts missing, like proper nfs locks replay, but it can be made to work as an application file system, where these ...

Re: Shared APPL_TOP filesystem question (Chuck Edwards)

From a performance requirement perspective, commercial NFS is overkill for shared application file systems. Standard Linux/UNIX NFS will do just fine and is quite cheap. For failover, you can simply set up two servers and have them rsync changes from one to another. If you experience a failure, simply mount the file system from the failover on your application servers and off you go. It's not instantaneous, to be sure, but it provides a couple of advantages: 1. Cost is very low. A pair of ~$900 white boxes with mirrored disk ...

Re: Shared APPL_TOP filesystem question (Luis Freitas)

Hmmm, NFS thirdy party vendors are $$$, but operating system clusterware to manage NFS high availability can also be $$$. Sun cluster suite, HP cluster, or Veritas is not exactly cheap. I don't know how the clusterware licensing goes for AIX. For Redhat, RHCS used to be licensed separatelly but on the latest release they included it on the operating system license. ...

Re: Shared APPL_TOP filesystem question (oraapps)

What is your Operating System. Try to stay away from NFS 3rd party vendors ($$$). If your Operating system Vendor has a tool or utility use it. I'm on AIX and the OS can hand and manage NFS (we call it automount). This way no deamons get stale or old or require rebooting. Hope this helps. ---- biz arrays bizarrays@xxxxxxxxxxxxx wrote: Hi Yury, ...

Cygwin installation problem (Subodh Deshpande)

hello all, am downloading freely available Cygwin from Cygwin.com, it has nearly downloaded 325 mb but could not install any thing.. to get the linux like environment on windows box which are the packages I should select. please help.. thanks in advance..subodh -- ...

Re: Shared APPL_TOP filesystem question (Luis Freitas)

NetApp Filer would be a good choice Also, you could have a high available NFS server, possible using vendor or Oracle clusterware to manage it. (Will require additional licensing) --- On Wed, 10/28/09, biz arrays bizarrays@xxxxxxxxxxxxx wrote: From: biz arrays bizarrays@xxxxxxxxxxxxx ...

Shared APPL_TOP filesystem question (biz arrays)

Hi Yury, Quick question on Shared APPL_TOP. We have test nfs no problem with, because it is a Single point of failure, are there any other certified options that could be used. I know few people use ocfs2 which is not supported for Appl_top file system sharing. Are you aware of any better ways of configuring shared APPL_TOP. (any ...

Out of Topic - Facing error during RHEL 4 AS 3 Installation ( Hangs at Uncompressing Linux... Ok, booting the kernel) (Shastry(DBA))

Hello All, Sorry in first place as this question might be felt Out of scope in this forum. I am trying to setup a 11.5.10.2 for testing purpose on RHEL 4 AS 3, But I was successful in installing the Linux by giving the below parameter: linux askmethod pci=nommconf all-generic-ide noapic nolapic ...

Re: rotatate logs - Apache has anyone got this to rotate at a specific time? (kathy duret)

actual I have 2.2 on the one and it isn't working. the 1.3 is actually working better go figure. Kathy --- On Mon, 10/19/09, Mark Weaver mark-clist@xxxxxxxxxx wrote: From: Mark Weaver mark-clist@xxxxxxxxxx ...

Re: rotatate logs - Apache has anyone got this to rotate at a specific time? (kathy duret)

tried it on both Apache 1.3 and 2.0 no dice 86400 basically rotates it every 24 hours. I am having issues trying to even force a log rotation. So much fun so little time. kathy ...

Re: WLS and OEM Grid (Luis Freitas)

Kathy, Well, for iAS, EBS, RAC, what I do is start everything on the host before installing the OEM agent, so it can see what ports are being used and choose other ones. And of course, install on a different ORACLE_HOME. But I never worked with WLS so cant guarantee this will work... (I think I am in trouble, since the new AS release is already WLS based :-) ...

Enable JVM monitoring in EBS (Virendra Patel)

Hi, Need help to setup JVM monitoring on on EBS to enable this in which file do in add the lines mentioned below -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=1099 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false Thanks ...

Re: rotatate logs - Apache has anyone got this to rotate at a specific time? (Chuck Edwards)

Run this from the command line: logrotate -f path to config file That will force a rotation of the logs specified in the config file, even if the parameters wouldn't indicate rotation is needed. If you already use logrotate.d, you can just specify the config file there: ...

Re: rotatate logs - Apache has anyone got this to rotate at a specific time? (kathy duret)

I am using the rotaelog funciton via Linux and it works The issue is I need to force it at midnight I can't shutdown the services. I want to find out how to force a rotatelog at midnight if I can't get the rotatelog function to do it. Thanks, ...

Re: rotatate logs - Apache has anyone got this to rotate at a specific time? (Chuck Edwards)

Have you tries using logrotated? It's included in most Linux distros, but available for any UNIX. Don't know about Windows. You can easily set it up to run out of cron and do a graceful apache HUP: Here's a logrotate script I use - this is in /etc/logrotate.d, but you can run logrotate directly from a cron script at midnight, too: path to ias_oracle_home/Apache/Apache/logs/error_log path to ...

rotatate logs - Apache has anyone got this to rotate at a specific time? (kathy duret)

I am using the rotatelog function for my Apache logs. ErrorLog |/u01/Apache/Apache/bin/rotatelogs /u01/app/oracle/product/sso10g/Apache/Apache/logs/error_log.%Y%m%d 86400 While this does rotate the logs every 24 hours with a datetime,I specifically need to have it run at midnight. Yes, I have an SR open and yet I posted to Apache forums. ...

Oracle Applications MAA questions (Jose Ruiz)

Hi, we are planning to provide MAA for our EBS Production instance. In the DB tier we are going to implement a Stand by database but for the Apps Tier I have some questions. We are going to clone the Apps tier firsts in a new server to be able to work with the stand by database, the problem here is how can we update this Apps tier each time we apply a patch in the Production instance. ...

Re: WLS and OEM Grid (kathy duret)

I will let you know. I got some stuff from another dbs and some from an Sr I am just worried about the fact the WLS the server has an EMAGENT ruuning that needs to run and now I have to install the OEM agent on the box. --- On Tue, 10/13/09, Luis Freitas lfreitas34@xxxxxxxxx wrote: ...

Re: WLS and OEM Grid (Luis Freitas)

Kathy, Never worked with WLS, but I don't really see an issue.(BTW, that is Web Logic Server, Right?) If the plugin doesnt work or is not available, you could get away registering user defined metrics on the host, which are essentially shell commands. Probably also Web Applications and Services, but my knowledge on grid control is rather limited... So I cant help you with those. ...

WLS and OEM Grid (kathy duret)

Has anyone hooked up WLS 11G to Grid Conrol? I know it has it's own EM agent but I need to set up alerts etc like on our db boxes and services and haven't done this on an apps box much less for WLS and all of our Portal services we are setting up. Yes I have a SR open on this request and it has been bounced back for several weeks between WLS and OEM groups. All I could find was a note from the overview dated September 9th that this was ...

Re: OPMN fails to start-up (Kalyan Sundar)

Ram/Atul, I was able to get through. There were some orphan opmn processes running on the server on same port. I killed them manually and it woked fine. Thanks, Kalyan On Wed, Oct 7, 2009 at 8:38 PM, atul@xxxxxxxxxxxxxxx wrote: ...

Re: OPMN fails to start-up (atul)

Sundar, Check if there is any other ons.conf on machine or change port in ons.conf from 6101 and try restarting . If this still fails share if this is 9i, 10g or 10gR3 opmn Atul Kumar ...

Re: OPMN fails to start-up (Ramakrishnan Seshadhri)

What is the eroor in ons.log? Also do you face the error when starting opmn or while bringing up components inside opmn container? Ram On Wed, Oct 7, 2009 at 6:32 PM, Kalyan Sundar kalyan.sundu@xxxxxxxxxwrote: ...

OPMN fails to start-up (Kalyan Sundar)

Hi all, I am facing an issues while starting up OPMN services. I can find below error in opmn.log. Could this be a port conflict issue?? or come issue with host name?? Please advice. 09/10/07 16:53:18 [ons-connect] Passive connection 127.0.0.1,6100 missing connect 09/10/07 16:53:18 [ons-connect] Passive connection 127.0.0.1,6100 missing ...

PLS Files (k srinivas)

Hi All .. Just a basic question,wht are .pls files and it significance in EBS.. ...

Re: Exception: oracle.apps.fnd.cache.CacheException while accessing self service appplications (Shastry DBA)

Thanks much to vikram and atul. I could fix the issue after running Synch WF Local tables. Sent from my iPod An :-) On 25-Sep-2009, at 7:18 PM, atul@xxxxxxxxxxxxxxx wrote: ...

Re: EBS 11i - Function not available to this responsibility (Harish Muramshetty)

Hi Bhagat, There should be a customSID.env file under APPL_TOP.check whether it exists and then run autoconfig. Regards, Harish. ...

EBS 11i - Function not available to this responsibility (BHAGAT SINGH)

If you are familiar with this error and have solution,please send me that. Best Regards, Bhagat ...

Re: Exception: oracle.apps.fnd.cache.CacheException while accessing self service appplications (atul)

Anant, There could be N reasons for duplicate keys in underlying tables . Search in metalink for ORA-01452 Synchronize WF local tables and you will get plenty of hits , search one specific to your instance. Regards Atul Kumar ...

Re: Exception: oracle.apps.fnd.cache.CacheException while accessing self service appplications (Shastry(DBA))

HI Vikram, I Got this below alert while executing the Synchronize WF local tables concurrent request. Any help is really appreciated. ORA-12801: error signaled in parallel query server P000 ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found Thanks, ...

Re: Exception: oracle.apps.fnd.cache.CacheException while accessing self service appplications (Vikram)

Try running the concurrent request: Synchronize WF local tables. On Fri, Sep 25, 2009 at 6:42 PM, Shastry(DBA) shastry17@xxxxxxxxx wrote: Hello Gurus, We have problems in accessing(self service web based application) iProcurement or any other responsibility from Oracle which opens a webpage eg. iProcurement, iExpense, and facing the below error ...

Exception: oracle.apps.fnd.cache.CacheException while accessing self service appplications (Shastry(DBA))

Hello Gurus, We have problems in accessing(self service web based application) iProcurement or any other responsibility from Oracle which opens a webpage eg. iProcurement, iExpense, and facing the below error An exception occured. URL=null ...

Re: in wf_notifications mail status is null (Subodh Deshpande)

yes this problem is resolved, one IMAP related os process was not running on ourserver, after starting it, it resumed. thanks! subodh ----- Original Message ---- From: Subodh Deshpande subodh_deshpande@xxxxxxxxx ...

RE: in wf_notifications mail status is null (Luis Freitas)

Hi, You can check the value for a particular user on FND_USER_PREFERENCES. Query the table for the user in question and see if he has something setup for the mail preference, I dont remember which key it is. This table also stores the system default value with a strange key that starts with # if I am not mistaken. ...

RE: Using Virtual Node name for Concurrent Node in R12 (Shyam Kumar)

Not sure if you got the reply Oracle supports Virtual Nodes - use the following metalink note 356433.1, (Section 2) I don't see any issues wheter its 11i/R12 ...

RE: in wf_notifications mail status is null (Shyam Kumar)

Sorry for the late reply. You need to verify the user setup - who reported that he can't get any emails. Login to OAM - Workflow Setup - Verify by sending a test email to the user who reported the problem. You can check the log in $APPLCSF/log/FND*.txt (Check for latest timestamp, or grep the files with NID) - to see if the emails are sent ...

Re: sending sms (Fred Bbaale)

Does your Telco provider have an sms-email interface? If they have , then you could use the Enterprise manager GC to send an email to your Phone account . Otherwise you might have to buy some GSM hardware -- Fred Bbaale ...

Re: sending sms (James Morrow)

Since your servers aren't actually *on* a cellular network, you'll have to do it through your carrier's email-to-sms gateway... Here are a few links: -- James ---------------------------------------------------------------------- ...

sending sms (Kenan �zt�rk)

hi gurus, i want to be informed by sms in case of any database failures, is there a simple way or a complete guide to accomplish this?? Best Regards, Kenan ...

RE: in wf_notifications mail status is null (oraapps)

Not sure what to verify. only could see this page as sysadmn user and it says html mail with attachments. sysmin doesn't have a e-mail account to work with our IMAP stuff. Not sure what notifications sysadmin should get? Greg once looked at it said I' lanning a ---- Shyam Kumar shyam4558@xxxxxxxxxxx wrote: Many users will not get email, if they don't have proper settings, ...

RE: in wf_notifications mail status is null (Shyam Kumar)

Many users will not get email, if they don't have proper settings, Responsibility - Preferences SSWA - Preferences - Email Style (Notifications section) Verify this... and also proper email (in order FND_USER, PER_ALL_PEOPLE_F, WF_LOCAL_ROLES) ...

Re: in wf_notifications mail status is null (oraapps)

Hello, I've been reading your posts. I have frequent issues around our mailer application.. and yes your blog and updates are usefull. I have a purchasing superuser that has her notification preference set to query. She is the main purchasing person and most all of my users forward their PO's to her. Once she does the work they then go to the controller or back to the suer for updates. Many users complaine that they don't get their ...

Re: in wf_notifications mail status is null (Subodh Deshpande)

Thanks Yuri, Luis :) am going through your blog Yuri and will be a regular visitor too :) I agree with notification mailermight be updating 'null' status instead of 'SENT' for some of the processed notifications. And what i found is, there are different mail status like 'SENT','ERROR','FAILED','MAIL', 'SENT' and 'NULL' till date, then in which case it updates to 'NULL'. ...

Re: in wf_notifications mail status is null (Jurijs Velikanovs)

Hi Suboh, I would go with Luis suggested direction. You might run the following query to find out a user email and notification properties: SELECT u.user_name, r.notification_preference, r.email_address FROM fnd_user u, wf_local_roles r WHERE r.name = u.user_name and u.user_name = 'username'; ...

Re: Oracle-Apps 11.5.9 on Solaris 10 (Nelabhotla Durga Charan)

Hi, SUN OS wise you will not get any issues and Solaris is a very standard ,robust platform for oracle apps. In your case, you are migrating 11.5.9 to same OS from lower to higher version. Regards Durga On Tue, Sep 15, 2009 at 12:30 PM, Avadhani mys avadhanimys@xxxxxxxxxwrote: ...

Oracle-Apps 11.5.9 on Solaris 10 (Avadhani mys)

Gurus, I would like to know if any one is running oracle ERP 11.5.9 [Production] environment on Sun Solaris 10, if yes what are the issues and risks involved and what could be the best practices. Our environment is on Sun Solaris 9 and We are planning to move the same to Solaris 10. Thanks in Advance. ...

Re: in wf_notifications mail status is null (Luis Freitas)

Suboh, If this is happening for only some user, then probably these users dont have e-mails on WF_USERS. Regards, Luis --- On Mon, 9/14/09, Subodh Deshpande subodh_deshpande@xxxxxxxxx wrote: ...