vngappsdba

error /appdata/app/Oracle/domains/aserver/devsoa_domain/servers/bam_server1/logs bam_server1-diagnostic.log  [2022-11-30T09:14:30.220-08:00] [bam_server1] [TRACE:32] [] [oracle.beam.server.service.alertsengine] [tid: [ACTIVE].ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: b9aac564-e273-4651-8c51-13b15dc5a357-00000946,0] [APP: BamServer] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.beam.server.service.alertsengine.engine.event.EventManager]  [SRC_METHOD: notify] exception on executing query Fix: Apply following 2 messages Patch 30334074: BAM12c Alert With Trigger Query Not Triggering Patch 30246778: BAM12c Alert With Parameterized Message Throws Serialization Error

  Insert into coretoebs_process_info (PROCESS_NAME,HOST_NAME,PORT_NAME,ACTIVE,CREATE_DATE,REQUEST_TYPE,PROTOCOL) values ('UpdateCRMProjectToEBS','soaapp01.rosendin.com',7001,'N',to_date('03-OCT-16','DD-MON-RR'),'POST','HTTP/1.1') Error report - ORA-01950: no privileges on tablespace 'USER Fix: SQL> ALTER USER apps_bpel QUOTA 100M ON USERS; User altered. SQL> GRANT UNLIMITED TABLESPACE TO apps_bpel; Grant succeeded.

 while running txkPostPDBCreationTasks.pl OPW-00021: Failed to retrieve DB password file location from the CRS resource [oracle@ebsproddb dbhome_1]$ Executing SYSTEM command: orapwd file=+DATA/PRDCDB_IAD1DZ/DATAFILE/orapwPRCDB force=y dbuniquename=PRDCDB Enter password for SYS:  OPW-00021: Failed to retrieve DB password file location from the CRS resource EXIT STATUS: 255 *******FATAL ERROR******* PROGRAM : (/u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/bin/txkPostPDBCreationTasks.pl) TIME    : Tue Nov 29 23:28:15 2022 FUNCTION: main::generateSystemOraPasswd [ Level 1 ]  ERRORMSG: Password file creation did not go through successfully. *******FATAL ERROR******* PROGRAM : (/u01/app/oracle/product/19.0.0.0/dbhome_1/appsutil/bin/txkPostPDBCreationTasks.pl) TIME    : Tue Nov 29 23:28:15 2022 FUNCTION: main::generateSystemOraPasswd [ Level 1 ]  ERRORMSG: Password file creation did not go through successfully. cause: DB UNIQUE NAME is wrong while r...

1 ) yum update -y 2 ) yum groupinstall "Server with GUI" 3) yum  install tigervnc-server tigervnc-server-module -y 4) ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target   4) yum install oracle-ebs-server-R12-preinstall  == for EBS 5) yum install openmotif21-2.1.30-11.el7.i686   6) systemctl unmask firewalld 6.1) systemctl enable firewalld 6.2) systemctl start firewalld 6.3) firewall-cmd --reload 6.4) firewall-cmd --zone=public --add-port=5901/tcp --permanent systemctl set-default graphical.target systemctl start graphical.target   7) yum install -y oracle-database-preinstall-19c  ==for Oracle DB  

 while executing  " yum update -y "command getting following error message Excluding 84 updates due to versionlock (use "yum versionlock status" to show them) No packages marked for update Fix: yum versionlock clear

echo "test"|mailx "test" vaddicloud@gmail.com verified maillog vi /var/log/maillog error:  sendmail[1785257]: 2ASIU1Gw1785257: to=root, ctladdr=root (0/0), delay=00:00:0.1] [127.0.0.1], dsn=4.0.0, stat=Deferred: Connection refused by [127.0.0.1]  mailq ===> showing some mails in queue whether server is using mailx or postfix commands to send emails root@xxxx1 ~]#  systemctl restart mailx Failed to restart mailx.service: Unit mailx.service not found.  mailx service is not enabled in the server Fix: server is using postfix to send emails systemctl restart postfix

  C:\app\xstore107\cfgtoollogs\netca\trace_OraDB19Home1-2211222AM5720.log  LISTENER:The information provided for this listener is currently in use by other software on this computer. Profile configuration complete. Check the trace file for details: C:\app\xstore107\cfgtoollogs\netca\trace_OraDB19Home1-2211222AM5720.log Oracle Net Services configuration failed. The exit code is 1      [Thread-291] [ 2022-11-22 02:57:29.380 PST ] [StepErrorHandler.collectFatalError:528] Collecting fatal error :[StepExecutionException: Error in Process: C:\app\19c\dbhome_1\bin\netca.bat    Parsing command line arguments: Parameter "silent" = true Parameter "local" = true Parameter "inscomp" = server Parameter "insprtcl" = TCP Parameter "orahome" = C:\app\19c\dbhome_1 Parameter "instype" = custom Parameter "listener" = LISTENER Parameter "lisport" = 1521 Parameter "cfg" = local Parameter "responsefile" = C...

 While configuring OAuth2.0 workflow  we are getting error "protocol not supported" as soon as enter inbound server name as outlook.office365.com Fix:  weblogic console servers   managed servers lock and edit forms-server1 ==>serverstart==>arguments==enter following line at the end of argument ==>save -DUseSunHttpHandler=true -Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2   oacore-server1 ==>serverstart==>arguments==enter following line at the end of argument ==>save -DUseSunHttpHandler=true -Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2   oafm-server1 ==>serverstart==>arguments==enter following line at the end of argument ==>save -DUseSunHttpHandler=true -Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2   admin-server1 ==>serverstart==>arguments==enter following line at the end of argument ==>save -DUseSunHttpHandler=true -Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2   Activate changes   bounce all services adstpall.sh ...

Unsuccessful in TNS ping of node EBSERPAPP2, error reported: Ping Timed Out. Could not contact Service Manager FNDSM_EBSERPAPP2_R12ZAT. The TNS alias could not be located, the listener process on EBSERPAPP2 could not be contacted, or the listener failed to spawn the Service Manager process. Cause: unable to telnet node2 from node1 [root@ebserpapp1 ~]# telnet ebserpapp2.nprdmt.nprd.oraclevcn.com 1646 Trying 10.203.2.144... ^C [root@ebserpapp1 ~]# telnet ebserpapp1.nprdmt.nprd.oraclevcn.com 1646 Trying 10.203.2.78... Connected to ebserpapp1.nprdmt.nprd.oraclevcn.com. Escape character is '^]'. ^] telnet> quit Connection closed. Solution: enable ingress rule in Cloud console to enable access node2 from node1.

  $AFJVAPRG -classpath .:$AF_CLASSPATH OAuthIMAPTest OCIEBDEV@xxxxihotels.com 029ed1da-8d5d-4b29-8492-c5d44db4e100 https://login.microsoftonline.com/902ff0f7xxxx-4fea-8a30-63142fd6438d/oauth2/v2.0/token https://outlook.office365.com/.default 01068342 01068343 Ox@xels22 /appltop/oracle/R12DEV/fs1/inst/apps/R12DEV_ebserpapp/appl/fnd/12.0.0/secure/R12DEV.dbc MicrosoftOffice365ExchangeOnline > /tmp/OAuth_Imaplatest.out javax.mail.AuthenticationFailedException: AUTHENTICATE failed.         at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:474)         at javax.mail.Service.connect(Service.java:275)         at javax.mail.Service.connect(Service.java:156)         at OAuthIMAPTest.main(OAuthIMAPTest.java:100) log file: OAuth AccessToken is => xfsdfasdfafasdfasdfasfasdfasdzAtNjMxNDJmZDY0MzhkIiwidXRpIjoiREdEYmduTHlnMHF0MUpxaHNwVkFBQSIsInZlciI6IjEuMCIsIndpZHMiOlsiMDk5N2ExZDAtMGQxZC00YWNiLWI0MDgtZ...

 Caused by: javax.naming.CommunicationException [Root exception is java.net.ConnectException: t3://xxxxx.nprdmt.nprd.oraclevcn.com:7021: Destination unreachable; nested exception is:         java.net.ConnectException: Connection timed out (Connection timed out); No available router to destination] Solution:  OCI Console ==> Network ==> VCN ==> Subnet ==> Security List ==> Ingress rule issue is with ingress rule for all ports on for second node specific 

 as  root user  1) create group  groupadd -g 1003 dba 2) Next, create the user and add it to the group:  useradd appr12uat -u 54323 -g 1003 3) details of user  id appr12uat uid=54323(appr12uat) gid=1003(dba) groups=1003(dba) 4) allow users to access cd /etc/ssh sshd_config vi sshd_config AllowUsers opc appr12uat 5) restart sshd service systemctl restart sshd

  FRM-92101 - There was a failure in forms server during startup.this could be due to invalid configuration Solution details are as folllows This issue is due to Load balancer session persistence as well ssl certificate . Upload the valid certificate at load balancer level. steps are as follows Networking ==> Load Balancers   ==>  Load Balancer Details ==>  Certificates select "Load Balancer Managed Certificates"   upload certificate.

error Error while invoking Main Menu. JBO-30012: A cookie for session E02mjlutVwzWPYleQZxVrDhU8D and application oracle.apps.fnd.framework.navigate.server.OANavigatePortletAM has already been registered  with application pool ebsuatdb.nprd.nprd.oraclevcn.comR12UAT1541oracle.apps.fnd.framework.navigate.server.OANavigatePortletAM. The cookie must be removed first. cause: due to load balancer session persistence and upload SSL certicate Fix:  1.      OCI console :Network : Load Balancer==> Backend Sets==>Edit Modify the  Session Persistence  configuration. For example, if you select  Enable Application Cookie Persistence , and set  Cookie Name  to  '*' , then responses that contain any cookie will be directed to the same server in the domain ensure that you are using valid ssl certificate

 in OCI ..DBCS  while executing dbcli list-databases getting the following error  DCS-10001:Internal error encountered: org.glassfish.jersey.internal.inject.InjectionManagerFactory: : java.io.FileNotFoundException: fix:  Restarting DCS agent solve this symptom. systemctl stop initdcsagent systemctl start initdcsagent dbcli list-databases ID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID xxxxxxxxxxxxxx UATCDB Si 19.15.0.0.0 true Oltp ASM Configured xxxxxxxx