tag:blogger.com,1999:blog-6335343228190511009.comments2023-10-17T03:07:46.787-07:00Oracle Apps TechnologyVikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.comBlogger1008125tag:blogger.com,1999:blog-6335343228190511009.post-54355383084634852612017-05-01T08:49:04.258-07:002017-05-01T08:49:04.258-07:00It is very much recommended as per support.oracle....It is very much recommended as per support.oracle.com article "Setting nproc values on Oracle Linux 6 for RHCK kernel (Doc ID 2108775.1)" Vikram Dashttps://www.blogger.com/profile/08777547738218549011noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-38731544156548234002017-04-10T02:52:03.525-07:002017-04-10T02:52:03.525-07:00After creating a controlfile manually without any ...After creating a controlfile manually without any backup how the database goes to a consistent state? Because the newly created controlfile does not have the scn details as well as checkpoint information that the deleted controlfile had. <br />Also after restoring the controlfile is it needed to open the database in resetlogs mode? If not why?<br /><br />Good question<br /><br />I too was very focusing on this one when I restore controlfile and open the database with resetlogs and I try to open with noresetlogs but no luck.<br /><br />With this point I clear my doubt and according to my understanding if you recreated controlfile or restore from autobackup the scn and ckpt information is different.<br /><br />Anyway a control file restored from a backup has an SCN taken at that "remote" time, different compared with those currently available in the datafiles and redo logs and so they have to be resynchronized.<br /><br />To resynchornized controlfile with redologs and datafiles we need to do resetlogs and you know resetlogs: "RESETLOGS will initialize the logs, reset your log sequence number, and start a new "incarnation" of the database."G M KHANhttps://www.blogger.com/profile/16948879493996798431noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-9517401926237153462017-03-27T10:06:29.046-07:002017-03-27T10:06:29.046-07:00This is helpful Thanks for posting it. This is helpful Thanks for posting it. Sharadhttps://www.blogger.com/profile/05535644349920784748noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-89119024534856036362017-03-17T14:48:03.131-07:002017-03-17T14:48:03.131-07:00We are looking for help with our 12.2.6 upgrade We are looking for help with our 12.2.6 upgrade Durga Prasad Vanamalahttps://www.blogger.com/profile/10097606094255518187noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-66186991377492194362017-03-01T22:50:57.593-08:002017-03-01T22:50:57.593-08:00Hi,
Thanks,
it's worked
SQL> select node...Hi,<br /><br />Thanks,<br /><br />it's worked<br /><br />SQL> select node_name from txk_tcc_results;<br /><br />NODE_NAME<br />--------------------------------------------------------------------------------<br />ebs2<br /><br />SQL> update txk_tcc_results set node_name 'ebs5' where node_name='ebs2';<br />update txk_tcc_results set node_name 'ebs5' where node_name='ebs2'<br /> *<br />ERROR at line 1:<br />ORA-00927: missing equal sign<br /><br /><br />SQL> update txk_tcc_results set node_name='ebs5' where node_name='ebs2';<br /><br />1 row updated.<br /><br />SQL> commit;<br /><br />Commit complete.<br /><br />Anonymoushttps://www.blogger.com/profile/04477515312746149096noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-87541309573080374642017-02-04T02:21:53.281-08:002017-02-04T02:21:53.281-08:00I am very much pleased with the contents you have ...I am very much pleased with the contents you have mentioned. I wanted to thank you for this great article. I enjoyed every little bit part of it and I will be waiting for the new updates.<br /><a href="https://docs.zoho.com/writer/published/19n3p0b2f1734f1c741c29ab4beaf4b612f90" rel="nofollow">custom logo</a>Tiffany Newcomerhttps://www.blogger.com/profile/12637011126933931112noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-41755796877899081192016-12-22T12:28:42.753-08:002016-12-22T12:28:42.753-08:00what is list snapshots and list of snapshots
are ...what is list snapshots and list of snapshots<br /><br />are they be deleted ? do we claim any space by delelting any space if we delete any snapshots<br /><br />Anonymoushttps://www.blogger.com/profile/10817158175302408803noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-87026658470256071582016-12-08T03:45:13.374-08:002016-12-08T03:45:13.374-08:00Hi Vikram.,
Thanks for tis blog it would be very ...Hi Vikram.,<br /><br />Thanks for tis blog it would be very useful for me if it resolves my issue,but i am not very clear about the steps performed over here and what parameters are used in the command sysntax.<br /><br />Also i donot understand from where i have to run these command and should application be down or up while executing these commands.<br />Kindly explain all step clearly.<br /><br />Urgent reply and help would be very helpful and thanks in Advance.<br /><br />Regards,<br />Harish Anand<br />+91-9560088453Anonymoushttps://www.blogger.com/profile/10858523438895943908noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-41760612328925334222016-11-06T00:23:24.456-07:002016-11-06T00:23:24.456-07:00Hi,
does it still work for newer version like 54 ...Hi,<br /><br />does it still work for newer version like 54 + of chrome 64bit ?<br /><br />RegardsBilluBhaihttps://www.blogger.com/profile/02258553660226302762noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-8255071969691781712016-11-01T13:21:35.201-07:002016-11-01T13:21:35.201-07:00Hi Vikram,
I'm setting java Workflow mailer t...Hi Vikram,<br /><br />I'm setting java Workflow mailer to connect using SSL to IMAP Server following the doc 1265949.1.<br /><br />In step 8, <br />Test connectivity to the IMAP server using Command-Line Notification Mailer Diagnostics.<br /><br />I'm getting below error, can you help me for this?<br /><br /> $AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap \ <br /> > Ddbcfile=/tmp/s1mtb2/t847.dbc \ <br /> > Dport=993 -Dssl=Y \ <br /> > Dtruststore=/opt/orapp847/appst847/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/security/cacerts \ <br /> > Dserver=appsmailert847.swissre.com \ <br /> > Daccount=imapt847@appsmailert847.swissre.com \ <br /> > Dpassword=GtmhiYc16o \ <br /> > Dconnect_timeout=120 -Ddebug=Y \ <br /> > Dlogfile=/tmp/testing.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer <br /> Exception in thread "main" java.lang.NoClassDefFoundError: Ddbcfile=/tmp/s1mtb2/t847/dbc <br /> Caused by: java.lang.ClassNotFoundException: Ddbcfile=.tmp.s1mtb2.t847.dbc <br /> at java.net.URLClassLoader$1.run(URLClassLoader.java:200) <br /> at java.security.AccessController.doPrivileged(Native Method) <br /> at java.net.URLClassLoader.findClass(URLClassLoader.java:188) <br /> at java.lang.ClassLoader.loadClass(ClassLoader.java:307) <br /> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) <br /> at java.lang.ClassLoader.loadClass(ClassLoader.java:252) <br /> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) <br /> Could not find the main class: Ddbcfile=/tmp/s1mtb2/t847.dbc. Program will exit. <br /><br />Regards,<br />WasimAnonymoushttps://www.blogger.com/profile/15129327282578622338noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-1675897244454072342016-10-23T22:31:02.124-07:002016-10-23T22:31:02.124-07:00Hi Vikram,
Thanks a lot for the solution. I have ...Hi Vikram,<br /><br />Thanks a lot for the solution. I have faced this issue while installing 12c(32 bit) client on RHEL 7.2(64 bit) platform. I have verified with all available metalink solutions not worked for me.We struggled by this almost a day.<br /><br />Finally i was able to fix it by installing 32 bit RPMs:<br /><br />sssd-client-1.11.6-30.el6_6.3.i686.rpm and its dependency RPMs<br /><br />I wonder by this because these rpms are not even mentioned as pre-requisites from oracle support. Thanks a lot for sharingprashanthhttps://www.blogger.com/profile/05488560944207808085noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-26870694903064977702016-10-20T20:07:25.701-07:002016-10-20T20:07:25.701-07:00Thanks great for this post. It solved my problem.Thanks great for this post. It solved my problem.Anonymoushttps://www.blogger.com/profile/15428499134307314682noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-2011091064225309282016-10-20T20:05:32.119-07:002016-10-20T20:05:32.119-07:00Thanks for this post. It help me and works fineThanks for this post. It help me and works fineAnonymoushttps://www.blogger.com/profile/15428499134307314682noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-87092375370591783642016-10-20T02:32:11.220-07:002016-10-20T02:32:11.220-07:00Hi Vikram,
What is the value you changed in the x...Hi Vikram,<br /><br />What is the value you changed in the xml files and did you change it accordingly to the port pool which you give. Kindly advice.<br /><br />SureshAnonymoushttps://www.blogger.com/profile/00536067684306007880noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-42466562743201192442016-09-18T23:36:23.033-07:002016-09-18T23:36:23.033-07:00Same issue in R12.2.4 but there is no $COMMON_TOP/...Same issue in R12.2.4 but there is no $COMMON_TOP/_pages<br />Any suggestions on how to proceed?Prateek Mohanhttps://www.blogger.com/profile/08838777933578081357noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-22704603738982330652016-07-18T01:55:38.337-07:002016-07-18T01:55:38.337-07:00Yes , Its helpful.
Great sharing,
thanks
kind re...Yes , Its helpful.<br />Great sharing, <br />thanks<br /><br />kind regards,<br />Anas AliAnonymoushttps://www.blogger.com/profile/12669898505644915440noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-53382753848663914922016-06-10T11:57:10.974-07:002016-06-10T11:57:10.974-07:00Renaming ldap directory worked for me. Thank you f...Renaming ldap directory worked for me. Thank you for your help!Amishhttps://www.blogger.com/profile/11737726964611476775noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-70290791900199864072016-05-07T20:03:56.731-07:002016-05-07T20:03:56.731-07:00How frequenlty is recommended to run snapshot usin...How frequenlty is recommended to run snapshot using adadmin to update APPL_TOP<br />What are the main advantages of it and what happens if we donot run since long time<br />How do I know snapshots are last captured when or ran last time<br />every time i apply patch it says updating snapshot " is it just updating only for the files which are part of that patch"phanihttps://www.blogger.com/profile/14143886110272930240noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-68567989847027797392016-05-04T18:29:59.182-07:002016-05-04T18:29:59.182-07:00Also, when there is change of permission on .DAT f...Also, when there is change of permission on .DAT files, or chnage of ownershiip of .DAT files.<br />The scenario will occur.<br /><br />VinodVinodhttps://www.blogger.com/profile/17519118594412584982noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-68428612151881918302016-04-06T03:43:40.623-07:002016-04-06T03:43:40.623-07:00When i remove _page, nothing is working....
Pleas...When i remove _page, nothing is working....<br /><br />Please provide the MOS id's if you resolve this issue, otherwise don't deviateMohd Qader (Learning Oracle)https://www.blogger.com/profile/05128822533271729158noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-74688958423288324142016-03-08T21:13:54.831-08:002016-03-08T21:13:54.831-08:00Well done Bro it worksWell done Bro it worksAnonymoushttps://www.blogger.com/profile/14343151644524340191noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-72365036717758225582016-03-08T03:06:55.289-08:002016-03-08T03:06:55.289-08:00thank you Mr. Vikram.
it worked for me.
Jayara...thank you Mr. Vikram. <br /><br />it worked for me. <br /><br />Jayaraj<br />jayaraj@sffeco.com.saJayaraJ IPhttps://www.blogger.com/profile/14016697694311681758noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-1259676108180469112016-02-28T22:04:13.240-08:002016-02-28T22:04:13.240-08:00Hi Kishore,
I am getting the same issue for R12.1...Hi Kishore,<br /><br />I am getting the same issue for R12.1.3 Instance. Can you please share the update for the resolution for it @Kishore<br /><br />Regards<br />BaigSalman Baighttps://www.blogger.com/profile/03326522596136653648noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-36948790724762735562016-02-28T22:03:31.908-08:002016-02-28T22:03:31.908-08:00Hi There,
I am getting the same issue for R12.1.3...Hi There,<br /><br />I am getting the same issue for R12.1.3 Instance. Can you please share the update for your solution, if any?<br /><br />Regards<br />BaigSalman Baighttps://www.blogger.com/profile/03326522596136653648noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-65201234259836350512016-02-22T22:58:48.872-08:002016-02-22T22:58:48.872-08:00Used this same \ldap rename fix tonight on a WL 10...Used this same \ldap rename fix tonight on a WL 10.3.6 server. Saved me a real headache.Troyhttps://www.blogger.com/profile/03234811057875589800noreply@blogger.com