oracle

Tnsping Net Service Name fails with TNS-12537: TNS:connection closed or Sqlplus connection errors out with Ora-12537     Cause:     * In the Sqlnet.ora file the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to some specific IP's of the Client Machine.     * If trying to connect to the Apps database, by default, with Oracle Apps Installation the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to Server Machines IP or Hostname.     Solution     (i)  You can disable these parameters in the Sqlnet.ora as following, then lsnrctl reload listener_name #tcp.validnode_checking = yes #tcp.invited_nodes=(xxx.domain.com) or    (ii) add the client machines ip address in the TCP.INVITEDNODES list, then lsnrctl reload listener_name

Initializing.     Run Edition context  : /oradev/oracle/r12/uat/fs1/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch edition context: /oradev/oracle/r12/uat/fs2/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch file system free space: 222.29 GB Validating system setup.     Node registry is valid.     [ERROR]     META:18:03:58.800: bad stylesheet: kustrigc     Encountered the above errors when performing database validations.     Resolve the above errors and restart adop. [STATEMENT] Please run adopscanlog utility, using the command "adopscanlog -latest=yes" to get the list of the log files along with snippet of the error message corresponding to each log file. adop exiting with status = 1 (Fail) $ Solution: 1. To find the current version of the adgrants.sql script on the instance, do the following:   a. Source the database environ...

While starting services in 12.1.3 using adstrtal.sh , oacore,oafm and forms are not coming. In $LOG_HOME/ora/10.1.3/opmn/opmn.log  , there is following error while starting : 9/05/02 01:04:36 [libopmnoc4j] Process Start Error: default_group~oacore~default_group~1 (2118410796:6598) 19/05/02 01:04:37 [pm-process] Stopping Process: default_group~oacore~default_group~1 (2118410796:6598) 19/05/02 01:04:37 [libopmnoc4j] Process Stop Error: default_group~oacore~default_group~1 (2118410796:6598) 19/05/02 01:04:37 [libopmnoc4j] Failed to construct stop command for proc: 2118410796 19/05/02 01:04:37 [libopmnoc4j] Forcefully Terminating Process: default_group~oacore~default_group~1 (2118410796:6598) 19/05/02 01:04:39 [pm-process] Starting Process: default_group~oacore~default_group~1 (2118410796:0) 19/05/02 01:04:46 [libopmnoc4j] Host and Port information for port type jms not sent by the OC4J process 19/05/02 01:04:46 [libopmnoc4j] WARNING: OC4J did not send the protocol value for port...

During cloning when running autoconfig on application node in R12.2.5: [APPLY PHASE]   AutoConfig could not successfully execute the following scripts:     Directory: /appclone/r12crp2/fs1/FMW_Home/webtier/perl/bin/perl -I /appclone/r12crp2/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /appclone/r12crp2/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /appclone/r12crp2/fs1/EBSapps/appl/au/12.0.0/perl -I /appclone/r12crp2/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/aix-thread-multi-64all /appclone/r12crp2/fs1/inst/apps/infrcrp2_cndarupgdbop01/admin/install       txkGenADOPWrapper.pl    INSTE8_APPLY       1 AutoConfig is exiting with status 1 AutoConfig execution completed on Wed Apr 17 16:11:48 2019 Time taken for AutoConfig execution to complete : 4 mins  16 secs Cause: This happens occasionally when old nodes are left in 12.2 tables and might be "fnd_conc_clone.setup_clean" was not exe...

ORA-16826: apply service state is inconsistent with the DelayMins property (Doc ID 1608166.1) DGMGRL> show configuration verbose; Configuration - orcl1_site   Protection Mode: MaxPerformance   Databases:     orcl1   - Primary database     dgorcl1 - Physical standby database        Warning: ORA-16826: apply service state is inconsistent with the DelayMins property      <<<<<<<<<<<<<<< Solution: Check on Which node MRP process is running. SQL>alter database recover managed standby database cancel; SQL> alter database recover managed standby database using current logfile disconnect;    

After the intergration of OAM with EBS, all profiles and oid configured. EBS and OID Provisioning of users also working when a new user in EBS is created. But when we call EBS URL then it prompts for SSO Login Page. After passing credentails pasge is keep processing like in endless loop. When I looked into  apache access.log , there was following error: <IP Addres from where login>- - [29/Oct/2018:16:00:00 +0530] "GET /OA_HTML/AppsLogin?requestUrl=http%3A%2F%2Fgstcrpcc.airtel.in%3A8002%2FOA_HTML%2FOA.jsp%3Fpage%3D%2Foracle%2Fapps%2Ffnd%2Fframework%2Fnavigate%2Fwebui%2FHomePG%26homePage%3DY%26transactionid%3D910851393%26oapc%3D58%26oas%3D-hLMEjZ3jTwNXKiRnDxm0Q..&cancelUrl=http%3A%2F%2Fgstcrpcc.airtel.in%3A8002%2FOA_HTML%2FAppsLogin&errText=You+have+insufficient+privileges+for+the+current+operation. HTTP/1.1" 302 1353 0 "http://bdrvl-pd-oid01.india.airtel.itm:14100/oam/server/obrareq.cgi?encquery%3DywXgwfpcCNSnIwu%2FlNOLWTIq%2BB%2FFnRa369au3LCzQoVMdd7Rz...

Error in oam_server1 diagnostic logs: [2018-10-28T00:37:05.544+05:30] [oam_server1] [ERROR] [OAMSSA-20027] [oracle.oam.user.identity.provider] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 22418d6c7523a70b:468d8b3c:166b1c5983b:-8000-000000000001653d,0] [APP: oam_server#11.1.2.0.0] Could not get user : SSOTEST, idstore: EBSIdStore, with exception: oracle.igf.ids.EntityNotFoundException: Entity not found for the search filter (&(objectclass=inetorgperson)(id=SSOTEST)).. [2018-10-28T00:37:05.545+05:30] [oam_server1] [NOTIFICATION] [] [oracle.oam.engine.authn] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 22418d6c7523a70b:468d8b3c:166b1c5983b:-8000-000000000001653d,0] [APP: oam_server#11.1.2.0.0] [[ oracle.security.am.engine.authn.api.exception.AuthenticationException         at oracle.security.am...